UPDATE data_universe_rkd SET Ticker = 'THAT', RIC = 'THAT.L', DisplayRIC = 'THAT.L' WHERE SecCode = 8243 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, ISIN = 'GB00BSQPKV53', Ticker = 'SHRA', SEDOL = 'BSQPKV', CUSIP = 'G8109621', RIC = 'SHRAa.L', DisplayRIC = 'SHRAa.L' WHERE SecCode = 10917 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'AZTECACPO.MX^C26' WHERE SecCode = 27527 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueCode = NULL WHERE SecCode = 74703 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA81783A1003', Ticker = 'SEVA', SEDOL = 'BTBJGC', CUSIP = '81783A10', RIC = 'SEVA.V', DisplayRIC = 'SEVA.V', RkdExchCode = 'CVE' WHERE SecCode = 94390 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'QIPT.TO^C26' WHERE SecCode = 95463 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueCode = NULL WHERE SecCode = 99970 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 123563 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 147678 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'PHPS', RIC = 'PHPS.PK', DisplayRIC = 'PHPS.PK' WHERE SecCode = 308878 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'INE377M01043', SEDOL = 'BVPKYN', CUSIP = 'Y2718D13' WHERE SecCode = 1468628 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 1472965 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '204630.KQ^C26' WHERE SecCode = 2747570 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 2981415 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 5489259 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = '0M0.F', DisplayRIC = '0M0.F', RkdExchCode = 'FRA' WHERE SecCode = 5516449 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'VIDA.PK^C26' WHERE SecCode = 10778627 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'BIO.CD^C26' WHERE SecCode = 11137326 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA62819M1023', Ticker = 'MMX', SEDOL = 'BTBJGM', CUSIP = '62819M10', RIC = 'MMX.V', DisplayRIC = 'MMX.V' WHERE SecCode = 11151246 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, Ticker = 'NGEN', SEDOL = 'BJXG1C', RIC = 'NGEN.O', DisplayRIC = 'NGEN.OQ', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11194822 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA90356T1075', Ticker = 'APPT', SEDOL = 'BTBJFR', CUSIP = '90356T10', RIC = 'APPT.CD', DisplayRIC = 'APPT.CD' WHERE SecCode = 11214004 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'CFLT.OQ^C26' WHERE SecCode = 11226189 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US89269P2020', SEDOL = 'BWTYM3', CUSIP = '89269P20' WHERE SecCode = 11228029 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA74031F1045', Ticker = 'BPC', SEDOL = 'BNZFWR', CUSIP = '74031F10', RIC = 'BPC.CD', DisplayRIC = 'BPC.CD' WHERE SecCode = 11243861 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'ULYX', RIC = 'ULYX.PK', DisplayRIC = 'ULYX.PK', RkdExchCode = 'OTC' WHERE SecCode = 11258993 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11291687 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11292836 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueOrder = 1, RkdListingType = 'OSR' WHERE SecCode = 11293245 AND Type_ = 1;
