UPDATE data_universe_rkd SET RIC = 'BKYI.PK', DisplayRIC = 'BKYI.PK', RkdExchCode = 'OTC' WHERE SecCode = 9345 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'KOIY.BO', DisplayRIC = 'KOIY.BO' WHERE SecCode = 76103 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'AU0000463820', Ticker = 'SPXDE', SEDOL = 'BSHSHW', RIC = 'SPXDE.AX', DisplayRIC = 'SPXDE.AX' WHERE SecCode = 87204 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'TH0670B10Z01', SEDOL = 'BX9GG3' WHERE SecCode = 90115 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'TH0814A10Z09', SEDOL = 'BX9GG1' WHERE SecCode = 122945 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'GSPT.NS^E26' WHERE SecCode = 143572 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'HPOW', RIC = 'HPOW.L', DisplayRIC = 'HPOW.L' WHERE SecCode = 288775 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'KLT.H', RIC = 'KLTh.V', DisplayRIC = 'KLTh.V' WHERE SecCode = 322565 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'KYG8442C1886', SEDOL = 'BVH9PT', CUSIP = 'G8442C18' WHERE SecCode = 1033939 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'ASTR', RIC = 'ASTRm.BK', DisplayRIC = 'ASTRm.BK' WHERE SecCode = 2217629 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'NSR.AX^E26' WHERE SecCode = 2429429 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'NLFSK.CO^E26' WHERE SecCode = 3396657 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y5625W11' WHERE SecCode = 3693295 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '7088.T^E26' WHERE SecCode = 4129530 AND Type_ = 10; UPDATE data_universe_rkd SET SEDOL = NULL, RIC = 'EDX.L', DisplayRIC = 'EDX.L', RkdExchCode = 'LON' WHERE SecCode = 4613103 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'T6S35V11' WHERE SecCode = 5635825 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6789484 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 6813232 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6813831 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6829102 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'RTB', RIC = 'RTB.O', DisplayRIC = 'RTB.OQ' WHERE SecCode = 10925095 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'WGSK', RIC = 'WGSK.PK', DisplayRIC = 'WGSK.PK' WHERE SecCode = 10926304 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'AREB.PK', DisplayRIC = 'AREB.PK', RkdExchCode = 'OTC' WHERE SecCode = 11156315 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1, Ticker = 'Q11', SEDOL = 'BVPDLP', RIC = 'Q11.F', DisplayRIC = 'Q11.F', RkdExchCode = 'FRA', RkdExchCtry = 'DEU' WHERE SecCode = 11174819 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 11232942 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'BNK' WHERE SecCode = 11293667 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11293776 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11294619 AND Type_ = 1;