UPDATE model_universe SET RkdExchCode = 'NA', RkdExchCtry = NULL WHERE SecCode = 29184 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'GARANTI BBVA TRY1' WHERE SecCode = 39773 AND Type_ = 10;
UPDATE model_universe SET QuotePermID = 21474913868, ExchCode = 'BUR' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE model_universe SET IsMajorSec = 'N' WHERE SecCode = 46631 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'GRUPA FT E SA PLN1.00' WHERE SecCode = 51077 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 57242 AND Type_ = 10;
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 PermOrgIPODate = '1991-07-04' WHERE SecCode = 67232 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951175.0 WHERE SecCode = 70938 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70947 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951268.0 WHERE SecCode = 71921 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 72881 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'SPY.NZ^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-05', SecMapEndDate = '2025-11-03', PermQuoteRetireDate = '2025-11-05', PermSecMapEndDate = '2025-11-04', endDate = '2025-11-03' WHERE SecCode = 76345 AND Type_ = 10;
UPDATE model_universe SET DsExchMnem = 'NAS', ExchCode = 'NSM' WHERE SecCode = 77931 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81643 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = '6416.T^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-11-05', SecMapEndDate = '2025-11-04', PermSecMapEndDate = '2025-11-04', endDate = '2025-11-04' WHERE SecCode = 85286 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85411 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = 'KNMP.KL^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-11-05', SecMapEndDate = '2025-10-10', PermQuoteRetireDate = '2025-11-05', PermSecMapEndDate = '2025-11-04', endDate = '2025-10-10' WHERE SecCode = 92128 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'MRZL', PermIDTicker = 'MRZL', RkdCUSIP = NULL, RkdRIC = 'MRZL.V', RkdDisplayRIC = 'MRZL.V' WHERE SecCode = 92563 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = NULL, RkdRIC = 'PKI.TO^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0, DsSecDelistDate = '2025-11-05', PermQuoteRetireDate = '2025-11-05', endDate = '2025-11-05' WHERE SecCode = 97829 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 99351 AND Type_ = 10;
UPDATE model_universe SET PermQuoteRetireDate = '2025-11-27' WHERE SecCode = 132080 AND Type_ = 10;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 146014 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'AU0000423089', RkdTicker = 'AMADA', PermIDTicker = 'AMADA', RkdSEDOL = 'BVLKB0', RkdRIC = 'AMADA.AX', RkdDisplayRIC = 'AMADA.AX', DsPrimQtSedol = 'BVLKB02', PermSecMapEndDate = '2025-11-04', endDate = '2025-11-04' WHERE SecCode = 161050 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 268435 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 321245 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL WHERE SecCode = 391840 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 1004365447.0 WHERE SecCode = 703543 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y2494F15' WHERE SecCode = 1024298 AND Type_ = 10;
UPDATE model_universe SET PriInstrPermID = 232903142394.0 WHERE SecCode = 1111347 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1458927 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueCode = 95391.0 WHERE SecCode = 2349785 AND Type_ = 10;
UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 2655880 AND Type_ = 10;
UPDATE model_universe SET IsMajorSec = 'Y' WHERE SecCode = 2907935 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueCode = 96794.0 WHERE SecCode = 3177804 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3315876 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3564647 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 3673678 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3809974 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'LGRSl', QuotePermID = 21693145541, ExchCode = 'BCO', PermQuoteRetireDate = '2025-07-21' WHERE SecCode = 3818837 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y2S37710' WHERE SecCode = 4026038 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y709Y810' WHERE SecCode = 4034112 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y3033L10' WHERE SecCode = 4040150 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y4S3R810' WHERE SecCode = 4040153 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y7T8GA10' WHERE SecCode = 4054381 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y973C010' WHERE SecCode = 4129798 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y7S0B910' WHERE SecCode = 4163629 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y990EK10' WHERE SecCode = 4168437 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y3R6TR10' WHERE SecCode = 4178606 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y901LY10' WHERE SecCode = 4178864 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y990ER10' WHERE SecCode = 4349911 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y669C410' WHERE SecCode = 4383292 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y990EL10' WHERE SecCode = 4385223 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y973BZ10' WHERE SecCode = 4395427 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y293BC10' WHERE SecCode = 4408311 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y445W010' WHERE SecCode = 4408312 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y603L510' WHERE SecCode = 4421096 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y990EQ10' WHERE SecCode = 4423819 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y445VZ10' WHERE SecCode = 4432472 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y3046010' WHERE SecCode = 4441387 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y9544G10' WHERE SecCode = 4443968 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y971KS10' WHERE SecCode = 4444668 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y257M310' WHERE SecCode = 4449609 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y2649D10' WHERE SecCode = 4451127 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y990EN10' WHERE SecCode = 4457141 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y9261610' WHERE SecCode = 4484327 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y774TR10' WHERE SecCode = 4524355 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y2S37910' WHERE SecCode = 4546440 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4557731 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y7011R10' WHERE SecCode = 4598587 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y6T03D10' WHERE SecCode = 4641478 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y774TQ10' WHERE SecCode = 4645342 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y990EM10' WHERE SecCode = 5437844 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y293BD10' WHERE SecCode = 5453394 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y774TS10' WHERE SecCode = 5466115 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y312GT10' WHERE SecCode = 5473213 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y7T8GB10' WHERE SecCode = 5474571 AND Type_ = 10;
UPDATE model_universe SET PermInstrStatus = 'DC' WHERE SecCode = 5478193 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y832F110' WHERE SecCode = 5478195 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y9544F10' WHERE SecCode = 5479901 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y971KR10' WHERE SecCode = 5482519 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y774TT10' WHERE SecCode = 5499288 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y832F210' WHERE SecCode = 5500262 AND Type_ = 10;
UPDATE model_universe SET PermQuoteRetireDate = '2025-11-27' WHERE SecCode = 5601206 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y7T92410' WHERE SecCode = 5894867 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y768TY10' WHERE SecCode = 5903111 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y990EP10' WHERE SecCode = 5923809 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y4108U10' WHERE SecCode = 5931895 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5965452 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y7694710' WHERE SecCode = 6443242 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y856F410' WHERE SecCode = 6507142 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Y5S5NN10' WHERE SecCode = 6513219 AND Type_ = 10;
UPDATE model_universe SET Name = 'SHAWBROOK GROUP PL ORD GBP0.005' WHERE SecCode = 6526493 AND Type_ = 10;
UPDATE model_universe SET Name = 'HARBORONE BANCORP INC NEW COM NEW' WHERE SecCode = 11160338 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11178148 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = NULL, RkdRIC = 'AND.TO^K25', DsCtryQtStatus = 'D', RkdIssueStatus = 0, DsSecDelistDate = '2025-11-05', PermQuoteRetireDate = '2025-11-05', endDate = '2025-11-05' WHERE SecCode = 11203092 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11239312 AND Type_ = 1;
UPDATE model_universe SET OrgPermID = 5096997367, IncCntry = 'USA', PriTRBCIndPermID = 4294951800.0, PermOrgIPODate = '2024-08-16', startDate = '2024-08-16' WHERE SecCode = 11270517 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'US42727R2031', RkdSEDOL = 'BVSWCC', RkdCUSIP = '42727R20', DsPrimQtSedol = 'BVSWCC0', PermSecMapEndDate = '2025-11-05', endDate = '2025-11-05' WHERE SecCode = 11271912 AND Type_ = 1;
