UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 2383 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = '2025432' WHERE SecCode = 4440 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2043520' WHERE SecCode = 4714 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2030630' WHERE SecCode = 5255 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2046563' WHERE SecCode = 6100 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2051589' WHERE SecCode = 6617 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2068909' WHERE SecCode = 7826 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2072773' WHERE SecCode = 7947 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2098768' WHERE SecCode = 9502 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2119186' WHERE SecCode = 10294 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2159524' WHERE SecCode = 10932 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2196275' WHERE SecCode = 11232 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2193328' WHERE SecCode = 13810 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2203175' WHERE SecCode = 14886 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2211457' WHERE SecCode = 15273 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2229557' WHERE SecCode = 17475 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2250494' WHERE SecCode = 18286 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BS3F4L' WHERE SecCode = 18913 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2260471' WHERE SecCode = 19684 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2283274' WHERE SecCode = 22095 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2252177' WHERE SecCode = 22233 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2297844' WHERE SecCode = 22673 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2960652' WHERE SecCode = 24549 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2323932' WHERE SecCode = 24645 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2339337' WHERE SecCode = 27527 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2347307' WHERE SecCode = 27980 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2886695' WHERE SecCode = 28600 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2367800' WHERE SecCode = 30118 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2372655' WHERE SecCode = 30495 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2415390' WHERE SecCode = 33110 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2437361' WHERE SecCode = 33986 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2457596' WHERE SecCode = 35640 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2985763' WHERE SecCode = 36594 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2490632' WHERE SecCode = 39531 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2504179' WHERE SecCode = 41308 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2503897' WHERE SecCode = 41317 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2326726' WHERE SecCode = 42770 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2595805' WHERE SecCode = 47152 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2599614' WHERE SecCode = 47592 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2626998' WHERE SecCode = 49556 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2649694' WHERE SecCode = 51242 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2655538' WHERE SecCode = 52120 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2665117' WHERE SecCode = 53283 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2681395' WHERE SecCode = 54980 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2681339' WHERE SecCode = 55060 AND Type_ = 1;
UPDATE data_universe SET DsExchMnem = 'DUS' WHERE SecCode = 56859 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = '2730123' WHERE SecCode = 59363 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2765136' WHERE SecCode = 61363 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2791380' WHERE SecCode = 69014 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2794538' WHERE SecCode = 69080 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2797623' WHERE SecCode = 69347 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2817112' WHERE SecCode = 70222 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2841058' WHERE SecCode = 71231 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2864323' WHERE SecCode = 73521 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2926171' WHERE SecCode = 73881 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2868745' WHERE SecCode = 74231 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2882875' WHERE SecCode = 74970 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 76248 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = '2907198' WHERE SecCode = 77029 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 77200 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = '2915715' WHERE SecCode = 77938 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2868949' WHERE SecCode = 78079 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2918208' WHERE SecCode = 78092 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2926212' WHERE SecCode = 78721 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2926416' WHERE SecCode = 78798 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2927475' WHERE SecCode = 79417 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2928616' WHERE SecCode = 79801 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81556 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = '2950404' WHERE SecCode = 81610 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2954428' WHERE SecCode = 81699 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2958152' WHERE SecCode = 81909 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = '2344364' WHERE SecCode = 82474 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 84223 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 86680 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5097118454.0, PriInstrPermID = 8589990899.0, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 87281 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87756 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 25727196678.0, ExchCode = 'A2X' WHERE SecCode = 88378 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q6400119' WHERE SecCode = 89807 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 92595 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 96544 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL WHERE SecCode = 101007 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'Y' WHERE SecCode = 105303 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 123870 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126781 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 137018 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'MUN' WHERE SecCode = 143039 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = '2350253' WHERE SecCode = 290580 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 311238 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CGM', RkdSEDOL = 'BS46CD' WHERE SecCode = 330805 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 549234 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 566785 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 593923 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BLIT', QuotePermID = 21482228292.0, ExchCode = 'STO', PermQuoteRetireDate = '2014-04-29' WHERE SecCode = 1456636 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2013309 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2800418 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'RENJ.J^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-12', endDate = '2026-01-12' WHERE SecCode = 2912878 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2924567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21628902471.0, ExchCode = 'MUN' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3263272 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VEONa', QuotePermID = 21610682901.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-11' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3406842 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3569570 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 3875294 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3968203 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4010776 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4032275 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4035749 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4204830 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4223309 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4300561 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4337006 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ABOU-M' WHERE SecCode = 4613101 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 = 4641478 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 4752205 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 4770119 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5156823 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5464394 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 5490547 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6601507 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6601522 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'B4QHGN7' WHERE SecCode = 10908710 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BS3FCJ' WHERE SecCode = 11004009 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236801355516.0, ExchCode = 'NAS', PermSecMapStartDate = '2026-01-09' WHERE SecCode = 11187785 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'LONA' WHERE SecCode = 11212286 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 11221665 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 11239213 AND Type_ = 1;
UPDATE data_universe SET DsExchQtStartDate = '2025-10-27' WHERE SecCode = 11287310 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232903350252.0 WHERE SecCode = 11289546 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236801355262.0, IsPrimaryQuote = 1.0, ExchCode = 'NSM' WHERE SecCode = 11290409 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236801355283.0, PriTrdQuotePermID = 236801355283.0, PriValQuotePermID = 25727040294.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, ExchCode = 'NMS', startDate = '2025-12-12' WHERE SecCode = 11290478 AND Type_ = 1;