UPDATE model_universe SET ISIN = NULL, Name = 'BATICIM BATI ANADO TRY1 (B SHARES)' WHERE SecCode = 36128 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'COFB.BR^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', PermQuoteRetireDate = '2026-07-01', endDate = '2026-06-30' WHERE SecCode = 36833 AND Type_ = 10;
UPDATE model_universe SET DsPrimQtSedol = 'BPXZLR0' WHERE SecCode = 60432 AND Type_ = 1;
UPDATE model_universe SET ISIN = NULL, Name = 'BATICIM CIMENTO SA TRY1 (B SHARES)' WHERE SecCode = 65907 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 68204 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 68209 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 69136 AND Type_ = 10;
UPDATE model_universe SET PermQuoteRetireDate = '2026-07-06' WHERE SecCode = 72507 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'GUJENERGY' WHERE SecCode = 72544 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', PermQuoteRetireDate = '2026-07-01', endDate = '2026-06-30' WHERE SecCode = 72952 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73995 AND Type_ = 10;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 74536 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-29' WHERE SecCode = 76126 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76748 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'CHINA NETCOM TECHN HKD0.25' WHERE SecCode = 79390 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79888 AND Type_ = 10;
UPDATE model_universe SET Name = 'MINING AMERICAS INC COM SHS', PermSecMapEndDate = '2026-01-03', endDate = '2026-01-03' WHERE SecCode = 80076 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 82584 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85483 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951742.0 WHERE SecCode = 85852 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 91086 AND Type_ = 10;
UPDATE model_universe SET PermSecMapEndDate = '2026-06-29', endDate = '2026-06-29' WHERE SecCode = 94266 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 94873 AND Type_ = 10;
UPDATE model_universe SET PermQuoteRetireDate = '2026-07-03' WHERE SecCode = 95203 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 97012 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'DNK' WHERE SecCode = 100680 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'USA' WHERE SecCode = 114440 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 120444 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'CYM' WHERE SecCode = 123508 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'IND' WHERE SecCode = 139134 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142684 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'VOIM' WHERE SecCode = 212058 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 293429 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 298971 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'ECHO', RkdRIC = 'ECHO.O', RkdDisplayRIC = 'ECHO.OQ' WHERE SecCode = 335216 AND Type_ = 1;
UPDATE model_universe SET DomCntry = 'CHN' WHERE SecCode = 355015 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', PermQuoteRetireDate = '2026-07-01', endDate = '2026-06-30' WHERE SecCode = 409378 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 533042 AND Type_ = 10;
UPDATE model_universe SET Name = 'KMD BRANDS LTD NPV POST SPLIT' WHERE SecCode = 552491 AND Type_ = 10;
UPDATE model_universe SET Name = 'UNIFY GROUP EUR0.02' WHERE SecCode = 555021 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1241264 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', PermQuoteRetireDate = '2026-07-01', endDate = '2026-06-30' WHERE SecCode = 1622819 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', endDate = '2026-06-30' WHERE SecCode = 2394793 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2455560 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2606470 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2862763 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2911314 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-29' WHERE SecCode = 3217845 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 3244872 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3276033 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3282988 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'VEONa', QuotePermID = 21610682901, ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-11' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3354056 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951237.0 WHERE SecCode = 3392421 AND Type_ = 10;
UPDATE model_universe SET Name = 'HUA XIA WATER GROU HKD0.01' WHERE SecCode = 3441674 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'DDG', DsCtryQtStatus = 'A', PermQuoteStatus = 'AC', ExchCode = 'UPC', DsSecDelistDate = NULL, SecMapEndDate = '2079-06-06', PermQuoteRetireDate = NULL, endDate = '2026-06-23' WHERE SecCode = 3703402 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3887973 AND Type_ = 10;
UPDATE model_universe SET Name = 'GREEN POWER GROU HKD0.01' WHERE SecCode = 4010777 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4201682 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 4388301 AND Type_ = 10;
UPDATE model_universe SET PermQuoteRetireDate = '2026-07-03' WHERE SecCode = 4494105 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4557737 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4617629 AND Type_ = 10;
UPDATE model_universe SET QuotePermID = 21884462002, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22', endDate = '2024-10-21' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4733111 AND Type_ = 10;
UPDATE model_universe SET Name = 'NINE & CO INC KRW100' WHERE SecCode = 4936070 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5146920 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5350554 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951709.0 WHERE SecCode = 5353894 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5397477 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5443486 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'NSLR', RkdRIC = 'NSLR.O', RkdDisplayRIC = 'NSLR.OQ', Name = 'NEOSTELLAR CAPITAL CORP COM NEW' WHERE SecCode = 11002274 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', endDate = '2026-06-30' WHERE SecCode = 11178625 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = '2026-04-11', endDate = '2026-04-11' WHERE SecCode = 11196712 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11201544 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'BRSCTV0' WHERE SecCode = 11210122 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'BPXZLQ9' WHERE SecCode = 11225381 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = '2025-04-11', endDate = '2025-04-11' WHERE SecCode = 11227447 AND Type_ = 1;
UPDATE model_universe SET OrgPermID = 5096906340, DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 1004365393.0, PermOrgIPODate = '2026-06-26', startDate = '2022-01-25' WHERE SecCode = 11237342 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 11255442 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11256494 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11264180 AND Type_ = 1;
UPDATE model_universe SET Name = 'MAREX GROUP LIMITED ORD', DsPrimQtSedol = 'BSBB331' WHERE SecCode = 11264576 AND Type_ = 1;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 11270991 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'US87821B1098', RkdTicker = 'TMS', RkdSEDOL = 'BVSRPN', RkdCUSIP = '87821B10', RkdRIC = 'TMS.O', RkdDisplayRIC = 'TMS.OQ' WHERE SecCode = 11277550 AND Type_ = 1;
