UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 5979 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-22', SecMapEndDate = '2026-07-20', endDate = '2026-07-20' WHERE SecCode = 17852 AND Type_ = 1;
UPDATE model_universe SET PriInstrPermID = NULL WHERE SecCode = 26606 AND Type_ = 1;
UPDATE model_universe SET RkdIssueStatus = 1 WHERE SecCode = 28992 AND Type_ = 10;
UPDATE model_universe SET Name = 'SINOPROS CORP LTD NPV (POST CONS)' WHERE SecCode = 70265 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71115 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'DELEK GROUP ILS0.1(POST SUBD)' WHERE SecCode = 75262 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951267.0 WHERE SecCode = 77113 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 77326 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'AU0000477796', RkdTicker = 'BLS', RkdSEDOL = 'BWW2M9', RkdCUSIP = 'Q7747417', RkdRIC = 'BLS.AX', RkdDisplayRIC = 'BLS.AX' WHERE SecCode = 78713 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 83107 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87838 AND Type_ = 10;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 87947 AND Type_ = 10;
UPDATE model_universe SET Name = 'ALL ENERGY & UTIL THB0.5 (LOCAL)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 90115 AND Type_ = 10;
UPDATE model_universe SET PriInstrPermID = NULL WHERE SecCode = 93063 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-22', SecMapEndDate = '2026-07-21', PermSecMapEndDate = '2026-07-21', endDate = '2026-07-21' WHERE SecCode = 96636 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'GORO', RkdRIC = 'GORO.V', RkdDisplayRIC = 'GORO.V' WHERE SecCode = 99271 AND Type_ = 1;
UPDATE model_universe SET Name = 'PONDY OXIDES & CHE INR2(POST SUBD)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 112417 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125696 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 170844 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 179072 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 309233 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 309977 AND Type_ = 10;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 322922 AND Type_ = 1;
UPDATE model_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-21' WHERE SecCode = 331577 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 343233 AND Type_ = 10;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 354792 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 632190 AND Type_ = 10;
UPDATE model_universe SET QuotePermID = 236792718878, PriValQuotePermID = NULL, IsPrimaryQuote = 0, ExchCode = 'KNT' WHERE SecCode = 810847 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'MULTIPOLAR TECHNOL IDR4' WHERE SecCode = 2287227 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951201.0 WHERE SecCode = 2603246 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2700365 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'BCG', PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'UPC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-07-21', PermSecMapEndDate = NULL, startDate = '2015-07-16', endDate = NULL WHERE SecCode = 2935048 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 RkdTicker = 'TCD', PermIDTicker = 'TCD', RkdSEDOL = NULL, RkdRIC = 'TCD.HNO', RkdDisplayRIC = 'TCD.HNO', RkdIssueStatus = 1, RkdExchCode = 'UPC', PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'UPC', DsSecDelistDate = NULL, SecMapEndDate = '2079-06-06', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-07-21', PermSecMapEndDate = NULL, startDate = '2017-05-26', endDate = NULL WHERE SecCode = 3354563 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4359799 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'STRK' WHERE SecCode = 4429541 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4487673 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951642.0 WHERE SecCode = 4807507 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5072141 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5443486 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 6917604 AND Type_ = 10;
UPDATE model_universe SET IncCntry = 'CAN' WHERE SecCode = 10780359 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11151222 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = 'CHGA', RkdRIC = 'CHGA.O', RkdDisplayRIC = 'CHGA.OQ', Name = 'CHANGE AGENTS CORPORATION COM' WHERE SecCode = 11156680 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11181200 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'US1979141041', RkdSEDOL = 'BVK35P', RkdCUSIP = '19791410' WHERE SecCode = 11184721 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11192828 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = NULL, startDate = '2016-08-17' WHERE SecCode = 11192844 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'C04L1R1' WHERE SecCode = 11193403 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11210266 AND Type_ = 1;
UPDATE model_universe SET RkdSEDOL = 'BVK0M1', PermOrgIPODate = NULL, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11214218 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11214381 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'KORE.N^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-21', SecMapEndDate = '2026-07-20', PermQuoteRetireDate = '2026-07-21', PermSecMapEndDate = '2026-07-21', endDate = '2026-07-20' WHERE SecCode = 11216102 AND Type_ = 1;
UPDATE model_universe SET Name = 'VULCAN INFRASTRUCTURE AND POWE CLASS A COM', PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11230326 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11240122 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11250670 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'C04JXJ1' WHERE SecCode = 11257710 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'US35661P1003', RkdTicker = 'FRNM', PermIDTicker = 'FRNM', RkdSEDOL = 'C04JZ2', RkdCUSIP = '35661P10', RkdRIC = 'FRNM.O', RkdDisplayRIC = 'FRNM.OQ', Name = 'FREENOME INC COMMON STOCK', Country = 'USA', ExchCode = 'NAS', PermOrgIPODate = NULL WHERE SecCode = 11266044 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = 'MEDS', RkdRIC = 'MEDS.O', RkdDisplayRIC = 'MEDS.OQ', Name = 'DATAMEDS AI INC COM' WHERE SecCode = 11275132 AND Type_ = 1;
UPDATE model_universe SET OrgPermID = 6000192799, PriInstrPermID = 232898803122.0, DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951179.0, PermOrgIPODate = '2025-09-30' WHERE SecCode = 11286103 AND Type_ = 1;
