UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 1339 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-01-05' WHERE SecCode = 8411 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 10318 AND Type_ = 1; UPDATE data_universe SET PermQuoteRetireDate = '2026-01-05' WHERE SecCode = 11436 AND Type_ = 10; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 13060 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 16121 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 16122 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'CYRE4', Name = 'CYRELA BRAZIL REAL PREF SHS NPV', QuotePermID = 236801035853.0, PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-12-31', PermSecMapEndDate = NULL, startDate = '1997-03-05' WHERE SecCode = 27637 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 28016 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 28247 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 28281 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 28313 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 28959 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 32226 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 36636 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 42571 AND Type_ = 1; UPDATE data_universe SET RkdRIC = 'PTIX.PK', RkdDisplayRIC = 'PTIX.PK', RkdExchCode = 'OTC', PermQuoteRetireDate = '2026-01-05' WHERE SecCode = 47024 AND Type_ = 1; UPDATE data_universe SET SecMapEndDate = '2026-01-02', endDate = '2026-01-01' WHERE SecCode = 49578 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2026-01-02', endDate = '2026-01-01' WHERE SecCode = 49579 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 53589 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 53590 AND Type_ = 1; UPDATE data_universe SET ISIN = NULL, Name = 'MAISON POMMERY & A EUR15' WHERE SecCode = 54959 AND Type_ = 10; UPDATE data_universe SET DsPrimQtSedol = 'BV6GRD0', DsExchMnem = 'NYS' WHERE SecCode = 55932 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58033 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58035 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58038 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58040 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58041 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58042 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58044 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58045 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58047 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58049 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58051 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58053 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58054 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58057 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58059 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58060 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58062 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58063 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58064 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58065 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58066 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58067 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58068 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 58069 AND Type_ = 1; UPDATE data_universe SET RkdRIC = 'PRPH.PK', RkdDisplayRIC = 'PRPH.PK', RkdExchCode = 'OTC', PermQuoteRetireDate = '2026-01-05' WHERE SecCode = 58625 AND Type_ = 1; UPDATE data_universe SET DomCntry = 'ITA' WHERE SecCode = 59357 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21805754481.0, ExchCode = 'MUN' WHERE SecCode = 61290 AND Type_ = 10; UPDATE data_universe SET Name = 'GENESIS SCALE HOLD HKD0.1' WHERE SecCode = 74702 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 79959 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CA60283L8087', RkdCUSIP = '60283L80', DsPrimQtSedol = 'BWJF8V6' WHERE SecCode = 80076 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 81622 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 81623 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 81624 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 81625 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'HACHIJUNI NAGANO NPV' WHERE SecCode = 82021 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 82871 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 84832 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 84833 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 84834 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 87795 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951893.0 WHERE SecCode = 91113 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 93580 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 93581 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 93582 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 93583 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 95750 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 96403 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 96404 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 96405 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 98616 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951868.0 WHERE SecCode = 98668 AND Type_ = 1; UPDATE data_universe SET ISIN = NULL, Name = 'LUOTEA OYJ NPV', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 99925 AND Type_ = 10; UPDATE data_universe SET Name = 'ORION DIGITAL CORP COM' WHERE SecCode = 100496 AND Type_ = 1; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 112861 AND Type_ = 10; UPDATE data_universe SET Name = 'CHUANGLIAN HOLDING HKD0.1' WHERE SecCode = 120434 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'TRAIL HEAD GLOBAL NPV' WHERE SecCode = 126255 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'ALGOQUANT', RkdRIC = 'ALGO.NS', RkdDisplayRIC = 'ALGO.NS', RkdExchCode = 'NSE' WHERE SecCode = 136743 AND Type_ = 10; UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-01-02', endDate = '2026-01-02' WHERE SecCode = 137412 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 150950 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'LANE B', PermIDTicker = 'LANE B', RkdRIC = 'LANEb.TE', RkdDisplayRIC = 'LANEb.TE' WHERE SecCode = 167478 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 182364 AND Type_ = 1; UPDATE data_universe SET PermQuoteRetireDate = '2026-01-05' WHERE SecCode = 292089 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 306344 AND Type_ = 1; UPDATE data_universe SET RkdTicker = 'ADG', PermIDTicker = 'ADG', RkdRIC = 'ADG.V', RkdDisplayRIC = 'ADG.V', RkdExchCode = 'CVE', ExchCode = 'CVE' WHERE SecCode = 330899 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 392425 AND Type_ = 10; UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-01-02' WHERE SecCode = 401626 AND Type_ = 10; UPDATE data_universe SET RkdCUSIP = 'Q8477919', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 557332 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'SHANGHAI BAO PHARM ''A''CNY1' WHERE SecCode = 559591 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-02', SecMapEndDate = '2025-12-30', PermQuoteRetireDate = '2026-01-02', endDate = '2025-12-30' WHERE SecCode = 564282 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 566423 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 999958 AND Type_ = 10; UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-01-02', endDate = '2026-01-02' WHERE SecCode = 1192471 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 1206764 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'RENDONG HOLDINGS ''A''CNY' WHERE SecCode = 1481671 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'MULTI COMMODITY EX INR2(POST SUBD)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 1543855 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 1898313 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2271010 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 2559050 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'RS HLDGS CO LTD NPV' WHERE SecCode = 2826667 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2833848 AND Type_ = 10; UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2025-12-30', PermQuoteRetireDate = '2026-01-02', PermSecMapEndDate = '2026-01-02', endDate = '2025-12-30' WHERE SecCode = 2837464 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21762568152.0, ExchCode = 'MUN', PermQuoteRetireDate = '2022-06-07', endDate = '2022-06-07' WHERE SecCode = 2944460 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21628902471.0, ExchCode = 'MUN' WHERE SecCode = 2982615 AND Type_ = 10; UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-01-02', endDate = '2026-01-02' WHERE SecCode = 3017884 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951259.0 WHERE SecCode = 3220407 AND Type_ = 10; UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-01-02', PermSecMapEndDate = '2026-01-02' WHERE SecCode = 3247566 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'VEONa', QuotePermID = 21610682901.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-11' WHERE SecCode = 3320065 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 3395200 AND Type_ = 10; UPDATE data_universe SET Name = 'DHANUKA INFRA RLTY INR10' WHERE SecCode = 3396340 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 3406031 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'CRAVIA INC NPV' WHERE SecCode = 3441671 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'GLC GP INC NPV' WHERE SecCode = 3699312 AND Type_ = 10; UPDATE data_universe SET RkdCUSIP = 'Y7S8VK10' WHERE SecCode = 4291597 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-01-05' WHERE SecCode = 4425686 AND Type_ = 10; UPDATE data_universe SET Name = 'HI-CRATES CO LTD NPV' WHERE SecCode = 4453367 AND Type_ = 10; UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2025-10-01', PermQuoteRetireDate = '2026-01-02', PermSecMapEndDate = '2026-01-02', endDate = '2025-10-01' WHERE SecCode = 4648163 AND Type_ = 10; UPDATE data_universe SET OrgPermID = 5097077715.0, PriInstrPermID = 25727283306.0 WHERE SecCode = 4682731 AND Type_ = 10; UPDATE data_universe SET Name = 'UNISOL HLDGS CORP NPV' WHERE SecCode = 4726091 AND Type_ = 10; UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe SET Name = 'QUANTS RESEARCH IN NPV' WHERE SecCode = 5063452 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-01-05' WHERE SecCode = 5142544 AND Type_ = 10; UPDATE data_universe SET RkdCUSIP = 'Y458W110' WHERE SecCode = 5182784 AND Type_ = 10; UPDATE data_universe SET RkdCUSIP = 'Y7T7TF11' WHERE SecCode = 5391301 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21975266861.0, ExchCode = 'DEU' WHERE SecCode = 5458395 AND Type_ = 10; UPDATE data_universe SET Name = 'NAMAN INDS PROXIMA INR10' WHERE SecCode = 5710432 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'DE000A40ZTT8', RkdTicker = 'TIW', RkdSEDOL = 'BP7M05', RkdCUSIP = 'D8T5DM10', RkdRIC = 'TIWn.DE', RkdDisplayRIC = 'TIWn.DE', RkdCode = 143867.0, RkdIssueID = 1.0, RkdIssueCode = 183745.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ETR', RkdExchCtry = 'DEU', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6289734 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 6394290 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'AU0000408783', RkdTicker = 'GG1', RkdSEDOL = 'BN2RMR', RkdCUSIP = 'Q4352F10', RkdRIC = 'GG1.AX', RkdDisplayRIC = 'GG1.AX', RkdCode = 143863.0, RkdIssueID = 1.0, RkdIssueCode = 183733.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6431509 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'AU0000432627', RkdTicker = 'BMC', RkdSEDOL = 'BVMR2Q', RkdRIC = 'BMC.AX', RkdDisplayRIC = 'BMC.AX', RkdCode = 143864.0, RkdIssueID = 1.0, RkdIssueCode = 183734.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'EDR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', ShPerListing = 1.0, PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6593846 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6612459 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 10905998 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 10909137 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 10929178 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 10959669 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 10971067 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 10986750 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 10990105 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11001704 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11005364 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CA3799631013', RkdTicker = 'GOGO', PermIDTicker = 'GOGO', RkdCUSIP = '37996310', RkdRIC = 'GOGO.CD', RkdDisplayRIC = 'GOGO.CD', DsPrimQtSedol = 'BSD5QY3' WHERE SecCode = 11005398 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11007008 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11012632 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11015874 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11016249 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11016618 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11020384 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11021256 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11021392 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11022803 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11023855 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11025238 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11026188 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11026560 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11029359 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11029374 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11030048 AND Type_ = 1; UPDATE data_universe SET Name = 'BRC GROUP HOLDINGS INC COM' WHERE SecCode = 11030646 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11033570 AND Type_ = 1; UPDATE data_universe SET DsPrimQtSedol = 'BT9QTM6' WHERE SecCode = 11035590 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11035680 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11042340 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11044249 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11045966 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11069298 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11071091 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11075610 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11077102 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11078624 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11103859 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11108102 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11112544 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11118639 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11130076 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11131299 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11135612 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11135892 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11137665 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11138800 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11140147 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11142439 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11142849 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11156741 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11160125 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11164995 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11165007 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11173218 AND Type_ = 1; UPDATE data_universe SET RkdTicker = 'HELP', PermIDTicker = 'HELP', RkdRIC = 'HELP.NLB', RkdDisplayRIC = 'HELP.NLB' WHERE SecCode = 11180990 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11181550 AND Type_ = 1; UPDATE data_universe SET Name = 'PINNACLE FINL PARTNERS INC FIXED TO FLTG RA' WHERE SecCode = 11186432 AND Type_ = 1; UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe SET Name = 'PINNACLE FINL PARTNERS INC FIXED RATE RESET' WHERE SecCode = 11198210 AND Type_ = 1; UPDATE data_universe SET Name = 'BRC GROUP HOLDINGS INC 6.875 DP SH PF A' WHERE SecCode = 11200979 AND Type_ = 1; UPDATE data_universe SET Name = 'BRC GROUP HOLDINGS INC 7.375 DP CUM B' WHERE SecCode = 11211866 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG6223S1259', RkdSEDOL = 'BWJDYL', RkdCUSIP = 'G6223S12', DsPrimQtSedol = 'BWJDYL2', PermSecMapEndDate = '2025-12-05', endDate = '2025-12-05' WHERE SecCode = 11217561 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US81256L3024', RkdCUSIP = '81256L30', DsPrimQtSedol = 'BWJDYD4' WHERE SecCode = 11221158 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG4691A1141', RkdCUSIP = 'G4691A11', DsPrimQtSedol = 'BTCLRT1', RkdListingType = 'OSR', ShPerListing = NULL, QuoteClass = 'ORD', InstrClass = 'ORD' WHERE SecCode = 11221669 AND Type_ = 1; UPDATE data_universe SET RkdRIC = 'BSLK.PK', RkdDisplayRIC = 'BSLK.PK', RkdExchCode = 'OTC', PermQuoteRetireDate = '2026-01-05' WHERE SecCode = 11223867 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11226010 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'MOOOF' WHERE SecCode = 11245786 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11268922 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CA6573361038', RkdTicker = 'NATO', RkdCUSIP = '65733610', RkdRIC = 'NATO.CD', RkdDisplayRIC = 'NATO.CD', DsPrimQtSedol = 'BT9QTR1' WHERE SecCode = 11271493 AND Type_ = 1; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11289546 AND Type_ = 1; UPDATE data_universe SET PermQuoteRetireDate = '2026-01-05' WHERE SecCode = 11289567 AND Type_ = 1;