UPDATE model_universe SET PermIDTicker = NULL, QuotePermID = 21475442988, ExchCode = 'CHI' WHERE SecCode = 4772 AND Type_ = 10;
UPDATE model_universe SET SecMapStartDate = '1960-01-01', startDate = '1960-01-01' WHERE SecCode = 23846 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 23996 AND Type_ = 1;
UPDATE model_universe SET PriInstrPermID = NULL WHERE SecCode = 25075 AND Type_ = 1;
UPDATE model_universe SET RkdIssueOrder = 1 WHERE SecCode = 28624 AND Type_ = 10;
UPDATE model_universe SET Name = 'NOVABASE SGPS SA EUR0.97' WHERE SecCode = 35101 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'USA' WHERE SecCode = 55063 AND Type_ = 1;
UPDATE model_universe SET DomCntry = 'HKG' WHERE SecCode = 69151 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'IND' WHERE SecCode = 71407 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'GREEN LEADER HLDGS HKD0.004' WHERE SecCode = 72986 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'SGP' WHERE SecCode = 73158 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'AU0000478117', RkdTicker = 'CYV', RkdSEDOL = 'BSSF4N', RkdRIC = 'CYV.AX', RkdDisplayRIC = 'CYV.AX' WHERE SecCode = 74387 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'USA' WHERE SecCode = 78585 AND Type_ = 1;
UPDATE model_universe SET DsPrimQtSedol = 'BPY0C48' WHERE SecCode = 79390 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'HKG' WHERE SecCode = 84805 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = NULL, RkdRIC = 'XOMA.OQ^G26', RkdIssueStatus = 0 WHERE SecCode = 85191 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85899 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = '012510.KS^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, DsSecDelistDate = '2026-07-15', SecMapEndDate = '2026-06-25', endDate = '2026-06-25' WHERE SecCode = 86473 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'USA' WHERE SecCode = 87093 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'BMG1941S1504', RkdSEDOL = 'BW61LW', RkdCUSIP = 'G1941S15' WHERE SecCode = 88263 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'BMG522112017', RkdSEDOL = 'BXD2L2', RkdCUSIP = 'G5221120' WHERE SecCode = 89269 AND Type_ = 10;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 90720 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 91086 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'HKG' WHERE SecCode = 91216 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = '000004.SZ^G26', RkdIssueStatus = 0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-07-14', startDate = '1991-08-26' WHERE SecCode = 95337 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = NULL, RkdRIC = '600636.SS^F26', RkdIssueStatus = 0 WHERE SecCode = 95877 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = NULL, RkdRIC = '600421.SS^F26', RkdIssueStatus = 0 WHERE SecCode = 113724 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'EBIL.BO', RkdDisplayRIC = 'EBIL.BO' WHERE SecCode = 135128 AND Type_ = 10;
UPDATE model_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 302601 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 312992 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'SGP' WHERE SecCode = 333221 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 553461 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = '300029.SZ^G26', RkdIssueStatus = 0 WHERE SecCode = 558540 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = '002808.SZ^G26', RkdIssueStatus = 0, PermSecMapEndDate = '2026-07-13' WHERE SecCode = 573055 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueCode = 86408.0 WHERE SecCode = 1205687 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, RkdTicker = 'AAGB', RkdRIC = 'AIRG.KL', RkdDisplayRIC = 'AIRG.KL', Name = 'AIRASIA GROUP BHD NPV' WHERE SecCode = 2278101 AND Type_ = 10;
UPDATE model_universe SET IncCntry = 'VGB' WHERE SecCode = 2536035 AND Type_ = 10;
UPDATE model_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 2564920 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2708934 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 2864406 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2894516 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'BRB' WHERE SecCode = 2905569 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-15', SecMapEndDate = '2025-10-08', PermQuoteRetireDate = '2026-07-15', endDate = '2025-10-08' WHERE SecCode = 2935048 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = '3546.T^F26', RkdIssueStatus = 0 WHERE SecCode = 3235105 AND Type_ = 10;
UPDATE model_universe SET IncCntry = 'VGB' WHERE SecCode = 3316565 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = NULL, RkdRIC = 'TCD.HM^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-15', SecMapEndDate = '2025-10-08', PermQuoteRetireDate = '2026-07-15', endDate = '2025-10-08' WHERE SecCode = 3354563 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 3397145 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueCode = 117890.0 WHERE SecCode = 4335825 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951631.0 WHERE SecCode = 4385223 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'AUS' WHERE SecCode = 4787472 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 5250953 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'AU0000477440', RkdTicker = 'SKG', RkdSEDOL = 'BVPFTH', RkdRIC = 'SKG.AX', RkdDisplayRIC = 'SKG.AX' WHERE SecCode = 5485039 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6414075 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6431535 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6513037 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6617659 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6734290 AND Type_ = 10;
UPDATE model_universe SET SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 6813816 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 6829246 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 6900879 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 6939102 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'WSR.N^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-14', SecMapEndDate = '2026-07-13', PermQuoteRetireDate = '2026-07-14', PermSecMapEndDate = '2026-07-14', endDate = '2026-07-13' WHERE SecCode = 10967956 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = NULL, PermSecMapEndDate = '2026-07-14' WHERE SecCode = 11078249 AND Type_ = 1;
UPDATE model_universe SET Name = 'EXPRO LTD ORD SHS', Country = 'CYM' WHERE SecCode = 11104336 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11158566 AND Type_ = 1;
UPDATE model_universe SET OrgPermID = 6000175781 WHERE SecCode = 11163549 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'EEX.N^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-14', SecMapEndDate = '2026-07-13', PermQuoteRetireDate = '2026-07-14', PermSecMapEndDate = '2026-07-14', endDate = '2026-07-13' WHERE SecCode = 11171866 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = 'AZIO', RkdRIC = 'AZIO.O', RkdDisplayRIC = 'AZIO.OQ' WHERE SecCode = 11173743 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951568.0, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11226560 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11226875 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = NULL WHERE SecCode = 11231455 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = '2021-12-15' WHERE SecCode = 11235729 AND Type_ = 1;
UPDATE model_universe SET Name = 'HONGLI GROUP INC. CL A SHR' WHERE SecCode = 11250986 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = NULL, RkdRIC = 'SDM.OQ^G26', RkdIssueStatus = 0 WHERE SecCode = 11277960 AND Type_ = 1;
UPDATE model_universe SET OrgPermID = 6000169509, PermOrgIPODate = '2025-11-13' WHERE SecCode = 11279159 AND Type_ = 1;
UPDATE model_universe SET RkdSEDOL = 'BXRVNH' WHERE SecCode = 11286103 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11286421 AND Type_ = 1;