UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'CALICHERAB.SN^C26', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-03-14' WHERE SecCode = 27134 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'CALICHERAA.SN^C26', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-03-14' WHERE SecCode = 29418 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = 'BV4J1X', DsPrimQtSedol = 'BV4J1X9', PermSecMapEndDate = '2026-03-14', endDate = '2026-03-14' WHERE SecCode = 32827 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 41255 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55846120871.0, ExchCode = 'CPH' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'ROLLI.ST^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-16', endDate = '2026-03-16' WHERE SecCode = 57722 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 65489 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-17' WHERE SecCode = 74558 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ASP' WHERE SecCode = 75796 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'PLAT.SI^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-16', SecMapEndDate = '2026-02-13', PermQuoteRetireDate = '2026-03-16', PermSecMapEndDate = '2026-03-15', endDate = '2026-02-13' WHERE SecCode = 76930 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '8063.HK^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-03-16', SecMapEndDate = '2026-03-13', PermSecMapEndDate = '2026-03-15', endDate = '2026-03-13' WHERE SecCode = 78626 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 84305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85361 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86796 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '8211.HK^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-03-16', SecMapEndDate = '2026-03-13', PermSecMapEndDate = '2026-03-15', endDate = '2026-03-13' WHERE SecCode = 88266 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 89357 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000056933.0, PriTRBCIndPermID = 4294951901.0, PermOrgIPODate = NULL WHERE SecCode = 90294 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 91289 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 92639 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '5386.NG', RkdDisplayRIC = '5386.NG', RkdExchCode = 'NAG' WHERE SecCode = 97224 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475425498.0, ExchCode = 'POS', PermQuoteRetireDate = '2008-04-26', endDate = '2008-04-26' WHERE SecCode = 142661 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 185740 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21798248748.0, ExchCode = 'DEU' WHERE SecCode = 186452 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836393879.0, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-18' WHERE SecCode = 297213 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 323357 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475473201.0, ExchCode = 'GER' WHERE SecCode = 351305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-16', PermQuoteRetireDate = '2026-03-16', endDate = '2026-03-16' WHERE SecCode = 370767 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-31' WHERE SecCode = 454277 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '0802.HK^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-03-16', PermSecMapEndDate = '2026-03-15', endDate = '2026-03-15' WHERE SecCode = 467519 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'SAII.BO^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-03-16', SecMapEndDate = '2020-02-25', PermSecMapEndDate = '2026-03-15', endDate = '2020-02-25' WHERE SecCode = 561400 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 796671 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-03-13', PermSecMapEndDate = NULL, startDate = '2010-09-28', endDate = NULL WHERE SecCode = 826229 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1082263 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2025-11-06' WHERE SecCode = 1111347 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1472778 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 RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'NITRATOS.SN^C26', PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-03-14' WHERE SecCode = 2253329 AND Type_ = 10;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 2693668 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 0.0 WHERE SecCode = 2782865 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2915026 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-03-16' WHERE SecCode = 2939987 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '222810.KQ^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-03-16', SecMapEndDate = '2026-03-13', PermSecMapEndDate = '2026-03-15', endDate = '2026-03-13' WHERE SecCode = 2955167 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 IsPrimaryQuote = 0.0 WHERE SecCode = 3284006 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 0.0 WHERE SecCode = 3297033 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 3320055 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667482861.0, ExchCode = 'QTX' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'LUMO' WHERE SecCode = 3522229 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4058518 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4379702 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4379704 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4456093 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4558203 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 8590857104.0 WHERE SecCode = 5288740 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '457940.KQ^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-03-16', SecMapEndDate = '2026-03-13', PermSecMapEndDate = '2026-03-15', endDate = '2026-03-13' WHERE SecCode = 5495257 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5500262 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2025-11-06' WHERE SecCode = 6541044 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-16', SecMapEndDate = '2026-03-13', PermSecMapEndDate = '2026-03-15', endDate = '2026-03-13' WHERE SecCode = 6642595 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6712479 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6715940 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6715945 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'IROQ.OQ^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-03-16', PermQuoteRetireDate = '2026-03-16', endDate = '2026-03-16' WHERE SecCode = 11005926 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BV4J1P', DsPrimQtSedol = 'BV4J1P1', PermSecMapEndDate = '2026-03-14', endDate = '2026-03-14' WHERE SecCode = 11026351 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'VIVO' WHERE SecCode = 11166235 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GOCOF' WHERE SecCode = 11183775 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG592901253', RkdSEDOL = 'BV4J1M', RkdCUSIP = 'G5929012', DsPrimQtSedol = 'BV4J1M8', PermSecMapEndDate = '2026-03-14', endDate = '2026-03-14' WHERE SecCode = 11193306 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'BHATF', PermIDTicker = NULL, RkdRIC = 'BHATF.PK', RkdDisplayRIC = 'BHATF.PK', RkdExchCode = 'OTC', PriTrdQuotePermID = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-16', PermSecMapEndDate = '2026-03-14', endDate = '2026-03-14' WHERE SecCode = 11199112 AND Type_ = 1;
UPDATE data_universe SET ModelCntry = 'US', DomCntry = 'USA' WHERE SecCode = 11214218 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000034566.0, PriInstrPermID = 25727286724.0 WHERE SecCode = 11219974 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US98422T2096', RkdSEDOL = 'BV4J2H', RkdCUSIP = '98422T20', DsPrimQtSedol = 'BV4J2H0', PermSecMapEndDate = '2026-03-14', endDate = '2026-03-14' WHERE SecCode = 11232636 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FNUC', RkdSEDOL = 'BWTYM4', DsPrimQtSedol = 'BWTYM44', PermSecMapEndDate = '2026-03-14', endDate = '2026-03-14' WHERE SecCode = 11234421 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5097107845.0, PriInstrPermID = 25727207517.0, PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 11238076 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG0544E1473', RkdSEDOL = 'BTHYCQ', RkdCUSIP = 'G0544E14', DsPrimQtSedol = 'BTHYCQ7', PermSecMapEndDate = '2026-03-14', endDate = '2026-03-14' WHERE SecCode = 11239813 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11249078 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BV4J1Y', DsPrimQtSedol = 'BV4J1Y0', PermSecMapEndDate = '2026-03-14', endDate = '2026-03-14' WHERE SecCode = 11250907 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US83087C3034', RkdSEDOL = 'BV4J1T', RkdCUSIP = '83087C30', DsPrimQtSedol = 'BV4J1T5', PermSecMapEndDate = '2026-03-14', endDate = '2026-03-14' WHERE SecCode = 11270511 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG8849D1289', RkdSEDOL = 'BV4J1J', RkdCUSIP = 'G8849D12', DsPrimQtSedol = 'BV4J1J5', PermSecMapEndDate = '2026-03-14', endDate = '2026-03-14' WHERE SecCode = 11273822 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG2748R2055', RkdSEDOL = 'BV4J1Q', RkdCUSIP = 'G2748R20', DsPrimQtSedol = 'BV4J1Q2', PermSecMapEndDate = '2026-03-14', endDate = '2026-03-14' WHERE SecCode = 11274177 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000049323.0, PriInstrPermID = 232868494040.0, PriTRBCIndPermID = NULL, PermOrgIPODate = '2025-02-20' WHERE SecCode = 11275118 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2025-11-06' WHERE SecCode = 11287866 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5097115718.0, PriInstrPermID = 232906376742.0 WHERE SecCode = 11290377 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232906884558.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11290921 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232915070472.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11290981 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232907239258.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11290990 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232907754428.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11290991 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 11292547 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236804241607.0, PriTrdQuotePermID = 236804241607.0, PriValQuotePermID = 25727030583.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, ExchCode = 'NMS' WHERE SecCode = 11293243 AND Type_ = 1;
