UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 2308 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 3637 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 3716 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 8027 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 22571 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 27487 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 27488 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 35657 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 38052 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 39654 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 40372 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 41034 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, PrimaryIssueType = 'EQU' WHERE SecCode = 41673 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 42297 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 46164 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 57736 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 57737 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 57742 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 58182 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 58491 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 59077 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, RIC = 'STGG.TG', DisplayRIC = 'STGG.TG' WHERE SecCode = 59737 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 67353 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'FOSE.BO', DisplayRIC = 'FOSE.BO' WHERE SecCode = 70495 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, PrimaryIssueType = 'EQU' WHERE SecCode = 77296 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 79202 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'US68557F3082', CUSIP = '68557F30' WHERE SecCode = 82506 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'AU0000464257', Ticker = 'MRT', SEDOL = 'BWPKSY', RIC = 'MRT.AX', DisplayRIC = 'MRT.AX' WHERE SecCode = 84618 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 92329 AND Type_ = 10; UPDATE data_universe_rkd SET RkdListingType = 'GSR' WHERE SecCode = 93601 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA57072P2061', CUSIP = '57072P20' WHERE SecCode = 96456 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 98066 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 100567 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 102973 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 114574 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, PrimaryIssueType = 'PVT' WHERE SecCode = 123563 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 137345 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'BMG780521750', SEDOL = 'BLN9HP', CUSIP = 'G7805217' WHERE SecCode = 137928 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 140746 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 143703 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 309142 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 311174 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 325276 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 331367 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 342294 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 359005 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 392192 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 503567 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 685080 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 703276 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 964808 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 997895 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 1260131 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 1287431 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 1548392 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 2338084 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'NO0013740142', SEDOL = 'BT8PHZ', CUSIP = 'R4S23F18' WHERE SecCode = 2374403 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 2864489 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, PrimaryIssueType = 'PVT' WHERE SecCode = 2981415 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, PrimaryIssueType = 'EQU' WHERE SecCode = 3098023 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 3439280 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 3439281 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'AU0000182552', Ticker = 'EBR', SEDOL = 'BN963C', RIC = 'EBR.AX', DisplayRIC = 'EBR.AX', ShPerListing = 0.1 WHERE SecCode = 4780386 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'P2R4BR13' WHERE SecCode = 6154012 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 10980226 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA8939761000', Ticker = 'OCEN', CUSIP = '89397610', RIC = 'OCEN.V', DisplayRIC = 'OCEN.V' WHERE SecCode = 11006192 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11034316 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11181983 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US1509643029' WHERE SecCode = 11186611 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 11192150 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US22053A2069', CUSIP = '22053A20' WHERE SecCode = 11196712 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11217675 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US4569482072' WHERE SecCode = 11234146 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA22406U1075', Ticker = 'CCMM', CUSIP = '22406U10', RIC = 'CCMM.V', DisplayRIC = 'CCMM.V' WHERE SecCode = 11236900 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA00971M7008' WHERE SecCode = 11239698 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'KYG4645R1222', CUSIP = 'G4645R12' WHERE SecCode = 11274686 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'KYG8221K1388', CUSIP = 'G8221K13' WHERE SecCode = 11275653 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'KYG9627R1157', CUSIP = 'G9627R11' WHERE SecCode = 11276630 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'YOOV', RIC = 'YOOV.O', DisplayRIC = 'YOOV.OQ' WHERE SecCode = 11277561 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'KYG8071C1116', CUSIP = 'G8071C11' WHERE SecCode = 11279079 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11290991 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueOrder = 1, RkdListingType = 'OSR', COATypeCode = 'IND' WHERE SecCode = 11293311 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11293847 AND Type_ = 1;