UPDATE data_universe SET RkdISIN = 'BMG2004J1036', RkdSEDOL = 'BVV7RC', RkdCUSIP = 'G2004J10', DsPrimQtSedol = 'BVV7RC7' WHERE SecCode = 12512 AND Type_ = 1; UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'CUK.N^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-07', PermQuoteRetireDate = '2026-05-07', endDate = '2026-05-07' WHERE SecCode = 12513 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = '2026-05-06' WHERE SecCode = 25455 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1996-06-07' WHERE SecCode = 27551 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = '2026-05-05' WHERE SecCode = 28992 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'CCL.L^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-07', SecMapEndDate = '2026-05-06', PermQuoteRetireDate = '2026-05-07', endDate = '2026-05-06' WHERE SecCode = 32261 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2026-05-06' WHERE SecCode = 49578 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10; UPDATE data_universe SET Name = 'ITCENCTS CO LTD KRW5000' WHERE SecCode = 70771 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71621 AND Type_ = 10; UPDATE data_universe SET PermSecMapEndDate = '2026-05-05' WHERE SecCode = 72565 AND Type_ = 10; UPDATE data_universe SET PermSecMapEndDate = '2026-05-06' WHERE SecCode = 73402 AND Type_ = 1; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '2014-01-22' WHERE SecCode = 74992 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 75720 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75950 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76050 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 76193 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76492 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951593.0 WHERE SecCode = 77035 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78536 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '2014-01-22' WHERE SecCode = 78903 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 79306 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'FINE DNC KRW2500' WHERE SecCode = 81471 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 81636 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82772 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 83269 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85941 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '2014-01-22' WHERE SecCode = 85955 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86003 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'JPN' WHERE SecCode = 86929 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87193 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87378 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 55838797189.0, ExchCode = 'JNB' WHERE SecCode = 88378 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL WHERE SecCode = 89466 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 89467 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CA00401X1024', RkdTicker = 'ABC', PermIDTicker = 'ABC', RkdSEDOL = 'BSNNS7', RkdCUSIP = '00401X10', RkdRIC = 'ABC.V', RkdDisplayRIC = 'ABC.V', DsPrimQtSedol = 'BSNNS74' WHERE SecCode = 90115 AND Type_ = 1; UPDATE data_universe SET ISIN = NULL, Name = 'NAM SUNG CORP KRW5000' WHERE SecCode = 90272 AND Type_ = 10; UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 90678 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10; UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 91251 AND Type_ = 10; UPDATE data_universe SET Name = 'H2G LIMITED NPV' WHERE SecCode = 91485 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 91973 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CA66660C1059', RkdTicker = 'NP', PermIDTicker = 'NP', RkdSEDOL = 'BSHW6S', RkdCUSIP = '66660C10', RkdRIC = 'NP.CD', RkdDisplayRIC = 'NP.CD', DsPrimQtSedol = 'BSHW6S4' WHERE SecCode = 92879 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 93275 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'SG CORPORATION KRW5000' WHERE SecCode = 94993 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CA64135V2049', RkdSEDOL = 'BSHW7R', RkdCUSIP = '64135V20', DsPrimQtSedol = 'BSHW7R0' WHERE SecCode = 98713 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = '2014-01-22' WHERE SecCode = 99233 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 100845 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 101281 AND Type_ = 1; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10; UPDATE data_universe SET Name = 'AUTAGCO LTD NPV' WHERE SecCode = 113941 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 114343 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 115826 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'IDRA.BO', RkdDisplayRIC = 'IDRA.BO' WHERE SecCode = 120588 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 127620 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 140399 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 140586 AND Type_ = 10; UPDATE data_universe SET Name = 'TRAFALGAR PROPERTY ORD GBP0.00001' WHERE SecCode = 142500 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951617.0 WHERE SecCode = 164382 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 178843 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'VLG', QuotePermID = 55838736391.0, ExchCode = 'MCE', PermQuoteRetireDate = '2013-08-09' WHERE SecCode = 182166 AND Type_ = 10; UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 182779 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21798248748.0, ExchCode = 'DEU' WHERE SecCode = 186452 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 192507 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21830289175.0, ExchCode = 'GTX' WHERE SecCode = 201949 AND Type_ = 10; UPDATE data_universe SET Name = 'LEXORA GLOBAL LTD INR10' WHERE SecCode = 256764 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 301125 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CA5629131031', RkdTicker = 'MANU', PermIDTicker = 'MANU', RkdSEDOL = 'BSNNS9', RkdCUSIP = '56291310', RkdRIC = 'MANU.V', RkdDisplayRIC = 'MANU.V', DsPrimQtSedol = 'BSNNS96' WHERE SecCode = 316714 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 343865 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'S CONNECT CO LTD KRW1000' WHERE SecCode = 349523 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 357924 AND Type_ = 10; UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 359624 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 557329 AND Type_ = 10; UPDATE data_universe SET Name = 'NEOVACS EUR0.0001' WHERE SecCode = 588831 AND Type_ = 10; UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 674803 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 806589 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 934968 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 956146 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 1002264 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 1211489 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 1226285 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-05-08' WHERE SecCode = 1254621 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1262120 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951684.0 WHERE SecCode = 1471745 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 1532756 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1534195 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21492779440.0, ExchCode = 'CPH' WHERE SecCode = 1541403 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'GRADIENTE', RkdRIC = 'GRAD.NS', RkdDisplayRIC = 'GRAD.NS', RkdExchCode = 'NSE' WHERE SecCode = 1611823 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 2204733 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2286302 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951373.0 WHERE SecCode = 2357968 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 2380623 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-05-05' WHERE SecCode = 2458784 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'TUINl', QuotePermID = 21553634480.0, ExchCode = 'BCO', PermQuoteRetireDate = '2015-05-20' WHERE SecCode = 2731347 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 2755820 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 2830896 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2831973 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 2846549 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-05-08' WHERE SecCode = 2911861 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'VGB' WHERE SecCode = 2926784 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951811.0 WHERE SecCode = 2928725 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 2945266 AND Type_ = 10; UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 2963479 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 2998985 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951949.0 WHERE SecCode = 3032260 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3033890 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951465.0 WHERE SecCode = 3043688 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951270.0 WHERE SecCode = 3103524 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951744.0 WHERE SecCode = 3199640 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 3201344 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951328.0 WHERE SecCode = 3275683 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 3287543 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 3288678 AND Type_ = 10; UPDATE data_universe SET Name = 'FLYDOO TECHNOLOGY HKD0.2' WHERE SecCode = 3289743 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951396.0 WHERE SecCode = 3295399 AND Type_ = 10; UPDATE data_universe SET IncCntry = 'GBR' WHERE SecCode = 3316565 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951779.0 WHERE SecCode = 3317674 AND Type_ = 10; UPDATE data_universe SET Name = 'ONCOINVENT ASA. NOK0.25' WHERE SecCode = 3320156 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21732297982.0, ExchCode = 'DUS' WHERE SecCode = 3324152 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951389.0 WHERE SecCode = 3339794 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 3341124 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 3370814 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'NXB.WA^G25' WHERE SecCode = 3386230 AND Type_ = 10; UPDATE data_universe SET Country = 'GBR' WHERE SecCode = 3395184 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951778.0 WHERE SecCode = 3401656 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 3403841 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951642.0 WHERE SecCode = 3429803 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'B24P.WA^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-07', endDate = '2026-05-07' WHERE SecCode = 3433491 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951284.0 WHERE SecCode = 3438134 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'SWE' WHERE SecCode = 3440355 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951807.0 WHERE SecCode = 3440406 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951791.0 WHERE SecCode = 3441675 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 3534901 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3545181 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 3566698 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21572528819.0, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3588129 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 3665631 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '2018-11-21' WHERE SecCode = 3668408 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951797.0 WHERE SecCode = 3716811 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951617.0 WHERE SecCode = 3776472 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3818857 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 3961773 AND Type_ = 10; UPDATE data_universe SET Name = 'KOREA MIRACLE PPL KRW100' WHERE SecCode = 3999398 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951786.0 WHERE SecCode = 4043054 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4049135 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-05-07', endDate = '2026-05-07' WHERE SecCode = 4054213 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4124817 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 4212247 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4307878 AND Type_ = 10; UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 4319483 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 4335841 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 4382911 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 4436942 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4444652 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951617.0 WHERE SecCode = 4476768 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4491669 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 4517656 AND Type_ = 10; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4561851 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21899163259.0, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30', endDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4645345 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4736609 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'ESP' WHERE SecCode = 4767842 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951764.0 WHERE SecCode = 4792275 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951911.0 WHERE SecCode = 4929225 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2026-05-06' WHERE SecCode = 5112392 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 5168302 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5239788 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '2023-03-17' WHERE SecCode = 5366265 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '2023-06-22' WHERE SecCode = 5449616 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '2023-06-23' WHERE SecCode = 5450886 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5493583 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951167.0 WHERE SecCode = 5495252 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 5527521 AND Type_ = 10; UPDATE data_universe SET RkdRIC = '452980.KQ^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-07', SecMapEndDate = '2026-05-06', PermQuoteRetireDate = '2026-05-07', endDate = '2026-05-06' WHERE SecCode = 5544127 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5553171 AND Type_ = 10; UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 5565405 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951768.0 WHERE SecCode = 5597635 AND Type_ = 10; UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 5610077 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5657384 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 5807801 AND Type_ = 10; UPDATE data_universe SET Name = 'ACME SOLAR HLDGS INR2' WHERE SecCode = 5993882 AND Type_ = 10; UPDATE data_universe SET IncCntry = 'THA' WHERE SecCode = 6006779 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6037549 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '2024-12-13' WHERE SecCode = 6039879 AND Type_ = 10; UPDATE data_universe SET RkdRIC = '7768.TW', RkdDisplayRIC = '7768.TW', DsExchMnem = 'TAI', RkdExchCode = 'TPE' WHERE SecCode = 6177697 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 6322268 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 6567895 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951330.0 WHERE SecCode = 6628822 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11200546 AND Type_ = 1; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11205402 AND Type_ = 1; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11209450 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = '2026-05-06' WHERE SecCode = 11218773 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 11219078 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 11222398 AND Type_ = 1; UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11222469 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 11226872 AND Type_ = 1; UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11232101 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11246642 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG2104U1159', RkdSEDOL = 'BSHW2L', RkdCUSIP = 'G2104U11', DsPrimQtSedol = 'BSHW2L9' WHERE SecCode = 11251022 AND Type_ = 1; UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'PKST.N^E26', DsCtryQtStatus = 'D', PrimaryIssueType = 'PVT', DsSecDelistDate = '2026-05-06', SecMapEndDate = '2026-05-05', endDate = '2026-05-05' WHERE SecCode = 11251539 AND Type_ = 1; UPDATE data_universe SET Name = 'UNION PWR METALS CORP COM' WHERE SecCode = 11257436 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 11259811 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 11261898 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11261939 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11270779 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CA2279211031', RkdTicker = 'CRG', RkdSEDOL = 'BVWQGQ', RkdCUSIP = '22792110', RkdRIC = 'CRG.V', RkdDisplayRIC = 'CRG.V', RkdCode = 144764.0, RkdIssueID = 1.0, RkdIssueCode = 185139.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CVE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11292733 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG3700S1241', RkdTicker = 'FMACU', RkdSEDOL = 'BWBR25', RkdCUSIP = 'G3700S12', RkdRIC = 'FMACU.O', RkdDisplayRIC = 'FMACU.OQ', RkdCode = 144758.0, RkdIssueID = 1.0, RkdIssueCode = 185131.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11293776 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US4829311020', RkdTicker = 'KLRA', RkdSEDOL = 'BVH8P1', RkdCUSIP = '48293110', RkdRIC = 'KLRA.O', RkdDisplayRIC = 'KLRA.OQ', RkdCode = 144755.0, RkdIssueID = 1.0, RkdIssueCode = 185127.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11294619 AND Type_ = 1;