UPDATE model_universe SET QuotePermID = 21715145964, ExchCode = 'AQX' WHERE SecCode = 1807 AND Type_ = 10; UPDATE model_universe SET PermIDTicker = NULL, QuotePermID = 55842440800, PermQuoteRetireDate = '2012-05-04', endDate = '2012-05-04' WHERE SecCode = 45820 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 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 = 'S' WHERE SecCode = 73754 AND Type_ = 10; UPDATE model_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 76171 AND Type_ = 10; UPDATE model_universe SET RkdISIN = 'AU000000FBR4', RkdTicker = 'FBR', RkdSEDOL = 'BZ0291', RkdCUSIP = 'Q3R26D21', RkdRIC = 'FBR.AX', RkdDisplayRIC = 'FBR.AX' WHERE SecCode = 79182 AND Type_ = 10; UPDATE model_universe SET RkdISIN = 'KYG2117P1458', RkdSEDOL = 'BPY0C4', RkdCUSIP = 'G2117P14' WHERE SecCode = 79390 AND Type_ = 10; UPDATE model_universe SET PermIDTicker = 'WSO B' WHERE SecCode = 80971 AND Type_ = 1; UPDATE model_universe SET PriTRBCIndPermID = 4294951745.0 WHERE SecCode = 85852 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86339 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86528 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 91257 AND Type_ = 10; UPDATE model_universe SET RkdTicker = 'PERMAGN', RkdRIC = 'PRMG.NS', RkdDisplayRIC = 'PRMG.NS', RkdExchCode = 'NSE' WHERE SecCode = 92344 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 94403 AND Type_ = 10; UPDATE model_universe SET RkdRIC = 'BHIB.KL^I26', RkdIssueStatus = 0 WHERE SecCode = 94982 AND Type_ = 10; UPDATE model_universe SET PrimaryIssueCode = 61633.0 WHERE SecCode = 97401 AND Type_ = 10; UPDATE model_universe SET PriValQuotePermID = NULL, IsPrimaryQuote = 0 WHERE SecCode = 134894 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 139411 AND Type_ = 10; UPDATE model_universe SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 142079 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 145938 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 170011 AND Type_ = 10; UPDATE model_universe SET DomCntry = 'SWE' WHERE SecCode = 176980 AND Type_ = 10; UPDATE model_universe SET PriValQuotePermID = NULL, IsPrimaryQuote = 0 WHERE SecCode = 180518 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 299025 AND Type_ = 10; UPDATE model_universe SET PriTRBCIndPermID = 4294951905.0 WHERE SecCode = 582001 AND Type_ = 10; UPDATE model_universe SET PriTRBCIndPermID = 4294951795.0 WHERE SecCode = 588859 AND Type_ = 10; UPDATE model_universe SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 624469 AND Type_ = 10; UPDATE model_universe SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 674803 AND Type_ = 10; UPDATE model_universe SET RkdTicker = 'PDI', PermIDTicker = 'PDI', RkdRIC = 'PDI.AX', RkdDisplayRIC = 'PDI.AX' WHERE SecCode = 890647 AND Type_ = 10; UPDATE model_universe SET RkdRIC = 'SHOW3.SA^I26', RkdIssueStatus = 0 WHERE SecCode = 1110900 AND Type_ = 10; UPDATE model_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 1493830 AND Type_ = 10; UPDATE model_universe SET PrimaryIssueCode = 100282.0 WHERE SecCode = 1540033 AND Type_ = 10; UPDATE model_universe SET PermIDTicker = 'ABGPe', QuotePermID = 21513756453, PriValQuotePermID = NULL, IsPrimaryQuote = 0, ExchCode = 'HFT', PermQuoteRetireDate = '2014-05-02', endDate = '2014-05-02' WHERE SecCode = 1699140 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2800426 AND Type_ = 10; UPDATE model_universe SET RkdTicker = 'DEEP', RkdRIC = 'DEPP.NS', RkdDisplayRIC = 'DEPP.NS', RkdExchCode = 'NSE' WHERE SecCode = 3596594 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3735955 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4036729 AND Type_ = 10; UPDATE model_universe SET PrimaryIssueCode = 120441.0 WHERE SecCode = 4142522 AND Type_ = 10; UPDATE model_universe SET PriTRBCIndPermID = 4294951855.0 WHERE SecCode = 4288890 AND Type_ = 10; UPDATE model_universe SET PrimaryIssueCode = 107926.0 WHERE SecCode = 4630511 AND Type_ = 10; UPDATE model_universe SET QuotePermID = 21854742316, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, endDate = NULL WHERE SecCode = 4761537 AND Type_ = 10; UPDATE model_universe SET PrimaryIssueCode = 129879.0 WHERE SecCode = 4766077 AND Type_ = 10; UPDATE model_universe SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 4777363 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4903829 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5035049 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5623997 AND Type_ = 10; UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5693824 AND Type_ = 10; UPDATE model_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6394298 AND Type_ = 10; UPDATE model_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6422983 AND Type_ = 10; UPDATE model_universe SET COATypeCode = 'IND' WHERE SecCode = 7025896 AND Type_ = 10; UPDATE model_universe SET PermIDTicker = 'TAP A' WHERE SecCode = 10924512 AND Type_ = 1; UPDATE model_universe SET RkdISIN = 'US98957E1064', RkdSEDOL = 'BV8CX0', RkdCUSIP = '98957E10', OrgPermID = 6000269150, DomCntry = 'USA', IncCntry = 'USA', PermOrgIPODate = NULL WHERE SecCode = 11223968 AND Type_ = 1; UPDATE model_universe SET PermIDTicker = 'UHAL B' WHERE SecCode = 11247265 AND Type_ = 1; UPDATE model_universe SET PermOrgIPODate = NULL WHERE SecCode = 11279159 AND Type_ = 1;