UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-03' WHERE SecCode = 3611 AND Type_ = 10; UPDATE model_universe SET PermIDTicker = 'CNSY' WHERE SecCode = 18270 AND Type_ = 1; UPDATE model_universe SET DsPrimQtSedol = 'BNYGM31' WHERE SecCode = 46706 AND Type_ = 1; UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-03', PermQuoteRetireDate = '2026-08-03', endDate = '2026-08-03' WHERE SecCode = 48360 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 68018 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69239 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70917 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71892 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73534 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81168 AND Type_ = 10; UPDATE model_universe SET ISIN = NULL WHERE SecCode = 85437 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86168 AND Type_ = 10; UPDATE model_universe SET PermIDTicker = 'SOLT-M' WHERE SecCode = 88549 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 89155 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 91338 AND Type_ = 10; UPDATE model_universe SET PermIDTicker = 'USAS', QuotePermID = 25727440034, ExchCode = 'ASE', PermSecMapStartDate = '2017-01-19' WHERE SecCode = 99085 AND Type_ = 1; UPDATE model_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 134942 AND Type_ = 10; UPDATE model_universe SET DsPrimQtSedol = 'BNYGJZ2' WHERE SecCode = 154474 AND Type_ = 1; UPDATE model_universe SET PermQuoteRetireDate = '2026-08-05' WHERE SecCode = 331641 AND Type_ = 1; UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1210715 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1468628 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2727820 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3258936 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3282221 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3305538 AND Type_ = 10; UPDATE model_universe SET PriTRBCIndPermID = 1004365603.0 WHERE SecCode = 3562797 AND Type_ = 10; UPDATE model_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 3578291 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4036729 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4168437 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4385227 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 PrimaryIssueType = 'EQU' WHERE SecCode = 6846681 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-03', PermQuoteRetireDate = '2026-08-03', endDate = '2026-08-03' WHERE SecCode = 11171838 AND Type_ = 1; UPDATE model_universe SET OrgPermID = 6000205647, PriInstrPermID = NULL, IsPrimaryInstr = 0, IncCntry = 'BMU', PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11181200 AND Type_ = 1; UPDATE model_universe SET RkdTicker = NULL, RkdRIC = 'LPRO.OQ^G26', RkdIssueStatus = 0 WHERE SecCode = 11182962 AND Type_ = 1; UPDATE model_universe SET DsPrimQtSedol = 'BNYHSZ8' WHERE SecCode = 11186433 AND Type_ = 1; UPDATE model_universe SET OrgPermID = 6000181193, PriInstrPermID = NULL, IsPrimaryInstr = 0, PermOrgIPODate = '2016-08-01' WHERE SecCode = 11192844 AND Type_ = 1; UPDATE model_universe SET OrgPermID = 6000204408, PriInstrPermID = NULL, IsPrimaryInstr = 0, IncCntry = 'CYM', PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 11214218 AND Type_ = 1; UPDATE model_universe SET RkdTicker = NULL, RkdRIC = 'SKYT.OQ^H26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, DsSecDelistDate = '2026-08-03', PermQuoteRetireDate = '2026-08-03', endDate = '2026-08-03' WHERE SecCode = 11222838 AND Type_ = 1; UPDATE model_universe SET DsPrimQtSedol = 'BNYHT11' WHERE SecCode = 11242380 AND Type_ = 1; UPDATE model_universe SET RkdISIN = 'KYG531511338', RkdCUSIP = 'G5315113', DsPrimQtSedol = 'BNYG4S0' WHERE SecCode = 11247303 AND Type_ = 1; UPDATE model_universe SET PermQuoteRetireDate = '2026-08-03', endDate = '2026-08-03' WHERE SecCode = 11257236 AND Type_ = 1; UPDATE model_universe SET RkdISIN = 'US71953R2076', RkdSEDOL = 'BXW276', RkdCUSIP = '71953R20', DsPrimQtSedol = 'BXW2769' WHERE SecCode = 11284287 AND Type_ = 1;