UPDATE model_universe SET IsMajorSec = 'Y' WHERE SecCode = 14280 AND Type_ = 1;
UPDATE model_universe SET ISIN = NULL, Name = 'MICHAEL PAGE PLC ORD GBP0.01' WHERE SecCode = 31560 AND Type_ = 10;
UPDATE model_universe SET QuotePermID = 21474913868, ExchCode = 'BUR' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'USA' WHERE SecCode = 57460 AND Type_ = 1;
UPDATE model_universe SET DomCntry = 'ZAF' WHERE SecCode = 70418 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70467 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE model_universe SET Name = 'GOODMAN NZ LTD & G NPV STAPLED' WHERE SecCode = 78081 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81730 AND Type_ = 10;
UPDATE model_universe SET DsPrimQtSedol = 'BNBWTH5' WHERE SecCode = 82333 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = '060240.KQ^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-23', SecMapEndDate = '2026-07-23', endDate = '2026-07-23' WHERE SecCode = 83485 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 84806 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 89550 AND Type_ = 10;
UPDATE model_universe SET PermQuoteRetireDate = '2026-07-27' WHERE SecCode = 91841 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 113724 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = NULL, RkdRIC = 'NFBK.OQ^G26', RkdIssueStatus = 0 WHERE SecCode = 331577 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 331996 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = NULL, QuotePermID = 55834800221, ExchCode = 'HKG', PermQuoteRetireDate = '2018-04-24', endDate = '2018-04-16' WHERE SecCode = 345190 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'CYNCA' WHERE SecCode = 345593 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 395048 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 400273 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 516194 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 547478 AND Type_ = 10;
UPDATE model_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-24', endDate = '2026-07-24' WHERE SecCode = 589622 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'PH0000062697', RkdTicker = 'TUBIG', PermIDTicker = 'TUBIG', RkdSEDOL = 'BMV9N1', RkdCUSIP = 'Y897ZF10', RkdRIC = 'TUBIG.PS', RkdDisplayRIC = 'TUBIG.PS', DsPrimQtSedol = 'BMV9N11' WHERE SecCode = 1708986 AND Type_ = 10;
UPDATE model_universe SET PermQuoteRetireDate = '2026-08-08' WHERE SecCode = 2311326 AND Type_ = 10;
UPDATE model_universe SET DsPrimQtSedol = 'BTNP4Q8' WHERE SecCode = 2499278 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'POWER' WHERE SecCode = 2739696 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 2827910 AND Type_ = 10;
UPDATE model_universe SET DsExchQtStartDate = '2015-05-18', startDate = '2015-05-14' WHERE SecCode = 2899614 AND Type_ = 10;
UPDATE model_universe SET DsExchMnem = 'HNX' WHERE SecCode = 2935048 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 DsExchMnem = 'HNX' WHERE SecCode = 3354563 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3883680 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4542562 AND Type_ = 10;
UPDATE model_universe SET DsPrimQtSedol = 'BXQ15X5' WHERE SecCode = 5527280 AND Type_ = 10;
UPDATE model_universe SET DsPrimQtSedol = 'BTNP4P7' WHERE SecCode = 6456244 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'KYG3314M1096', RkdSEDOL = 'BTCL6X', RkdCUSIP = 'G3314M10' WHERE SecCode = 11104336 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-22', PermSecMapEndDate = '2026-07-22' WHERE SecCode = 11147409 AND Type_ = 1;
UPDATE model_universe SET OrgPermID = 6000196386, PermOrgIPODate = NULL WHERE SecCode = 11184721 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-24', endDate = '2026-07-24' WHERE SecCode = 11207414 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'BXW27L4' WHERE SecCode = 11211489 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'BXW27H0' WHERE SecCode = 11224254 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = 'GRSD' WHERE SecCode = 11227626 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = 'VIP' WHERE SecCode = 11230326 AND Type_ = 1;
UPDATE model_universe SET RkdIssueID = 2, RkdIssueCode = 166669, RkdIssueOrder = 2, RkdListingType = NULL WHERE SecCode = 11237419 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = 'VLOS', PermIDTicker = 'VLOS', RkdRIC = 'VLOS.O', RkdDisplayRIC = 'VLOS.OQ' WHERE SecCode = 11269897 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11274771 AND Type_ = 1;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 11296208 AND Type_ = 1;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 11297291 AND Type_ = 1;
