UPDATE data_universe SET RkdDisplayRIC = 'BMNR.N', DsExchMnem = 'NYS', RkdExchCode = 'NYSE', ExchCode = 'NYS' WHERE SecCode = 3853 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 27134 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 29418 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'MERC3.SA^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-04-09', SecMapEndDate = '2025-11-10', PermQuoteRetireDate = '2026-03-27', PermSecMapEndDate = '2026-04-09', endDate = '2025-11-10' WHERE SecCode = 29844 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951440.0 WHERE SecCode = 33161 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 36033 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'SUPN' WHERE SecCode = 36873 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 37128 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 44368 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 46170 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-04-09' WHERE SecCode = 49579 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 52607 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'IRL' WHERE SecCode = 54951 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09', endDate = '2026-04-09' WHERE SecCode = 59737 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836324566.0, ExchCode = 'BER', PermQuoteRetireDate = '2018-01-16' WHERE SecCode = 60120 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NSUG.I', QuotePermID = 21475572974.0, ExchCode = 'CHI', PermQuoteRetireDate = '2008-01-23', endDate = '2008-01-23' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 67136 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'SEE.N^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-04-09', SecMapEndDate = '2026-04-08', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09', endDate = '2026-04-08' WHERE SecCode = 68839 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 69151 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 69439 AND Type_ = 10;
UPDATE data_universe SET Name = 'JOJO LTD INR10' WHERE SecCode = 69705 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 70361 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70885 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71148 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 72337 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SGP' WHERE SecCode = 72392 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 72983 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'VGB' WHERE SecCode = 73158 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 73688 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 74186 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 74321 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75950 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 76090 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 76659 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'BMU' WHERE SecCode = 77346 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'HKG' WHERE SecCode = 77873 AND Type_ = 10;
UPDATE data_universe SET Name = 'OVANTI LIMITED NPV DFD 13/04/26 (EX-SPLIT)' WHERE SecCode = 77877 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q8793A19' WHERE SecCode = 78043 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SGP' WHERE SecCode = 78064 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000089263.0, OrgTypeCode = 'COM', IncCntry = NULL, PriTRBCIndPermID = 4294951333.0, PermOrgIPODate = '2026-04-07' WHERE SecCode = 78081 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 78460 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78655 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 78958 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 79306 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 79378 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 80202 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 81592 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 81636 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 81676 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236805427814.0 WHERE SecCode = 81820 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 81841 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 82665 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 82898 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 83992 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 85075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86003 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 87100 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 87193 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 87365 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 87376 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 88258 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-04-09', endDate = '2026-04-09' WHERE SecCode = 91025 AND Type_ = 1;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'CYM' WHERE SecCode = 91251 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 91276 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 91975 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 93063 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 94395 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 94697 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 96441 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 97105 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 97746 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 98119 AND Type_ = 10;
UPDATE data_universe SET Name = 'KAIROS MINERALS LT NPV DFD 14/04/26(EX-SPLIT)' WHERE SecCode = 99340 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 100680 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 105524 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 105576 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 112692 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 112948 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 114343 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'GULF KEYSTONE PETR USD1 (CDI)' WHERE SecCode = 115390 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 127614 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 127620 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'UKR' WHERE SecCode = 130255 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 130383 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 134527 AND Type_ = 10;
UPDATE data_universe SET Name = 'MPF SYSTEMS LTD INR10.00' WHERE SecCode = 138067 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'CYM' WHERE SecCode = 139835 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'BMU' WHERE SecCode = 140663 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 140942 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 141041 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 141097 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 142134 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 142629 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SGP' WHERE SecCode = 143560 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 145495 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 146402 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 178843 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 214630 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 269250 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 269427 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 296445 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'CYM' WHERE SecCode = 299550 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 299990 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 302755 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 334399 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 336830 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'AU0000459323', RkdTicker = 'WWIDA', PermIDTicker = 'WWIDA', RkdSEDOL = 'BVJ15B', RkdRIC = 'WWIDA.AX', RkdDisplayRIC = 'WWIDA.AX', DsPrimQtSedol = 'BVJ15B6', PermSecMapEndDate = '2026-04-09', endDate = '2026-04-09' WHERE SecCode = 347684 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 356652 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 359624 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 362271 AND Type_ = 1;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 366358 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 369170 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'CYM' WHERE SecCode = 384296 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 524466 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 545470 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 545910 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 553444 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 554344 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 556656 AND Type_ = 10;
UPDATE data_universe SET Name = 'DIAN SWASTATIKA IDR1' WHERE SecCode = 558537 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'TLT.HNO^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-04-10', SecMapEndDate = '2026-02-03', PermQuoteRetireDate = '2026-04-10', PermSecMapEndDate = '2026-04-09', endDate = '2026-02-03' WHERE SecCode = 561073 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 564881 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 580377 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 587491 AND Type_ = 10;
UPDATE data_universe SET Name = 'NEOVACS EUR0.0005' WHERE SecCode = 588831 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '4132.TWO^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-04-10', SecMapEndDate = '2026-04-09', PermSecMapEndDate = '2026-04-09', endDate = '2026-04-09' WHERE SecCode = 702391 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'CYM' WHERE SecCode = 822049 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 850477 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 852952 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 880546 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 882233 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 890755 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'CYM' WHERE SecCode = 890820 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 918855 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 966413 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 990250 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 1211489 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 1261036 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 1335466 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 1460241 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRDGl', QuotePermID = 21531119071.0, ExchCode = 'BCO', PermQuoteRetireDate = '2014-03-20' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 1548445 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 1839781 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'HKG' WHERE SecCode = 1990909 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'CYM' WHERE SecCode = 2014147 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 2241769 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 2379762 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 2381660 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'CYM' WHERE SecCode = 2386507 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 2433071 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2441664 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 2445238 AND Type_ = 10;
UPDATE data_universe SET Name = 'HBG HOTELS LIMITED INR10' WHERE SecCode = 2541445 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 2579462 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2585343 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'BMU' WHERE SecCode = 2585474 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2802740 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'UNTU', RkdRIC = 'UNTU.ASE', RkdDisplayRIC = 'UNTU.ASE' WHERE SecCode = 2841844 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 2899674 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 2900667 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'CYM' WHERE SecCode = 2910659 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951990.0 WHERE SecCode = 2924553 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 2963479 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 3037826 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'AVARDA', PermIDTicker = 'AVARDA', RkdRIC = 'AVARDA.ST', RkdDisplayRIC = 'AVARDA.ST' WHERE SecCode = 3196330 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 3241310 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'VGB' WHERE SecCode = 3321102 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21732297982.0, ExchCode = 'DUS' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 3345921 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3373276 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'VGB' WHERE SecCode = 3409309 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 3435132 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '6652.TWO^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-04-10', SecMapEndDate = '2026-04-09', PermSecMapEndDate = '2026-04-09', endDate = '2026-04-09' WHERE SecCode = 3440122 AND Type_ = 10;
UPDATE data_universe SET Name = 'BANK SYARIAH INDO IDR500' WHERE SecCode = 3493639 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NGIL', QuotePermID = 25727169919.0, ExchCode = 'MCD' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'IPARK HYUNDAI DEV KRW5000' WHERE SecCode = 3518211 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 3589017 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3713364 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7056.T^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-04-10', SecMapEndDate = '2019-03-05', PermSecMapEndDate = '2026-04-09', endDate = '2019-03-05' WHERE SecCode = 3777677 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 3779974 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4053515 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4071590 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-04-08', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09', endDate = '2026-04-08' WHERE SecCode = 4079151 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'IRL' WHERE SecCode = 4079163 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 4178608 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 4319483 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 4391264 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 4586482 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4607294 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21929410708.0, ExchCode = 'DUS' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '4773.TWO^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-04-10', SecMapEndDate = '2026-03-20', PermSecMapEndDate = '2026-04-09', endDate = '2026-03-20' WHERE SecCode = 5052443 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 5085769 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5085771 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 5249135 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '5883.T^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-04-10', SecMapEndDate = '2026-03-06', PermSecMapEndDate = '2026-04-09', endDate = '2026-03-06' WHERE SecCode = 5395742 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 5478289 AND Type_ = 10;
UPDATE data_universe SET Name = 'DOMANI FAMILY CH0.1', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 5487993 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5525173 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 5663500 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-10-14', endDate = '2025-10-14' WHERE SecCode = 5886920 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-04-08', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09', endDate = '2026-04-08' WHERE SecCode = 6043647 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 6213106 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'CYM' WHERE SecCode = 6291847 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 6291848 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 6429307 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-04-10', SecMapEndDate = '2026-04-09', PermSecMapEndDate = '2026-04-09', endDate = '2026-04-09' WHERE SecCode = 6694372 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6737825 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6755628 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6756392 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6762062 AND Type_ = 10;
UPDATE data_universe SET Name = 'POOL SAFE INC COM NEW' WHERE SecCode = 10926191 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 10971989 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 10973822 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11021184 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 11111276 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11133288 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CYM', PriTRBCIndPermID = 4294951191.0 WHERE SecCode = 11138578 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US78396V3078', RkdSEDOL = 'BTWQT8', RkdCUSIP = '78396V30', DsPrimQtSedol = 'BTWQT89' WHERE SecCode = 11162137 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US25401T5048', RkdTicker = 'DBRG PR H', RkdSEDOL = 'BNHTS0', RkdCUSIP = '25401T50', RkdRIC = 'DBRG_ph.K', RkdDisplayRIC = 'DBRG_ph.N', RkdCode = 98066.0, RkdIssueID = 5.0, RkdIssueCode = 184914.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 2.0, RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11166631 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US70931T3014', RkdTicker = 'PMT PR A', RkdSEDOL = 'BF0BHG', RkdCUSIP = '70931T30', RkdRIC = 'PMT_pa', RkdDisplayRIC = 'PMT_pa.N', RkdCode = 75744.0, RkdIssueID = 3.0, RkdIssueCode = 184918.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 2.0, RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11169084 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US25401T4058', RkdTicker = 'DBRG PR I', RkdSEDOL = 'BNHTS2', RkdCUSIP = '25401T40', RkdRIC = 'DBRG_pi.K', RkdDisplayRIC = 'DBRG_pi.N', RkdCode = 98066.0, RkdIssueID = 6.0, RkdIssueCode = 184915.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 3.0, RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11172841 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US70931T4004', RkdTicker = 'PMT PR B', RkdSEDOL = 'BF5GLS', RkdCUSIP = '70931T40', RkdRIC = 'PMT_pb', RkdDisplayRIC = 'PMT_pb.N', RkdCode = 75744.0, RkdIssueID = 4.0, RkdIssueCode = 184919.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 3.0, RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11174145 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US25401T3068', RkdTicker = 'DBRG PR J', RkdSEDOL = 'BNHTS4', RkdCUSIP = '25401T30', RkdRIC = 'DBRG_pj.K', RkdDisplayRIC = 'DBRG_pj.N', RkdCode = 98066.0, RkdIssueID = 7.0, RkdIssueCode = 184916.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 4.0, RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11176824 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 25727255535.0, ExchCode = 'NMS', PermSecMapStartDate = '2021-06-19' WHERE SecCode = 11198774 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11204015 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11214658 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11214925 AND Type_ = 1;
UPDATE data_universe SET RkdExchCode = 'TSE', RkdExchCtry = 'CAN' WHERE SecCode = 11221935 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11223856 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US70931T5092', RkdTicker = 'PMT PR C', RkdSEDOL = 'BMFK2M', RkdCUSIP = '70931T50', RkdRIC = 'PMT_pc', RkdDisplayRIC = 'PMT_pc.N', RkdCode = 75744.0, RkdIssueID = 5.0, RkdIssueCode = 184920.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 4.0, RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11228809 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'TRCTF' WHERE SecCode = 11233691 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'ASNS.PK', RkdDisplayRIC = 'ASNS.PK', RkdExchCode = 'OTC' WHERE SecCode = 11241826 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11248790 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11250693 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-03-24', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09', endDate = '2026-03-24' WHERE SecCode = 11253112 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-04-09', SecMapEndDate = '2026-03-24', endDate = '2026-03-24' WHERE SecCode = 11253160 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SCAI', Name = 'SALESCLOSER TECHNOLOGIES LTD COM' WHERE SecCode = 11253247 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermInstrStatus = 'DC' WHERE SecCode = 11255668 AND Type_ = 1;
UPDATE data_universe SET Country = 'USA', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-04-08', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09', endDate = '2026-04-08' WHERE SecCode = 11257235 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 11260982 AND Type_ = 1;
UPDATE data_universe SET DsTypeCode = 'ADR' WHERE SecCode = 11293177 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951899.0 WHERE SecCode = 11293820 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG8303R1002', RkdTicker = 'TMTS', RkdSEDOL = 'BS2C7B', RkdCUSIP = 'G8303R10', RkdRIC = 'TMTS.O', RkdDisplayRIC = 'TMTS.OQ', RkdCode = 144654.0, RkdIssueID = 1.0, RkdIssueCode = 184922.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11294069 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'TMCR', QuotePermID = 236805391894.0, InstrPermID = 232904879624.0, OrgPermID = 6000045501.0, PriTrdQuotePermID = 236805391894.0, PriValQuotePermID = 25727028171.0, PriInstrPermID = 232904879624.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NAS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951916.0, PermOrgIPODate = '2026-04-08', PermSecMapStartDate = '2026-04-07', startDate = '2026-04-07' WHERE SecCode = 11294240 AND Type_ = 1;
