UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'TET.L^G26' WHERE SecCode = 12192 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 27902 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 28602 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'AMNI.PK^F26' WHERE SecCode = 35958 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 45181 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'GUJENERGY', RIC = 'GJAA.NS', DisplayRIC = 'GJAA.NS' WHERE SecCode = 72544 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'AU000000BXN6', Ticker = 'BXN', SEDOL = 'B7Z3MX', CUSIP = 'Q7747415', RIC = 'BXN.AX', DisplayRIC = 'BXN.AX' WHERE SecCode = 78713 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'AURQ.BO', DisplayRIC = 'AURQ.BO' WHERE SecCode = 79084 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y013AW12' WHERE SecCode = 79775 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'MRC.AX^F26' WHERE SecCode = 80275 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'YELLQ.PK^G26' WHERE SecCode = 82853 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = '600599.SS^F26' WHERE SecCode = 82957 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 94154 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'GH.TO^F26' WHERE SecCode = 94266 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'KARD.BE^H20', RkdExchCode = 'BER' WHERE SecCode = 104330 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 112779 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'GAON' WHERE SecCode = 349154 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 384163 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'X9606N10' WHERE SecCode = 433757 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 1551611 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'TH4920B10Z01', SEDOL = 'BPYV48' WHERE SecCode = 2417295 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'ALFER', RIC = 'ALFER.PA', DisplayRIC = 'ALFER.PA' WHERE SecCode = 2571188 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueCode = 112706.0 WHERE SecCode = 3348752 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'BLINC B', RIC = 'BLINCb.ST', DisplayRIC = 'BLINCb.ST' WHERE SecCode = 3355024 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE900L01028', SEDOL = 'BSBB2G', CUSIP = 'Y5S61Y12' WHERE SecCode = 3396295 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'MEDFIN B', RIC = 'MEDFINb.NGM', DisplayRIC = 'MEDFINb.NGM' WHERE SecCode = 3433717 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 6389710 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 6440004 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6806346 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6865118 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6927600 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6939103 AND Type_ = 10; UPDATE data_universe_rkd SET SEDOL = 'BSBFLD' WHERE SecCode = 11105323 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US34417J6091', SEDOL = 'BRSCWV', CUSIP = '34417J60' WHERE SecCode = 11138087 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11155145 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'FOX.CD^G26' WHERE SecCode = 11156594 AND Type_ = 1; UPDATE data_universe_rkd SET ShPerListing = 0.2 WHERE SecCode = 11214660 AND Type_ = 1; UPDATE data_universe_rkd SET SEDOL = 'BTH26H' WHERE SecCode = 11256494 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'VGG9888Q1292', SEDOL = 'BRSCV2', CUSIP = 'G9888Q12' WHERE SecCode = 11264467 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11295462 AND Type_ = 1;