UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-03', SecMapEndDate = '2026-07-02', PermQuoteRetireDate = '2026-07-03', endDate = '2026-07-02' WHERE SecCode = 12192 AND Type_ = 10;
UPDATE model_universe SET DsPrimQtSedol = 'BTCL724' WHERE SecCode = 18047 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 27772 AND Type_ = 1;
UPDATE model_universe SET IsMajorSec = 'Y' WHERE SecCode = 66432 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 67906 AND Type_ = 10;
UPDATE model_universe SET PriValQuotePermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 72952 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73616 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'BXN', DsPrimQtSedol = 'B7Z3MX9' WHERE SecCode = 78713 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 88648 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 90314 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 91257 AND Type_ = 10;
UPDATE model_universe SET DsPrimQtSedol = 'BSBFLF1' WHERE SecCode = 93821 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '600608.SS^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-03', SecMapEndDate = '2026-06-29', endDate = '2026-06-29' WHERE SecCode = 95203 AND Type_ = 10;
UPDATE model_universe SET PermQuoteRetireDate = '2026-07-22' WHERE SecCode = 96636 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 97691 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 98717 AND Type_ = 10;
UPDATE model_universe SET QuotePermID = 21898260294, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 113490 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 140844 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 143382 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'VOIM', RkdRIC = 'VOIM.OL', RkdDisplayRIC = 'VOIM.OL' WHERE SecCode = 212058 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-02', SecMapEndDate = '2026-06-22', PermQuoteRetireDate = '2026-07-02', endDate = '2026-06-22' WHERE SecCode = 283464 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'NMAD', RkdRIC = 'NMAD.O', RkdDisplayRIC = 'NMAD.OQ' WHERE SecCode = 320972 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-02', SecMapEndDate = '2026-06-22', PermQuoteRetireDate = '2026-07-02', endDate = '2026-06-22' WHERE SecCode = 341321 AND Type_ = 10;
UPDATE model_universe SET PriValQuotePermID = NULL WHERE SecCode = 409378 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'ALUNI', RkdRIC = 'ALUNI.PA', RkdDisplayRIC = 'ALUNI.PA' WHERE SecCode = 555021 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 566782 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 854182 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = '2026-07-02' WHERE SecCode = 863623 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 891406 AND Type_ = 10;
UPDATE model_universe SET PriValQuotePermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 1622819 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'BJC HEAVY INDUSTRI THB1 (LOCAL)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 2417295 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'ROOTK CO LTD KRW500' WHERE SecCode = 2865468 AND Type_ = 10;
UPDATE model_universe SET QuotePermID = 236801075390, IsPrimaryQuote = 0, ExchCode = 'KNT' WHERE SecCode = 3217845 AND Type_ = 10;
UPDATE model_universe SET DsPrimQtSedol = 'BSBB2P6' WHERE SecCode = 3317576 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 DsPrimQtSedol = 'BSBB2G7' WHERE SecCode = 3396295 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'DDG', RkdRIC = 'DDG.HNO', RkdDisplayRIC = 'DDG.HNO', DsExchMnem = 'HNX', RkdIssueStatus = 1, RkdExchCode = 'UPC' WHERE SecCode = 3703402 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3772579 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = '2026-07-01' WHERE SecCode = 3961764 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4043055 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 4223306 AND Type_ = 10;
UPDATE model_universe SET PriValQuotePermID = 21776462902.0 WHERE SecCode = 4388174 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951777.0 WHERE SecCode = 4451253 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '605081.SS^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-03', SecMapEndDate = '2026-06-29', endDate = '2026-06-29' WHERE SecCode = 4494105 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'VOEPL', QuotePermID = 236809169007, ExchCode = 'NSI' WHERE SecCode = 5155289 AND Type_ = 10;
UPDATE model_universe SET Name = 'ARTGO HOLDINGS LTD HKD0.1' WHERE SecCode = 5853200 AND Type_ = 10;
UPDATE model_universe SET DsCmpyCode = 214844 WHERE SecCode = 6039875 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y1R6TD14' WHERE SecCode = 6839608 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951830.0 WHERE SecCode = 6870723 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 6923709 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'CA70137X4030', RkdSEDOL = 'BRSD2G', RkdCUSIP = '70137X40' WHERE SecCode = 10923248 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'BTH25W8' WHERE SecCode = 10933963 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 11002274 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'CA25466C1077', RkdCUSIP = '25466C10', DsPrimQtSedol = 'BSBFLD9', SecMapEndDate = '2026-07-02', endDate = '2026-07-02' WHERE SecCode = 11105323 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'BTCL713' WHERE SecCode = 11182627 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = 'FXHO' WHERE SecCode = 11222087 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = 'CIRC' WHERE SecCode = 11229331 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'BMG5T40M1045', RkdSEDOL = 'BSBB33', RkdCUSIP = 'G5T40M10' WHERE SecCode = 11264576 AND Type_ = 1;
UPDATE model_universe SET DomCntry = 'GBR' WHERE SecCode = 11274178 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = '2025-02-28', startDate = '2025-02-28' WHERE SecCode = 11277550 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = 'SECZ', Country = 'USA', DsPrimQtSedol = 'BPXZLS1', DsExchMnem = 'NYS', ExchCode = 'NYS' WHERE SecCode = 11277957 AND Type_ = 1;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 11297024 AND Type_ = 1;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 11297683 AND Type_ = 1;
