UPDATE model_universe SET ISIN = NULL, Name = 'DCC ENERGY PLC ORD EUR0.25 (CDI)' WHERE SecCode = 3398 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'HELICAL PLC ORD GBP0.0105' WHERE SecCode = 5979 AND Type_ = 10;
UPDATE model_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2018-01-15', PermSecMapEndDate = '2026-07-20', endDate = '2018-01-15' WHERE SecCode = 10081 AND Type_ = 10;
UPDATE model_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-07-17', PermQuoteRetireDate = '2026-07-21', PermSecMapEndDate = '2026-07-20', endDate = '2026-07-17' WHERE SecCode = 13231 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'CREG.PK', RkdDisplayRIC = 'CREG.PK', RkdExchCode = 'OTC', PermQuoteRetireDate = '2026-07-21', endDate = '2026-07-21' WHERE SecCode = 14009 AND Type_ = 1;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 46163 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'AMPER SA EUR1.25(POST CONS)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 60151 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 68018 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 76022 AND Type_ = 10;
UPDATE model_universe SET Name = 'FBR LTD NPV DFD 27/07/26(EX-SPLT)' WHERE SecCode = 79182 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81495 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 81697 AND Type_ = 10;
UPDATE model_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 82721 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 87838 AND Type_ = 10;
UPDATE model_universe SET Name = 'GREAT WALL TERROIR HKD0.1 POST B/L CHANGE', DsPrimQtSedol = 'BXV1RZ6', PermSecMapEndDate = '2026-07-20', endDate = '2026-07-20' WHERE SecCode = 87947 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 89799 AND Type_ = 10;
UPDATE model_universe SET DsPrimQtSedol = 'BVMHG63', PermSecMapEndDate = '2026-05-12', endDate = '2026-05-12' WHERE SecCode = 90115 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 94937 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'TONGYANG INC KRW1000' WHERE SecCode = 97691 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98797 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'CA38141A6025', RkdSEDOL = 'BTMT3V', RkdCUSIP = '38141A60' WHERE SecCode = 99271 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-16', SecMapEndDate = '2026-07-15', endDate = '2026-07-15' WHERE SecCode = 111353 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'BVMWHP4', PermSecMapEndDate = '2026-07-20', endDate = '2026-07-20' WHERE SecCode = 112417 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 179072 AND Type_ = 10;
UPDATE model_universe SET PermSecMapStartDate = '2019-04-12' WHERE SecCode = 201990 AND Type_ = 10;
UPDATE model_universe SET Name = 'OSISKO GOLD GROUP INC COM NEW' WHERE SecCode = 322922 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-21', SecMapEndDate = '2026-07-20', PermQuoteRetireDate = '2026-07-21', endDate = '2026-07-20' WHERE SecCode = 331577 AND Type_ = 1;
UPDATE model_universe SET ISIN = NULL, Name = 'ARTINI HLDGS LTD HKD0.25' WHERE SecCode = 384065 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 555880 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 555936 AND Type_ = 10;
UPDATE model_universe SET QuotePermID = 21616156917, IsPrimaryQuote = 0, PermQuoteStatus = 'DC', ExchCode = 'MCX', PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 555939 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 557845 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 557901 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 656342 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 685120 AND Type_ = 10;
UPDATE model_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-07-19' WHERE SecCode = 810847 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 879276 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1468628 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1636779 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2244322 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2592377 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2750968 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A', DsSecDelistDate = NULL, SecMapEndDate = '2079-06-06', endDate = '2026-07-14' WHERE SecCode = 2935048 AND Type_ = 10;
UPDATE model_universe SET Name = 'AGOS CO LTD KRW500' WHERE SecCode = 2986160 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-20', SecMapEndDate = '2026-07-08', PermQuoteRetireDate = '2026-07-20', PermSecMapEndDate = '2026-07-20', endDate = '2026-07-08' WHERE SecCode = 3217882 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951994.0 WHERE SecCode = 3267027 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3309731 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3354563 AND Type_ = 10;
UPDATE model_universe SET DsPrimQtSedol = 'BWRXW32' WHERE SecCode = 3378474 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3873151 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4036729 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 4409912 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'NGRD3.SA^G26', RkdIssueStatus = 0, PermOrgIPODate = NULL WHERE SecCode = 4446111 AND Type_ = 10;
UPDATE model_universe SET QuotePermID = 21899163259, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30', endDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 4627843 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 6400766 AND Type_ = 10;
UPDATE model_universe SET IsMajorSec = 'Y', PermOrgIPODate = '2025-11-07' WHERE SecCode = 6541027 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 6945364 AND Type_ = 10;
UPDATE model_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 10989949 AND Type_ = 1;
UPDATE model_universe SET Name = 'GATES INDUSTRIAL CORP LTD COM' WHERE SecCode = 11181200 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'BVK35P5' WHERE SecCode = 11184721 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'BXWTPD3' WHERE SecCode = 11188238 AND Type_ = 1;
UPDATE model_universe SET RkdSEDOL = 'BXP2VZ', Name = 'NIKI BIOSOLUTIONS INC COM' WHERE SecCode = 11192828 AND Type_ = 1;
UPDATE model_universe SET Name = 'QUHUO LTD ORD SHS CL A' WHERE SecCode = 11209704 AND Type_ = 1;
UPDATE model_universe SET ExchCode = 'NAS' WHERE SecCode = 11247303 AND Type_ = 1;
UPDATE model_universe SET Name = 'MINDFORGE INC ORD SHS CL A' WHERE SecCode = 11263606 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'C04JZ28' WHERE SecCode = 11266044 AND Type_ = 1;
UPDATE model_universe SET ExchCode = 'NAS' WHERE SecCode = 11268942 AND Type_ = 1;
UPDATE model_universe SET Name = 'BOXABL INC COM', PermOrgIPODate = NULL, startDate = '2025-02-08' WHERE SecCode = 11274771 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = 'CIGL' WHERE SecCode = 11277561 AND Type_ = 1;
UPDATE model_universe SET PriInstrPermID = NULL WHERE SecCode = 11286103 AND Type_ = 1;
