UPDATE model_universe SET PermSecMapEndDate = '2026-07-24', endDate = '2026-07-24' WHERE SecCode = 59688 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 68018 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70631 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73145 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 74874 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 82721 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 83485 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-27', SecMapEndDate = '2026-07-24', PermSecMapEndDate = '2026-07-26', endDate = '2026-07-24' WHERE SecCode = 91841 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = '2024-09-03' WHERE SecCode = 93063 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 94355 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 119146 AND Type_ = 10;
UPDATE model_universe SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-07-24', PermSecMapEndDate = NULL, startDate = '2009-10-14', endDate = NULL WHERE SecCode = 126818 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'KYG2287A1590', RkdCUSIP = 'G2287A15', PermSecMapEndDate = '2026-07-25', endDate = '2026-07-25' WHERE SecCode = 306753 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 331996 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'US82935V4068', RkdCUSIP = '82935V40', PermSecMapEndDate = '2026-07-25', endDate = '2026-07-25' WHERE SecCode = 352045 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 455870 AND Type_ = 10;
UPDATE model_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-24', PermSecMapEndDate = '2026-07-24' WHERE SecCode = 553461 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'ASHIKAG' WHERE SecCode = 1465979 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1468628 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueCode = 90505.0 WHERE SecCode = 1546969 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'AU0000478992', RkdTicker = 'SGC', RkdSEDOL = 'BVZJ7K', RkdCUSIP = 'Q850GW10', RkdRIC = 'SGC.AX', RkdDisplayRIC = 'SGC.AX' WHERE SecCode = 1621235 AND Type_ = 10;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 1708986 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'NS1', PermSecMapEndDate = '2026-07-24', endDate = '2026-07-24' WHERE SecCode = 3124055 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3196334 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3264433 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3282221 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3305538 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 3318059 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 = 3597942 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4036729 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4049096 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 4087748 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4335872 AND Type_ = 10;
UPDATE model_universe SET PermQuoteRetireDate = '2026-08-10' WHERE SecCode = 4505791 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4612958 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4733111 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6727820 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 6728349 AND Type_ = 10;
UPDATE model_universe SET PermQuoteRetireDate = '2026-08-04' WHERE SecCode = 10964740 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-24', PermSecMapEndDate = '2026-07-24' WHERE SecCode = 11072080 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = '2013-08-09' WHERE SecCode = 11104336 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'US84862C4015', RkdCUSIP = '84862C40', DsPrimQtSedol = 'BV4JYH4' WHERE SecCode = 11132638 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'US92941V4077', RkdCUSIP = '92941V40', PermSecMapEndDate = '2026-07-25', endDate = '2026-07-25' WHERE SecCode = 11181173 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = NULL, RkdRIC = 'TRIN.K', RkdDisplayRIC = 'TRIN.N', RkdIssueStatus = 0, ExchCode = 'NYS' WHERE SecCode = 11213542 AND Type_ = 1;
UPDATE model_universe SET ExchCode = 'NSM' WHERE SecCode = 11216054 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = 'TONT', PermIDTicker = 'TONT', RkdRIC = 'TONT.K', RkdDisplayRIC = 'TONT.A' WHERE SecCode = 11268479 AND Type_ = 1;
