UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 475 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 819 AND Type_ = 10;
UPDATE data_universe SET IncCntry = NULL WHERE SecCode = 2707 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 3543 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 4512 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 4619 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00BT5GNW84', RkdSEDOL = 'BT5GNW', RkdCUSIP = 'G4390420' WHERE SecCode = 5979 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 6419 AND Type_ = 10;
UPDATE data_universe SET IncCntry = NULL WHERE SecCode = 6877 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 7166 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-20', endDate = '2026-07-20' WHERE SecCode = 10081 AND Type_ = 10;
UPDATE data_universe SET IncCntry = NULL WHERE SecCode = 11372 AND Type_ = 10;
UPDATE data_universe SET IncCntry = NULL WHERE SecCode = 11996 AND Type_ = 10;
UPDATE data_universe SET IncCntry = NULL WHERE SecCode = 12079 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-20', endDate = '2026-07-20' WHERE SecCode = 13231 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 19885 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 24116 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'LASCONDES' WHERE SecCode = 28165 AND Type_ = 10;
UPDATE data_universe SET IncCntry = NULL WHERE SecCode = 28416 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'OROBLANCO' WHERE SecCode = 29336 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 29986 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SANTARITA' WHERE SecCode = 31252 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 33824 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 33868 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 33937 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236809413457.0 WHERE SecCode = 34112 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 34267 AND Type_ = 1;
UPDATE data_universe SET IncCntry = NULL WHERE SecCode = 36162 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SWE' WHERE SecCode = 38874 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 45475 AND Type_ = 10;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 46706 AND Type_ = 1;
UPDATE data_universe SET endDate = '2026-07-20' WHERE SecCode = 49435 AND Type_ = 10;
UPDATE data_universe SET RkdListingType = 'GSR' WHERE SecCode = 51313 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'FINGb.ST^G26', RkdIssueStatus = 0.0 WHERE SecCode = 55872 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL, RkdRIC = 'AAHG.D^G26', RkdDisplayRIC = 'AAHG.D^G26', RkdIssueStatus = 0.0, RkdExchCode = 'DUS' WHERE SecCode = 56295 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = NULL WHERE SecCode = 57034 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'CINV' WHERE SecCode = 59613 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 60151 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 68018 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69536 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70098 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75012 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75057 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75299 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76103 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 RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 77957 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78203 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78207 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78583 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO', PrimaryIssueCode = 145187.0, RelType = 7.0 WHERE SecCode = 78664 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78740 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79084 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79086 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 79182 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79422 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82271 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82358 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-19', SecMapEndDate = '2026-07-16', PermSecMapEndDate = '2026-07-19', endDate = '2026-07-16' WHERE SecCode = 82721 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82974 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 83138 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85350 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86521 AND Type_ = 10;
UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 86744 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87178 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 = 89799 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 91332 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 92313 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 RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 97691 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 97907 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 98099 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98341 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 98477 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98852 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 114727 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115197 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115260 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115980 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 116617 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 120585 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 123430 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 124738 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 125248 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 125625 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 125692 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 125762 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126259 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126429 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126430 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126433 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126517 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE567L01025', RkdSEDOL = 'BT6D6W', RkdCUSIP = 'Y5S2C711' WHERE SecCode = 126529 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126595 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126638 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126810 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126828 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126972 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 127261 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 128794 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 130886 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 131516 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 131520 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 133893 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134770 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134846 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134905 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135272 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135448 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135730 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135736 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135958 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136507 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136772 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136775 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136779 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136981 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136987 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136991 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 137019 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 138036 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 142799 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 144665 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 145633 AND Type_ = 10;
UPDATE data_universe SET endDate = '2026-07-20' WHERE SecCode = 146271 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 146670 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'GORO.A^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-18', SecMapEndDate = '2026-07-17', PermQuoteRetireDate = '2026-07-18', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-17' WHERE SecCode = 154472 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 193324 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'COLOCOLO' WHERE SecCode = 214381 AND Type_ = 10;
UPDATE data_universe SET endDate = '2026-07-20' WHERE SecCode = 241853 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243314 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243354 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 254713 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 255960 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 256504 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 258767 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 288634 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'UNIONGOLF' WHERE SecCode = 295899 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 301475 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 301476 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MULTIX' WHERE SecCode = 309970 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA68827X1050', RkdTicker = 'OGG', PermIDTicker = 'OGG', RkdSEDOL = 'BTXM5X', RkdCUSIP = '68827X10', RkdRIC = 'OGG.V', RkdDisplayRIC = 'OGG.V', DsPrimQtSedol = 'BTXM5X3', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 322922 AND Type_ = 1;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 323135 AND Type_ = 10;
UPDATE data_universe SET IncCntry = NULL WHERE SecCode = 331012 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 349507 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA7276321014', RkdTicker = 'PURO', PermIDTicker = 'PURO', RkdCUSIP = '72763210', RkdRIC = 'PURO.V', RkdDisplayRIC = 'PURO.V', DsPrimQtSedol = 'BXP2X46', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 353611 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US8900233029', RkdCUSIP = '89002330', DsPrimQtSedol = 'BXP2VY2', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 354792 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 356773 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 378075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 378081 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 379859 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 389876 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 403765 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 408145 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 425884 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AZULAZUL' WHERE SecCode = 440850 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 442754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 519104 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 520670 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 536888 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 537537 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 685105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 786648 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 794875 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '057050.KS^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-07-20', SecMapEndDate = '2026-06-25', endDate = '2026-06-25' WHERE SecCode = 810847 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 843986 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 843994 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 876445 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1204782 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1209860 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2011-09-02' WHERE SecCode = 1341380 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1353487 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1465105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1468628 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1522789 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1622760 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1629626 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1670286 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CTY1SN0112', QuotePermID = 21512394267.0, ExchCode = 'HEX' WHERE SecCode = 1677271 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1980972 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1998415 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2252347 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2338222 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2341361 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2380641 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21532984899.0, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2452498 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2457963 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2469416 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2553216 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2587195 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2592376 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2646543 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2700373 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2017-01-24' WHERE SecCode = 2706327 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2717421 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2782958 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2873693 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 2891386 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2909912 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2926786 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2943703 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667488199.0, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3005679 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3040837 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3056869 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3064599 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3084613 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3212151 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3212191 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3233484 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3247535 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3309013 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET IncCntry = NULL WHERE SecCode = 3434642 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3535953 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3543193 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3754743 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 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 DsCtryQtStatus = 'S' WHERE SecCode = 4032215 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4036729 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 DsCtryQtStatus = 'S' WHERE SecCode = 4451120 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4531619 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 = 'A' WHERE SecCode = 4588291 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4722080 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4749894 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21929410708.0, ExchCode = 'DUS' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5054829 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5142396 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5418727 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236778108786.0, ExchCode = 'FRA' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '374A.T', RkdDisplayRIC = '374A.T', RkdExchCode = 'TYO' WHERE SecCode = 6356130 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6394301 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6414075 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6431535 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6448553 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6478326 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6503362 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6522450 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6538872 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6587240 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6590947 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6590976 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6612483 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6617660 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6631818 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6734290 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6985063 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 10923251 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-20', PermQuoteRetireDate = '2026-07-20', endDate = '2026-07-20' WHERE SecCode = 11012221 AND Type_ = 1;
UPDATE data_universe SET IncCntry = NULL WHERE SecCode = 11030021 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 11034779 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US88631G4038', RkdCUSIP = '88631G40', DsPrimQtSedol = 'BXP2VW0', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 11068542 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000182781.0, PriInstrPermID = 8589943208.0, PriTRBCIndPermID = 4294951916.0, PermOrgIPODate = '2013-08-19' WHERE SecCode = 11105323 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US74640Y3045', RkdCUSIP = '74640Y30', DsPrimQtSedol = 'BXP2VV9', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 11151222 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'BMG391041073', RkdCUSIP = 'G3910410', DsPrimQtSedol = 'BPY0594', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 11181200 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US02462A2033', RkdSEDOL = 'BTCL71', RkdCUSIP = '02462A20' WHERE SecCode = 11182627 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US6539421023', RkdTicker = 'NIKI', PermIDTicker = 'NIKI', RkdCUSIP = '65394210', RkdRIC = 'NIKI.O', RkdDisplayRIC = 'NIKI.OQ', DsPrimQtSedol = 'BXP2VZ3', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 11192828 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CATTF' WHERE SecCode = 11203366 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US67054R3021', RkdCUSIP = '67054R30', DsPrimQtSedol = 'BXP2W38', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 11210266 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'BURU.PK', RkdDisplayRIC = 'BURU.PK', RkdExchCode = 'OTC', PermQuoteRetireDate = '2026-07-20', endDate = '2026-07-20' WHERE SecCode = 11214016 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG2646Y1044', RkdCUSIP = 'G2646Y10', DsPrimQtSedol = 'BVK0M11', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 11214218 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG207071245', RkdCUSIP = 'G2070712', DsPrimQtSedol = 'BVK0LK3', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 11214381 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US20678X6013', RkdCUSIP = '20678X60', DsPrimQtSedol = 'BXP2W27', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 11240122 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG1991X1337', RkdCUSIP = 'G1991X13', DsPrimQtSedol = 'BXP2W05', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 11250670 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-20', PermQuoteRetireDate = '2026-07-20', endDate = '2026-07-20' WHERE SecCode = 11260559 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-20', PermQuoteRetireDate = '2026-07-20', endDate = '2026-07-20' WHERE SecCode = 11260969 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'MF', PermIDTicker = 'MF', RkdRIC = 'MF.O', RkdDisplayRIC = 'MF.OQ' WHERE SecCode = 11263606 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-20', PermQuoteRetireDate = '2026-07-20', endDate = '2026-07-20' WHERE SecCode = 11274425 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000182781.0, PriInstrPermID = 8589943208.0, PriTRBCIndPermID = 4294951916.0, PermOrgIPODate = '2013-08-19' WHERE SecCode = 11274561 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US10316W1071', RkdTicker = 'BXBL', PermIDTicker = 'BXBL', RkdSEDOL = 'BVK0LX', RkdCUSIP = '10316W10', RkdRIC = 'BXBL.O', RkdDisplayRIC = 'BXBL.OQ', DsPrimQtSedol = 'BVK0LX6', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 11274771 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232927756199.0 WHERE SecCode = 11296371 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232927756199.0, IsPrimaryInstr = 1.0, startDate = '2026-05-27' WHERE SecCode = 11299373 AND Type_ = 1;
