UPDATE model_universe SET DsPrimQtSedol = 'BVYB5Y4' WHERE SecCode = 2459 AND Type_ = 1;
UPDATE model_universe SET SecMapEndDate = '2026-07-31', PermSecMapEndDate = '2026-08-03' WHERE SecCode = 3611 AND Type_ = 10;
UPDATE model_universe SET Name = 'CERENOME INC COM NEW' WHERE SecCode = 18270 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 PermSecMapEndDate = '2026-08-01', endDate = '2026-08-01' WHERE SecCode = 46706 AND Type_ = 1;
UPDATE model_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-07-20', PermSecMapEndDate = '2026-08-03', endDate = '2026-07-20' WHERE SecCode = 48360 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 68018 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-08-03', SecMapEndDate = '2026-07-16', PermQuoteRetireDate = '2026-07-31', PermSecMapEndDate = '2026-08-03', endDate = '2026-07-16' WHERE SecCode = 69239 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73145 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86795 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 88073 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'SOLT-M' WHERE SecCode = 88549 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'BMG2164J2089', RkdSEDOL = 'BVZJWH', RkdCUSIP = 'G2164J20' WHERE SecCode = 92897 AND Type_ = 10;
UPDATE model_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 137928 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'PHC' WHERE SecCode = 143799 AND Type_ = 10;
UPDATE model_universe SET PermSecMapEndDate = '2026-08-01', endDate = '2026-08-01' WHERE SecCode = 154474 AND Type_ = 1;
UPDATE model_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-08-03', endDate = '2026-08-03' WHERE SecCode = 161158 AND Type_ = 10;
UPDATE model_universe SET Name = 'TAKE SOLUTIONS INR1' WHERE SecCode = 318166 AND Type_ = 10;
UPDATE model_universe SET IncCntry = NULL WHERE SecCode = 347222 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'GOLDEN BRDG GP HOL NPV' WHERE SecCode = 401666 AND Type_ = 10;
UPDATE model_universe SET Name = 'CHYY DEVELOPMENT G USD0.01' WHERE SecCode = 565859 AND Type_ = 10;
UPDATE model_universe SET PermQuoteRetireDate = '2026-09-01' WHERE SecCode = 1278568 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2455560 AND Type_ = 10;
UPDATE model_universe SET Name = 'JIUFANG DIGITAL TE HKD0.2' WHERE SecCode = 2813094 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'MAISONS DU MONDE EUR0.001' WHERE SecCode = 3174281 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'SPRU.NS', RkdDisplayRIC = 'SPRU.NS' WHERE SecCode = 3185057 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-08-03', SecMapEndDate = '2026-07-31', PermQuoteRetireDate = '2026-07-31', PermSecMapEndDate = '2026-08-03', endDate = '2026-07-31' WHERE SecCode = 3258936 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = NULL, QuotePermID = 21610513041, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4036729 AND Type_ = 10;
UPDATE model_universe SET Name = 'JIUTAI DIGITAL TEC HKD0.001' WHERE SecCode = 4154006 AND Type_ = 10;
UPDATE model_universe SET DomCntry = NULL WHERE SecCode = 4850228 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'INE682M01020', RkdSEDOL = 'BXQ15X', RkdCUSIP = 'Y4S77P13' WHERE SecCode = 5527280 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'AEROPLANE' WHERE SecCode = 6756394 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 6945361 AND Type_ = 10;
UPDATE model_universe SET RkdIssueStatus = 0 WHERE SecCode = 10973754 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', SecMapEndDate = '2026-07-31', PermSecMapEndDate = '2026-08-03', endDate = '2026-07-31' WHERE SecCode = 11171838 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'US3724464017', RkdSEDOL = 'BV4JYK', RkdCUSIP = '37244640' WHERE SecCode = 11177776 AND Type_ = 1;
UPDATE model_universe SET Country = 'BMU', PriInstrPermID = 21631734783.0, IsPrimaryInstr = 1 WHERE SecCode = 11181200 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = '2026-07-31' WHERE SecCode = 11182962 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = '2026-08-01', endDate = '2026-08-01' WHERE SecCode = 11186433 AND Type_ = 1;
UPDATE model_universe SET PriInstrPermID = 21593061041.0, IsPrimaryInstr = 1, startDate = '2016-08-01' WHERE SecCode = 11192844 AND Type_ = 1;
UPDATE model_universe SET Name = 'STARLING ONCOLOGY INSTITUTE IN COM' WHERE SecCode = 11207431 AND Type_ = 1;
UPDATE model_universe SET PriInstrPermID = 25727310928.0, IsPrimaryInstr = 1, PermOrgIPODate = '2020-10-29' WHERE SecCode = 11214218 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', SecMapEndDate = '2026-07-30', PermSecMapEndDate = '2026-08-03', endDate = '2026-07-30' WHERE SecCode = 11222838 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = '2026-08-01', endDate = '2026-08-01' WHERE SecCode = 11242380 AND Type_ = 1;
UPDATE model_universe SET RkdSEDOL = 'BNYG4S', PermSecMapEndDate = '2026-08-01', endDate = '2026-08-01' WHERE SecCode = 11247303 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = '2026-08-01', endDate = '2026-08-01' WHERE SecCode = 11284287 AND Type_ = 1;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 11297671 AND Type_ = 1;