UPDATE data_universe_rkd SET COATypeCode = 'BNK' WHERE SecCode = 8593 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 27134 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 29418 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'US4169062043', CUSIP = '41690620' WHERE SecCode = 32827 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'AU000000ASP3', Ticker = 'ASP', SEDOL = '623701', CUSIP = 'Q0569119', RIC = 'ASP.AX', DisplayRIC = 'ASP.AX' WHERE SecCode = 75796 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, Ticker = 'HVX', RIC = 'HVX.HNO', DisplayRIC = 'HVX.HNO', RkdExchCode = 'UPC' WHERE SecCode = 826229 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 2253329 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'POON.PFT^C26' WHERE SecCode = 2488650 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'LUMO', RIC = 'LUMO.HE', DisplayRIC = 'LUMO.HE' WHERE SecCode = 3522229 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 5953913 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6541030 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6555567 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6628395 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'US1850642018', CUSIP = '18506420' WHERE SecCode = 11026351 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11108257 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL WHERE SecCode = 11144671 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'VIVO', RIC = 'VIVO.O', DisplayRIC = 'VIVO.OQ' WHERE SecCode = 11166235 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'BHAT.OQ' WHERE SecCode = 11199112 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA3591341035', Ticker = 'FNUC', CUSIP = '35913410', RIC = 'FNUC.O', DisplayRIC = 'FNUC.OQ' WHERE SecCode = 11234421 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'KYG5140V1207', CUSIP = 'G5140V12' WHERE SecCode = 11250907 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11292241 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11292839 AND Type_ = 1;