UPDATE data_universe SET RkdTicker = 'EMBJ', RkdRIC = 'EMBJ', RkdDisplayRIC = 'EMBJ.N' WHERE SecCode = 23541 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2025-10-31' WHERE SecCode = 36452 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1988-09-26' WHERE SecCode = 51466 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 55423 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'BIGTK.E', PermIDTicker = 'BIGTK.E', RkdRIC = 'BIGTK.IS', RkdDisplayRIC = 'BIGTK.IS' WHERE SecCode = 65376 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 66401 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 67930 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000012494', RkdTicker = 'PRX', PermIDTicker = 'PRX', RkdSEDOL = 'BDZVKM', RkdCUSIP = 'Q7747618', RkdRIC = 'PRX.AX', RkdDisplayRIC = 'PRX.AX', DsPrimQtSedol = 'BDZVKM0' WHERE SecCode = 68875 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE258A01024', RkdSEDOL = 'BMD7MP', RkdCUSIP = 'Y0881N15', DsPrimQtSedol = 'BMD7MP0', PermSecMapEndDate = '2025-10-31', endDate = '2025-10-31' WHERE SecCode = 72005 AND Type_ = 10;
UPDATE data_universe SET Name = 'AIRASIA INDONESIA IDR250' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET Name = 'ACCEL LIMITED INR2' WHERE SecCode = 78333 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '1990-01-01' WHERE SecCode = 79239 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '1995-04-25' WHERE SecCode = 81055 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-03' WHERE SecCode = 83605 AND Type_ = 10;
UPDATE data_universe SET Name = 'MBSB BERHAD NPV' WHERE SecCode = 88065 AND Type_ = 10;
UPDATE data_universe SET Name = 'BOYD GROUP SERVICES INC COM' WHERE SecCode = 91305 AND Type_ = 1;
UPDATE data_universe SET RkdCUSIP = 'Y0S64711' WHERE SecCode = 92081 AND Type_ = 10;
UPDATE data_universe SET Name = 'TOKYO CENTURY CORP NPV' WHERE SecCode = 92238 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2011-11-24' WHERE SecCode = 92838 AND Type_ = 10;
UPDATE data_universe SET Name = 'TIAN JIN BOHAI CHE ''A''CNY1' WHERE SecCode = 97514 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BLUE INDUSTRIAL DE KRW500' WHERE SecCode = 99231 AND Type_ = 10;
UPDATE data_universe SET Name = 'TAYNINH EUR0.01' WHERE SecCode = 101286 AND Type_ = 10;
UPDATE data_universe SET Name = 'EUROPLASMA EUR0.025' WHERE SecCode = 101467 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'THE KOREA ECONOMIC KRW500' WHERE SecCode = 114517 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000CSEAK0', RkdRIC = 'IPO-EQU.AX', RkdDisplayRIC = 'IPO-EQU.AX' WHERE SecCode = 122937 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2007-08-06' WHERE SecCode = 125569 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2025-10-30' WHERE SecCode = 137441 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-03' WHERE SecCode = 137922 AND Type_ = 10;
UPDATE data_universe SET Name = 'ORBMINCO LTD NPV' WHERE SecCode = 140027 AND Type_ = 10;
UPDATE data_universe SET Name = 'MFC ASSET MANAGEM MFC-NICHADA THANI PROPERTY' WHERE SecCode = 141492 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'MIRIS HOLDING AB NPV(POST CONS)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 146237 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 232906584217.0 WHERE SecCode = 147575 AND Type_ = 10;
UPDATE data_universe SET Name = 'MALATH COOPERATIVE SAR10' WHERE SecCode = 283716 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'MIRAE ASSET MAPS M REALTY INVESTMENT COMPANY' WHERE SecCode = 285430 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '1995-04-19' WHERE SecCode = 288633 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-10-31', endDate = '2025-10-31' WHERE SecCode = 291245 AND Type_ = 1;
UPDATE data_universe SET Name = 'DONGKOOK PHARMACEU KRW500.00' WHERE SecCode = 295167 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'ETHY', RkdRIC = 'ETHY.ASE', RkdDisplayRIC = 'ETHY.ASE' WHERE SecCode = 370942 AND Type_ = 10;
UPDATE data_universe SET Name = 'CITAGLOBAL BHD NPV' WHERE SecCode = 401533 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'ACTIVO INMOBILIAR PEN0.10' WHERE SecCode = 521900 AND Type_ = 10;
UPDATE data_universe SET Name = 'IMEXPHARM CORP VND10000' WHERE SecCode = 522859 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'POLARIS UNO INC KRW500' WHERE SecCode = 560727 AND Type_ = 10;
UPDATE data_universe SET Name = 'MONGOLIAN MINING C USD0.1' WHERE SecCode = 833608 AND Type_ = 10;
UPDATE data_universe SET Name = 'FINEOTEX CHEMICAL INR1(POST SUBD)' WHERE SecCode = 1024298 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'SRSO.BO', RkdDisplayRIC = 'SRSO.BO' WHERE SecCode = 1204795 AND Type_ = 10;
UPDATE data_universe SET Name = 'YEONG GUAN ENERGY. TWD10', Country = 'CYM' WHERE SecCode = 1561116 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-03' WHERE SecCode = 2383400 AND Type_ = 10;
UPDATE data_universe SET Name = 'IZ YATIRIM HOLDING TRY1 (B SHARES)' WHERE SecCode = 2390323 AND Type_ = 10;
UPDATE data_universe SET Name = 'FRASERS PROPERTY.L NPV' WHERE SecCode = 2459932 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PRX', DsPrimQtSedol = 'BDZVKM0' WHERE SecCode = 2595747 AND Type_ = 10;
UPDATE data_universe SET Name = 'MODULEX CONST TECH INR10' WHERE SecCode = 2625814 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 2655880 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2701584 AND Type_ = 10;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 21773621324.0, PermOrgIPODate = '2025-10-31' WHERE SecCode = 2819089 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 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, COATypeCode = NULL WHERE SecCode = 2860578 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3055015 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2016-02-25' WHERE SecCode = 3099733 AND Type_ = 10;
UPDATE data_universe SET Name = 'VSING LTD HKD0.1' WHERE SecCode = 3208817 AND Type_ = 10;
UPDATE data_universe SET Name = 'CHARTER HALL LONG NPV (STAPLED)' WHERE SecCode = 3256271 AND Type_ = 10;
UPDATE data_universe SET Name = 'HANOI BEER ALCOHOL VND10000' WHERE SecCode = 3296013 AND Type_ = 10;
UPDATE data_universe SET Name = 'ONCOINVENT ASA. NOK1', PriInstrPermID = NULL, IsPrimaryInstr = 0.0 WHERE SecCode = 3320156 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-03' WHERE SecCode = 3321165 AND Type_ = 10;
UPDATE data_universe SET Name = 'JIANGSU LOPAL TEC. A CNY1' WHERE SecCode = 3321437 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = '9876', PermIDTicker = '9876', RkdRIC = '9876.HK', RkdDisplayRIC = '9876.HK' WHERE SecCode = 3400257 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3409194 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-03' WHERE SecCode = 3434717 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2018-05-11' WHERE SecCode = 3495862 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2018-06-04' WHERE SecCode = 3510547 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21922259627.0, ExchCode = 'EQD' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2018-12-19' WHERE SecCode = 3706438 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 3740588 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 3787154 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, PermIDTicker = 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, COATypeCode = NULL, PermQuoteStatus = 'DC', SecMapEndDate = '2025-10-30', PermQuoteRetireDate = '2025-10-31', PermSecMapEndDate = '2025-10-31', endDate = '2025-10-30' WHERE SecCode = 3825584 AND Type_ = 10;
UPDATE data_universe SET Name = 'HOTEI PROPERTIES EUR1' WHERE SecCode = 3885199 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET Name = 'MFC ASSET MANAGEM THAILAND FUTURE FUND (LOCAL' WHERE SecCode = 4049091 AND Type_ = 10;
UPDATE data_universe SET Name = 'ACRO BIOMEDICAL(TW TWD10', Country = 'TWN' WHERE SecCode = 4280561 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE1000077F7' WHERE SecCode = 4421096 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-10-31' WHERE SecCode = 4511509 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 4542564 AND Type_ = 10;
UPDATE data_universe SET Name = 'CITAGLOBAL BHD RCPS 05/05/31 MYR0.55' WHERE SecCode = 4589224 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-03' WHERE SecCode = 4616797 AND Type_ = 10;
UPDATE data_universe SET Name = 'HARENA RARE EARTHS ORD GBP0.005' WHERE SecCode = 4684126 AND Type_ = 10;
UPDATE data_universe SET Name = 'KTBST MIXED FREEHO THB10 (LOCAL)' WHERE SecCode = 4770123 AND Type_ = 10;
UPDATE data_universe SET Name = 'BEIGENE LTD A USD0.0001', Country = 'CYM' WHERE SecCode = 4807494 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00BW9N7242', RkdSEDOL = 'BW9N72', DsPrimQtSedol = 'BW9N724' WHERE SecCode = 4815285 AND Type_ = 10;
UPDATE data_universe SET Name = 'C CORE TECHNOLOGY A CNY1' WHERE SecCode = 4825078 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2022-05-04' WHERE SecCode = 4985764 AND Type_ = 10;
UPDATE data_universe SET Name = 'NORDIC RESOURCES NPV' WHERE SecCode = 5023818 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236798269874.0, PriValQuotePermID = 236798269874.0, ExchCode = 'GER', PermSecMapStartDate = '2025-10-30' WHERE SecCode = 5082549 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'EMPIRE', PermIDTicker = 'EMPIRE', RkdRIC = 'EMPIREm.BK', RkdDisplayRIC = 'EMPIREm.BK' WHERE SecCode = 5178470 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'EMPIRE-R' WHERE SecCode = 5178473 AND Type_ = 10;
UPDATE data_universe SET Name = 'HYUNDAI GREEN FOOD KRW500 (POST-SPLIT)' WHERE SecCode = 5391299 AND Type_ = 10;
UPDATE data_universe SET Name = 'VERTIS INFRAS INR10' WHERE SecCode = 5546604 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'EFOR.E', PermIDTicker = 'EFOR.E', RkdRIC = 'EFOR.IS', RkdDisplayRIC = 'EFOR.IS' WHERE SecCode = 5827159 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2024-09-27' WHERE SecCode = 5936391 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryInstr = 0.0 WHERE SecCode = 6039856 AND Type_ = 10;
UPDATE data_universe SET Name = 'EUROPLASMA EUR0.025' WHERE SecCode = 6445626 AND Type_ = 10;
UPDATE data_universe SET Name = 'LLOYDS ENGINEERING PPD INR19.50UPD INR19.50' WHERE SecCode = 6453918 AND Type_ = 10;
UPDATE data_universe SET Name = 'CISCO SYSTEMS DR5000:1 CROWDSTRIKE HOLDIN' WHERE SecCode = 6476475 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00BV9DPV21', RkdTicker = 'SHAW', RkdSEDOL = 'BV9DPV', RkdCUSIP = 'G8072S12', RkdRIC = 'SHAW.L', RkdDisplayRIC = 'SHAW.L', RkdCode = 102480.0, RkdIssueID = 1.0, RkdIssueCode = 128816.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'LON', RkdExchCtry = 'GBR', PrimaryIssueType = 'EQU', COATypeCode = 'BNK' WHERE SecCode = 6526493 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA2798521076', RkdTicker = 'EDCU', RkdCUSIP = '27985210', RkdRIC = 'EDCU.V', RkdDisplayRIC = 'EDCU.V' WHERE SecCode = 11025361 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2013-01-09', startDate = '2013-01-09' WHERE SecCode = 11030696 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 11044476 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11160338 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11164064 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG752711330', RkdCUSIP = 'G7527113' WHERE SecCode = 11176237 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA88831L2021', RkdCUSIP = '88831L20' WHERE SecCode = 11178148 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-10-31' WHERE SecCode = 11202140 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US0070258852', RkdCUSIP = '00702588' WHERE SecCode = 11207780 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-10-31', SecMapEndDate = '2025-10-30', endDate = '2025-10-30' WHERE SecCode = 11215253 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG4465R1294', RkdCUSIP = 'G4465R12' WHERE SecCode = 11236809 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US0008472021', RkdCUSIP = '00084720' WHERE SecCode = 11239312 AND Type_ = 1;
UPDATE data_universe SET InstrPermID = 18040305005.0, PriInstrPermID = 18040305005.0 WHERE SecCode = 11251501 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11255021 AND Type_ = 1;
UPDATE data_universe SET Name = 'ESH ACQUISITION CORP COM CL A' WHERE SecCode = 11255356 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11256445 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'FTW', RkdRIC = 'FTW', RkdDisplayRIC = 'FTW.N' WHERE SecCode = 11270085 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11284220 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11285141 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5096995204.0, IncCntry = 'CYM', PriTRBCIndPermID = NULL WHERE SecCode = 11287078 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT', COATypeCode = 'IND' WHERE SecCode = 11287404 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236798224346.0, IsPrimaryQuote = 1.0, ExchCode = 'NSM' WHERE SecCode = 11287481 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236798224214.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11287515 AND Type_ = 1;
