UPDATE data_universe SET PermIDTicker = 'BRK A' WHERE SecCode = 9061 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BRK B' WHERE SecCode = 9062 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BIO B' WHERE SecCode = 9288 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BF A' WHERE SecCode = 10641 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BF B' WHERE SecCode = 10642 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 14621 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRF0S43' WHERE SecCode = 15660 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CMS PRB' WHERE SecCode = 16775 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 17276 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 17404 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 17405 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CRD B' WHERE SecCode = 17605 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CRD A' WHERE SecCode = 17606 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CTA PRA' WHERE SecCode = 22093 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CTA PRB' WHERE SecCode = 22094 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'EP PRC' WHERE SecCode = 23272 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AKO A' WHERE SecCode = 23546 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AKO B' WHERE SecCode = 23547 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AGM A' WHERE SecCode = 25551 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRF0S54' WHERE SecCode = 30186 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GS PRA' WHERE SecCode = 30802 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GS PRD' WHERE SecCode = 30820 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GS PRC' WHERE SecCode = 30826 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GTN A' WHERE SecCode = 31105 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GEF B' WHERE SecCode = 31364 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'DISTIL PLC ORD GBP0.0001' WHERE SecCode = 31491 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 32045 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'HVT A' WHERE SecCode = 32897 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'HL PRB' WHERE SecCode = 33143 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'HEI A' WHERE SecCode = 33149 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000331008.0, PriInstrPermID = 8590932904.0, PermOrgIPODate = '1991-07-01', startDate = '1991-07-01' WHERE SecCode = 33185 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'IRL' WHERE SecCode = 33937 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365555.0 WHERE SecCode = 39795 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1980-03-17' WHERE SecCode = 40071 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'LEN B' WHERE SecCode = 42029 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 42117 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'LXP PRC' WHERE SecCode = 42212 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-09-08' WHERE SecCode = 42719 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000359302.0, PriInstrPermID = 8589956852.0, PriTRBCIndPermID = 4294951830.0 WHERE SecCode = 43201 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 43332 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MKC V' WHERE SecCode = 45244 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MACO.I', QuotePermID = 21475575870.0, ExchCode = 'CCH', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BML PRH' WHERE SecCode = 46124 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BML PRH' WHERE SecCode = 46245 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BML PRG' WHERE SecCode = 46247 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BML PRJ' WHERE SecCode = 46278 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MET PRA' WHERE SecCode = 46459 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MOG A' WHERE SecCode = 47811 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MOG B' WHERE SecCode = 47812 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'DYH', QuotePermID = 21830308575.0, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 48143 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'FLG PRU' WHERE SecCode = 50367 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 50527 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRF0S76' WHERE SecCode = 53304 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1998-12-04' WHERE SecCode = 56748 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21605378798.0, ExchCode = 'STU', PermQuoteRetireDate = '2021-06-09' WHERE SecCode = 61290 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ALPER' WHERE SecCode = 66479 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951434.0 WHERE SecCode = 67915 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 68290 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1993-12-01' WHERE SecCode = 68545 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 70563 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 70607 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951245.0 WHERE SecCode = 71080 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, OrgPermID = 6000278159.0, PriInstrPermID = 8589974405.0, PriTRBCIndPermID = 4294951227.0, PermOrgIPODate = '2026-09-03', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 72108 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 74352 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 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 PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 76485 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951944.0 WHERE SecCode = 76580 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951474.0 WHERE SecCode = 77527 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'SRIKPRIND', RkdRIC = 'KPRI.NS', RkdDisplayRIC = 'KPRI.NS', RkdExchCode = 'NSE' WHERE SecCode = 78106 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1995-01-03' WHERE SecCode = 78542 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1991-02-01' WHERE SecCode = 79121 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1990-01-01' WHERE SecCode = 79534 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 79900 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 81053 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1995-01-02' WHERE SecCode = 81264 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1995-01-17' WHERE SecCode = 83652 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 83656 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1993-09-20' WHERE SecCode = 84392 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 85841 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365435.0 WHERE SecCode = 88648 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 88776 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 PermQuoteRetireDate = '2026-09-08' WHERE SecCode = 89953 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 90492 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951506.0 WHERE SecCode = 91288 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 92018 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951877.0 WHERE SecCode = 92019 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 92990 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 93203 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 95172 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 PermOrgIPODate = NULL, startDate = '1995-04-10' WHERE SecCode = 95810 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1995-01-02' WHERE SecCode = 95956 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 99424 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-10-01' WHERE SecCode = 105528 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 105667 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951551.0 WHERE SecCode = 111480 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'HAZOOR', RkdRIC = 'HAZO.NS', RkdDisplayRIC = 'HAZO.NS', RkdExchCode = 'NSE' WHERE SecCode = 111840 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2001-04-23' WHERE SecCode = 115198 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951931.0, PermOrgIPODate = NULL, startDate = '1995-01-02' WHERE SecCode = 115199 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1996-02-26' WHERE SecCode = 115971 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0, PermOrgIPODate = NULL, startDate = '1996-02-26' WHERE SecCode = 116611 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2004-03-16' WHERE SecCode = 123125 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 123129 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 125610 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 125636 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1993-07-13' WHERE SecCode = 126060 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951642.0 WHERE SecCode = 126323 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 126373 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 126538 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951880.0, PermOrgIPODate = NULL, startDate = '1999-12-06' WHERE SecCode = 126585 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 126620 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951638.0 WHERE SecCode = 126631 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0, PermOrgIPODate = NULL, startDate = '1995-04-19' WHERE SecCode = 131789 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AP' WHERE SecCode = 132659 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 134833 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1992-09-09' WHERE SecCode = 135531 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1993-07-13' WHERE SecCode = 135742 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1995-04-24' WHERE SecCode = 135970 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1995-01-02' WHERE SecCode = 136033 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1995-01-03' WHERE SecCode = 136284 AND Type_ = 10;
UPDATE data_universe SET Name = 'TCC CONCEPT INR2 (POST SUBD)' WHERE SecCode = 136492 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2003-10-21' WHERE SecCode = 136497 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951801.0 WHERE SecCode = 136505 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1992-11-04' WHERE SecCode = 136518 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 136891 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1995-05-26' WHERE SecCode = 137336 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951681.0 WHERE SecCode = 137571 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1995-01-06' WHERE SecCode = 139772 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951488.0 WHERE SecCode = 140965 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 141095 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 141892 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1995-01-03' WHERE SecCode = 142572 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951193.0 WHERE SecCode = 145731 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21507329852.0, ExchCode = 'FRA' WHERE SecCode = 178289 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 180085 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BAC PRE' WHERE SecCode = 187381 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2007-02-01' WHERE SecCode = 196159 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MER PRK' WHERE SecCode = 219026 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'EPR PRC' WHERE SecCode = 226023 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 243267 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 243307 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1994-01-07' WHERE SecCode = 254684 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'SWARNSAR', RkdRIC = 'SWAM.NS', RkdDisplayRIC = 'SWAM.NS', RkdExchCode = 'NSE' WHERE SecCode = 255787 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951844.0, PermOrgIPODate = NULL, startDate = '2004-10-28' WHERE SecCode = 256138 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951678.0, PermOrgIPODate = NULL, startDate = '2005-07-07' WHERE SecCode = 256143 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951464.0 WHERE SecCode = 256233 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1994-05-06' WHERE SecCode = 256235 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BML PRL' WHERE SecCode = 291977 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CIG C' WHERE SecCode = 306344 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 306685 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AHT PRD' WHERE SecCode = 313766 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'EQH PRC' WHERE SecCode = 323725 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BAC PRL' WHERE SecCode = 336538 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2026-09-03' WHERE SecCode = 340660 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'EPR PRE' WHERE SecCode = 345331 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 385733 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 386790 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 396021 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 424321 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 73191.0 WHERE SecCode = 427686 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'FRA' WHERE SecCode = 443158 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 450138 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951912.0 WHERE SecCode = 519106 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 519984 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 520005 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 557938 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 560843 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2010-05-14' WHERE SecCode = 588636 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 717246 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951841.0 WHERE SecCode = 784476 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951807.0 WHERE SecCode = 806589 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 823018 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PDI', DsPrimQtSedol = 'B3N05H9' WHERE SecCode = 890647 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'FCR.GB', QuotePermID = 21475653561.0, IsPrimaryQuote = 0.0, ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17', endDate = '2012-01-17' WHERE SecCode = 907800 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951807.0 WHERE SecCode = 934968 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '9PQ', Name = 'XMH HOLDINGS LTD NPV (POST SPLT)' WHERE SecCode = 966010 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2011-07-21' WHERE SecCode = 1154835 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951368.0, PermOrgIPODate = NULL, startDate = '2011-05-04' WHERE SecCode = 1164914 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 1270231 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 1471513 AND Type_ = 10;
UPDATE data_universe SET Name = 'INTEGRATED PROTEIN INR1 (POST SUBD)', SecMapEndDate = '2079-06-06', endDate = NULL WHERE SecCode = 1471725 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 1479222 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BTNMPF5' WHERE SecCode = 1494004 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 1525513 AND Type_ = 10;
UPDATE data_universe SET Name = 'OVERBOUNDS SA PLN0.10' WHERE SecCode = 1591241 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 1594649 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CTY1SN0112', QuotePermID = 21512394267.0, ExchCode = 'HEX' WHERE SecCode = 1677271 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2195914 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2217621 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BTNMPF5' WHERE SecCode = 2250544 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0, PermOrgIPODate = NULL WHERE SecCode = 2285078 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 2466351 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951477.0 WHERE SecCode = 2583472 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951488.0 WHERE SecCode = 2628633 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 2637948 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'C057M19' WHERE SecCode = 2813083 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VAD' WHERE SecCode = 2830908 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2911295 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951390.0 WHERE SecCode = 3002458 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3048457 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3124062 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951449.0 WHERE SecCode = 3166463 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3196987 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3223307 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 3233997 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951390.0 WHERE SecCode = 3263712 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3275685 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3282908 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3289827 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'DNK' WHERE SecCode = 3303273 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q6040T13' WHERE SecCode = 3309732 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PDI', DsPrimQtSedol = 'B3N05H9' WHERE SecCode = 3356354 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951495.0 WHERE SecCode = 3358237 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3365580 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 3368002 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG739531203', RkdSEDOL = 'BXD2KZ', RkdCUSIP = 'G7395312' WHERE SecCode = 3378476 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3407572 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3488287 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3504370 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PADL' WHERE SecCode = 3566802 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2018-02-27' WHERE SecCode = 3625876 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951354.0 WHERE SecCode = 3685243 AND Type_ = 10;
UPDATE data_universe SET Name = 'PATRIA PROPERTIES COTAS NPV' WHERE SecCode = 3852662 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3886819 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 3958670 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 = 'ROYAL CARIBBEAN GP BDR EACH 28 REPR 1 COM' WHERE SecCode = 4077638 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 OrgPermID = 6000276687.0, PriInstrPermID = 8590940388.0, DomCntry = 'HKG', IncCntry = 'HKG', PermOrgIPODate = '2026-09-02' WHERE SecCode = 4396374 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 DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-09-04', SecMapEndDate = '2025-12-18', PermQuoteRetireDate = '2026-09-04', endDate = '2025-12-18' WHERE SecCode = 4608552 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951896.0 WHERE SecCode = 4661381 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 21854742316.0 WHERE SecCode = 4761537 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 4787472 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951390.0 WHERE SecCode = 4842767 AND Type_ = 10;
UPDATE data_universe SET Name = 'KLEVO REWARDS LTD NPV' WHERE SecCode = 4871191 AND Type_ = 10;
UPDATE data_universe SET Name = 'HT ROBOTICS CO LTD KRW100', PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 4938157 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5227169 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'CLGUN' WHERE SecCode = 5288769 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5623997 AND Type_ = 10;
UPDATE data_universe SET Name = 'IQ SENSING AG NPV' WHERE SecCode = 5626508 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951807.0 WHERE SecCode = 5807801 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951506.0 WHERE SecCode = 5944557 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6082611 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 1.0 WHERE SecCode = 6672572 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951390.0 WHERE SecCode = 6857266 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE2KRP01017', RkdTicker = '544823', RkdSEDOL = 'BTMJ9W', RkdCUSIP = 'Y2S33R10', RkdRIC = 'DEVC.BO', RkdDisplayRIC = 'DEVC.BO', RkdCode = 145457.0, RkdIssueID = 1.0, RkdIssueCode = 186205.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'BOM', RkdExchCtry = 'IND', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6985946 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 7040442 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-08-12', PermQuoteRetireDate = '2026-09-04', PermSecMapEndDate = '2026-09-04', endDate = '2026-08-12' WHERE SecCode = 7040513 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-09-01' WHERE SecCode = 7080327 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951996.0 WHERE SecCode = 10927842 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'C PRN' WHERE SecCode = 10970877 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'KIM PRN' WHERE SecCode = 11001649 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 11022365 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CDR PRB' WHERE SecCode = 11029059 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MITT PRA' WHERE SecCode = 11034060 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MITT PRB' WHERE SecCode = 11035949 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ALL PRB' WHERE SecCode = 11045850 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MFA PRB' WHERE SecCode = 11072363 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FBRT PRE' WHERE SecCode = 11074374 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CMRE PRB' WHERE SecCode = 11103859 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FITB PRI' WHERE SecCode = 11112032 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CMRE PRC' WHERE SecCode = 11118639 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'DSX PRB' WHERE SecCode = 11129532 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ACR PRC' WHERE SecCode = 11136205 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GSL PRB' WHERE SecCode = 11138806 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CMRE PRD' WHERE SecCode = 11148112 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'DLNG PRA' WHERE SecCode = 11150414 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11153770 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BHR PRB' WHERE SecCode = 11158659 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AHT PRF' WHERE SecCode = 11160626 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AHL PRD' WHERE SecCode = 11162499 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CIM PRA' WHERE SecCode = 11163331 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AHT PRG' WHERE SecCode = 11163494 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MTB PRH' WHERE SecCode = 11163698 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AXS PRE' WHERE SecCode = 11164060 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MAA PRI' WHERE SecCode = 11165334 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'KEY PRI' WHERE SecCode = 11165492 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'DBRG PRH' WHERE SecCode = 11166631 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CIM PRB' WHERE SecCode = 11168237 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FLG PRA' WHERE SecCode = 11169439 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'NCSM.OQ^I26', RkdIssueStatus = 0.0 WHERE SecCode = 11171585 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'EFC PRD' WHERE SecCode = 11172191 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GLOP PRA' WHERE SecCode = 11172383 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'DBRG PRI' WHERE SecCode = 11172841 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CODI PRA' WHERE SecCode = 11173855 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AMH PRG' WHERE SecCode = 11174723 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'DLR PRJ' WHERE SecCode = 11175650 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'KIM PRL' WHERE SecCode = 11175816 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'IVR PRC' WHERE SecCode = 11175855 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CHMI PRA' WHERE SecCode = 11175876 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AHT PRH' WHERE SecCode = 11176004 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CDR PRC' WHERE SecCode = 11176005 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GNL PRA' WHERE SecCode = 11176665 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'DBRG PRJ' WHERE SecCode = 11176824 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'IIPR PRA' WHERE SecCode = 11177190 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'INN PRE' WHERE SecCode = 11178746 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AHT PRI' WHERE SecCode = 11178972 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'EPR PRG' WHERE SecCode = 11179435 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'EXXBF' WHERE SecCode = 11179802 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'KIM PRM' WHERE SecCode = 11180082 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GLOP PRB' WHERE SecCode = 11181055 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BFS PRD' WHERE SecCode = 11181176 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CODI PRB' WHERE SecCode = 11183036 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BH A' WHERE SecCode = 11185060 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 25727227247.0, PriValQuotePermID = 25727404555.0 WHERE SecCode = 11185229 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BAC PRB' WHERE SecCode = 11185260 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MET PRE' WHERE SecCode = 11185870 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'KEY PRJ' WHERE SecCode = 11188267 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BAC PRK' WHERE SecCode = 11189352 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AMH PRH' WHERE SecCode = 11189996 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CIM PRC' WHERE SecCode = 11190016 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'JPM PRD' WHERE SecCode = 11190112 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ASB PRE' WHERE SecCode = 11190165 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000250430.0, PriInstrPermID = 21664014678.0, IncCntry = 'USA', PriTRBCIndPermID = 1004365348.0 WHERE SecCode = 11190437 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'HIG PRG' WHERE SecCode = 11191516 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GLOP PRC' WHERE SecCode = 11191835 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BHR PRD' WHERE SecCode = 11191934 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CIM PRD' WHERE SecCode = 11193406 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'JPM PRC' WHERE SecCode = 11193440 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CHMI PRB' WHERE SecCode = 11193909 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'DLR PRK' WHERE SecCode = 11194629 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'DUK PRA' WHERE SecCode = 11195241 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'KEY PRK' WHERE SecCode = 11196142 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AGM PRD' WHERE SecCode = 11196683 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ATH PRA' WHERE SecCode = 11197810 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AHRT PRA' WHERE SecCode = 11197966 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BAC PRM' WHERE SecCode = 11198063 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'RLGDF' WHERE SecCode = 11199084 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ALL PRH' WHERE SecCode = 11199208 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AHL PRE' WHERE SecCode = 11199469 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SGRX' WHERE SecCode = 11199544 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FITB PRA' WHERE SecCode = 11199938 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'COF PRI' WHERE SecCode = 11200096 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BAC PRN' WHERE SecCode = 11200186 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BFS PRE' WHERE SecCode = 11200194 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MITT PRC' WHERE SecCode = 11200204 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FITB PRK' WHERE SecCode = 11200229 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'REXR PRC' WHERE SecCode = 11200236 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ATH PRB' WHERE SecCode = 11200284 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'DLR PRL' WHERE SecCode = 11200720 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CFG PRE' WHERE SecCode = 11201408 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'JPM PRJ' WHERE SecCode = 11201765 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ALL PRI' WHERE SecCode = 11201878 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CODI PRC' WHERE SecCode = 11202195 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'EQH PRA' WHERE SecCode = 11202374 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GNL PRB' WHERE SecCode = 11202377 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'T PRA' WHERE SecCode = 11202929 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-04', PermSecMapEndDate = '2026-09-04' WHERE SecCode = 11203030 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MET PRF' WHERE SecCode = 11204034 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'WFC PRZ' WHERE SecCode = 11204332 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ARR PRC' WHERE SecCode = 11204518 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'COF PRJ' WHERE SecCode = 11204681 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'DX PRC' WHERE SecCode = 11205274 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BEP PRA' WHERE SecCode = 11205405 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MFA PRC' WHERE SecCode = 11205555 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AGM PRE' WHERE SecCode = 11207756 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FHN PRE' WHERE SecCode = 11207942 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AUB PRA' WHERE SecCode = 11208266 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ASB PRF' WHERE SecCode = 11208548 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AGM PRF' WHERE SecCode = 11210964 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 11211670 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'COF PRK' WHERE SecCode = 11212132 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BIP PRA' WHERE SecCode = 11212340 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BAC PRO' WHERE SecCode = 11214168 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CFR PRB' WHERE SecCode = 11214700 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ATH PRD' WHERE SecCode = 11216185 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ALTG PRA' WHERE SecCode = 11216686 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BIP PRB' WHERE SecCode = 11217476 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BAC PRP' WHERE SecCode = 11217750 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PSYGF' WHERE SecCode = 11218243 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'JPM PRK' WHERE SecCode = 11220639 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'KREF PRA' WHERE SecCode = 11222460 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'COF PRL' WHERE SecCode = 11223239 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FHN PRF' WHERE SecCode = 11223240 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BW PRA' WHERE SecCode = 11223635 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'LFT PRA' WHERE SecCode = 11223641 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'JPM PRL' WHERE SecCode = 11224266 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ACR PRD' WHERE SecCode = 11224337 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AGM PRG' WHERE SecCode = 11224516 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ABR PRD' WHERE SecCode = 11224779 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PSA PRP' WHERE SecCode = 11225316 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BOH PRA' WHERE SecCode = 11225319 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CLDT PRA' WHERE SecCode = 11226159 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CMS PRC' WHERE SecCode = 11226258 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CTO PRA' WHERE SecCode = 11226405 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'JPM PRM' WHERE SecCode = 11227758 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'COF PRN' WHERE SecCode = 11227880 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ABR PRE' WHERE SecCode = 11228285 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'INN PRF' WHERE SecCode = 11228447 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ADC PRA' WHERE SecCode = 11229740 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FCLX', Name = 'FCL-X FIRE SAFETY INC COM', PermSecMapEndDate = '2026-09-04', endDate = '2026-09-04' WHERE SecCode = 11230021 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ICR PRA' WHERE SecCode = 11230025 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11230091 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ABR PRF' WHERE SecCode = 11231712 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BAC PRQ' WHERE SecCode = 11232407 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'HPP PRC' WHERE SecCode = 11233599 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GPMT PRA' WHERE SecCode = 11234520 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'EFC PRB' WHERE SecCode = 11235583 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GRBK PRA' WHERE SecCode = 11235957 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRF0SP4' WHERE SecCode = 11237445 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BAC PRS' WHERE SecCode = 11237688 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11238413 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5096767156.0, PriInstrPermID = 25727201584.0, DomCntry = 'JPN', IncCntry = 'CYM', PriTRBCIndPermID = 4294951411.0, PermOrgIPODate = '2026-07-24' WHERE SecCode = 11238417 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA29975G2036', RkdSEDOL = 'BX3H19', RkdCUSIP = '29975G20' WHERE SecCode = 11239946 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BANC PRF' WHERE SecCode = 11242408 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'KEY PRL' WHERE SecCode = 11244779 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'LNC PRD' WHERE SecCode = 11247419 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ATH PRE' WHERE SecCode = 11247942 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'RWT PRA' WHERE SecCode = 11248779 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'EFC PRC' WHERE SecCode = 11249375 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'JXN PRA' WHERE SecCode = 11250211 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'C057RK3' WHERE SecCode = 11251097 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ALL PRJ' WHERE SecCode = 11252887 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'APGE.OQ^I26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-04', PermSecMapEndDate = '2026-09-04' WHERE SecCode = 11255023 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000250531.0, PriInstrPermID = 232810448660.0, PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 11256250 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GNL PRD' WHERE SecCode = 11257020 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GNL PRE' WHERE SecCode = 11257021 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRF0S98' WHERE SecCode = 11258156 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SCE PRM' WHERE SecCode = 11259796 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SYF PRB' WHERE SecCode = 11262557 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ALB PRA' WHERE SecCode = 11263025 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MTB PRJ' WHERE SecCode = 11264984 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SCE PRN' WHERE SecCode = 11265053 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CFG PRH' WHERE SecCode = 11265224 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BOH PRB' WHERE SecCode = 11266183 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NEE PRS' WHERE SecCode = 11266248 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'RF PRF' WHERE SecCode = 11267534 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MS PRQ' WHERE SecCode = 11267598 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SBXD U' WHERE SecCode = 11268483 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'HPE PRC' WHERE SecCode = 11269360 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRF0SN2' WHERE SecCode = 11270239 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ARES PRB' WHERE SecCode = 11270461 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BA PRA' WHERE SecCode = 11271004 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NEE PRT' WHERE SecCode = 11271014 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AHL PRF' WHERE SecCode = 11271946 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'OPP PRC' WHERE SecCode = 11272074 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PCG PRX' WHERE SecCode = 11272243 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ANG PRD' WHERE SecCode = 11273823 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'JACS U' WHERE SecCode = 11274338 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'TRTN PRF' WHERE SecCode = 11274490 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'RPT PRC' WHERE SecCode = 11275337 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'RAC U' WHERE SecCode = 11275371 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'KKR PRD' WHERE SecCode = 11275698 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'XTND', DsPrimQtSedol = 'BWJJDD5', DsExchMnem = 'NYS', ExchCode = 'NYS', PermSecMapEndDate = '2026-09-04', endDate = '2026-09-04' WHERE SecCode = 11275776 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BNY PRK' WHERE SecCode = 11275816 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SOUL U' WHERE SecCode = 11276941 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FOUR PRA' WHERE SecCode = 11277892 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'COPL U' WHERE SecCode = 11277920 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'QXO PRB' WHERE SecCode = 11278511 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'JENA U' WHERE SecCode = 11278710 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'EVAC U' WHERE SecCode = 11280134 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PAII U' WHERE SecCode = 11280866 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CFG PRI' WHERE SecCode = 11281072 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'LOB PRA' WHERE SecCode = 11281338 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2025-07-30' WHERE SecCode = 11281412 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NLY PRJ' WHERE SecCode = 11281577 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AGM PRH' WHERE SecCode = 11283965 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2025-07-30', startDate = '2025-07-30' WHERE SecCode = 11284217 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'RITM PRE' WHERE SecCode = 11285480 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FCRS U' WHERE SecCode = 11285908 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRF0SF4' WHERE SecCode = 11285909 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BCSS U' WHERE SecCode = 11286100 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'YCY U' WHERE SecCode = 11286202 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'KRSP U' WHERE SecCode = 11286203 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AIIA U' WHERE SecCode = 11286420 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MTB PRK' WHERE SecCode = 11287356 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'VACI U' WHERE SecCode = 11287596 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PINE PRA' WHERE SecCode = 11287732 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'XRN PRB' WHERE SecCode = 11288131 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ALUB U' WHERE SecCode = 11288167 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BFH PRA' WHERE SecCode = 11288436 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SAC U' WHERE SecCode = 11289053 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SBXE U' WHERE SecCode = 11289054 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NWAX U' WHERE SecCode = 11289056 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BEBE U' WHERE SecCode = 11289728 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BIII U' WHERE SecCode = 11289847 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PNFP PRA' WHERE SecCode = 11290244 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PNFP PRB' WHERE SecCode = 11290245 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'TRTN PRG' WHERE SecCode = 11290373 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'RITM PRF' WHERE SecCode = 11290542 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'LEGO U' WHERE SecCode = 11290990 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'C PRR' WHERE SecCode = 11291081 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'UAC U' WHERE SecCode = 11291257 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'WPAC U' WHERE SecCode = 11291426 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FITB PRM' WHERE SecCode = 11291429 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ORCL PRD' WHERE SecCode = 11291462 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'IRAB U' WHERE SecCode = 11291485 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CLBR U' WHERE SecCode = 11291562 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'XFLH U' WHERE SecCode = 11291901 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'WHR PRA' WHERE SecCode = 11292486 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'TRAD U' WHERE SecCode = 11292538 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NEE PRV' WHERE SecCode = 11292600 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GLED U' WHERE SecCode = 11292836 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'KCAC U' WHERE SecCode = 11292838 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FHN PRH' WHERE SecCode = 11292917 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MTAL U' WHERE SecCode = 11293198 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BWIV U' WHERE SecCode = 11293509 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'KPET U' WHERE SecCode = 11293913 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CFTR PRA' WHERE SecCode = 11293937 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PLUN U' WHERE SecCode = 11294499 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'QRED U' WHERE SecCode = 11294535 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'KCA U' WHERE SecCode = 11294935 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'WENC U' WHERE SecCode = 11295154 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ETSS U' WHERE SecCode = 11295229 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BFH PRB' WHERE SecCode = 11295357 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'VECA U' WHERE SecCode = 11295427 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SAGU U' WHERE SecCode = 11295488 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'OTAI U' WHERE SecCode = 11295628 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AGM PRI' WHERE SecCode = 11295810 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'DGAC U' WHERE SecCode = 11296371 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FTRA U' WHERE SecCode = 11297191 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AAC U' WHERE SecCode = 11298526 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'VII U' WHERE SecCode = 11298692 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2026-07-07', startDate = '2026-07-07' WHERE SecCode = 11298897 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SAMO U' WHERE SecCode = 11299061 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11299220 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MTB PRL' WHERE SecCode = 11299344 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PSA PRT' WHERE SecCode = 11299527 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PNAQ U' WHERE SecCode = 11300259 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG5080G1091', RkdTicker = 'JTTT', RkdSEDOL = 'BV8CWJ', RkdCUSIP = 'G5080G10', RkdRIC = 'JTTT.O', RkdDisplayRIC = 'JTTT.OQ', RkdCode = 145456.0, RkdIssueID = 1.0, RkdIssueCode = 186204.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11300978 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 236813849964.0, PriValQuotePermID = 25726991618.0, IsPrimaryInstr = 1.0, startDate = '2026-08-18' WHERE SecCode = 11301300 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'JONE', QuotePermID = 236813846213.0, InstrPermID = 232933765320.0, OrgPermID = 6000135913.0, PriTrdQuotePermID = 236813846180.0, PriValQuotePermID = 25726991724.0, PriInstrPermID = 232933765320.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'XNG', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-07-14', PermSecMapStartDate = '2026-09-02', startDate = '2026-07-14' WHERE SecCode = 11301363 AND Type_ = 1;