UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 4083 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 6290 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 8717 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236806171223.0, PriTrdQuotePermID = 236806171223.0, ExchCode = 'NAS', PermSecMapStartDate = '2026-04-24' WHERE SecCode = 27234 AND Type_ = 1;
UPDATE data_universe SET IncCntry = 'BRA' WHERE SecCode = 27315 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'BRA' WHERE SecCode = 27316 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR', IncCntry = 'GBR' WHERE SecCode = 31974 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 33932 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 33934 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 34124 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 34148 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'AUT', IncCntry = 'AUT' WHERE SecCode = 34298 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'AUT', IncCntry = 'AUT' WHERE SecCode = 34299 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 34337 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 34959 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 35058 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'FRA' WHERE SecCode = 35320 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'FRA' WHERE SecCode = 35948 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 36264 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 36651 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'TUR', IncCntry = 'TUR' WHERE SecCode = 37186 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 37706 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 38442 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 39026 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 39474 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 39770 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 39869 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 42988 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'FRA' WHERE SecCode = 43309 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 44493 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SGP' WHERE SecCode = 44746 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 45040 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 45162 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'TUR', IncCntry = 'TUR' WHERE SecCode = 45163 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'FRA' WHERE SecCode = 46281 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'NLD' WHERE SecCode = 46846 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'FRA' WHERE SecCode = 48219 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 48360 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 48589 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 48818 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'ITA' WHERE SecCode = 51163 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 51202 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 52668 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'FRA' WHERE SecCode = 52868 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BEL', IncCntry = 'BEL' WHERE SecCode = 52897 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'TUR', IncCntry = 'TUR' WHERE SecCode = 53338 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 56468 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'DEU', IncCntry = 'DEU' WHERE SecCode = 61070 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA' WHERE SecCode = 61982 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 63770 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'FRA' WHERE SecCode = 64819 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 65376 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'NOR' WHERE SecCode = 66876 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'TWN', IncCntry = 'TWN' WHERE SecCode = 66982 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 67149 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'TWN', IncCntry = 'TWN' WHERE SecCode = 67179 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ZAF', IncCntry = 'ZAF' WHERE SecCode = 69396 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 69928 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70756 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70917 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 72766 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 74255 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 74585 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'AUS' WHERE SecCode = 74997 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75860 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 DomCntry = 'ZAF', IncCntry = 'ZAF' WHERE SecCode = 76625 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'IND', IncCntry = 'IND' WHERE SecCode = 76952 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 77305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 77410 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '8209.T^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-04-27', endDate = '2026-04-27' WHERE SecCode = 80148 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82233 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ZAF', IncCntry = 'ZAF' WHERE SecCode = 82687 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 83725 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GGY' WHERE SecCode = 83736 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'SGP' WHERE SecCode = 83761 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SGP' WHERE SecCode = 83992 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86934 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 87466 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'ZAF' WHERE SecCode = 88280 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55838797189.0, ExchCode = 'JNB' WHERE SecCode = 88378 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'ZAF' WHERE SecCode = 88954 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'ZAF' WHERE SecCode = 89166 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 DsCtryQtStatus = 'S' WHERE SecCode = 89723 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'ZAF' WHERE SecCode = 89940 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 90104 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 90107 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'ZAF' WHERE SecCode = 90267 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'ZAF' WHERE SecCode = 90268 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'ZAF' WHERE SecCode = 90282 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 90990 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = '7105.T^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-04-27', endDate = '2026-04-27' WHERE SecCode = 91011 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 91674 AND Type_ = 10;
UPDATE data_universe SET ExchCode = 'TOR' WHERE SecCode = 93447 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'FKM.V^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-04-27', PermQuoteRetireDate = '2026-04-27', endDate = '2026-04-27' WHERE SecCode = 93937 AND Type_ = 1;
UPDATE data_universe SET IncCntry = 'CAN' WHERE SecCode = 94572 AND Type_ = 1;
UPDATE data_universe SET IncCntry = 'NLD' WHERE SecCode = 94954 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 95047 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 95093 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 95250 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 95294 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 95876 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ZAF', IncCntry = 'ZAF' WHERE SecCode = 95934 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ZAF', IncCntry = 'ZAF' WHERE SecCode = 96150 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 96538 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 99024 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21898257779.0, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 100742 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 100924 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 102876 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SWE', IncCntry = 'SWE' WHERE SecCode = 103304 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 111677 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 113243 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 114012 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'NOR' WHERE SecCode = 115213 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR', IncCntry = 'GBR' WHERE SecCode = 124913 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'JEY' WHERE SecCode = 130255 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951893.0 WHERE SecCode = 134794 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'IRL' WHERE SecCode = 137760 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'NOR', IncCntry = 'CYM' WHERE SecCode = 139916 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 141332 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 142031 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 142033 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'LUX' WHERE SecCode = 142642 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'NOR', IncCntry = 'NOR' WHERE SecCode = 143040 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'AUS' WHERE SecCode = 145658 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 145938 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'ZAF' WHERE SecCode = 146540 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 151133 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 151134 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 179072 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 183623 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SGP', IncCntry = 'SGP' WHERE SecCode = 196926 AND Type_ = 10;
UPDATE data_universe SET RkdDisplayRIC = 'MLCO.O' WHERE SecCode = 224179 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 243342 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '600355.SS^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-04-27', endDate = '2026-04-27' WHERE SecCode = 285308 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 298631 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'IFSUS' WHERE SecCode = 302149 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 309036 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BINT' WHERE SecCode = 317693 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'SRVL.ASE^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PriInstrPermID = 232932104823.0, IsPrimaryInstr = 0.0, DsSecDelistDate = '2026-04-27', PermQuoteRetireDate = '2026-04-27', endDate = '2026-04-27' WHERE SecCode = 317701 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 324866 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'UKR' WHERE SecCode = 334531 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 336830 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = '1893.H', QuotePermID = 21476459275.0, ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24', endDate = '2012-05-24' WHERE SecCode = 345190 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MIRLUS' WHERE SecCode = 345939 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 372856 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 395057 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'BEL' WHERE SecCode = 397637 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'BEL' WHERE SecCode = 404817 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 411775 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'NLD' WHERE SecCode = 519607 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'FRA' WHERE SecCode = 534830 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 548524 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 552209 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'FRA' WHERE SecCode = 555021 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 555050 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'AUS' WHERE SecCode = 555817 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'RUS' WHERE SecCode = 555961 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'NOR' WHERE SecCode = 556669 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 563043 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'CYM' WHERE SecCode = 674803 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 697807 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 703144 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'NOR', IncCntry = 'NOR' WHERE SecCode = 710689 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'MAC' WHERE SecCode = 788509 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'MNG' WHERE SecCode = 833608 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 846667 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'AUS' WHERE SecCode = 848062 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 883105 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'REU', IncCntry = 'REU' WHERE SecCode = 894193 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 971038 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'JEY' WHERE SecCode = 1025043 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1254621 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 1457705 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1467740 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRDGl', QuotePermID = 21531119071.0, ExchCode = 'BCO', PermQuoteRetireDate = '2014-03-20' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 1534146 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 1539991 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21492779440.0, ExchCode = 'CPH' WHERE SecCode = 1541403 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ESP' WHERE SecCode = 1597277 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 1598051 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1614005 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'INRETC1US', PermIDTicker = 'INRETC1US' WHERE SecCode = 1689195 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'CYM' WHERE SecCode = 1922582 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 2027380 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'AUS' WHERE SecCode = 2049301 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA' WHERE SecCode = 2211995 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 2228046 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'DEU', IncCntry = 'DEU' WHERE SecCode = 2271740 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 2272671 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SGP' WHERE SecCode = 2379762 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 2390323 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-04-24', endDate = '2026-04-24' WHERE SecCode = 2469416 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA' WHERE SecCode = 2496887 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA' WHERE SecCode = 2522873 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'AUT', IncCntry = 'AUT' WHERE SecCode = 2541471 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 2687335 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 2739721 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 2831978 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 2837455 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 2857037 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'TUR', IncCntry = 'TUR' WHERE SecCode = 2900879 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 2911314 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2911861 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 2925410 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'AUS', IncCntry = 'AUS' WHERE SecCode = 2940845 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 2953263 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'FRA' WHERE SecCode = 2997064 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3152611 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '3541.T^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-04-27', endDate = '2026-04-27' WHERE SecCode = 3174446 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21716782408.0, ExchCode = 'MUN', PermQuoteRetireDate = '2021-06-21', endDate = '2021-01-20' WHERE SecCode = 3255119 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3273515 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BEL', IncCntry = 'BEL' WHERE SecCode = 3295150 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PriValQuotePermID = NULL, DsSecDelistDate = '2026-04-27', PermQuoteRetireDate = '2026-04-27', endDate = '2026-04-27' WHERE SecCode = 3358228 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'MYS' WHERE SecCode = 3401808 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'AUS' WHERE SecCode = 3404175 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3444651 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ZAF' WHERE SecCode = 3495762 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 3497934 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'FRA' WHERE SecCode = 3545200 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'FRA' WHERE SecCode = 3619305 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 3634524 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ESP', IncCntry = 'ESP' WHERE SecCode = 3713367 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 3819061 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 3837228 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SWE' WHERE SecCode = 3844862 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 3886658 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'MNG' WHERE SecCode = 3938564 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 IncCntry = 'FRA' WHERE SecCode = 3997016 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4001156 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4214316 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 4214408 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 DomCntry = 'GBR' WHERE SecCode = 4355921 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4382180 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'NOR', IncCntry = 'NOR' WHERE SecCode = 4417292 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RANAo', DsCtryQtStatus = 'D', QuotePermID = 21800722506.0, PriValQuotePermID = NULL, IsPrimaryQuote = 0.0, ExchCode = 'BCO', DsSecDelistDate = '2026-04-27', endDate = '2026-04-27' WHERE SecCode = 4511455 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 4537848 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4553949 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 IncCntry = 'TUR' WHERE SecCode = 4567129 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'TUR', IncCntry = 'TUR' WHERE SecCode = 4588369 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 4598676 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 4623218 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'NOR', IncCntry = 'NOR' WHERE SecCode = 4636310 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 4658859 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'NLD' WHERE SecCode = 4714953 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 21853461208.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-24', endDate = '2026-04-24' WHERE SecCode = 4750082 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'ITA' WHERE SecCode = 4786371 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'ITA' WHERE SecCode = 4804664 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GGY' WHERE SecCode = 4854822 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'TUR', IncCntry = 'TUR' WHERE SecCode = 4952524 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 4983995 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'FRA' WHERE SecCode = 5037226 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'IND' WHERE SecCode = 5144072 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236785348309.0, ExchCode = 'QTX' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5268198 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 5283351 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 5310457 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5383310 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5383312 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'TUR', IncCntry = 'TUR' WHERE SecCode = 5481067 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 5482635 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'TUR', IncCntry = 'TUR' WHERE SecCode = 5563513 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'CYM' WHERE SecCode = 5565405 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'FRA' WHERE SecCode = 5814593 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 5822220 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 5950581 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 6026058 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'FRA' WHERE SecCode = 6147580 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'MAC' WHERE SecCode = 6509307 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 6622352 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 11016627 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BWKCBP', DsPrimQtSedol = 'BWKCBP1' WHERE SecCode = 11020386 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BW0TQJ', DsPrimQtSedol = 'BW0TQJ1', PermSecMapEndDate = '2026-04-25', endDate = '2026-04-25' WHERE SecCode = 11109486 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 11142190 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11158155 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11160389 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11160390 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BW0TQD', DsPrimQtSedol = 'BW0TQD5' WHERE SecCode = 11166192 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11178321 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'OSM', RkdSEDOL = 'BW0TV3', PermSecMapEndDate = '2026-04-25', endDate = '2026-04-25' WHERE SecCode = 11182728 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11186768 AND Type_ = 1;
UPDATE data_universe SET IncCntry = 'USA' WHERE SecCode = 11190074 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11195175 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11195932 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11200314 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'MAPS.PK', RkdDisplayRIC = 'MAPS.PK', RkdExchCode = 'OTC', PriTrdQuotePermID = NULL, PermQuoteRetireDate = '2026-04-27', endDate = '2026-04-27' WHERE SecCode = 11200871 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11206349 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 11213494 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BVK6XS', DsPrimQtSedol = 'BVK6XS3', PermSecMapEndDate = '2026-04-25', endDate = '2026-04-25' WHERE SecCode = 11214755 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 11215201 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'LUX' WHERE SecCode = 11215873 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BW0TR1', DsPrimQtSedol = 'BW0TR10', PermSecMapEndDate = '2026-04-25', endDate = '2026-04-25' WHERE SecCode = 11216254 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US98878K1088', PermIDTicker = 'ZSQR', RkdSEDOL = 'BPBP6Z', RkdCUSIP = '98878K10', DsPrimQtSedol = 'BPBP6Z5', ExchCode = 'NMS', PermSecMapEndDate = '2026-04-25', endDate = '2026-04-25' WHERE SecCode = 11216358 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'LUX' WHERE SecCode = 11218142 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11218867 AND Type_ = 1;
UPDATE data_universe SET IncCntry = 'CYM' WHERE SecCode = 11220682 AND Type_ = 1;
UPDATE data_universe SET IncCntry = 'CYM' WHERE SecCode = 11223572 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BPBP7G', RkdCUSIP = '81694410', DsPrimQtSedol = 'BPBP7G3', PermSecMapEndDate = '2026-04-25', endDate = '2026-04-25' WHERE SecCode = 11224790 AND Type_ = 1;
UPDATE data_universe SET IncCntry = 'USA' WHERE SecCode = 11224867 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BW0TR8', DsPrimQtSedol = 'BW0TR87', PermSecMapEndDate = '2026-04-25', endDate = '2026-04-25' WHERE SecCode = 11238402 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BW0TRB', DsPrimQtSedol = 'BW0TRB0', PermSecMapEndDate = '2026-04-25', endDate = '2026-04-25' WHERE SecCode = 11253723 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GXLDF' WHERE SecCode = 11258008 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 11258995 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11259985 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN', IncCntry = 'CAN' WHERE SecCode = 11286386 AND Type_ = 1;
UPDATE data_universe SET IncCntry = 'FRA' WHERE SecCode = 11288479 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236806104605.0, IsPrimaryQuote = 1.0, ExchCode = 'NAS' WHERE SecCode = 11294834 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'XE', QuotePermID = 236806171250.0, InstrPermID = 232824115192.0, OrgPermID = 6000088284.0, PriTrdQuotePermID = 236806171250.0, PriValQuotePermID = 25727025310.0, PriInstrPermID = 232824115192.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NSM', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PermOrgIPODate = '2026-04-24', PermSecMapStartDate = '2026-04-24' WHERE SecCode = 11294934 AND Type_ = 1;
