UPDATE model_universe SET Name = 'BANK NOVA SCOTIA B C COM' WHERE SecCode = 8274 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951354.0 WHERE SecCode = 12287 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 13227 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951555.0 WHERE SecCode = 13469 AND Type_ = 1;
UPDATE model_universe SET RkdListingType = 'OSR' WHERE SecCode = 14769 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951648.0 WHERE SecCode = 16884 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 17097 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951533.0 WHERE SecCode = 18781 AND Type_ = 1;
UPDATE model_universe SET RkdListingType = 'OSR' WHERE SecCode = 19090 AND Type_ = 1;
UPDATE model_universe SET Name = 'DELUXE CORP MEDIUM TERM NTS COM' WHERE SecCode = 19416 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 26650 AND Type_ = 1;
UPDATE model_universe SET Name = '1ST FINL BANCORP COM' WHERE SecCode = 26820 AND Type_ = 1;
UPDATE model_universe SET RkdListingType = 'OSR' WHERE SecCode = 34555 AND Type_ = 1;
UPDATE model_universe SET Name = 'KILROY REALTY CORP COM' WHERE SecCode = 39650 AND Type_ = 1;
UPDATE model_universe SET Name = 'JEFFERIES FINANCIAL GROUP IN COM' WHERE SecCode = 42064 AND Type_ = 1;
UPDATE model_universe SET RkdListingType = 'OSR' WHERE SecCode = 43807 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 44507 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951866.0 WHERE SecCode = 44735 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 45825 AND Type_ = 1;
UPDATE model_universe SET RkdListingType = 'OSR' WHERE SecCode = 47113 AND Type_ = 1;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 50028 AND Type_ = 10;
UPDATE model_universe SET RkdListingType = 'OSR' WHERE SecCode = 51115 AND Type_ = 1;
UPDATE model_universe SET RkdListingType = 'OSR' WHERE SecCode = 51156 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951318.0 WHERE SecCode = 52077 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951998.0 WHERE SecCode = 53156 AND Type_ = 1;
UPDATE model_universe SET RkdListingType = 'OSR' WHERE SecCode = 57857 AND Type_ = 1;
UPDATE model_universe SET DomCntry = NULL, IncCntry = NULL WHERE SecCode = 59251 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 59656 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = 'NSUd', QuotePermID = 21531132175, ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26', endDate = '2020-11-16' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951722.0 WHERE SecCode = 68149 AND Type_ = 1;
UPDATE model_universe SET RkdIssueStatus = 1 WHERE SecCode = 70154 AND Type_ = 10;
UPDATE model_universe SET RkdListingType = 'OSR' WHERE SecCode = 73342 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 74269 AND Type_ = 10;
UPDATE model_universe SET RkdListingType = 'OSR' WHERE SecCode = 75747 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 76281 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 76661 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'INE376C01038', RkdTicker = 'CLCIND', RkdSEDOL = 'BP8ZG1', RkdCUSIP = 'Y8123914', RkdRIC = 'CLCI.NS', RkdDisplayRIC = 'CLCI.NS' WHERE SecCode = 78579 AND Type_ = 10;
UPDATE model_universe SET Name = 'VIRGINIA NATL BK CHRLOTSVLE COM' WHERE SecCode = 80134 AND Type_ = 1;
UPDATE model_universe SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 82077 AND Type_ = 10;
UPDATE model_universe SET RkdListingType = 'OSR' WHERE SecCode = 82851 AND Type_ = 1;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 83114 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 84956 AND Type_ = 1;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 87540 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 87703 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87755 AND Type_ = 10;
UPDATE model_universe SET RkdListingType = 'OSR' WHERE SecCode = 93596 AND Type_ = 1;
UPDATE model_universe SET RkdListingType = 'OSR' WHERE SecCode = 96195 AND Type_ = 1;
UPDATE model_universe SET QuotePermID = 21898257779, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE model_universe SET RkdIssueStatus = 0 WHERE SecCode = 140968 AND Type_ = 10;
UPDATE model_universe SET Name = 'PSG CORPORATION PC THB1 (LOCAL)' WHERE SecCode = 165534 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'CA80401L8033', RkdSEDOL = 'BV9C8R', RkdCUSIP = '80401L80' WHERE SecCode = 210689 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'AU0000058737', RkdTicker = 'LOT', RkdSEDOL = 'BK6XLC', RkdCUSIP = 'Q5633617', RkdRIC = 'LOT.AX', RkdDisplayRIC = 'LOT.AX', Name = 'LOTUS RESOURCES NPV' WHERE SecCode = 455870 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'ALGBE.PA^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, DsSecDelistDate = '2026-01-30', SecMapEndDate = '2025-12-01', endDate = '2025-12-01' WHERE SecCode = 1158940 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueCode = 92155.0 WHERE SecCode = 2459994 AND Type_ = 10;
UPDATE model_universe SET PermSecMapEndDate = '2026-01-29' WHERE SecCode = 2585343 AND Type_ = 10;
UPDATE model_universe SET Name = 'ASIA STRAT DIGIT HKD0.032' WHERE SecCode = 2804064 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 3283975 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'TITLE.BK', RkdDisplayRIC = 'TITLE.BK' WHERE SecCode = 3402642 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 3404428 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3547243 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'M5298Y24' WHERE SecCode = 4429562 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueCode = 123599.0 WHERE SecCode = 4607552 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 PermSecMapEndDate = '2026-01-29' WHERE SecCode = 4637758 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11222626 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = NULL, RkdRIC = 'SHCO.N^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, DsSecDelistDate = '2026-01-29', SecMapEndDate = '2026-01-28', endDate = '2026-01-28' WHERE SecCode = 11227251 AND Type_ = 1;
UPDATE model_universe SET PriTrdQuotePermID = 236802155855.0 WHERE SecCode = 11233331 AND Type_ = 1;
UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 11287745 AND Type_ = 1;
