UPDATE data_universe_rkd SET ShPerListing = 33743217.0 WHERE SecCode = 7197 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 24430 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'BAP' WHERE SecCode = 28346 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'ELEKTRA.MX^D26' WHERE SecCode = 31370 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'IMPMQ', RIC = 'IMPMQ.PK', DisplayRIC = 'IMPMQ.PK' WHERE SecCode = 35592 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'MRGO.PK^D26' WHERE SecCode = 44565 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'ILKKA1.HE^D26' WHERE SecCode = 58851 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'ILKKA', RIC = 'ILKKA.HE', DisplayRIC = 'ILKKA.HE' WHERE SecCode = 58852 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 75423 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'ELRL', RIC = 'ELRL.TA', DisplayRIC = 'ELRL.TA' WHERE SecCode = 78430 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'GYFT.BO', DisplayRIC = 'GYFT.BO' WHERE SecCode = 82553 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CA78657T1084', Ticker = 'SF', SEDOL = 'BPBPBW', CUSIP = '78657T10', RIC = 'SF.V', DisplayRIC = 'SF.V' WHERE SecCode = 97778 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'EBP', RIC = 'EBP.WA', DisplayRIC = 'EBP.WA' WHERE SecCode = 101022 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'FOLD.OQ^D26' WHERE SecCode = 102088 AND Type_ = 1; UPDATE data_universe_rkd SET RkdListingType = 'GSR' WHERE SecCode = 114410 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'TYCN', RIC = 'TYCN.CA', DisplayRIC = 'TYCN.CA' WHERE SecCode = 145936 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 153607 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US9286612067', SEDOL = 'BMWDT4', CUSIP = '92866120' WHERE SecCode = 295486 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 519205 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'GG00BWZ6KH33', SEDOL = 'BWZ6KH', CUSIP = 'G4196W25' WHERE SecCode = 2382443 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'VAF.HM^D26' WHERE SecCode = 2912792 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '5259.T^D26' WHERE SecCode = 3407834 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'NNG.AX^D26' WHERE SecCode = 4502482 AND Type_ = 10; UPDATE data_universe_rkd SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'TAR', RIC = 'TAR.L', DisplayRIC = 'TAR.L' WHERE SecCode = 5281304 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = '7760.TW', DisplayRIC = '7760.TW', RkdExchCode = 'TPE' WHERE SecCode = 5917709 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6710170 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 11030886 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueOrder = 1 WHERE SecCode = 11074374 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11153513 AND Type_ = 1; UPDATE data_universe_rkd SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11198674 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueCode = 19515.0, RelType = 1.0 WHERE SecCode = 11216640 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US45032V3069', SEDOL = 'BPBP61', CUSIP = '45032V30' WHERE SecCode = 11225845 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA0515341059', Ticker = 'AURR', SEDOL = 'BPBP63', CUSIP = '05153410', RIC = 'AURR.CD', DisplayRIC = 'AURR.CD' WHERE SecCode = 11233898 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'VBIO', RIC = 'VBIO.O', DisplayRIC = 'VBIO.OQ' WHERE SecCode = 11233903 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA92244M1041', Ticker = 'PAIN', SEDOL = 'BPBPC4', CUSIP = '92244M10', RIC = 'PAIN.V', DisplayRIC = 'PAIN.V' WHERE SecCode = 11244158 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 11248419 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'ZSPC.PK', DisplayRIC = 'ZSPC.PK', RkdExchCode = 'OTC' WHERE SecCode = 11272365 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'KYG286871127', SEDOL = 'BPBP5J', CUSIP = 'G2868711' WHERE SecCode = 11274178 AND Type_ = 1; UPDATE data_universe_rkd SET SEDOL = 'BNRRCN' WHERE SecCode = 11294499 AND Type_ = 1;