UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 1331 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 1332 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 1333 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 1334 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 1.0 WHERE SecCode = 7851 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 1.0, startDate = '1994-04-04' WHERE SecCode = 27995 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 0.0, startDate = '1996-11-26' WHERE SecCode = 28133 AND Type_ = 10;
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 SecMapEndDate = '2026-04-17' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 57743 AND Type_ = 1;
UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 70619 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'KUWAIT & GULF LINK KWD0.1' WHERE SecCode = 70784 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 27974.0 WHERE SecCode = 70930 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'TPC ROBOTICS CORPO KRW500.00' WHERE SecCode = 78942 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1996-08-12' WHERE SecCode = 79135 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'ECO SIMPLEX CO LTD KRW500' WHERE SecCode = 80274 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86003 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 89309 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 92379 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 93467 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2004-12-15', startDate = '2004-12-07' WHERE SecCode = 124012 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 125758 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'CNTL', RkdRIC = 'CNTL.S', RkdDisplayRIC = 'CNTL.S', Name = 'CENTIEL AG CHF0.01(REGD)' WHERE SecCode = 146022 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'IBIS-M' WHERE SecCode = 146133 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21507329852.0, ExchCode = 'FRA' WHERE SecCode = 178289 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21798248733.0, ExchCode = 'FRA' WHERE SecCode = 186452 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951740.0 WHERE SecCode = 296704 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SHINHWAPRITECH CO KRW500' WHERE SecCode = 332640 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475473202.0, ExchCode = 'FRA' WHERE SecCode = 351305 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 355079 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2002-11-27' WHERE SecCode = 367326 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 369170 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2007-08-21' WHERE SecCode = 380968 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'UNITED FID INS CO AED1' WHERE SecCode = 395061 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 532611 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'GARCIA LLORENTE LE COM NPV' WHERE SecCode = 563078 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 586319 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951740.0 WHERE SecCode = 1468604 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRDG', QuotePermID = 21512147101.0, ExchCode = 'LSE', PermQuoteRetireDate = '2013-12-17' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET Name = 'ASGARD ALCOBEV LTD INR1 (POST SUBD)' WHERE SecCode = 1997874 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'ROYAL.IS^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-04-17', SecMapEndDate = '2022-12-22', endDate = '2022-12-22' WHERE SecCode = 2226891 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'JTLD.BO', RkdDisplayRIC = 'JTLD.BO' WHERE SecCode = 2469416 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2014-02-10' WHERE SecCode = 2470094 AND Type_ = 10;
UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 2633145 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'UBUNTU MINING & ME ORD USD0.0005 (DI)' WHERE SecCode = 2841844 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 2990814 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21587931857.0, ExchCode = 'BTE' WHERE SecCode = 3157265 AND Type_ = 10;
UPDATE data_universe SET Name = 'LTM LTD INR1' WHERE SecCode = 3216906 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21597458276.0, ExchCode = 'BER', PermQuoteRetireDate = '2020-07-27', endDate = '2020-07-27' WHERE SecCode = 3255119 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21610513041.0, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951617.0 WHERE SecCode = 3321532 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667482861.0, ExchCode = 'QTX' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3394207 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'PASHUPATI COTSPIN INR1 POST SUBD' WHERE SecCode = 3396301 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 3631179 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951949.0 WHERE SecCode = 4066630 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236805846657.0 WHERE SecCode = 4369879 AND Type_ = 10;
UPDATE data_universe SET RkdListingType = 'OSR', ShPerListing = NULL, PrimaryIssueCode = NULL, RelType = NULL WHERE SecCode = 4540648 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 4616827 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21884462002.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22', endDate = '2024-10-21' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 4659794 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 134486.0 WHERE SecCode = 5183014 AND Type_ = 10;
UPDATE data_universe SET Name = 'BLUEVENTURE GP PCL THB0.5 (LOCAL)' WHERE SecCode = 5341591 AND Type_ = 10;
UPDATE data_universe SET Name = 'BLUEVENTURE GP PCL THB0.5 (NVDR)' WHERE SecCode = 5341593 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236778108786.0, ExchCode = 'FRA' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5567938 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 5678857 AND Type_ = 10;
UPDATE data_universe SET Name = 'GRAND FIELD GROUP HKD0.2 (PARALLEL 05/06/24)', Country = 'BMU' WHERE SecCode = 5740794 AND Type_ = 10;
UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 5842997 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7821.TW', RkdDisplayRIC = '7821.TW', RkdExchCode = 'TPE' WHERE SecCode = 6213117 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 6371486 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, RkdCode = 142478.0, RkdIssueCode = 181752.0, RkdExchCode = 'NA', RkdExchCtry = NULL, PrimaryIssueType = 'IPO', PrimaryIssueCode = NULL, COATypeCode = '' WHERE SecCode = 6383728 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000459869', RkdTicker = 'KOA', RkdSEDOL = 'BV5KTG', RkdCUSIP = 'Q5S49R10', RkdRIC = 'KOA.AX', RkdDisplayRIC = 'KOA.AX', RkdCode = 144691.0, RkdIssueID = 1.0, RkdIssueCode = 185011.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6752847 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-04-02' WHERE SecCode = 6756391 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6782575 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-04-16' WHERE SecCode = 6782580 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6786369 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 10964740 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BX54GQ5', SecMapEndDate = '2026-04-17', endDate = '2026-04-17' WHERE SecCode = 11065371 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 11108968 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'P' WHERE SecCode = 11152585 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BRFAF', QuotePermID = 236805847074.0, InstrPermID = 192761166589.0, OrgPermID = 4295861073.0, PriValQuotePermID = 25727426172.0, PriInstrPermID = 8590936126.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'PNK', QuoteClass = 'CUM', InstrClass = 'CUM', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951362.0, PermOrgIPODate = '1997-08-11', PermSecMapStartDate = '2026-04-16' WHERE SecCode = 11175901 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11189974 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 11190562 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 11191167 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236805784996.0, ExchCode = 'NAS', PermSecMapStartDate = '2026-04-16' WHERE SecCode = 11198767 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'RADLF' WHERE SecCode = 11199082 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 1000.0 WHERE SecCode = 11213058 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 11231953 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 11234694 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BX54GT8' WHERE SecCode = 11248163 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BX54GY3' WHERE SecCode = 11267015 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11269127 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11278158 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'XNDU', ModelCntry = 'CA', InfoCode = 395680, DsSecCode = 272226, DsCmpyCode = 213128, DsCtryQtStatus = 'A', DsPrimQtSedol = 'BV4KDC5', DsExchMnem = 'TSE', DsExchCtryCode = 'CA', DsQuoteCurr = 'CAD', QuotePermID = 236804840324.0, InstrPermID = 232925343954.0, OrgPermID = 5097043523.0, PriTrdQuotePermID = NULL, PriValQuotePermID = 236804840324.0, PriInstrPermID = 232925343954.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TOR', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951211.0, DsSecDelistDate = NULL, DsExchQtStartDate = '2026-03-27', SecMapStartDate = '2026-03-27', SecMapEndDate = '2079-06-06', PermQuoteRetireDate = NULL, PermOrgIPODate = '2026-03-27', PermSecMapStartDate = '2026-03-26', PermSecMapEndDate = NULL, startDate = '2026-03-26', endDate = NULL WHERE SecCode = 11278379 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVFCFD5' WHERE SecCode = 11281132 AND Type_ = 1;
UPDATE data_universe SET Name = 'PHILIP MORRIS INTL INC CDN DEPOSITORY' WHERE SecCode = 11286870 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL, IsPrimaryInstr = 0.0 WHERE SecCode = 11292424 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL, IsPrimaryInstr = 0.0 WHERE SecCode = 11293452 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ARXS', QuotePermID = 236805784979.0, InstrPermID = 232929296078.0, OrgPermID = 6000074238.0, PriTrdQuotePermID = 236805784967.0, PriValQuotePermID = 25727026374.0, PriInstrPermID = 232929296078.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'GSA', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951856.0, PermOrgIPODate = '2026-04-16', PermSecMapStartDate = '2026-04-16' WHERE SecCode = 11294537 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MAIR', QuotePermID = 236805673770.0, InstrPermID = 232925743698.0, OrgPermID = 6000054142.0, PriTrdQuotePermID = 236805673770.0, PriValQuotePermID = 25727026992.0, PriInstrPermID = 232925743698.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951796.0, PermOrgIPODate = '2026-04-16', PermSecMapStartDate = '2026-04-14', startDate = '2026-04-14' WHERE SecCode = 11294562 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236805703971.0, IsPrimaryQuote = 1.0, ExchCode = 'TOR' WHERE SecCode = 11294571 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG1R59W1019', RkdTicker = 'BHAV', PermIDTicker = 'BHAV', RkdSEDOL = 'BVPKCV', RkdCUSIP = 'G1R59W10', RkdRIC = 'BHAV.O', RkdDisplayRIC = 'BHAV.OQ', RkdCode = 144555.0, RkdIssueID = 1.0, RkdIssueCode = 184745.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND', QuotePermID = 236805704846.0, InstrPermID = 232915006505.0, OrgPermID = 6000031381.0, PriTrdQuotePermID = 236805704846.0, PriValQuotePermID = 25727026729.0, PriInstrPermID = 232915006505.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-03-19', PermSecMapStartDate = '2026-04-15', startDate = '2026-03-19' WHERE SecCode = 11294588 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG2294A1013', RkdTicker = 'CTAA', PermIDTicker = 'CTAA', RkdSEDOL = 'BSRD8B', RkdCUSIP = 'G2294A10', RkdRIC = 'CTAA.O', RkdDisplayRIC = 'CTAA.OQ', RkdCode = 144463.0, RkdIssueID = 1.0, RkdIssueCode = 184556.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '', QuotePermID = 236805704694.0, InstrPermID = 232918789762.0, OrgPermID = 6000034622.0, PriTrdQuotePermID = 236805704694.0, PriValQuotePermID = 25727026760.0, PriInstrPermID = 232918789762.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-02-24', PermSecMapStartDate = '2026-04-15', startDate = '2026-02-24' WHERE SecCode = 11294590 AND Type_ = 1;
