UPDATE model_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 475 AND Type_ = 10;
UPDATE model_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 819 AND Type_ = 10;
UPDATE model_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 4512 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'GB00BT5GNW84', RkdSEDOL = 'BT5GNW', RkdCUSIP = 'G4390420' WHERE SecCode = 5979 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-20', endDate = '2026-07-20' WHERE SecCode = 10081 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-20', endDate = '2026-07-20' WHERE SecCode = 13231 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 19885 AND Type_ = 1;
UPDATE model_universe SET DomCntry = 'CAN' WHERE SecCode = 24116 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = 'LASCONDES' WHERE SecCode = 28165 AND Type_ = 10;
UPDATE model_universe SET PermIDTicker = 'OROBLANCO' WHERE SecCode = 29336 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 29986 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = 'SANTARITA' WHERE SecCode = 31252 AND Type_ = 10;
UPDATE model_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 33824 AND Type_ = 10;
UPDATE model_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 33868 AND Type_ = 10;
UPDATE model_universe SET RkdIssueStatus = 0 WHERE SecCode = 33937 AND Type_ = 10;
UPDATE model_universe SET OrgTypeCode = 'COM' WHERE SecCode = 45475 AND Type_ = 10;
UPDATE model_universe SET ExchCode = 'NAS' WHERE SecCode = 46706 AND Type_ = 1;
UPDATE model_universe SET RkdListingType = 'GSR' WHERE SecCode = 51313 AND Type_ = 1;
UPDATE model_universe SET RkdRIC = 'FINGb.ST^G26', RkdIssueStatus = 0 WHERE SecCode = 55872 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = NULL WHERE SecCode = 57034 AND Type_ = 1;
UPDATE model_universe SET PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 60151 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 68018 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75012 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75299 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 79182 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82271 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-19', SecMapEndDate = '2026-07-16', PermSecMapEndDate = '2026-07-19', endDate = '2026-07-16' WHERE SecCode = 82721 AND Type_ = 10;
UPDATE model_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 83138 AND Type_ = 10;
UPDATE model_universe SET DomCntry = NULL WHERE SecCode = 86744 AND Type_ = 1;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87178 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 89799 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 97691 AND Type_ = 10;
UPDATE model_universe SET DomCntry = 'USA' WHERE SecCode = 98477 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'GORO.A^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-18', SecMapEndDate = '2026-07-17', PermQuoteRetireDate = '2026-07-18', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-17' WHERE SecCode = 154472 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = 'MULTIX' WHERE SecCode = 309970 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'CA68827X1050', RkdTicker = 'OGG', PermIDTicker = 'OGG', RkdSEDOL = 'BTXM5X', RkdCUSIP = '68827X10', RkdRIC = 'OGG.V', RkdDisplayRIC = 'OGG.V', DsPrimQtSedol = 'BTXM5X3', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 322922 AND Type_ = 1;
UPDATE model_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 323135 AND Type_ = 10;
UPDATE model_universe SET OrgTypeCode = 'COM' WHERE SecCode = 349507 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'US8900233029', RkdCUSIP = '89002330', DsPrimQtSedol = 'BXP2VY2', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 354792 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = 'AZULAZUL' WHERE SecCode = 440850 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = '057050.KS^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0, DsSecDelistDate = '2026-07-20', SecMapEndDate = '2026-06-25', endDate = '2026-06-25' WHERE SecCode = 810847 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 843986 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1468628 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1522789 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2457963 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2700373 AND Type_ = 10;
UPDATE model_universe SET DsExchQtStartDate = '2017-01-24' WHERE SecCode = 2706327 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2717421 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3056869 AND Type_ = 10;
UPDATE model_universe SET IncCntry = NULL WHERE SecCode = 3434642 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4036729 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4451120 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4722080 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6394301 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6414075 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6431535 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6478326 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6503362 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6522450 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6538872 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6587240 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6590976 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6612483 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6617660 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6631818 AND Type_ = 10;
UPDATE model_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6734290 AND Type_ = 10;
UPDATE model_universe SET OrgPermID = 6000182781, PriInstrPermID = 8589943208.0, PriTRBCIndPermID = 4294951916.0, PermOrgIPODate = '2013-08-19' WHERE SecCode = 11105323 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'US74640Y3045', RkdCUSIP = '74640Y30', DsPrimQtSedol = 'BXP2VV9', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 11151222 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'BMG391041073', RkdCUSIP = 'G3910410', DsPrimQtSedol = 'BPY0594', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 11181200 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'US02462A2033', RkdSEDOL = 'BTCL71', RkdCUSIP = '02462A20' WHERE SecCode = 11182627 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'US6539421023', RkdTicker = 'NIKI', PermIDTicker = 'NIKI', RkdCUSIP = '65394210', RkdRIC = 'NIKI.O', RkdDisplayRIC = 'NIKI.OQ', DsPrimQtSedol = 'BXP2VZ3', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 11192828 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'US67054R3021', RkdCUSIP = '67054R30', DsPrimQtSedol = 'BXP2W38', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 11210266 AND Type_ = 1;
UPDATE model_universe SET RkdRIC = 'BURU.PK', RkdDisplayRIC = 'BURU.PK', RkdExchCode = 'OTC', PermQuoteRetireDate = '2026-07-20', endDate = '2026-07-20' WHERE SecCode = 11214016 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'KYG2646Y1044', RkdCUSIP = 'G2646Y10', DsPrimQtSedol = 'BVK0M11', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 11214218 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'KYG207071245', RkdCUSIP = 'G2070712', DsPrimQtSedol = 'BVK0LK3', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 11214381 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'US20678X6013', RkdCUSIP = '20678X60', DsPrimQtSedol = 'BXP2W27', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 11240122 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'KYG1991X1337', RkdCUSIP = 'G1991X13', DsPrimQtSedol = 'BXP2W05', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 11250670 AND Type_ = 1;
UPDATE model_universe SET RkdTicker = 'MF', PermIDTicker = 'MF', RkdRIC = 'MF.O', RkdDisplayRIC = 'MF.OQ' WHERE SecCode = 11263606 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = 'US10316W1071', RkdTicker = 'BXBL', PermIDTicker = 'BXBL', RkdSEDOL = 'BVK0LX', RkdCUSIP = '10316W10', RkdRIC = 'BXBL.O', RkdDisplayRIC = 'BXBL.OQ', DsPrimQtSedol = 'BVK0LX6', PermSecMapEndDate = '2026-07-18', endDate = '2026-07-18' WHERE SecCode = 11274771 AND Type_ = 1;
