UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3726 AND Type_ = 10;
UPDATE model_universe SET Name = 'BANK OF MARIN BANCORP COM' WHERE SecCode = 8239 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 18913 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = 'MRSH', PermIDTicker = 'MRSH', RkdRIC = 'MRSH.K', RkdDisplayRIC = 'MRSH.N', Name = 'MARSH NEW COM' WHERE SecCode = 44716 AND Type_ = 1;
UPDATE model_universe SET RkdIssueStatus = 1 WHERE SecCode = 47451 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70969 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'INE237A01036', RkdSEDOL = 'BNBX1W', RkdCUSIP = 'Y4S3A312', DsPrimQtSedol = 'BNBX1W7', PermSecMapEndDate = '2026-01-13', endDate = '2026-01-13' WHERE SecCode = 71861 AND Type_ = 10;
UPDATE model_universe SET PermQuoteRetireDate = '2026-01-15' WHERE SecCode = 73063 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73099 AND Type_ = 10;
UPDATE model_universe SET OrgPermID = 5097097499, PriInstrPermID = 8590932398.0, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 73342 AND Type_ = 1;
UPDATE model_universe SET PermQuoteRetireDate = '2026-01-28' WHERE SecCode = 75092 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'SPIC HYDROPOWER CO ''A''CNY1' WHERE SecCode = 77892 AND Type_ = 10;
UPDATE model_universe SET PermQuoteRetireDate = '2026-01-15' WHERE SecCode = 83226 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 95137 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'INE298G01035', RkdSEDOL = 'BV7G16', RkdCUSIP = 'Y0034J14', DsPrimQtSedol = 'BV7G160', PermSecMapEndDate = '2026-01-13', endDate = '2026-01-13' WHERE SecCode = 95887 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'YOUNG POONG CORP KRW500' WHERE SecCode = 99255 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 114915 AND Type_ = 10;
UPDATE model_universe SET Name = 'VERGNET EUR0.76(POST CONS)' WHERE SecCode = 123967 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126781 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 140047 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'MBTN.BN', RkdDisplayRIC = 'MBTN.BN', RkdExchCode = 'BRN', PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-01-14', endDate = '2026-01-14' WHERE SecCode = 176977 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 208725 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 309092 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 330805 AND Type_ = 1;
UPDATE model_universe SET RkdRIC = '111870.KQ^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-01-14', SecMapEndDate = '2026-01-13', PermQuoteRetireDate = '2026-01-14', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-01-13', endDate = '2026-01-13' WHERE SecCode = 866487 AND Type_ = 10;
UPDATE model_universe SET PermSecMapEndDate = '2026-01-13' WHERE SecCode = 1166946 AND Type_ = 10;
UPDATE model_universe SET PermQuoteRetireDate = '2026-01-16' WHERE SecCode = 1482699 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1497364 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = '2013-03-13' WHERE SecCode = 2179940 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2457965 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = '2014-11-04' WHERE SecCode = 2685352 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'CHINA SUPPLY CHAIN HKD0.02' WHERE SecCode = 2753942 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = '2015-06-10' WHERE SecCode = 2912882 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2994441 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = '226360.KQ^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-01-14', SecMapEndDate = '2026-01-13', PermQuoteRetireDate = '2026-01-14', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-01-13', endDate = '2026-01-13' WHERE SecCode = 3015893 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3108143 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = '174880.KQ^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-01-14', SecMapEndDate = '2026-01-13', PermQuoteRetireDate = '2026-01-14', PermSecMapEndDate = '2026-01-13', endDate = '2026-01-13' WHERE SecCode = 3211133 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3429553 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = '2018-02-08' WHERE SecCode = 3435757 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3444651 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3569570 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3629696 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3878945 AND Type_ = 10;
UPDATE model_universe SET OrgTypeCode = 'CINV', PermOrgIPODate = '2021-07-30' WHERE SecCode = 4727655 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = '176A.T^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-14', SecMapEndDate = '2026-01-13', PermSecMapEndDate = '2026-01-13', endDate = '2026-01-13' WHERE SecCode = 5731529 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 5814581 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueCode = 115043.0 WHERE SecCode = 5993882 AND Type_ = 10;
UPDATE model_universe SET Name = 'MEYSU GIDA SANAYI TRY1' WHERE SecCode = 6139876 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = '2025-07-25' WHERE SecCode = 6389703 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'VISN', PermIDTicker = 'VISN', RkdRIC = 'VISN.O', RkdDisplayRIC = 'VISN.OQ', Name = 'VISTANCE NETWORKS INC COM' WHERE SecCode = 11108716 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = NULL, RkdSEDOL = NULL, RkdRIC = 'CODX.PK', RkdDisplayRIC = 'CODX.PK', RkdExchCode = 'OTC', PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-01-14', endDate = '2026-01-14' WHERE SecCode = 11174584 AND Type_ = 1;
UPDATE model_universe SET Name = 'LEONABIO INC COM' WHERE SecCode = 11212286 AND Type_ = 1;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 11289565 AND Type_ = 1;
