UPDATE data_universe SET DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-14', SecMapEndDate = '2026-03-13', endDate = '2026-03-13' WHERE SecCode = 27134 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1994-11-14' WHERE SecCode = 28027 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-14', SecMapEndDate = '2026-03-13', endDate = '2026-03-13' WHERE SecCode = 29418 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US4169062043', RkdCUSIP = '41690620' WHERE SecCode = 32827 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 4295867582.0, PriInstrPermID = 8590007282.0, IsPrimaryInstr = 0.0 WHERE SecCode = 38308 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 67013 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951287.0 WHERE SecCode = 67097 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75678 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU000000ASP3', RkdTicker = 'ASP', RkdSEDOL = '623701', RkdCUSIP = 'Q0569119', RkdRIC = 'ASP.AX', RkdDisplayRIC = 'ASP.AX', DsPrimQtSedol = '6237017' 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 PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 76703 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76930 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 = 'A' WHERE SecCode = 78626 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A', PriTRBCIndPermID = 4294951759.0 WHERE SecCode = 88266 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 RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-13', PermSecMapEndDate = '2026-03-12' WHERE SecCode = 91198 AND Type_ = 10;
UPDATE data_universe SET Name = 'ORIENTAL MEDIA GP NPV' WHERE SecCode = 91607 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-03-12' WHERE SecCode = 92746 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 PermQuoteRetireDate = '2026-04-01' WHERE SecCode = 95627 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-03-12' WHERE SecCode = 96268 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21474869184.0, IsPrimaryQuote = 0.0, ExchCode = 'IXJ', PermQuoteRetireDate = '2012-09-18', endDate = '2012-09-18' WHERE SecCode = 96478 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 PermIDTicker = 'MARSONS', QuotePermID = 236804169193.0, ExchCode = 'NSI' WHERE SecCode = 122690 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 = 268435 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 467519 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 522879 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 559304 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-16' WHERE SecCode = 561400 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 578983 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 586452 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 789974 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'HVX', PermIDTicker = 'HVX', RkdRIC = 'HVX.HNO', RkdDisplayRIC = 'HVX.HNO', DsCtryQtStatus = 'A', RkdIssueStatus = 1.0, RkdExchCode = 'UPC', PermQuoteStatus = 'AC', ExchCode = 'UPC', DsSecDelistDate = NULL, SecMapEndDate = '2079-06-06', PermQuoteRetireDate = NULL, PermOrgIPODate = NULL WHERE SecCode = 826229 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 1019998 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 1529243 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 1541385 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 1833223 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 2021767 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-03-14', SecMapEndDate = '2026-03-13', endDate = '2026-03-13' WHERE SecCode = 2253329 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2603244 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = NULL, IsPrimaryInstr = 0.0 WHERE SecCode = 2782865 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2879975 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2915023 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2939987 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-16' WHERE SecCode = 2955167 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'FR', OrgPermID = 5066587907.0, DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 2988197 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2015-10-23' WHERE SecCode = 3007952 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 3054000 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 3186836 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'HINDUSTHAN URBAN I POST SUBD INR2' WHERE SecCode = 3212191 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = NULL, IsPrimaryInstr = 0.0 WHERE SecCode = 3284006 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = NULL, IsPrimaryInstr = 0.0 WHERE SecCode = 3297033 AND Type_ = 10;
UPDATE data_universe SET Name = 'GURU KRUPA GEMS & INR10' WHERE SecCode = 3356357 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951852.0 WHERE SecCode = 3364885 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3441675 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21650788270.0, ExchCode = 'INC' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'LUMO', RkdRIC = 'LUMO.HE', RkdDisplayRIC = 'LUMO.HE' WHERE SecCode = 3522229 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528819.0, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3777677 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 PriTRBCIndPermID = 4294951797.0 WHERE SecCode = 4006862 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 RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4561851 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4571432 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-13', PermSecMapEndDate = '2026-03-13' WHERE SecCode = 4605803 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951696.0 WHERE SecCode = 4723544 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4794514 AND Type_ = 10;
UPDATE data_universe SET Name = 'BRBI BR PTNRS SA UNITS (1 COM & 2 PRF)' WHERE SecCode = 4807497 AND Type_ = 10;
UPDATE data_universe SET Name = 'BEACON RISE HOLDIN ORD GBP0.0001' WHERE SecCode = 4938698 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 5013451 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951226.0 WHERE SecCode = 5119089 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21565180699.0, ExchCode = 'FRA' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 5395742 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-16' WHERE SecCode = 5495257 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 5953913 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6541030 AND Type_ = 10;
UPDATE data_universe SET Name = 'SURAJ INDUSTRIES INR10 (PPD INR20 UPD INR20)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 6554792 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236804171603.0 WHERE SecCode = 6712479 AND Type_ = 10;
UPDATE data_universe SET Name = 'NORTHWEST HEALTHCARE TR UNIT' WHERE SecCode = 10934600 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US1850642018', RkdCUSIP = '18506420' WHERE SecCode = 11026351 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-13', PermSecMapEndDate = '2026-03-13' WHERE SecCode = 11030360 AND Type_ = 1;
UPDATE data_universe SET Name = 'LIBERTY DEFENSE HLDGS LTD COM NEW', PermSecMapEndDate = '2026-03-13', endDate = '2026-03-13' WHERE SecCode = 11065308 AND Type_ = 1;
UPDATE data_universe SET Name = 'ALDEYRA THERAPEUTICS INC COM' WHERE SecCode = 11114256 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'VIVO', RkdRIC = 'VIVO.O', RkdDisplayRIC = 'VIVO.OQ' WHERE SecCode = 11166235 AND Type_ = 1;
UPDATE data_universe SET Name = 'KLX ENERGY SERVICES HOLDINGS COM NEW' WHERE SecCode = 11189446 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'BHAT.OQ' WHERE SecCode = 11199112 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11219974 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11223968 AND Type_ = 1;
UPDATE data_universe SET Country = 'USA' WHERE SecCode = 11225955 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11232780 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA3591341035', RkdTicker = 'FNUC', RkdCUSIP = '35913410', RkdRIC = 'FNUC.O', RkdDisplayRIC = 'FNUC.OQ' WHERE SecCode = 11234421 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2021-12-01' WHERE SecCode = 11234992 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'EWISF' WHERE SecCode = 11235336 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11238076 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2022-08-19', startDate = '2022-08-19' WHERE SecCode = 11244971 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG5140V1207', RkdCUSIP = 'G5140V12' WHERE SecCode = 11250907 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11275118 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11290377 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232901029194.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11290893 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2026-02-10' WHERE SecCode = 11291809 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11292241 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG3645T1040', RkdTicker = 'FVAV', RkdSEDOL = 'BVPN3M', RkdCUSIP = 'G3645T10', RkdRIC = 'FVAV.O', RkdDisplayRIC = 'FVAV.OQ', RkdCode = 144489.0, RkdIssueID = 1.0, RkdIssueCode = 184633.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11292539 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11292839 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PAYP', DsTypeCode = 'EQ', QuotePermID = 236803113053.0, InstrPermID = 232921573060.0, OrgPermID = 5066606009.0, PriTrdQuotePermID = 236803113053.0, PriValQuotePermID = 25727034524.0, PriInstrPermID = 232921573060.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NSM', QuoteClass = 'ADR', InstrClass = 'ADR', OrgTypeCode = 'COM', DomCntry = 'JPN', IncCntry = 'JPN', PriTRBCIndPermID = 4294951765.0, PermOrgIPODate = '2026-03-12', PermSecMapStartDate = '2026-03-12' WHERE SecCode = 11293177 AND Type_ = 1;
