UPDATE data_universe SET IsMajorSec = 'Y' WHERE SecCode = 2862 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475442988.0, ExchCode = 'CHI' WHERE SecCode = 4772 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 13061 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951520.0 WHERE SecCode = 13227 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'OROBLANCO' WHERE SecCode = 29336 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MACO', QuotePermID = 21474913868.0, ExchCode = 'BUR', PermQuoteRetireDate = '2010-08-19', endDate = '2010-08-18' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 66291 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 67742 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 68473 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE312M01024', RkdSEDOL = 'C0471N', RkdCUSIP = 'Y445ZW10', DsPrimQtSedol = 'C0471N5', PermSecMapEndDate = '2026-08-06', endDate = '2026-08-06' WHERE SecCode = 69705 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73598 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75111 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75277 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 Name = 'METROCON HLDGS LTD NPV (POST-SPLT)' WHERE SecCode = 77332 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'SEVE.BO^H26', RkdIssueStatus = 0.0, PermOrgIPODate = NULL WHERE SecCode = 81568 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET Name = 'INDAH KIAT PULP&PA IDR1000' WHERE SecCode = 84547 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BMVD0Q7' WHERE SecCode = 86443 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 = 90016 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 93659 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 93909 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 94982 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 ISIN = NULL, Name = 'TVB LTD NPV' WHERE SecCode = 97150 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 100604 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'SGP' WHERE SecCode = 112291 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 DsCtryQtStatus = 'S' WHERE SecCode = 140586 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 145938 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 192507 AND Type_ = 10;
UPDATE data_universe SET Name = 'BANK CAPITAL INDON IDR100' WHERE SecCode = 325412 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CEL', DsPrimQtSedol = 'B28V912' WHERE SecCode = 332462 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000135065.0, PriInstrPermID = 8591016916.0, PriTRBCIndPermID = NULL WHERE SecCode = 358152 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 395045 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 395046 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 548524 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 553958 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 726788 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ZAF' WHERE SecCode = 804226 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 821300 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1619265 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 2253409 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-08-07', PermSecMapEndDate = '2026-08-06', endDate = '2026-08-06' WHERE SecCode = 2339260 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '1246.HK^H26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-08-07', PermQuoteRetireDate = '2026-08-07', PermSecMapEndDate = '2026-08-06', endDate = '2026-08-06' WHERE SecCode = 2372649 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2535221 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2745145 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BT7JJ94', PermSecMapEndDate = '2026-08-06', endDate = '2026-08-06' WHERE SecCode = 2835254 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-07' WHERE SecCode = 2919788 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2984547 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951774.0 WHERE SecCode = 3038373 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951284.0 WHERE SecCode = 3118169 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951806.0 WHERE SecCode = 3120762 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3187179 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-07' WHERE SecCode = 3196947 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'BPP.BK^G26', RkdIssueStatus = 0.0, PermOrgIPODate = NULL WHERE SecCode = 3258936 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3259989 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951753.0 WHERE SecCode = 3305658 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21610513041.0, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21858470979.0, ExchCode = 'FRA', PermQuoteRetireDate = '2024-01-03', endDate = '2023-12-29' WHERE SecCode = 3436782 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3564647 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528792.0, ExchCode = 'FRA' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET Name = 'MULTIQURE SA PLN0.10' WHERE SecCode = 3693373 AND Type_ = 10;
UPDATE data_universe SET Name = 'SCALARE PTNRS HLDG NPV' WHERE SecCode = 3721200 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CEL', DsPrimQtSedol = 'B28V912' WHERE SecCode = 3827940 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951321.0 WHERE SecCode = 3852662 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 = 'WAVUS CO LTD KRW500' WHERE SecCode = 4029409 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4038216 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4053515 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 4264582 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 = 'D', DsSecDelistDate = '2026-08-06' WHERE SecCode = 4314985 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4451120 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4466617 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-06', endDate = '2026-08-06' WHERE SecCode = 4502156 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 123758.0 WHERE SecCode = 4552176 AND Type_ = 10;
UPDATE data_universe SET Name = 'GETO NEW MATERIALS A CNY1' WHERE SecCode = 4558219 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 Name = 'TRUSTBTC SA PLN0.10' WHERE SecCode = 4705726 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21860598463.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-10-09' WHERE SecCode = 4800907 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'J0332612' WHERE SecCode = 4852113 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21932177205.0, ExchCode = 'MUN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5146920 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'NSE' WHERE SecCode = 5155289 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951312.0 WHERE SecCode = 5178468 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5410102 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5464396 AND Type_ = 10;
UPDATE data_universe SET Name = 'MULTI GARAM UTAMA IDR20' WHERE SecCode = 5490563 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'VISDEM', RkdRIC = 'VISY.NS', RkdDisplayRIC = 'VISY.NS', Name = 'VISDEM TECHNOSYS INR10' WHERE SecCode = 5536095 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951312.0 WHERE SecCode = 5904433 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5978189 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951312.0 WHERE SecCode = 6601462 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951312.0 WHERE SecCode = 6601464 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951319.0 WHERE SecCode = 6601472 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951328.0 WHERE SecCode = 6902161 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6917390 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6945362 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-08-07', SecMapEndDate = '2026-08-06', endDate = '2026-08-06' WHERE SecCode = 6960490 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y6T0N910' WHERE SecCode = 6967192 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6969135 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6974605 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'ES0106043005', RkdTicker = 'DIGIS', RkdSEDOL = 'BWPHNP', RkdCUSIP = 'E3R93Y10', RkdRIC = 'DIGIS.MC', RkdDisplayRIC = 'DIGIS.MC', RkdCode = 145307.0, RkdIssueID = 1.0, RkdIssueCode = 185947.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'MCE', RkdExchCtry = 'ESP', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6985983 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7017409 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'COPR.K', RkdDisplayRIC = 'COPR.A', RkdExchCode = 'ASE' WHERE SecCode = 10920375 AND Type_ = 1;
UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 11014480 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA2902576099', RkdSEDOL = 'BTMRFL', RkdCUSIP = '29025760', RkdRIC = 'BABY.CD', RkdDisplayRIC = 'BABY.CD', RkdExchCode = 'CNQ' WHERE SecCode = 11027686 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-08-06' WHERE SecCode = 11027691 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2012-09-20' WHERE SecCode = 11033683 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11158354 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11158355 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-07', endDate = '2026-08-07' WHERE SecCode = 11187718 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BT6M488' WHERE SecCode = 11197007 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236811734356.0, ExchCode = 'NAS', PermSecMapStartDate = '2026-08-04', startDate = '2019-11-07' WHERE SecCode = 11202000 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'QBTS.O', RkdDisplayRIC = 'QBTS.OQ', RkdExchCode = 'NASD' WHERE SecCode = 11216054 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BT6ML76' WHERE SecCode = 11223868 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11238417 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5096767156.0, PriInstrPermID = 25727201584.0, DomCntry = 'JPN', IncCntry = 'CYM', PriTRBCIndPermID = 4294951411.0, PermOrgIPODate = '2026-07-24', startDate = '2026-02-20' WHERE SecCode = 11240505 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US83301J3086', RkdSEDOL = 'BTCLFS', RkdCUSIP = '83301J30' WHERE SecCode = 11247311 AND Type_ = 1;
UPDATE data_universe SET Name = 'EGL TECHNOLOGY INC COM SHS' WHERE SecCode = 11255741 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11261930 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000205939.0, PriInstrPermID = 232845843099.0, IncCntry = 'USA', PriTRBCIndPermID = 4294951263.0, PermOrgIPODate = '2024-06-12' WHERE SecCode = 11266044 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BT6ML87' WHERE SecCode = 11272226 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11273567 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000201915.0, PriInstrPermID = 232831314190.0, PriTRBCIndPermID = 4294951649.0, PermOrgIPODate = '2025-01-29' WHERE SecCode = 11274425 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000201915.0, PriInstrPermID = 232831314190.0, PriTRBCIndPermID = 4294951649.0, PermOrgIPODate = '2025-01-29', startDate = '2025-01-29' WHERE SecCode = 11274771 AND Type_ = 1;
UPDATE data_universe SET DsExchMnem = 'CNQ', PermSecMapEndDate = '2026-08-06', endDate = '2026-08-06' WHERE SecCode = 11278535 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2026-01-30' WHERE SecCode = 11289849 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2026-01-30', startDate = '2026-01-30' WHERE SecCode = 11293574 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11297350 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11298598 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11298973 AND Type_ = 1;
UPDATE data_universe SET DsExchQtStartDate = '2026-07-30' WHERE SecCode = 11299694 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11300030 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236811734238.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11300033 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 236811875746.0, PriValQuotePermID = 25726994814.0 WHERE SecCode = 11300122 AND Type_ = 1;