UPDATE data_universe_rkd SET ShPerListing = 33743217.0 WHERE SecCode = 7197 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'FONR.OQ^F26' WHERE SecCode = 27805 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'PPLI', RIC = 'PPLI.O', DisplayRIC = 'PPLI.OQ' WHERE SecCode = 34455 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 53155 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = '000638.SZ^F26' WHERE SecCode = 73938 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'MGCI.OM^F26' WHERE SecCode = 87769 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '9067.T^F26' WHERE SecCode = 88511 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 100359 AND Type_ = 1; UPDATE data_universe_rkd SET RkdExchCode = 'TSE', RkdExchCtry = 'CAN' WHERE SecCode = 100361 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 243646 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'SIRS.BO^F26' WHERE SecCode = 314958 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 887451 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'M5307120' WHERE SecCode = 1004455 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'SE0029277631', SEDOL = 'BVYHMY', CUSIP = 'W7820929' WHERE SecCode = 2909235 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'DE000A41YD16', Ticker = 'B4B0', SEDOL = 'BN4PWJ', CUSIP = 'D5S17Q21', RIC = 'B4B0n.H', DisplayRIC = 'B4B0n.H' WHERE SecCode = 3376114 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'DE000A41YD24', Ticker = 'B4B1', SEDOL = 'BN4PX7', CUSIP = 'D5S17Q22', RIC = 'B4B1n_p.H', DisplayRIC = 'B4B1n_p.H' WHERE SecCode = 3376117 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '0XP.H^F26' WHERE SecCode = 3572808 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'STABL.ST^F26' WHERE SecCode = 4129789 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 4491668 AND Type_ = 10; UPDATE data_universe_rkd SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'GB00BN0ZLR96', SEDOL = 'BN0ZLR', CUSIP = 'G937EZ10' WHERE SecCode = 5067274 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6622507 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6789475 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Q4566740' WHERE SecCode = 6808989 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6846681 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'M2723M10' WHERE SecCode = 6865118 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = NULL WHERE SecCode = 11001706 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11014419 AND Type_ = 1; UPDATE data_universe_rkd SET CUSIP = 'M5307120' WHERE SecCode = 11110620 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11111276 AND Type_ = 1; UPDATE data_universe_rkd SET ShPerListing = 2500.0 WHERE SecCode = 11131840 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'ECM.H', RIC = 'ECMh.V', DisplayRIC = 'ECMh.V', RkdExchCode = 'NEX' WHERE SecCode = 11159122 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11183588 AND Type_ = 1; UPDATE data_universe_rkd SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe_rkd SET SEDOL = 'BSQLM2', RIC = 'BIPC.TO', DisplayRIC = 'BIPC.TO', RkdExchCode = 'TSE', RkdExchCtry = 'CAN' WHERE SecCode = 11206349 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11214796 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'KYG9627S1131', SEDOL = 'BWMWQ5', CUSIP = 'G9627S11' WHERE SecCode = 11276890 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11294771 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11294834 AND Type_ = 1;