UPDATE model_universe SET ISIN = NULL, Name = 'JOHNSON MATTHEY ORD GBP1.478994', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 6872 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-08-17', SecMapEndDate = '2026-08-14', PermQuoteRetireDate = '2026-08-17', PermSecMapEndDate = '2026-08-17', endDate = '2026-08-14' WHERE SecCode = 7360 AND Type_ = 1;
UPDATE model_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 9081 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'VMRK', RkdRIC = 'VMRK.K', RkdDisplayRIC = 'VMRK.N', Name = 'VIVMARK RESIDENTIAL SH BEN INT' WHERE SecCode = 24399 AND Type_ = 1;
UPDATE model_universe SET Name = 'FRANKLIN TEMPLETON INC COM' WHERE SecCode = 28262 AND Type_ = 1;
UPDATE model_universe SET ISIN = NULL, Name = 'PROFUTURO AFP PEN1800.69' WHERE SecCode = 30331 AND Type_ = 10;
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 DsExchMnem = 'NAS' WHERE SecCode = 53259 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 68018 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-08-18', SecMapEndDate = '2026-07-29', PermQuoteRetireDate = '2026-08-18', PermSecMapEndDate = '2026-08-17', endDate = '2026-07-29' WHERE SecCode = 69823 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'SPELS', QuotePermID = 236812542357, ExchCode = 'NSI' WHERE SecCode = 72144 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'TUTIALKA', QuotePermID = 236812542378, ExchCode = 'NSI' WHERE SecCode = 72736 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'AVANCE', QuotePermID = 236812532359, ExchCode = 'NSI' WHERE SecCode = 76634 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'SWISSMLTRY', PermIDTicker = 'SWISSMLTRY', RkdRIC = 'SWIS.NS', RkdDisplayRIC = 'SWIS.NS', RkdExchCode = 'NSE', QuotePermID = 236812542369, ExchCode = 'NSI' WHERE SecCode = 78194 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'VOITHPAPR', QuotePermID = 236812542389, ExchCode = 'NSI' WHERE SecCode = 78264 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'SEKURITIND', QuotePermID = 236812542344, ExchCode = 'NSI' WHERE SecCode = 78556 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'ZIJIN LONGKING CO ''A''CNY1' WHERE SecCode = 78697 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'TANAA', QuotePermID = 236812542372, ExchCode = 'NSI' WHERE SecCode = 78962 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'ACGL', QuotePermID = 236812532357, ExchCode = 'NSI' WHERE SecCode = 79532 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'ANDREWYU', QuotePermID = 236812532350, ExchCode = 'NSI' WHERE SecCode = 79991 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'LOTUSCHO', QuotePermID = 236812542309, ExchCode = 'NSI' WHERE SecCode = 81054 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'JYOTIRES', QuotePermID = 236812532396, ExchCode = 'NSI' WHERE SecCode = 81153 AND Type_ = 10;
UPDATE model_universe SET DsPrimQtSedol = 'C051N29' WHERE SecCode = 85397 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = NULL, RkdRIC = '2323.HK^H26', RkdIssueStatus = 0, SecMapEndDate = '2026-08-14', PermSecMapEndDate = '2026-08-16', endDate = '2026-08-14' WHERE SecCode = 87246 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 89214 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-18', endDate = '2026-08-18' WHERE SecCode = 90405 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-18', endDate = '2026-08-18' WHERE SecCode = 91266 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = 'PERMAGN', QuotePermID = 236812542337, ExchCode = 'NSI' WHERE SecCode = 92344 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'ECORECO', QuotePermID = 236812532379, ExchCode = 'NSI' WHERE SecCode = 93183 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'WATERBASE', PermIDTicker = 'WATERBASE', RkdRIC = 'WTRB.NS', RkdDisplayRIC = 'WTRB.NS', RkdExchCode = 'NSE', QuotePermID = 236812542392, ExchCode = 'NSI' WHERE SecCode = 98704 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'HAZOOR', QuotePermID = 236812532388, ExchCode = 'NSI' WHERE SecCode = 111840 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'ORIRAIL', QuotePermID = 236812542330, ExchCode = 'NSI' WHERE SecCode = 115973 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'SHIVACEM', QuotePermID = 236812542352, ExchCode = 'NSI' WHERE SecCode = 125364 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'ONIXSOLAR', QuotePermID = 236812532401, ExchCode = 'NSI' WHERE SecCode = 125442 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'MOHITE', QuotePermID = 236812542306, ExchCode = 'NSI' WHERE SecCode = 126268 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'AXTEL', QuotePermID = 236812532360, ExchCode = 'NSI' WHERE SecCode = 130883 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'ISTLTD', QuotePermID = 236812532391, ExchCode = 'NSI' WHERE SecCode = 134766 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'EBIX', QuotePermID = 236812532377, ExchCode = 'NSI' WHERE SecCode = 135128 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'BMU' WHERE SecCode = 143568 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 170844 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-08-17', PermQuoteRetireDate = '2026-08-17', PermSecMapEndDate = '2026-08-17', endDate = '2026-08-17' WHERE SecCode = 186577 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'TGVSL', QuotePermID = 236812542374, ExchCode = 'NSI' WHERE SecCode = 202359 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'EMPIND', QuotePermID = 236812532381, ExchCode = 'NSI' WHERE SecCode = 258785 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'CRSL', QuotePermID = 236812532373, ExchCode = 'NSI' WHERE SecCode = 288469 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'ADVANCED TECHNOL KWD0.1' WHERE SecCode = 319924 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'VTMLTD', PermIDTicker = 'VTMLTD', RkdRIC = 'VTML.NS', RkdDisplayRIC = 'VTML.NS', RkdExchCode = 'NSE', QuotePermID = 236812542387, ExchCode = 'NSI' WHERE SecCode = 322335 AND Type_ = 10;
UPDATE model_universe SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 381505 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'KMCSHIL', QuotePermID = 236812542311, ExchCode = 'NSI' WHERE SecCode = 420073 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 547478 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueCode = 80578.0 WHERE SecCode = 564890 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'ENKEIWHEL', QuotePermID = 236812532380, ExchCode = 'NSI' WHERE SecCode = 1220836 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-18', SecMapEndDate = '2026-08-14', PermSecMapEndDate = '2026-08-17', endDate = '2026-08-14' WHERE SecCode = 1587600 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'VIRTUALG', QuotePermID = 236812542384, ExchCode = 'NSI' WHERE SecCode = 2002197 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'ONEGLOBAL', QuotePermID = 236812532402, ExchCode = 'NSI' WHERE SecCode = 2530467 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'VISHAL', PermIDTicker = 'VISHAL', RkdRIC = 'VIFA.NS', RkdDisplayRIC = 'VIFA.NS', RkdExchCode = 'NSE', QuotePermID = 236812542390, ExchCode = 'NSI' WHERE SecCode = 2622965 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'TOYAMSL', QuotePermID = 236812532411, ExchCode = 'NSI' WHERE SecCode = 2625813 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'MIIL', PermIDTicker = 'MIIL', RkdRIC = 'MEGC.NS', RkdDisplayRIC = 'MEGC.NS', RkdExchCode = 'NSE', QuotePermID = 236812542305, ExchCode = 'NSI' WHERE SecCode = 2643273 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'WARDINMOBI', QuotePermID = 236812542391, ExchCode = 'NSI' WHERE SecCode = 2825602 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'SUNRAKSHAK', QuotePermID = 236812542362, ExchCode = 'NSI' WHERE SecCode = 2963532 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'PANORAMA', QuotePermID = 236812542331, ExchCode = 'NSI' WHERE SecCode = 3033926 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'BLUECLOUDS', QuotePermID = 236812532363, ExchCode = 'NSI' WHERE SecCode = 3077437 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'FREDUN', QuotePermID = 236812532384, ExchCode = 'NSI' WHERE SecCode = 3118174 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'LANCER', PermIDTicker = 'LANCER', RkdRIC = 'LANC.NS', RkdDisplayRIC = 'LANC.NS', RkdExchCode = 'NSE', QuotePermID = 236812542307, ExchCode = 'NSI' WHERE SecCode = 3133062 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3258797 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 PermIDTicker = 'SGRL', QuotePermID = 236812542347, ExchCode = 'NSI' WHERE SecCode = 3396697 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3396703 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'DEEP', QuotePermID = 236812532375, ExchCode = 'NSI' WHERE SecCode = 3596594 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 3915673 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4036729 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4168437 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4379702 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 4429559 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'EKI', QuotePermID = 236812532382, ExchCode = 'NSI' WHERE SecCode = 4557791 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 PermIDTicker = 'PM1', DsPrimQtSedol = 'BVK8SY0', PermSecMapEndDate = '2026-08-17', endDate = '2026-08-17' WHERE SecCode = 4702568 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 5712059 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 6829246 AND Type_ = 10;
UPDATE model_universe SET Country = 'JPN' WHERE SecCode = 6921032 AND Type_ = 10;
UPDATE model_universe SET DsPrimQtSedol = 'BT06SY0' WHERE SecCode = 10913025 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = 'ALM', RkdSEDOL = 'BS84NZ', RkdRIC = 'ALM.O', RkdDisplayRIC = 'ALM.OQ', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 10964740 AND Type_ = 1;
UPDATE model_universe SET RkdCUSIP = 'M6S83C10' WHERE SecCode = 11146091 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = NULL, RkdRIC = 'TALK.OQ^H26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, DsSecDelistDate = '2026-08-18', SecMapEndDate = '2026-08-14', endDate = '2026-08-14' WHERE SecCode = 11210508 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'BT06T03' WHERE SecCode = 11218761 AND Type_ = 1;
UPDATE model_universe SET RkdSEDOL = 'BV86X4' WHERE SecCode = 11226875 AND Type_ = 1;
UPDATE model_universe SET Name = 'QMMM HOLDINGS LTD COM SHS CL A' WHERE SecCode = 11267479 AND Type_ = 1;
UPDATE model_universe SET Name = 'AIR WATER VENTURES LTD ORD SHS', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11279412 AND Type_ = 1;