UPDATE model_universe SET PermIDTicker = NULL, QuotePermID = 21475442988, ExchCode = 'CHI' WHERE SecCode = 4772 AND Type_ = 10; UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 18047 AND Type_ = 1; UPDATE model_universe SET OrgTypeCode = 'COM' WHERE SecCode = 27910 AND Type_ = 1; UPDATE model_universe SET OrgTypeCode = 'COM' WHERE SecCode = 27911 AND Type_ = 1; UPDATE model_universe SET DsPrimQtSedol = 'BXM1HJ9' WHERE SecCode = 28391 AND Type_ = 1; UPDATE model_universe SET PermIDTicker = 'MACO.I', QuotePermID = 21475575870, ExchCode = 'CCH', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 45892 AND Type_ = 10; UPDATE model_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 47438 AND Type_ = 10; UPDATE model_universe SET PriTRBCIndPermID = 4294951822.0 WHERE SecCode = 50801 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 59148 AND Type_ = 10; UPDATE model_universe SET PriTRBCIndPermID = 4294951391.0 WHERE SecCode = 66162 AND Type_ = 10; UPDATE model_universe SET Name = 'METRODATA ELECTRON IDR10' WHERE SecCode = 74610 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76411 AND Type_ = 10; UPDATE model_universe SET Name = 'BLS PHARM LTD NPV', SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 78713 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81778 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85888 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-07', SecMapEndDate = '2026-06-25', PermQuoteRetireDate = '2026-07-07', PermSecMapEndDate = '2026-07-07', endDate = '2026-06-25' WHERE SecCode = 96110 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 96998 AND Type_ = 10; UPDATE model_universe SET QuotePermID = 21898257779, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 114799 AND Type_ = 10; UPDATE model_universe SET Name = 'QUALITY HOUSES BUS THB8.1747 (LOCAL) REIT' WHERE SecCode = 186191 AND Type_ = 10; UPDATE model_universe SET Name = 'NOMAD PWR SOLUTIONS INC COM', PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 320972 AND Type_ = 1; UPDATE model_universe SET DomCntry = 'USA' WHERE SecCode = 321914 AND Type_ = 1; UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 351431 AND Type_ = 10; UPDATE model_universe SET PermIDTicker = 'VNE', DsCtryQtStatus = 'A', PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'UPC', DsSecDelistDate = NULL, SecMapEndDate = '2079-06-06', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-07-07', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 522937 AND Type_ = 10; UPDATE model_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 1556960 AND Type_ = 10; UPDATE model_universe SET RkdRIC = '203690.KQ^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, DsSecDelistDate = '2026-07-08', SecMapEndDate = '2026-07-07', PermSecMapEndDate = '2026-07-07', endDate = '2026-07-07' WHERE SecCode = 2646553 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3026618 AND Type_ = 10; UPDATE model_universe SET Name = 'HAOSEN FINTECH GP HKD0.002' WHERE SecCode = 3378474 AND Type_ = 10; UPDATE model_universe SET ISIN = NULL WHERE SecCode = 3401662 AND Type_ = 10; UPDATE model_universe SET RkdISIN = 'BRECOMACNOR9', RkdTicker = 'ECOM3', PermIDTicker = 'ECOM3', RkdRIC = 'ECOM3.SA', RkdDisplayRIC = 'ECOM3.SA', DsPrimQtSedol = 'BXPVNL0', PermSecMapEndDate = '2026-07-07', endDate = '2026-07-07' WHERE SecCode = 4657577 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5072141 AND Type_ = 10; UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 6945369 AND Type_ = 10; UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 10933963 AND Type_ = 1; UPDATE model_universe SET Name = 'TECNOGLASS INC COM' WHERE SecCode = 11028764 AND Type_ = 1; UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-08', endDate = '2026-07-08' WHERE SecCode = 11080057 AND Type_ = 1; UPDATE model_universe SET Name = 'DISCOVERY MNG LTD COM' WHERE SecCode = 11105323 AND Type_ = 1; UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11182627 AND Type_ = 1; UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11204164 AND Type_ = 1; UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11207414 AND Type_ = 1; UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-08', SecMapEndDate = '2026-07-06', endDate = '2026-07-06' WHERE SecCode = 11231455 AND Type_ = 1; UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11272674 AND Type_ = 1; UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11273677 AND Type_ = 1; UPDATE model_universe SET ExchCode = 'NMS' WHERE SecCode = 11279727 AND Type_ = 1; UPDATE model_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 11291638 AND Type_ = 1; UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 11297326 AND Type_ = 1;