UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1807 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 4907 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 27115 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 41370 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MACO.I', QuotePermID = 21475575870.0, ExchCode = 'CCH', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-18', PermSecMapEndDate = '2026-03-18' WHERE SecCode = 66233 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75850 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 76193 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 76208 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET Name = 'TURKCELL ILETISIM SPON ADR NEW' WHERE SecCode = 77037 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 77184 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236804436684.0 WHERE SecCode = 80014 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 81655 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951329.0 WHERE SecCode = 81978 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82957 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 83586 AND Type_ = 10;
UPDATE data_universe SET Name = 'CHUBB LTD SWITZ COM' WHERE SecCode = 83700 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85973 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86003 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL WHERE SecCode = 89466 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 89467 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PriTRBCIndPermID = 4294951879.0, PermSecMapEndDate = '2026-03-19' WHERE SecCode = 92019 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA9749101015', RkdSEDOL = 'BW5W07', RkdCUSIP = '97491010', DsPrimQtSedol = 'BW5W071' WHERE SecCode = 94983 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 95463 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951929.0 WHERE SecCode = 98338 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951266.0 WHERE SecCode = 99050 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 99200 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-03-18' WHERE SecCode = 105229 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CENTAUR MEDIA ORD GBP0.001' WHERE SecCode = 111378 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 141836 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-03-18' WHERE SecCode = 142232 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 143394 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 147433 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'M3B0', Name = 'PYRAMID AG NPV (POST SPLIT)' WHERE SecCode = 171251 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21507329852.0, ExchCode = 'FRA' WHERE SecCode = 178289 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236798948725.0, ExchCode = 'DUS' WHERE SecCode = 396306 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-30' WHERE SecCode = 564492 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'ALCAR.PA^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-20', SecMapEndDate = '2025-12-01', PermQuoteRetireDate = '2026-03-20', endDate = '2025-12-01' WHERE SecCode = 726370 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951778.0 WHERE SecCode = 882491 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 1121165 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951488.0 WHERE SecCode = 1139929 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, PermIDTicker = 'XEN', Name = 'XENITRA LIMITED NPV', SecMapEndDate = '2079-06-06', endDate = NULL WHERE SecCode = 1465316 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRDG', QuotePermID = 21512147101.0, ExchCode = 'LSE', PermQuoteRetireDate = '2013-12-17' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CHERYONG IND CO LT KRW500' WHERE SecCode = 1527481 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21492779438.0, ExchCode = 'BUR' WHERE SecCode = 1541403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1678746 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21532984899.0, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 2400895 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2436714 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951478.0 WHERE SecCode = 2583472 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2598695 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2620149 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667488199.0, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'XEN' WHERE SecCode = 3160142 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'ALPCV.PA^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-20', SecMapEndDate = '2026-03-19', PermQuoteRetireDate = '2026-03-20', endDate = '2026-03-19' WHERE SecCode = 3183968 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3229199 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21597458276.0, ExchCode = 'BER', PermQuoteRetireDate = '2020-07-27', endDate = '2020-07-27' WHERE SecCode = 3255119 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000460404', RkdTicker = 'TSR', PermIDTicker = 'TSR', RkdSEDOL = 'BWBR21', RkdRIC = 'TSR.AX', RkdDisplayRIC = 'TSR.AX', DsPrimQtSedol = 'BWBR218' WHERE SecCode = 3296401 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'XEN' WHERE SecCode = 3394633 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 3402869 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3409784 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 3961773 AND Type_ = 10;
UPDATE data_universe SET Name = 'CHUBB LTD SWITZ BDR EACH 4 REPR 1 COM' WHERE SecCode = 4077692 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951488.0 WHERE SecCode = 4169154 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4291601 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4307878 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-20' WHERE SecCode = 4338899 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791494702.0, PermQuoteStatus = 'AC', ExchCode = 'JAX', PermQuoteRetireDate = NULL, endDate = NULL WHERE SecCode = 4365821 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 4459250 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4540765 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4561851 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-19', SecMapEndDate = '2026-03-18', PermQuoteRetireDate = '2026-03-19', PermSecMapEndDate = '2026-03-19', endDate = '2026-03-18' WHERE SecCode = 4574916 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21884462002.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22', endDate = '2024-10-21' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'SMCRT.OL^C26', RkdDisplayRIC = 'SMCRT.OL1', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-20', SecMapEndDate = '2026-03-19', PermQuoteRetireDate = '2026-03-20', endDate = '2026-03-19' WHERE SecCode = 4627843 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21565180699.0, ExchCode = 'FRA' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 5162444 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'KLS' WHERE SecCode = 5411328 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-03-18', endDate = '2026-03-18' WHERE SecCode = 6182386 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-03-18', endDate = '2026-03-18' WHERE SecCode = 6256352 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-03-18', endDate = '2026-03-18' WHERE SecCode = 6305182 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6627693 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-03-20', SecMapEndDate = '2026-03-19', endDate = '2026-03-19' WHERE SecCode = 6654321 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'TREGNTK00016', RkdTicker = 'GENKM.E', RkdSEDOL = 'BT5HZ5', RkdCUSIP = 'M4946F10', RkdRIC = 'GENKM.IS', RkdDisplayRIC = 'GENKM.IS', RkdCode = 144510.0, RkdIssueID = 1.0, RkdIssueCode = 184683.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'IST', RkdExchCtry = 'TUR', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6702410 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'M8232U10', COATypeCode = 'IND' WHERE SecCode = 6710027 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y007BS10' WHERE SecCode = 6721511 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y830HE10' WHERE SecCode = 6724255 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6724414 AND Type_ = 10;
UPDATE data_universe SET Name = 'MASTECH HLDGS INC COM' WHERE SecCode = 10778332 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-04-01' WHERE SecCode = 10986427 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'FLT.TO', RkdDisplayRIC = 'FLT.TO', RkdExchCode = 'TSE', ExchCode = 'TOR' WHERE SecCode = 11008504 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US88631G3048', RkdSEDOL = 'BW5VWJ', RkdCUSIP = '88631G30', DsPrimQtSedol = 'BW5VWJ4' WHERE SecCode = 11068542 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-04-01' WHERE SecCode = 11157918 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'AMRQ.V^C26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-20', endDate = '2026-03-20' WHERE SecCode = 11174819 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11178785 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11181983 AND Type_ = 1;
UPDATE data_universe SET Country = 'USA' WHERE SecCode = 11192817 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'UOKAF', PermIDTicker = NULL, RkdRIC = 'UOKAF.PK', RkdDisplayRIC = 'UOKAF.PK', RkdExchCode = 'OTC', PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-20', endDate = '2026-03-20' WHERE SecCode = 11193306 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11194856 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'RADLD', Name = 'RADIAL RESH CORP COM NEW', PermSecMapEndDate = '2026-03-19', endDate = '2026-03-19' WHERE SecCode = 11199082 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA58518J3091', RkdSEDOL = 'BVWP3Y', RkdCUSIP = '58518J30', DsPrimQtSedol = 'BVWP3Y4' WHERE SecCode = 11202604 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US68622D2053', RkdSEDOL = 'BW5VWL', RkdCUSIP = '68622D20', DsPrimQtSedol = 'BW5VWL6' WHERE SecCode = 11211867 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 11212121 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 11243861 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 11254409 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 11256494 AND Type_ = 1;
UPDATE data_universe SET ModelCntry = 'US', DomCntry = 'USA' WHERE SecCode = 11275372 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11291137 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232917637965.0 WHERE SecCode = 11291139 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 236804442492.0, PriValQuotePermID = 25727030239.0, IsPrimaryInstr = 1.0, startDate = '2026-01-29' WHERE SecCode = 11293396 AND Type_ = 1;
