UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'AZN.OQ^B26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-02-02', endDate = '2026-02-02' WHERE SecCode = 6887 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'CADE.N^B26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-02-02', endDate = '2026-02-02' WHERE SecCode = 8113 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-01-30', endDate = '2026-01-30' WHERE SecCode = 9936 AND Type_ = 10;
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, PrimaryIssueCode = NULL, RelType = NULL, COATypeCode = NULL WHERE SecCode = 12845 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'CMA.N^B26', RkdIssueStatus = 0.0, endDate = '2026-02-02' WHERE SecCode = 15770 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NSUd', QuotePermID = 21531132175.0, ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26', endDate = '2020-11-16' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, RkdExchCode = 'NA', RkdExchCtry = NULL WHERE SecCode = 74315 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 75783 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75796 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 RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 80134 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GRIVRG', QuotePermID = 21475431561.0, ExchCode = 'SUB', PermQuoteRetireDate = '2007-01-11' WHERE SecCode = 80954 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-02-02', PermSecMapEndDate = '2026-02-01', endDate = '2026-02-01' WHERE SecCode = 81938 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL, DsSecDelistDate = '2025-11-23' WHERE SecCode = 86870 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL WHERE SecCode = 89466 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 89467 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 89771 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 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 RkdTicker = NULL, RkdRIC = 'TBRD.V^B26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-02-02', endDate = '2026-02-02' WHERE SecCode = 95957 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-01-31', endDate = '2026-01-31' WHERE SecCode = 98786 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21898257779.0, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 141836 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 407332 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 823376 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'EUZ.L^B26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-02-02', endDate = '2026-02-02' WHERE SecCode = 907800 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-02-02' WHERE SecCode = 938241 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL, DsCtryQtStatus = 'A', DsSecDelistDate = NULL WHERE SecCode = 1158940 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 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 DsCtryQtStatus = 'S' WHERE SecCode = 2278248 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3053187 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3292626 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'SAMTb.NGM^B26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-02-02', endDate = '2026-02-02' WHERE SecCode = 3318040 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3359296 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3376098 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3386159 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2018-03-09', startDate = '2018-03-08' WHERE SecCode = 3439564 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3444651 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-01-20', endDate = '2026-01-20' WHERE SecCode = 3523345 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2019-04-25' WHERE SecCode = 3818125 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 3961773 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4032275 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4040137 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-02-02', endDate = '2026-02-02' WHERE SecCode = 4079206 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 DsCtryQtStatus = 'S' WHERE SecCode = 4422560 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 = 'A' WHERE SecCode = 4586450 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-01-30', endDate = '2026-01-30' WHERE SecCode = 4608546 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21899163259.0, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30', endDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4983975 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21975266861.0, ExchCode = 'DEU' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5489262 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'TAI' WHERE SecCode = 5579612 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 22099147197.0, ExchCode = 'DEU' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'OPC.CD^B26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-02-02', endDate = '2026-02-02' WHERE SecCode = 11009217 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL, PermSecMapEndDate = '2026-01-30' WHERE SecCode = 11015059 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-01-31', endDate = '2026-01-31' WHERE SecCode = 11022684 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'TRP_pi.TO^B26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-02-02', endDate = '2026-02-02' WHERE SecCode = 11156282 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-01-31', endDate = '2026-01-31' WHERE SecCode = 11156315 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL, DsCtryQtStatus = 'A', DsSecDelistDate = NULL WHERE SecCode = 11172780 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'CADE_pa.N^B26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-02-02', endDate = '2026-02-02' WHERE SecCode = 11202192 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'JAMF.OQ^B26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-02-02', endDate = '2026-02-02' WHERE SecCode = 11210203 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-02-02', endDate = '2026-02-02' WHERE SecCode = 11287206 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-02-02', endDate = '2026-02-02' WHERE SecCode = 11289468 AND Type_ = 1;
