UPDATE data_universe SET OrgTypeCode = 'CINV' WHERE SecCode = 5485 AND Type_ = 10;
UPDATE data_universe SET Name = 'BANK OF AMER CORP COM' WHERE SecCode = 8156 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK OF AMER CORP PFD 1/1200SER2' WHERE SecCode = 46245 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK OF AMER CORP PFD1/1200 SR1' WHERE SecCode = 46247 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK OF AMER CORP PFD DP1/1200 4' WHERE SecCode = 46278 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 DsCtryQtStatus = 'A' WHERE SecCode = 67118 AND Type_ = 10;
UPDATE data_universe SET Name = 'FOSECO CRU IND LTD INR5' WHERE SecCode = 70495 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71148 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'GC MEDIAI CORP KRW500' WHERE SecCode = 72711 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73164 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73938 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76681 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000320459', RkdTicker = 'OVT', PermIDTicker = 'OVT', RkdSEDOL = 'BR1W02', RkdCUSIP = 'Q496BK11', RkdRIC = 'OVT.AX', RkdDisplayRIC = 'OVT.AX', DsPrimQtSedol = 'BR1W025' WHERE SecCode = 77877 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78536 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78933 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-04-16' WHERE SecCode = 79135 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 79378 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82559 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82772 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 83589 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 83994 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q4704L24', Name = 'MARITANA MINERALS NPV', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 84618 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86003 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 87378 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 87379 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'HER CHEE INDUSTRIA TWD2.5' WHERE SecCode = 87812 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 88653 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 88699 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 89771 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 90276 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 91110 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-04-13', SecMapEndDate = '2026-04-10', PermSecMapEndDate = '2026-04-12', endDate = '2026-04-10' WHERE SecCode = 91772 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 105546 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 232929931207.0 WHERE SecCode = 114357 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 126438 AND Type_ = 10;
UPDATE data_universe SET Name = 'ODIOT SA EUR1 (POST CONSOLIDATION)' WHERE SecCode = 126701 AND Type_ = 10;
UPDATE data_universe SET Name = 'SANDMARTIN INT HLD HKD0.10 (POST COMP)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 137928 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142870 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 180539 AND Type_ = 10;
UPDATE data_universe SET Name = 'BANK OF AMER CORP PFD PER1/1000E' WHERE SecCode = 187381 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK OF AMER CORP INCM CP OBG NT' WHERE SecCode = 219026 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK OF AMER CORP PFD 1/1200SER5' WHERE SecCode = 291977 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK OF AMER CORP 7.25%CNV PFD L' WHERE SecCode = 336538 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 55834800221.0, ExchCode = 'HKG', PermQuoteRetireDate = '2018-04-24', endDate = '2018-04-16' WHERE SecCode = 345190 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475473201.0, ExchCode = 'GER' WHERE SecCode = 351305 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 384163 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21530871393.0, ExchCode = 'CHI' WHERE SecCode = 437391 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'HSI.HNO^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-04-14', SecMapEndDate = '2026-04-10', PermQuoteRetireDate = '2026-04-14', PermSecMapEndDate = '2026-04-13', endDate = '2026-04-10' WHERE SecCode = 522899 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 555860 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 555895 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 559894 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'VC5.HNO^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-04-14', SecMapEndDate = '2025-05-30', PermQuoteRetireDate = '2026-04-14', PermSecMapEndDate = '2026-04-13', endDate = '2025-05-30' WHERE SecCode = 561054 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 587491 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'OVT', DsPrimQtSedol = 'BR1W025' WHERE SecCode = 786223 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'NOVKAN.ST^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-04-14', SecMapEndDate = '2026-04-13', PermQuoteRetireDate = '2026-04-14', endDate = '2026-04-13' WHERE SecCode = 1030653 AND Type_ = 10;
UPDATE data_universe SET Name = 'BANK OF AMER CORP BDR EACH 4 REP 1 COM' WHERE SecCode = 1092013 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 1107137 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1481671 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 1580352 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'OVT', DsPrimQtSedol = 'BR1W025' WHERE SecCode = 1693476 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-04-16' WHERE SecCode = 1694061 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'NEXT BIOMETRICS GR NOK10', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 2374403 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2574384 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-04-16' WHERE SecCode = 2586428 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-04-12' WHERE SecCode = 2598695 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'OVT', DsPrimQtSedol = 'BR1W025' WHERE SecCode = 2625086 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2711205 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2747621 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2890449 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 96743.0 WHERE SecCode = 2905774 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 2929636 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3000144 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21587931857.0, ExchCode = 'BTE' WHERE SecCode = 3157265 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-04-10', PermSecMapEndDate = '2026-04-13', endDate = '2026-04-10' WHERE SecCode = 3246340 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3318951 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667482861.0, ExchCode = 'QTX' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 3345921 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3386085 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 3410261 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3588129 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 3589017 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3818857 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FRA' WHERE SecCode = 4196857 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2020-10-19', SecMapEndDate = '2020-10-16', endDate = '2020-10-16' WHERE SecCode = 4377436 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4491669 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 4539303 AND Type_ = 10;
UPDATE data_universe SET Name = 'BIOALPHA HOLDINGS ICPS 15/05/2026 MYR0.22' WHERE SecCode = 4608541 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21818254739.0, ExchCode = 'BCO', PermQuoteRetireDate = '2026-01-13' WHERE SecCode = 4617741 AND Type_ = 10;
UPDATE data_universe SET Name = 'EBR SYSTEMS INC NPV CDI 1:1' WHERE SecCode = 4780386 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 4889166 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-04-14', SecMapEndDate = '2026-04-09', PermQuoteRetireDate = '2026-04-14', endDate = '2026-04-09' WHERE SecCode = 5108979 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-04-14', SecMapEndDate = '2026-04-09', PermQuoteRetireDate = '2026-04-14', endDate = '2026-04-09' WHERE SecCode = 5112392 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21565180699.0, ExchCode = 'FRA' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'DRSL', PermIDTicker = 'DRSL', RkdRIC = 'DRSL.TA', RkdDisplayRIC = 'DRSL.TA' WHERE SecCode = 5229783 AND Type_ = 10;
UPDATE data_universe SET Name = 'YIGIT AKUE MALZEME TRY1' WHERE SecCode = 5796794 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '202A.T^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-04-14', PermSecMapEndDate = '2026-04-13', endDate = '2026-04-13' WHERE SecCode = 5819566 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6004543 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 22099147197.0, ExchCode = 'DEU' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2010-12-15' WHERE SecCode = 10982650 AND Type_ = 1;
UPDATE data_universe SET Name = 'TRANSOCEANIC INVT INC COM' WHERE SecCode = 11006192 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, RkdRIC = 'WORX.PK', RkdDisplayRIC = 'WORX.PK', RkdExchCode = 'OTC', PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-14', endDate = '2026-04-14' WHERE SecCode = 11162137 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US29273V7047', RkdTicker = 'ET PR I', RkdSEDOL = 'BMHLS3', RkdCUSIP = '29273V70', RkdRIC = 'ET_pi', RkdDisplayRIC = 'ET_pi.N', RkdCode = 51550.0, RkdIssueID = 10.0, RkdIssueCode = 184939.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 6.0, RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11168246 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK OF AMER CORP 6 NCUM PFD SR GG' WHERE SecCode = 11185260 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK OF AMER CORP 5.875 NCM PFD HH' WHERE SecCode = 11189352 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK OF AMER CORP 5.375 DP PFD KK' WHERE SecCode = 11198063 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'FRA' WHERE SecCode = 11199132 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK OF AMER CORP 5% NCUM PFD LL' WHERE SecCode = 11200186 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK OF AMER CORP DP SH NCUM NN' WHERE SecCode = 11214168 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK OF AMER CORP 4.125% DP PFD PP' WHERE SecCode = 11217750 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 11218281 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK OF AMER CORP 4.250% DP PFD QQ' WHERE SecCode = 11232407 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2022-01-25', startDate = '2022-01-25' WHERE SecCode = 11237647 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK OF AMER CORP 4.750% DP PFD SS' WHERE SecCode = 11237688 AND Type_ = 1;
UPDATE data_universe SET Name = 'VERDERA ENERGY CORP COM' WHERE SecCode = 11247421 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2023-05-25' WHERE SecCode = 11253247 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11255668 AND Type_ = 1;
UPDATE data_universe SET Name = 'SUNCRETE INC COM SHS CL A' WHERE SecCode = 11257235 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'ZTG', PermIDTicker = 'ZTG', RkdRIC = 'ZTG.O', RkdDisplayRIC = 'ZTG.OQ' WHERE SecCode = 11284952 AND Type_ = 1;
UPDATE data_universe SET Name = 'GOLD OROGEN RES CORP COM' WHERE SecCode = 11291811 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11292240 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11292241 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', IsPrimaryInstr = 0.0 WHERE SecCode = 11292243 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2026-03-03' WHERE SecCode = 11292733 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG8557R1294', RkdTicker = 'SUMAU', RkdSEDOL = 'BSHWN5', RkdCUSIP = 'G8557R12', RkdRIC = 'SUMAU.O', RkdDisplayRIC = 'SUMAU.OQ', RkdCode = 144663.0, RkdIssueID = 1.0, RkdIssueCode = 184946.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11293143 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'Y', QuotePermID = 236805536818.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11294417 AND Type_ = 1;
