UPDATE model_universe SET Name = 'EBIQUITY PLC ORD GBP 0.0001' WHERE SecCode = 5832 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951787.0 WHERE SecCode = 7309 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 12764 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 17327 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = NULL, RkdRIC = 'FONR.OQ^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, DsSecDelistDate = '2026-06-04', SecMapEndDate = '2026-06-02', endDate = '2026-06-02' WHERE SecCode = 27805 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 29418 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 30232 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = 'PPLI', RkdRIC = 'PPLI.O', RkdDisplayRIC = 'PPLI.OQ', Name = 'PEOPLE INCORPORATED COM NEW' WHERE SecCode = 34455 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951866.0 WHERE SecCode = 42761 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = NULL, startDate = '1988-04-05' WHERE SecCode = 45794 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'MACO.I', QuotePermID = 21475575870, ExchCode = 'CCH', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951271.0 WHERE SecCode = 45939 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 50949 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 59120 AND Type_ = 1;
UPDATE model_universe SET PermQuoteRetireDate = '2026-06-19' WHERE SecCode = 67906 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951554.0 WHERE SecCode = 69894 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 70269 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'BMU' WHERE SecCode = 73192 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = '000638.SZ^F26', DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-03', SecMapEndDate = '2026-04-13', PermQuoteRetireDate = '2026-06-03', PermSecMapEndDate = '2026-06-03', endDate = '2026-04-13' WHERE SecCode = 73938 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 75219 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = 'ATHDA', PermSecMapEndDate = '2026-06-02', endDate = '2026-06-02' WHERE SecCode = 75379 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82759 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86003 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 86303 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 87126 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = '9067.T^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-04', SecMapEndDate = '2026-06-03', PermSecMapEndDate = '2026-06-03', endDate = '2026-06-03' WHERE SecCode = 88511 AND Type_ = 10;
UPDATE model_universe SET SecMapStartDate = '1997-04-11' WHERE SecCode = 90401 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951344.0 WHERE SecCode = 90602 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 1004365342.0 WHERE SecCode = 96809 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 97398 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 98178 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951384.0 WHERE SecCode = 101146 AND Type_ = 1;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 104982 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 111297 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115324 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951811.0 WHERE SecCode = 116171 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 133245 AND Type_ = 10;
UPDATE model_universe SET DsExchMnem = 'NSE' WHERE SecCode = 135748 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = NULL, startDate = '1993-10-21' WHERE SecCode = 145422 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 146444 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = NULL, startDate = '1995-01-02' WHERE SecCode = 255957 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 334731 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 376837 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'SAIGON TREASURE CO VND10000' WHERE SecCode = 522897 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951347.0 WHERE SecCode = 537956 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 1261606 AND Type_ = 10;
UPDATE model_universe SET Name = 'HONG KONG GOLD HKD0.04' WHERE SecCode = 1565080 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951345.0 WHERE SecCode = 1706291 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2200264 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2238141 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 2441643 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951968.0 WHERE SecCode = 2551294 AND Type_ = 10;
UPDATE model_universe SET Name = 'HUA HONG SEMICONDU NPV' WHERE SecCode = 2650541 AND Type_ = 10;
UPDATE model_universe SET Name = 'XINMING CHINA HOLD HKD0.25' WHERE SecCode = 2924595 AND Type_ = 10;
UPDATE model_universe SET Name = 'CHIA TAI ENTERPRIS USD0.1' WHERE SecCode = 2929636 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951671.0 WHERE SecCode = 2990814 AND Type_ = 10;
UPDATE model_universe SET Name = 'TAI KAM HOLDINGS L HKD0.05' WHERE SecCode = 3258937 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'VEONa', QuotePermID = 21610682901, ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-11' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 3375310 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'DE000A41YD16', RkdTicker = 'B4B0', RkdSEDOL = 'BN4PWJ', RkdCUSIP = 'D5S17Q21', RkdRIC = 'B4B0n.H', RkdDisplayRIC = 'B4B0n.H', DsPrimQtSedol = 'BN4PWJ4' WHERE SecCode = 3376114 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 3396657 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951788.0 WHERE SecCode = 3410320 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951855.0 WHERE SecCode = 3887970 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4379702 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951266.0 WHERE SecCode = 4491673 AND Type_ = 10;
UPDATE model_universe SET QuotePermID = 21899163259, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30', endDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE model_universe SET OrgTypeCode = 'CINV' WHERE SecCode = 5031884 AND Type_ = 10;
UPDATE model_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-03', PermSecMapEndDate = '2026-06-03' WHERE SecCode = 5161399 AND Type_ = 10;
UPDATE model_universe SET Name = 'HUA HONG SEMICONDU CNY1 A' WHERE SecCode = 5490557 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951765.0 WHERE SecCode = 5640162 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 6285562 AND Type_ = 10;
UPDATE model_universe SET Name = 'NANCHANG SANRUI CNY1' WHERE SecCode = 6773037 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 6789475 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Q4566740' WHERE SecCode = 6808989 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 6846681 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'M2723M10' WHERE SecCode = 6865118 AND Type_ = 10;
UPDATE model_universe SET QuotePermID = 21475110262, ExchCode = 'NSQ' WHERE SecCode = 10965319 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 11034341 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 11176481 AND Type_ = 1;
UPDATE model_universe SET DomCntry = 'USA' WHERE SecCode = 11192616 AND Type_ = 1;
UPDATE model_universe SET RkdSEDOL = 'BSQLM2', RkdRIC = 'BIPC.TO', RkdDisplayRIC = 'BIPC.TO', RkdExchCode = 'TSE', RkdExchCtry = 'CAN' WHERE SecCode = 11206349 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 11206880 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 11211234 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 11214005 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = '2021-06-25' WHERE SecCode = 11226283 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = '2022-02-04' WHERE SecCode = 11238076 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-03' WHERE SecCode = 11245859 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 11250924 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 11251539 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 11258427 AND Type_ = 1;
UPDATE model_universe SET PermOrgIPODate = NULL, startDate = '2024-09-13' WHERE SecCode = 11269640 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 11279172 AND Type_ = 1;
UPDATE model_universe SET DomCntry = 'CYM' WHERE SecCode = 11285566 AND Type_ = 1;
