UPDATE data_universe SET IncCntry = 'GBR' WHERE SecCode = 11372 AND Type_ = 10;
UPDATE data_universe SET IsMajorSec = 'Y' WHERE SecCode = 14280 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 14281 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'MICHAEL PAGE PLC ORD GBP0.01' WHERE SecCode = 31560 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21474913868.0, ExchCode = 'BUR' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-07-23' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 57460 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'ZAF' WHERE SecCode = 70418 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70467 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 76806 AND Type_ = 1;
UPDATE data_universe SET Name = 'GOODMAN NZ LTD & G NPV STAPLED' WHERE SecCode = 78081 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81730 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BNBWTH5' WHERE SecCode = 82333 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '060240.KQ^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-23', SecMapEndDate = '2026-07-23', endDate = '2026-07-23' WHERE SecCode = 83485 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 84806 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 89550 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-27' WHERE SecCode = 91841 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ARO', Name = 'ALTORO METALS LTD NPV', SecMapEndDate = '2079-06-06', endDate = NULL WHERE SecCode = 92639 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SKYLAND PETROL GRP NPV' WHERE SecCode = 94787 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 113724 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-23', PermSecMapEndDate = '2026-07-23' WHERE SecCode = 121063 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125539 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126529 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126634 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2027-01-01' WHERE SecCode = 137680 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AHN', DsPrimQtSedol = 'B1H69N3' WHERE SecCode = 180020 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'NFBK.OQ^G26', RkdIssueStatus = 0.0 WHERE SecCode = 331577 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 331996 AND Type_ = 10;
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 PermIDTicker = 'CYNCA' WHERE SecCode = 345593 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475473201.0, ExchCode = 'GER' WHERE SecCode = 351305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 395048 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236798948725.0, ExchCode = 'DUS' WHERE SecCode = 396306 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 400273 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 411896 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 516194 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 536888 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 547478 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-24', endDate = '2026-07-24' WHERE SecCode = 589622 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1121968 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'PH0000062697', RkdTicker = 'TUBIG', PermIDTicker = 'TUBIG', RkdSEDOL = 'BMV9N1', RkdCUSIP = 'Y897ZF10', RkdRIC = 'TUBIG.PS', RkdDisplayRIC = 'TUBIG.PS', DsPrimQtSedol = 'BMV9N11' WHERE SecCode = 1708986 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2283967 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-08-08' WHERE SecCode = 2311326 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21532984899.0, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236810389226.0 WHERE SecCode = 2436736 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BTNP4Q8' WHERE SecCode = 2499278 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'POWER' WHERE SecCode = 2739696 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'POWER-R' WHERE SecCode = 2739698 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2827910 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2015-05-18', startDate = '2015-05-14' WHERE SecCode = 2899614 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'HNX' WHERE SecCode = 2935048 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21628902471.0, ExchCode = 'MUN' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET Name = 'YESUN TECH CO LTD KRW500' WHERE SecCode = 3247331 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3272839 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21610513041.0, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'HNX' WHERE SecCode = 3354563 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3883680 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ARO' WHERE SecCode = 4058518 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4542562 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4752161 AND Type_ = 10;
UPDATE data_universe SET DsTypeCode = 'NVDR' WHERE SecCode = 4756590 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00BWYF7709', RkdSEDOL = 'BWYF77', RkdCUSIP = 'G8715C12' WHERE SecCode = 4773789 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21975266861.0, ExchCode = 'DEU' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXQ15X5' WHERE SecCode = 5527280 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-07-22' WHERE SecCode = 5567944 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXQ13Y2' WHERE SecCode = 6137602 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BTNP4P7' WHERE SecCode = 6456244 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SE0028825042', RkdTicker = 'NTECH', RkdSEDOL = 'BXM7BR', RkdCUSIP = 'W8783G11', RkdRIC = 'NTECH.ST', RkdDisplayRIC = 'NTECH.ST', RkdCode = 145221.0, RkdIssueID = 1.0, RkdIssueCode = 185828.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'STO', RkdExchCtry = 'SWE', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6908116 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-23', PermSecMapEndDate = '2026-07-23', endDate = '2026-07-23' WHERE SecCode = 6951849 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE1SRC01010', RkdTicker = '544826', RkdSEDOL = 'BW2JHM', RkdCUSIP = 'Y6S4RZ10', RkdRIC = 'MILW.BO', RkdDisplayRIC = 'MILW.BO', RkdCode = 145214.0, RkdIssueID = 1.0, RkdIssueCode = 185817.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'BOM', RkdExchCtry = 'IND', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6997056 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 7000381 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11046293 AND Type_ = 1;
UPDATE data_universe SET Name = 'PATTERSON METALS CORP COM SHS', PermSecMapEndDate = '2026-07-23', endDate = '2026-07-23' WHERE SecCode = 11061719 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG3314M1096', RkdSEDOL = 'BTCL6X', RkdCUSIP = 'G3314M10' WHERE SecCode = 11104336 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-22', PermSecMapEndDate = '2026-07-22' WHERE SecCode = 11147409 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-22', PermSecMapEndDate = '2026-07-22' WHERE SecCode = 11177647 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000196386.0, PermOrgIPODate = NULL WHERE SecCode = 11184721 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CCCFD', DsPrimQtSedol = 'BRCB4B8' WHERE SecCode = 11193523 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'CNX' WHERE SecCode = 11201062 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-24', endDate = '2026-07-24' WHERE SecCode = 11207414 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXW27L4' WHERE SecCode = 11211489 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXW27H0' WHERE SecCode = 11224254 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GRSD' WHERE SecCode = 11227626 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'VIP' WHERE SecCode = 11230326 AND Type_ = 1;
UPDATE data_universe SET RkdIssueID = 2.0, RkdIssueCode = 166669.0, RkdIssueOrder = 2.0, RkdListingType = NULL WHERE SecCode = 11237419 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-22', PermSecMapEndDate = '2026-07-22' WHERE SecCode = 11257506 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000176722.0, PriInstrPermID = 232851626455.0, PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 11269247 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'VLOS', PermIDTicker = 'VLOS', RkdRIC = 'VLOS.O', RkdDisplayRIC = 'VLOS.OQ' WHERE SecCode = 11269897 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'VLOSU' WHERE SecCode = 11269939 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11274771 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVPL316' WHERE SecCode = 11275656 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11296208 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11297291 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11299479 AND Type_ = 1;
