UPDATE model_universe SET ISIN = NULL, Name = 'PEBBLE BEACH SYSTE ORD GBP0.005' WHERE SecCode = 1929 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A', DsSecDelistDate = NULL, SecMapEndDate = '2079-06-06', endDate = '2026-07-13' WHERE SecCode = 29401 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = NULL WHERE SecCode = 30735 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = NULL WHERE SecCode = 30742 AND Type_ = 10;
UPDATE model_universe SET RkdIssueStatus = 0, PermQuoteRetireDate = '2026-07-31', PermSecMapEndDate = '2026-07-31', endDate = '2026-07-31' WHERE SecCode = 33139 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'MACO', QuotePermID = 21474913868, ExchCode = 'BUR', PermQuoteRetireDate = '2010-08-19', endDate = '2010-08-18' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE model_universe SET IsMajorSec = 'Y' WHERE SecCode = 50540 AND Type_ = 1;
UPDATE model_universe SET ISIN = NULL, Name = 'AIS SAS KGAA NPV' WHERE SecCode = 51649 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 67612 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = '4367.T^G26', RkdIssueStatus = 0, PermSecMapEndDate = '2026-07-29' WHERE SecCode = 69109 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71845 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73534 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76411 AND Type_ = 10;
UPDATE model_universe SET PriValQuotePermID = NULL, IsPrimaryQuote = 0 WHERE SecCode = 83485 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'BMU' WHERE SecCode = 84805 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85899 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 89196 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = '2763.T^G26', RkdIssueStatus = 0, PermSecMapEndDate = '2026-07-29' WHERE SecCode = 89199 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 89771 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 91338 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 104850 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951912.0 WHERE SecCode = 126550 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 251973 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'AC' WHERE SecCode = 300646 AND Type_ = 1;
UPDATE model_universe SET SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 332462 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 395057 AND Type_ = 10;
UPDATE model_universe SET Name = 'E FOR L AIM PUBLIC THB0.5 (LOCAL)' WHERE SecCode = 464243 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 496999 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 1604270 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2455560 AND Type_ = 10;
UPDATE model_universe SET Name = 'ROOTK CO LTD KRW1000' WHERE SecCode = 2865468 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2926130 AND Type_ = 10;
UPDATE model_universe SET RkdSEDOL = 'BF20GH' WHERE SecCode = 3354563 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3629679 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4194828 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4542562 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5146920 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6846681 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-31', PermQuoteRetireDate = '2026-07-31', PermSecMapEndDate = '2026-07-31', endDate = '2026-07-31' WHERE SecCode = 10976948 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 10978767 AND Type_ = 1;
UPDATE model_universe SET Name = 'TECNOGLASS HOLDINGS INC COM', DsPrimQtSedol = 'BHCVTN5' WHERE SecCode = 11028764 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-31', SecMapEndDate = '2026-07-30', endDate = '2026-07-30' WHERE SecCode = 11182962 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 11221441 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'BT3L2N9' WHERE SecCode = 11233010 AND Type_ = 1;
UPDATE model_universe SET Name = 'TEVOGEN INC COM NEW' WHERE SecCode = 11236680 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 1004365417.0 WHERE SecCode = 11239698 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = 'GVHGF', RkdRIC = 'GVHGF.PK', RkdDisplayRIC = 'GVHGF.PK', RkdExchCode = 'OTC' WHERE SecCode = 11241899 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'BXL29L9' WHERE SecCode = 11274459 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'PTNM.OQ^G26', RkdIssueStatus = 0, PermQuoteStatus = 'DC', SecMapEndDate = '2025-10-03', PermQuoteRetireDate = '2026-07-30', PermSecMapEndDate = '2026-07-30', endDate = '2025-10-03' WHERE SecCode = 11278787 AND Type_ = 1;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 11297308 AND Type_ = 1;