UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 31098 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 35474 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 35486 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951891.0 WHERE SecCode = 36511 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'KWY' WHERE SecCode = 39746 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 43708 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 48843 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 49518 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-05-19' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951937.0 WHERE SecCode = 50491 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951354.0 WHERE SecCode = 53117 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951357.0 WHERE SecCode = 54202 AND Type_ = 10;
UPDATE data_universe SET Name = 'PUBLIC STORAGE COM' WHERE SecCode = 58032 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NSUd', QuotePermID = 21531132175.0, ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26', endDate = '2020-11-16' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951397.0 WHERE SecCode = 67941 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 69368 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 69369 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951745.0 WHERE SecCode = 69396 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2010-03-31' WHERE SecCode = 69502 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 69596 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951893.0 WHERE SecCode = 70372 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70756 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951291.0 WHERE SecCode = 70974 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'A BROWN CO INC PHP1' WHERE SecCode = 72327 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SHINSUNG E&G KRW5000' WHERE SecCode = 72400 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'ABS-CBN HLDGS CORP PDR EACH REP 1 SHARE PHP1' WHERE SecCode = 73513 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SG&G CORPORATION KRW1000' WHERE SecCode = 75930 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 ISIN = NULL, Name = 'DAEHAN FLOUR MILL KRW500' WHERE SecCode = 76196 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'ESSEN TECH KRW1000' WHERE SecCode = 77410 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78828 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC' WHERE SecCode = 79181 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79241 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 79958 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81810 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'HANCHANG PAPER CO KRW2500' WHERE SecCode = 82233 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'VITZRO SYS KRW2500' WHERE SecCode = 83317 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000463978', RkdTicker = 'BUYDA', PermIDTicker = 'BUYDA', RkdSEDOL = 'BT8PL7', RkdRIC = 'BUYDA.AX', RkdDisplayRIC = 'BUYDA.AX', DsPrimQtSedol = 'BT8PL73' WHERE SecCode = 83612 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 84824 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 85079 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 85244 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85834 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86132 AND Type_ = 10;
UPDATE data_universe SET Name = 'PLAYGRAM CO LTD KRW1000' WHERE SecCode = 86934 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87109 AND Type_ = 10;
UPDATE data_universe SET Name = 'PONYLINK CO  LTD KRW500' WHERE SecCode = 87466 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365603.0 WHERE SecCode = 88867 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 88882 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 DsCtryQtStatus = 'S' WHERE SecCode = 90013 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 90824 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 90856 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 90896 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 90904 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951354.0 WHERE SecCode = 91591 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951899.0 WHERE SecCode = 94094 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 1004365342.0 WHERE SecCode = 94232 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'A SORIANO CORP PHP1' WHERE SecCode = 94863 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 DsCtryQtStatus = 'S' WHERE SecCode = 95610 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 95664 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 96735 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951354.0 WHERE SecCode = 97724 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 99097 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951291.0 WHERE SecCode = 99519 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951357.0 WHERE SecCode = 100588 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SE0028925701', RkdSEDOL = 'BVVFNZ', RkdCUSIP = 'W5938H24', DsPrimQtSedol = 'BVVFNZ6' WHERE SecCode = 102754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 104994 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 105080 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 111560 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951699.0 WHERE SecCode = 112263 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951630.0 WHERE SecCode = 114518 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 114727 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 115419 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 116295 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 133785 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 136711 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 137316 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 141951 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'VISACHROME', PermIDTicker = 'VISACHROME' WHERE SecCode = 143733 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-05-28' WHERE SecCode = 145065 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 145246 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 145938 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'TH0922D10Z05', RkdSEDOL = 'BRJHXQ', DsPrimQtSedol = 'BRJHXQ7', PermSecMapEndDate = '2025-10-07', endDate = '2025-10-07' WHERE SecCode = 165534 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 169161 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 185120 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 200545 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'NC& CO LTD KRW2500' WHERE SecCode = 301125 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 302783 AND Type_ = 10;
UPDATE data_universe SET Name = 'GMA HOLDINGS INC PDR EACH REPR 7 COM SH' WHERE SecCode = 305465 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 321759 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 324858 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SANG BO KRW2500' WHERE SecCode = 324866 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951366.0 WHERE SecCode = 373240 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 467564 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951914.0 WHERE SecCode = 547445 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 555531 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 559112 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-05-21' WHERE SecCode = 577384 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 598890 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951852.0 WHERE SecCode = 773879 AND Type_ = 10;
UPDATE data_universe SET Name = 'KETO MOTORS LTD INR10 (POST SPLT)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 786648 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 897185 AND Type_ = 10;
UPDATE data_universe SET Name = 'SIRIUS MEDIA EUR100(POST CONSOLIDATION)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 1109069 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'CENP.BO', RkdDisplayRIC = 'CENP.BO' WHERE SecCode = 1208371 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1483929 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 QuotePermID = 21492779440.0, ExchCode = 'CPH' WHERE SecCode = 1541403 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 1582265 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 1614017 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 1720593 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951841.0 WHERE SecCode = 1948243 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'WINPAC INC KRW2500' WHERE SecCode = 2164376 AND Type_ = 10;
UPDATE data_universe SET Name = 'FAMIEN RESOURCES L NPV', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 2372641 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21532984899.0, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 2696579 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2708934 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2862763 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2988210 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'KMPHARMACEUTICAL C KRW500' WHERE SecCode = 3000144 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = 'BLN80X', DsPrimQtSedol = 'BLN80X0', PermSecMapEndDate = '2022-02-07', endDate = '2022-02-07' WHERE SecCode = 3002458 AND Type_ = 10;
UPDATE data_universe SET Name = 'SATOSHI HOLDINGS KRW500' WHERE SecCode = 3054014 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2016-08-01' WHERE SecCode = 3069380 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21724552589.0, PermQuoteStatus = 'AC', ExchCode = 'BTE', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3177550 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3194837 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3230626 AND Type_ = 10;
UPDATE data_universe SET Name = 'JK RIVER STONE REA KRW5000' WHERE SecCode = 3245596 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 3282990 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951506.0 WHERE SecCode = 3321104 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 3321123 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21732297982.0, ExchCode = 'DUS' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951774.0 WHERE SecCode = 3359156 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 3435654 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21650788270.0, ExchCode = 'INC' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'AAV', RkdRIC = 'AAV.HNO', RkdDisplayRIC = 'AAV.HNO', DsCtryQtStatus = 'A', RkdIssueStatus = 1.0, RkdExchCode = 'UPC', DsSecDelistDate = NULL, SecMapEndDate = '2079-06-06' WHERE SecCode = 3531558 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528819.0, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 3731076 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365612.0 WHERE SecCode = 3909704 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '149300.KN^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-20', SecMapEndDate = '2026-05-19', PermQuoteRetireDate = '2026-05-20', endDate = '2026-05-19' WHERE SecCode = 3945211 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 DsCtryQtStatus = 'A' WHERE SecCode = 4001156 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 4043071 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951852.0 WHERE SecCode = 4077659 AND Type_ = 10;
UPDATE data_universe SET Name = 'PUBLIC STORAG BDR EACH 5 REPR 1 COM' WHERE SecCode = 4079161 AND Type_ = 10;
UPDATE data_universe SET Name = 'POONGJEON PHARMACY KRW2500' WHERE SecCode = 4264582 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4287534 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 4291597 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 PriTRBCIndPermID = 4294951354.0 WHERE SecCode = 4388121 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4424403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4489164 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951750.0 WHERE SecCode = 4499133 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'LPGO', QuotePermID = 21799232905.0, InstrPermID = 21799228462.0, OrgPermID = 5037649251.0, PriValQuotePermID = 21799232905.0, PriInstrPermID = 21799228462.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'DC', PermInstrStatus = 'AC', ExchCode = 'STO', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'SWE', IncCntry = 'SWE', PriTRBCIndPermID = 4294951272.0, PermQuoteRetireDate = '2026-05-19', PermOrgIPODate = '2021-03-01', PermSecMapStartDate = '2021-02-19', PermSecMapEndDate = '2026-05-19', startDate = '2021-02-19' WHERE SecCode = 4513760 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 PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 4667070 AND Type_ = 10;
UPDATE data_universe SET Name = 'A BROWN CO INC PRF A' WHERE SecCode = 4786378 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236799369659.0, ExchCode = 'CHI' WHERE SecCode = 4815279 AND Type_ = 10;
UPDATE data_universe SET Name = 'PLC RESOURCES LTD NPV' WHERE SecCode = 4873658 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC' WHERE SecCode = 4882385 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21929410708.0, ExchCode = 'DUS' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 4914438 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951791.0 WHERE SecCode = 5022238 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5037204 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TMHK' WHERE SecCode = 5037215 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5096919 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951774.0 WHERE SecCode = 5119086 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21565180699.0, ExchCode = 'FRA' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5268198 AND Type_ = 10;
UPDATE data_universe SET Name = 'JUPITER LIFE LINE INR2' WHERE SecCode = 5527280 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC' WHERE SecCode = 5553171 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC' WHERE SecCode = 5597638 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 5611413 AND Type_ = 10;
UPDATE data_universe SET Name = 'A BROWN CO INC PRF B 8.25%' WHERE SecCode = 5668086 AND Type_ = 10;
UPDATE data_universe SET Name = 'A BROWN CO INC PREF C 8.75%' WHERE SecCode = 5668087 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5740525 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 5936371 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7803.TW', RkdDisplayRIC = '7803.TW', DsExchMnem = 'TAI', RkdExchCode = 'TPE' WHERE SecCode = 6012718 AND Type_ = 10;
UPDATE data_universe SET Name = 'HANGZHOU JIUYUAN CNY 1 H' WHERE SecCode = 6018237 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 6389714 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6448816 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 6522468 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GENOO', QuotePermID = 236804839165.0, InstrPermID = 232924875827.0, PriValQuotePermID = NULL, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermInstrStatus = 'NA', ExchCode = 'STO' WHERE SecCode = 6741012 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6839612 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'MYQ0452OO001', RkdTicker = 'GOLDLI', RkdSEDOL = 'BPDJH9', RkdRIC = 'GOLL.KL', RkdDisplayRIC = 'GOLL.KL', RkdCode = 144870.0, RkdIssueID = 1.0, RkdIssueCode = 185296.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'KUL', RkdExchCtry = 'MYS', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6857264 AND Type_ = 10;
UPDATE data_universe SET Name = 'COMMERCE SPLIT CORP COMMERCE SPLIT C' WHERE SecCode = 10958846 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 10966118 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11030383 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 11044262 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951322.0 WHERE SecCode = 11108466 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11108815 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11131840 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-19', PermSecMapEndDate = '2022-08-26', endDate = '2022-08-26' WHERE SecCode = 11139994 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951852.0 WHERE SecCode = 11141262 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11142544 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AGNPF', Name = 'GREY MATTERS HEALTH INC CL A COM' WHERE SecCode = 11156632 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 11166691 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 11169119 AND Type_ = 1;
UPDATE data_universe SET Name = 'PUBLIC STORAGE PFD SHS F 5.15%' WHERE SecCode = 11172866 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 11174891 AND Type_ = 1;
UPDATE data_universe SET Name = 'PUBLIC STORAGE 5.05% CUM PFD G' WHERE SecCode = 11175599 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11176237 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11183746 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11183776 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ULTHD', Name = 'NORDX METALS CORP COM', PermSecMapEndDate = '2023-12-27', endDate = '2023-12-27' WHERE SecCode = 11185275 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951249.0 WHERE SecCode = 11188389 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11193348 AND Type_ = 1;
UPDATE data_universe SET Name = 'PUBLIC STORAGE 5.60 DEPSHS RP H' WHERE SecCode = 11194414 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 11194993 AND Type_ = 1;
UPDATE data_universe SET Name = 'ATIF HOLDINGS LIMITED SHS NEW' WHERE SecCode = 11196570 AND Type_ = 1;
UPDATE data_universe SET Name = 'PUBLIC STORAGE 4.875% DP SH PFD' WHERE SecCode = 11200155 AND Type_ = 1;
UPDATE data_universe SET Name = 'PUBLIC STORAGE 4.7% DP SH PF J' WHERE SecCode = 11201898 AND Type_ = 1;
UPDATE data_universe SET Name = 'PUBLIC STORAGE 4.75 DP PFD SH K' WHERE SecCode = 11203150 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11207780 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 11207860 AND Type_ = 1;
UPDATE data_universe SET Name = 'PUBLIC STORAGE 4.625 DEP PFD L' WHERE SecCode = 11208520 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 11210769 AND Type_ = 1;
UPDATE data_universe SET Name = 'PUBLIC STORAGE 4.125 DP SH PF M' WHERE SecCode = 11210937 AND Type_ = 1;
UPDATE data_universe SET Name = 'PUBLIC STORAGE 3.875% DEP PFD N' WHERE SecCode = 11213097 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951855.0 WHERE SecCode = 11213537 AND Type_ = 1;
UPDATE data_universe SET Name = 'PUBLIC STORAGE 3.900% DEP PFD O' WHERE SecCode = 11214641 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 11214647 AND Type_ = 1;
UPDATE data_universe SET Name = 'REAL ESTATE SPLIT CORP REAL ESTATE SPLI' WHERE SecCode = 11214925 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951855.0 WHERE SecCode = 11215416 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2025-11-21', endDate = '2025-11-21' WHERE SecCode = 11218121 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA68405H3080', RkdSEDOL = 'BT3HLN', RkdCUSIP = '68405H30', DsPrimQtSedol = 'BT3HLN0' WHERE SecCode = 11222037 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'QTEX', RkdRIC = 'QTEX.O', RkdDisplayRIC = 'QTEX.OQ' WHERE SecCode = 11222088 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-05-19', SecMapEndDate = '2026-05-18', endDate = '2026-05-18' WHERE SecCode = 11224336 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951765.0 WHERE SecCode = 11224802 AND Type_ = 1;
UPDATE data_universe SET Name = 'PUBLIC STORAGE 4% DEP SHS PFD P' WHERE SecCode = 11225316 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'MCW.OQ^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-20', SecMapEndDate = '2026-05-18', endDate = '2026-05-18' WHERE SecCode = 11226283 AND Type_ = 1;
UPDATE data_universe SET Name = 'PUBLIC STORAGE 3.950% DEP PFD Q' WHERE SecCode = 11228572 AND Type_ = 1;
UPDATE data_universe SET Name = 'PUBLIC STORAGE 4% DEP PFD SHS R' WHERE SecCode = 11233801 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 11233871 AND Type_ = 1;
UPDATE data_universe SET Name = 'PUBLIC STORAGE 4.100% DP PFD S' WHERE SecCode = 11236692 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NPV', Name = 'NEXT PHASE VENTURES LTD COM SHS', SecMapStartDate = '2022-01-21', PermSecMapEndDate = '2026-05-19', endDate = '2026-05-19' WHERE SecCode = 11237323 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-05-15', SecMapEndDate = '2026-05-14', endDate = '2026-05-14' WHERE SecCode = 11237837 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 11260949 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2025-06-14', endDate = '2025-06-14' WHERE SecCode = 11264491 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951852.0 WHERE SecCode = 11279768 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11282219 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2026-03-26', startDate = '2026-03-26' WHERE SecCode = 11293820 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236805703971.0, InstrPermID = 232929334025.0, OrgPermID = 5038041006.0, PriValQuotePermID = 236805703971.0, PriInstrPermID = 21488861716.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'AC', ExchCode = 'TOR', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951901.0, PermQuoteRetireDate = '2026-05-19', PermOrgIPODate = '2012-05-16', PermSecMapStartDate = '2026-04-15', PermSecMapEndDate = '2026-05-19', startDate = '2026-04-15' WHERE SecCode = 11294571 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, IsMajorSec = 'N', RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL, PriInstrPermID = 232901226787.0 WHERE SecCode = 11295427 AND Type_ = 1;
