UPDATE data_universe_rkd SET Ticker = 'NOTVQ', SEDOL = NULL, RIC = 'NOTVQ.PK', DisplayRIC = 'NOTVQ.PK', RkdExchCode = 'OTC' WHERE SecCode = 9321 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 44507 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'MASI.OQ^F26' WHERE SecCode = 44800 AND Type_ = 1;
UPDATE data_universe_rkd SET CUSIP = 'D1176028' WHERE SecCode = 51554 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q1714E20' WHERE SecCode = 83612 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '4556.T^F26' WHERE SecCode = 85118 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CA4820451017', Ticker = 'JUN.A', SEDOL = 'BVTD8G', CUSIP = '48204510', RIC = 'JUNa.V', DisplayRIC = 'JUNa.V' WHERE SecCode = 97343 AND Type_ = 1;
UPDATE data_universe_rkd SET CUSIP = 'Y3814N25' WHERE SecCode = 1485605 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'AOF.AX^F26' WHERE SecCode = 3184368 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, RIC = 'TBX0.TG', DisplayRIC = 'TBX0.TG' WHERE SecCode = 3339539 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueCode = NULL WHERE SecCode = 4425536 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'G1993H10' WHERE SecCode = 4511509 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 4533297 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'V7797B10' WHERE SecCode = 4820980 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'HUI', RIC = 'HUI.L', DisplayRIC = 'HUI.L', RkdExchCode = 'LON' WHERE SecCode = 4825109 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6622350 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6686349 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y077NE10' WHERE SecCode = 6802661 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y8818910' WHERE SecCode = 6806185 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6806345 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 6806346 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y767UC10' WHERE SecCode = 6839611 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6857268 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y6T0KL10' WHERE SecCode = 6870722 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'LFTO', SEDOL = 'BPSKXZ', RIC = 'LFTO.O', DisplayRIC = 'LFTO.OQ', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 6897245 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, Ticker = 'TRLV', SEDOL = 'BGNKTH', RIC = 'TRLV.K', DisplayRIC = 'TRLV.N', RkdExchCode = 'NYSE', RkdExchCtry = 'USA' WHERE SecCode = 11190437 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA05157Q1028', Ticker = 'AURO', SEDOL = 'BVTD8L', CUSIP = '05157Q10', RIC = 'AURO.V', DisplayRIC = 'AURO.V' WHERE SecCode = 11215356 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US92339H2004', SEDOL = 'BVTD8N', CUSIP = '92339H20' WHERE SecCode = 11219488 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US8256935003', SEDOL = 'BVTD8K', CUSIP = '82569350' WHERE SecCode = 11245181 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = '52D0', RIC = '52D0.F^F26', RkdExchCode = 'FRA', RkdExchCtry = 'DEU' WHERE SecCode = 11245859 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'KYG3937M2059', SEDOL = 'BVTD87', CUSIP = 'G3937M20' WHERE SecCode = 11258165 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueCode = NULL, RelType = NULL WHERE SecCode = 11260395 AND Type_ = 1;
UPDATE data_universe_rkd SET ShPerListing = 1.0 WHERE SecCode = 11263764 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CH1476899161', Ticker = 'VRXA', SEDOL = 'BVMH34', CUSIP = 'H9130A10', RIC = 'VRXA.O', DisplayRIC = 'VRXA.OQ' WHERE SecCode = 11270117 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US05338N1019', Ticker = 'AVAT', SEDOL = 'BWRXM8', CUSIP = '05338N10', RIC = 'AVAT.O', DisplayRIC = 'AVAT.OQ' WHERE SecCode = 11274579 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11277843 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'BREZU.OQ^F26' WHERE SecCode = 11295855 AND Type_ = 1;
