UPDATE data_universe_rkd SET ShPerListing = 33743217.0 WHERE SecCode = 7197 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, SEDOL = 'BN14KP', RIC = 'NOTVQ.PK^G26' WHERE SecCode = 9321 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'CREG.PK', DisplayRIC = 'CREG.PK', RkdExchCode = 'OTC' WHERE SecCode = 14009 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'MPVD.TO^G26' WHERE SecCode = 48452 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA38141A6025', SEDOL = 'BTMT3V', CUSIP = '38141A60' WHERE SecCode = 99271 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'GUKEI.MM^G26' WHERE SecCode = 2251487 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'AU0000473282', SEDOL = 'BRCFQ2', CUSIP = 'Q7797A10' WHERE SecCode = 2528745 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'LIVE', RIC = 'LIVE.L', DisplayRIC = 'LIVE.L' WHERE SecCode = 3382330 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 3794666 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'PRE' WHERE SecCode = 4443990 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'NGRD3.SA^G26' WHERE SecCode = 4446111 AND Type_ = 10; UPDATE data_universe_rkd SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6400766 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'PRE' WHERE SecCode = 6934853 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6945364 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6969133 AND Type_ = 10; UPDATE data_universe_rkd SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe_rkd SET SEDOL = 'BXP2VZ' WHERE SecCode = 11192828 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA67449X1050', Ticker = 'OCAL', SEDOL = 'BVK35N', CUSIP = '67449X10', RIC = 'OCAL.V', DisplayRIC = 'OCAL.V' WHERE SecCode = 11244657 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11299305 AND Type_ = 1;