UPDATE model_universe SET ISIN = NULL, Name = 'POWERHOUSE ENRG GP ORD GBP0.0001' WHERE SecCode = 10573 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'PAZRIO.CN', RkdDisplayRIC = 'PAZRIO.CN' WHERE SecCode = 27018 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'EXITO.CN', RkdDisplayRIC = 'EXITO.CN' WHERE SecCode = 27179 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'BBVACOL.CN', RkdDisplayRIC = 'BBVACOL.CN' WHERE SecCode = 27263 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'POPULAR.CN', RkdDisplayRIC = 'POPULAR.CN' WHERE SecCode = 27286 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'BOGOTA.CN', RkdDisplayRIC = 'BOGOTA.CN' WHERE SecCode = 27341 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'OCCIDENTE.CN', RkdDisplayRIC = 'OCCIDENTE.CN' WHERE SecCode = 27471 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'CARTON.CN', RkdDisplayRIC = 'CARTON.CN' WHERE SecCode = 27801 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'GRUPOARGOS.CN', RkdDisplayRIC = 'GRUPOARGOS.CN' WHERE SecCode = 27900 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'CEMARGOS.CN', RkdDisplayRIC = 'CEMARGOS.CN' WHERE SecCode = 27901 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'NUTRESA.CN', RkdDisplayRIC = 'NUTRESA.CN' WHERE SecCode = 27954 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'GRUPOSURA.CN', RkdDisplayRIC = 'GRUPOSURA.CN' WHERE SecCode = 28364 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'GRUPOAVAL.CN', RkdDisplayRIC = 'GRUPOAVAL.CN' WHERE SecCode = 29137 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'VILLAS.CN', RkdDisplayRIC = 'VILLAS.CN' WHERE SecCode = 29138 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'PROMIGAS.CN', RkdDisplayRIC = 'PROMIGAS.CN' WHERE SecCode = 30328 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'CELSIA.CN', RkdDisplayRIC = 'CELSIA.CN' WHERE SecCode = 30658 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'GRUBOLIVAR.CN', RkdDisplayRIC = 'GRUBOLIVAR.CN' WHERE SecCode = 30769 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'CORFICOLCF.CN', RkdDisplayRIC = 'CORFICOLCF.CN' WHERE SecCode = 31220 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'KWY', RkdRIC = 'KWY', RkdDisplayRIC = 'KWY.N' WHERE SecCode = 39746 AND Type_ = 1;
UPDATE model_universe SET RkdIssueStatus = 0 WHERE SecCode = 48754 AND Type_ = 10;
UPDATE model_universe SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 69402 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75930 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76196 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'KBI DONGKOOK IND KRW2500', DsCtryQtStatus = 'A' WHERE SecCode = 77126 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 77410 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'MANIKER COMPANY KRW1000', DsCtryQtStatus = 'A' WHERE SecCode = 78634 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = '2692.T^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, DsSecDelistDate = '2026-05-19', SecMapEndDate = '2026-05-18', PermSecMapEndDate = '2026-05-18', endDate = '2026-05-18' WHERE SecCode = 79181 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79241 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82233 AND Type_ = 10;
UPDATE model_universe SET Name = 'BITPLANET CO LTD KRW500' WHERE SecCode = 82542 AND Type_ = 10;
UPDATE model_universe SET Name = 'CNT85 INC KRW2500', DsCtryQtStatus = 'A' WHERE SecCode = 83487 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85361 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86132 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86799 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86934 AND Type_ = 10;
UPDATE model_universe SET IncCntry = 'BHS' WHERE SecCode = 87124 AND Type_ = 1;
UPDATE model_universe SET Name = 'SPENDA LTD NPV DFD 21/05/26(EX-SPLIT)' WHERE SecCode = 87204 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87466 AND Type_ = 10;
UPDATE model_universe SET PermQuoteRetireDate = '2026-06-01' WHERE SecCode = 87641 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87838 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 88193 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 99351 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 141376 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'JOOYONTECH CO LTD KRW1000', DsCtryQtStatus = 'A' WHERE SecCode = 179072 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 183464 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', SecMapEndDate = '2024-12-02', endDate = '2024-12-02' WHERE SecCode = 255791 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 294085 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'WOONGJIN THINKBIG KRW1000' WHERE SecCode = 295905 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 298971 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'US48127Q1094', RkdTicker = 'CPFID', PermIDTicker = NULL, RkdSEDOL = 'BMW3X9', RkdCUSIP = '48127Q10', RkdRIC = 'CPFID.PK', RkdDisplayRIC = 'CPFID.PK', RkdIssueID = 1, RkdIssueCode = 86888, RkdIssueStatus = 1, RkdIssueOrder = 2, RkdListingType = NULL, RkdExchCode = 'OTC', PermQuoteStatus = 'DC', SecMapEndDate = '2026-05-14', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-05-18', endDate = '2026-05-14' WHERE SecCode = 309092 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 324866 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-18', SecMapEndDate = '2026-05-15', PermSecMapEndDate = '2026-05-18', endDate = '2026-05-15' WHERE SecCode = 329828 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 332462 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'MINEROS.CN', RkdDisplayRIC = 'MINEROS.CN' WHERE SecCode = 347222 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'ECOPETROL.CN', RkdDisplayRIC = 'ECOPETROL.CN' WHERE SecCode = 350029 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'GGY' WHERE SecCode = 387264 AND Type_ = 10;
UPDATE model_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-05-14', PermSecMapEndDate = '2026-05-17', endDate = '2026-05-14' WHERE SecCode = 406383 AND Type_ = 10;
UPDATE model_universe SET Name = 'DSM CORPORATION KRW500', DsCtryQtStatus = 'A' WHERE SecCode = 461603 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'INCASTILLA.CN', RkdDisplayRIC = 'INCASTILLA.CN' WHERE SecCode = 519060 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'PROTECCION.CN', RkdDisplayRIC = 'PROTECCION.CN' WHERE SecCode = 519567 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'CONCONCRET.CN', RkdDisplayRIC = 'CONCONCRET.CN' WHERE SecCode = 519755 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'CSACOL.CN', RkdDisplayRIC = 'CSACOL.CN' WHERE SecCode = 520495 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'FABRICATO.CN', RkdDisplayRIC = 'FABRICATO.CN' WHERE SecCode = 550263 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 560320 AND Type_ = 10;
UPDATE model_universe SET Name = 'PHIONX USD0.015' WHERE SecCode = 637304 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 643063 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 1480267 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'ELCONDOR.CN', RkdDisplayRIC = 'ELCONDOR.CN' WHERE SecCode = 1543889 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2164376 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'RIOPAILA.CN', RkdDisplayRIC = 'RIOPAILA.CN' WHERE SecCode = 2429985 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'SGA SOLUTIONS CO L KRW500', DsCtryQtStatus = 'A' WHERE SecCode = 2448338 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'TERPEL.CN', RkdDisplayRIC = 'TERPEL.CN' WHERE SecCode = 2623009 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 2623928 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2708934 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2862763 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2879979 AND Type_ = 10;
UPDATE model_universe SET RkdSEDOL = 'BX01MR', Name = 'MADISON HOLDINGS G HKD0.1', DsPrimQtSedol = 'BX01MR4' WHERE SecCode = 3002458 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3258797 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3339560 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3407487 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 3431044 AND Type_ = 10;
UPDATE model_universe SET QuotePermID = 21922259627, ExchCode = 'EQD' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'T5263L12' WHERE SecCode = 3779974 AND Type_ = 10;
UPDATE model_universe SET Name = 'HLB BIOSTEP CO LTD KRW500', DsCtryQtStatus = 'A' WHERE SecCode = 4028388 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 4197945 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4264582 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4379702 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4424403 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'R3R38116', Name = 'HEXAGON PURUS ASA NOK1', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 4443375 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 4614771 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951396.0 WHERE SecCode = 4636324 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5019011 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5037204 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5161399 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 5176773 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-18', SecMapEndDate = '2026-05-15', PermSecMapEndDate = '2026-05-18', endDate = '2026-05-15' WHERE SecCode = 5738497 AND Type_ = 10;
UPDATE model_universe SET Name = 'SHANDONG BOYUAN AD CNY1 A' WHERE SecCode = 6035208 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6786375 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueCode = 144753.0, RelType = NULL, COATypeCode = 'IND' WHERE SecCode = 6813821 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'US25382K1007', RkdSEDOL = 'BMWF3W', RkdCUSIP = '25382K10', Name = 'DIGIMARC PARENT INC COM', DsPrimQtSedol = 'BMWF3W9' WHERE SecCode = 10785144 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 10973798 AND Type_ = 1;
UPDATE model_universe SET DomCntry = 'VGB' WHERE SecCode = 11076755 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = '2026-05-16', endDate = '2026-05-16' WHERE SecCode = 11108815 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = NULL, RkdRIC = 'SLNO.OQ^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, DsSecDelistDate = '2026-05-19', SecMapEndDate = '2026-05-15', endDate = '2026-05-15' WHERE SecCode = 11139994 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = '2026-05-18', endDate = '2026-05-18' WHERE SecCode = 11142544 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = '2026-05-18', endDate = '2026-05-18' WHERE SecCode = 11176237 AND Type_ = 1;
UPDATE model_universe SET OrgPermID = 6000110068, PriInstrPermID = 21711884151.0, PriTRBCIndPermID = 4294951205.0, PermOrgIPODate = '2019-09-19' WHERE SecCode = 11200314 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'VGG5279F3007', RkdSEDOL = 'BRDXC4', RkdCUSIP = 'G5279F30', DsPrimQtSedol = 'BRDXC42' WHERE SecCode = 11218121 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 11240840 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 11241882 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'KYG6421C1380', RkdSEDOL = 'BRF0NM', RkdCUSIP = 'G6421C13', DsPrimQtSedol = 'BRF0NM6' WHERE SecCode = 11264491 AND Type_ = 1;
UPDATE model_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11273589 AND Type_ = 1;
UPDATE model_universe SET Name = 'AIR GLOBAL PLC SHS', Country = 'JEY', DsPrimQtSedol = 'BT8Q3M5', PermSecMapEndDate = '2026-05-18', endDate = '2026-05-18' WHERE SecCode = 11279854 AND Type_ = 1;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 11295044 AND Type_ = 1;
