UPDATE model_universe SET DsPrimQtSedol = 'BWPD4D8', PermSecMapEndDate = '2026-06-24', endDate = '2026-06-24' WHERE SecCode = 430 AND Type_ = 10;
UPDATE model_universe SET DsPrimQtSedol = 'BNVVWV7' WHERE SecCode = 13989 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 18802 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 23502 AND Type_ = 1;
UPDATE model_universe SET DomCntry = NULL WHERE SecCode = 33326 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 34611 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 49873 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 50014 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951544.0 WHERE SecCode = 56330 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951860.0 WHERE SecCode = 64017 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 67390 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'USA' WHERE SecCode = 68148 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 1004365480.0 WHERE SecCode = 69150 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70873 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71997 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 76157 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 77184 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'AU0000470981', RkdTicker = 'BXNDA', RkdSEDOL = 'BTZCS5', RkdRIC = 'BXNDA.AX', RkdDisplayRIC = 'BXNDA.AX', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 78713 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 82770 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 82820 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 83511 AND Type_ = 10;
UPDATE model_universe SET Name = 'BLADEX INC SHS E' WHERE SecCode = 86958 AND Type_ = 1;
UPDATE model_universe SET DomCntry = 'BMU' WHERE SecCode = 87392 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'KAISA HEALTH GROUP HKD0.0625' WHERE SecCode = 89269 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 90338 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'XINHUA NEWS MEDIA HKD0.4 POST CONS' WHERE SecCode = 91736 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-25', SecMapEndDate = '2026-06-24', PermSecMapEndDate = '2026-06-24', endDate = '2026-06-24' WHERE SecCode = 94669 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 1004365417.0 WHERE SecCode = 95086 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = '2026-06-23', endDate = '2026-06-23' WHERE SecCode = 96476 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951587.0 WHERE SecCode = 99350 AND Type_ = 10;
UPDATE model_universe SET QuotePermID = 21898260294, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951266.0 WHERE SecCode = 112239 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 113210 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 127118 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 140900 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 143572 AND Type_ = 10;
UPDATE model_universe SET PermSecMapEndDate = '2026-06-23' WHERE SecCode = 206733 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 291871 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 391247 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 542367 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'TWN' WHERE SecCode = 558297 AND Type_ = 10;
UPDATE model_universe SET Name = 'KEM TECH CORP KRW500' WHERE SecCode = 564083 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1557092 AND Type_ = 10;
UPDATE model_universe SET Name = 'JAKOTA CAPITAL (HO HKD0.5' WHERE SecCode = 1660603 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'PKP CARGO SA PLN1.00' WHERE SecCode = 2387340 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 2513984 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 2747503 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2747569 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 2830906 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2914936 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951854.0 WHERE SecCode = 3044062 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 3281930 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'LAFANG JIAHUA CO A CNY1' WHERE SecCode = 3317251 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3384465 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951447.0 WHERE SecCode = 3408076 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951255.0 WHERE SecCode = 3644456 AND Type_ = 10;
UPDATE model_universe SET PermSecMapEndDate = '2026-06-23' WHERE SecCode = 3703402 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3978265 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4287534 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951855.0 WHERE SecCode = 4539159 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951410.0 WHERE SecCode = 4542562 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 1004365429.0 WHERE SecCode = 4553949 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 4557737 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 PriTRBCIndPermID = 1004365435.0 WHERE SecCode = 4751036 AND Type_ = 10;
UPDATE model_universe SET Name = 'MENGTIAN HOME GP A CNY1' WHERE SecCode = 4807507 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951797.0 WHERE SecCode = 4973304 AND Type_ = 10;
UPDATE model_universe SET Name = 'BURJEEL HLDGS PLC AED0.1' WHERE SecCode = 5188797 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951868.0 WHERE SecCode = 5213046 AND Type_ = 10;
UPDATE model_universe SET Name = 'SRIBS CONSULTING ''A'' CNY1' WHERE SecCode = 5359400 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 6734290 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 6748879 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 6880027 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'HAPN', RkdRIC = 'HAPN.O', RkdDisplayRIC = 'HAPN.OQ', RkdExchCode = 'NASD' WHERE SecCode = 11142751 AND Type_ = 1;
UPDATE model_universe SET PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 11234124 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = NULL, startDate = '2025-04-18' WHERE SecCode = 11277550 AND Type_ = 1;