UPDATE model_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-14', SecMapEndDate = '2026-05-28', PermQuoteRetireDate = '2026-07-14', endDate = '2026-05-28' WHERE SecCode = 4259 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'BKYI.O', RkdDisplayRIC = 'BKYI.OQ', RkdExchCode = 'NASD' WHERE SecCode = 9345 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'US2312694084', RkdSEDOL = 'BTCL72', RkdCUSIP = '23126940' WHERE SecCode = 18047 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 RkdISIN = 'US7743744093', RkdSEDOL = 'BPXZLR', RkdCUSIP = '77437440' WHERE SecCode = 60432 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'DONGIL TECHNOLOGY KRW100' WHERE SecCode = 72682 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'USA' WHERE SecCode = 73894 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'BTMPX06' WHERE SecCode = 82659 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 83485 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85020 AND Type_ = 10;
UPDATE model_universe SET Name = 'ADVANCED BLDG INDS SAR10' WHERE SecCode = 85454 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87939 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = NULL, RkdRIC = '0431.HK^G26', RkdIssueStatus = 0 WHERE SecCode = 88250 AND Type_ = 10;
UPDATE model_universe SET Name = 'AVALON ADVANCED MATLS INC COM' WHERE SecCode = 90720 AND Type_ = 1;
UPDATE model_universe SET DomCntry = 'USA' WHERE SecCode = 93682 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'CA03114D1087', RkdSEDOL = 'BSBFLF', RkdCUSIP = '03114D10' WHERE SecCode = 93821 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 93941 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-14', SecMapEndDate = '2026-07-13', PermQuoteRetireDate = '2026-07-14', endDate = '2026-07-13' WHERE SecCode = 95337 AND Type_ = 10;
UPDATE model_universe SET SecMapEndDate = '2026-07-07', PermSecMapEndDate = '2026-07-13', endDate = '2026-07-07' WHERE SecCode = 96998 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'USA' WHERE SecCode = 98684 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 99271 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 114068 AND Type_ = 10;
UPDATE model_universe SET DsPrimQtSedol = 'BXS0303' WHERE SecCode = 293512 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 484585 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 538910 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 558540 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'SHENZHEN PENGFEI G ''A''CNY1' WHERE SecCode = 562535 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-14', SecMapEndDate = '2026-07-13', PermQuoteRetireDate = '2026-07-14', endDate = '2026-07-13' WHERE SecCode = 573055 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueCode = 83596.0 WHERE SecCode = 821832 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1468628 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'AAGB' WHERE SecCode = 2278101 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2385337 AND Type_ = 10;
UPDATE model_universe SET Name = 'BAAN HOLDING GROUP SAR1' WHERE SecCode = 2583466 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2894516 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2952368 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3267027 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3354056 AND Type_ = 10;
UPDATE model_universe SET Name = 'ATLANTIC SAPPH ASA NOK0.05' WHERE SecCode = 3375309 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4036729 AND Type_ = 10;
UPDATE model_universe SET Name = 'INMAR COMPANY FOR SAR10' WHERE SecCode = 4753629 AND Type_ = 10;
UPDATE model_universe SET Name = 'SHL FINANCE CO SAR10' WHERE SecCode = 4969391 AND Type_ = 10;
UPDATE model_universe SET Name = 'PAMTEK CO LTD KRW100' WHERE SecCode = 5422624 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueCode = 96743.0, RelType = 4.0 WHERE SecCode = 6796772 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 6948301 AND Type_ = 10;
UPDATE model_universe SET QuotePermID = 21565122724, ExchCode = 'GSB' WHERE SecCode = 10965319 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = '2026-07-07' WHERE SecCode = 11028764 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = NULL, RkdRIC = 'ESPR.OQ^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-14', SecMapEndDate = '2026-07-10', PermQuoteRetireDate = '2026-07-14', endDate = '2026-07-10' WHERE SecCode = 11078249 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'BTCL6X8' WHERE SecCode = 11104336 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'US01626W2008', RkdSEDOL = 'BRSCTV', RkdCUSIP = '01626W20' WHERE SecCode = 11210122 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'US57142B2034', RkdSEDOL = 'BPXZLQ', RkdCUSIP = '57142B20' WHERE SecCode = 11225381 AND Type_ = 1;
UPDATE model_universe SET RkdSEDOL = 'BWL861' WHERE SecCode = 11226560 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 11277960 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'BXRYF88' WHERE SecCode = 11279079 AND Type_ = 1;
UPDATE model_universe SET Name = 'GENERAL FUSION GROUP LTD SHS CL A', PermOrgIPODate = NULL, startDate = '2025-09-27' WHERE SecCode = 11286103 AND Type_ = 1;
