UPDATE data_universe SET IncCntry = 'CAN' WHERE SecCode = 5705 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1996-08-21' WHERE SecCode = 12664 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DATA', QuotePermID = 55836051372.0, ExchCode = 'LSE', PermQuoteRetireDate = '2010-10-22', endDate = '2010-10-21' WHERE SecCode = 31747 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BQRDX71', DsExchMnem = 'HAM', DsExchQtStartDate = '1996-05-31' WHERE SecCode = 51554 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BQS8PT1' WHERE SecCode = 51555 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69698 AND Type_ = 10;
UPDATE data_universe SET Name = 'KOIYA INTERNATIONA INR10' WHERE SecCode = 76103 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78742 AND Type_ = 10;
UPDATE data_universe SET Name = 'ASTRA ENTERPRISE THB0.6 (NVDR)' WHERE SecCode = 80704 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81919 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 83994 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86796 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86918 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-12' WHERE SecCode = 87204 AND Type_ = 10;
UPDATE data_universe SET Name = 'ALL ENERGY & UTIL THB1 (LOCAL)' WHERE SecCode = 90115 AND Type_ = 10;
UPDATE data_universe SET Name = 'ALL ENERGY & UTIL THB1 (NVDR)' WHERE SecCode = 90117 AND Type_ = 10;
UPDATE data_universe SET Name = 'CHINA GOLDCORP LTD. COM' WHERE SecCode = 92347 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA39138C8741', RkdTicker = 'GWO.PR.H', RkdSEDOL = 'B0GZRN', RkdCUSIP = '39138C87', RkdRIC = 'GWO_ph.TO', RkdDisplayRIC = 'GWO_ph.TO', RkdCode = 14935.0, RkdIssueID = 5.0, RkdIssueCode = 21134.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 5.0, RkdExchCode = 'TSE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = 'FIN' WHERE SecCode = 94713 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA39138C8824', RkdTicker = 'GWO.PR.G', RkdSEDOL = 'B02TGC', RkdCUSIP = '39138C88', RkdRIC = 'GWO_pg.TO', RkdDisplayRIC = 'GWO_pg.TO', RkdCode = 14935.0, RkdIssueID = 3.0, RkdIssueCode = 21631.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 4.0, RkdExchCode = 'TSE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = 'FIN' WHERE SecCode = 94714 AND Type_ = 1;
UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 97949 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21898257779.0, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET Name = 'NOBIA AB NPV' WHERE SecCode = 102878 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115981 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'POSCO-THAINOX PCL THB10 (LOCAL)' WHERE SecCode = 122945 AND Type_ = 10;
UPDATE data_universe SET Name = 'POSCO-THAINOX PCL THB10 (NVDR)' WHERE SecCode = 123109 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 136715 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 141412 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-12' WHERE SecCode = 143572 AND Type_ = 10;
UPDATE data_universe SET Name = 'IOKENM CO LTD KRW100' WHERE SecCode = 146402 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'P1S9GM10' WHERE SecCode = 184471 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'CYM' WHERE SecCode = 200890 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 269427 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'H-POWER PLC ORD GBP0.001' WHERE SecCode = 288775 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 395046 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 395049 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 411775 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'AUS' WHERE SecCode = 772343 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'CAN' WHERE SecCode = 997772 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1083459 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'HANSAEMK CO LTD KRW1000' WHERE SecCode = 1173673 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1444255 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1534195 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1653492 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2065783 AND Type_ = 10;
UPDATE data_universe SET Name = 'ASTRA ENTERPRISE THB0.6 (LOCAL)' WHERE SecCode = 2217629 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2769155 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3033890 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 QuotePermID = 21732297982.0, ExchCode = 'DUS' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21635385247.0, PermQuoteStatus = 'DC', ExchCode = 'BTE', PermQuoteRetireDate = '2026-04-27' WHERE SecCode = 3358228 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-13' WHERE SecCode = 3396657 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 3403841 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'FREB', QuotePermID = 21633326859.0, ExchCode = 'MUN', PermQuoteRetireDate = '2018-06-22' WHERE SecCode = 3429677 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3493641 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-05-29' WHERE SecCode = 3508359 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21685853416.0, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 3827945 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-12' WHERE SecCode = 4129530 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4383293 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4456235 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = 'BNDMJS', DsExchMnem = 'LON', PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-13', PermSecMapEndDate = '2026-05-13', endDate = '2026-05-13' WHERE SecCode = 4613103 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236799418543.0, ExchCode = 'SIG' WHERE SecCode = 4815279 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21959379953.0, ExchCode = 'TDG' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4918578 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236785348309.0, ExchCode = 'QTX' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5448738 AND Type_ = 10;
UPDATE data_universe SET Name = 'ITSEC ASIA PT IDR12.5' WHERE SecCode = 5491797 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'CINV' WHERE SecCode = 5886924 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6037549 AND Type_ = 10;
UPDATE data_universe SET DsCmpyCode = 213875, IsMajorSec = 'Y' WHERE SecCode = 6622147 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6685955 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6773061 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000459398', RkdTicker = 'KAO', RkdSEDOL = 'BW5Z6Q', RkdCUSIP = 'Q5211N10', RkdRIC = 'KAO.AX', RkdDisplayRIC = 'KAO.AX', RkdCode = 144849.0, RkdIssueID = 1.0, RkdIssueCode = 185240.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6789483 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 6813232 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y971L410' WHERE SecCode = 6820135 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y408RN10' WHERE SecCode = 6836129 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y637AZ10' WHERE SecCode = 6839609 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RTB' WHERE SecCode = 10925095 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'DHR.H', RkdRIC = 'DHRh.V', RkdDisplayRIC = 'DHRh.V', RkdExchCode = 'NEX' WHERE SecCode = 10964736 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11079898 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11148397 AND Type_ = 1;
UPDATE data_universe SET Name = 'KEZAR LIFE SCIENCES INC COM NEW', PermOrgIPODate = NULL WHERE SecCode = 11186429 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'RVPH.OQ', RkdIssueStatus = 0.0 WHERE SecCode = 11191215 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2018-12-19', startDate = '2018-12-19' WHERE SecCode = 11192883 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11195740 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11197145 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'SNCY.OQ', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-14', SecMapEndDate = '2026-05-12', endDate = '2026-05-12' WHERE SecCode = 11220771 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11226252 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'IE0009876H30', RkdCUSIP = 'G1331113', DsPrimQtSedol = 'BT9QVD1' WHERE SecCode = 11249174 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'ALCY.OQ', RkdIssueStatus = 0.0 WHERE SecCode = 11254323 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11266303 AND Type_ = 1;
UPDATE data_universe SET Country = 'USA' WHERE SecCode = 11269370 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11270950 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-13', PermSecMapEndDate = '2026-05-13' WHERE SecCode = 11279604 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US37954A4022', RkdTicker = 'XRN PR B', RkdSEDOL = 'BVMNM8', RkdCUSIP = '37954A40', RkdRIC = 'XRN_pb', RkdDisplayRIC = 'XRN_pb.N', RkdCode = 88702.0, RkdIssueID = 2.0, RkdIssueCode = 185244.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11288131 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232922661803.0 WHERE SecCode = 11295154 AND Type_ = 1;
