UPDATE data_universe_rkd SET ShPerListing = 33743217.0 WHERE SecCode = 7197 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 9790 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'CYAN', RIC = 'CYAN.PK', DisplayRIC = 'CYAN.PK' WHERE SecCode = 18150 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 23840 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 34048 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueOrder = 2, RkdListingType = NULL WHERE SecCode = 43804 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'NGMC', RIC = 'NGMC.PK', DisplayRIC = 'NGMC.PK' WHERE SecCode = 50525 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'LJM1R.RI^C26' WHERE SecCode = 58099 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 80999 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'KLIN.BO', DisplayRIC = 'KLIN.BO' WHERE SecCode = 82333 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'IRKA.KL^C26' WHERE SecCode = 84674 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueCode = NULL WHERE SecCode = 84916 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'KNM.AX^C26' WHERE SecCode = 93867 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 95567 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'BPROP', RIC = 'BPRO.KL', DisplayRIC = 'BPRO.KL' WHERE SecCode = 96188 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 116306 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'MADL.BO', DisplayRIC = 'MADL.BO' WHERE SecCode = 116579 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y2738A10' WHERE SecCode = 120435 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'KYG9897L1115', SEDOL = 'BR4Z1B', CUSIP = 'G9897L11' WHERE SecCode = 1493913 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'GOIN.KL^C26' WHERE SecCode = 4057396 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'KYG6082P1211', SEDOL = 'BN7BN5', CUSIP = 'G6082P12' WHERE SecCode = 4487613 AND Type_ = 10; UPDATE data_universe_rkd SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Q8801K22' WHERE SecCode = 5037315 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6626017 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6658290 AND Type_ = 10; UPDATE data_universe_rkd SET RkdListingType = 'EDR', ShPerListing = 0.0 WHERE SecCode = 11073795 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US04301G7060', SEDOL = 'BWYD5L', CUSIP = '04301G70' WHERE SecCode = 11153097 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueType = 'C', RkdListingType = 'OSR' WHERE SecCode = 11161916 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueOrder = 1 WHERE SecCode = 11177805 AND Type_ = 1; UPDATE data_universe_rkd SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 11194085 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'GNFTY.PK^C26' WHERE SecCode = 11195004 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueOrder = 2 WHERE SecCode = 11195911 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'DMRA', RIC = 'DMRA.O', DisplayRIC = 'DMRA.OQ' WHERE SecCode = 11214218 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11226407 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'OIO', RIC = 'OIO.O', DisplayRIC = 'OIO.OQ' WHERE SecCode = 11240703 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'LIRC.TO^C26' WHERE SecCode = 11250260 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US73017P5089', SEDOL = 'BWYD5S', CUSIP = '73017P50' WHERE SecCode = 11259864 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11292277 AND Type_ = 1;