UPDATE model_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-15', SecMapEndDate = '2025-09-11', PermQuoteRetireDate = '2025-09-12', PermSecMapEndDate = '2025-09-15', endDate = '2025-09-11' WHERE SecCode = 697 AND Type_ = 10;
UPDATE model_universe SET RkdIssueOrder = 4 WHERE SecCode = 4537 AND Type_ = 1;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 9703 AND Type_ = 10;
UPDATE model_universe SET Name = 'BIO GREEN MED SOLUTION  INC COM JUNE 2025' WHERE SecCode = 18200 AND Type_ = 1;
UPDATE model_universe SET Name = 'DURECT CORP COM NEW' WHERE SecCode = 22244 AND Type_ = 1;
UPDATE model_universe SET PriInstrPermID = NULL, IsPrimaryInstr = 0 WHERE SecCode = 45120 AND Type_ = 1;
UPDATE model_universe SET QuotePermID = 21532854931, ExchCode = 'AQX' WHERE SecCode = 45820 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 53655 AND Type_ = 1;
UPDATE model_universe SET PermIDTicker = 'BTBB', QuotePermID = 21474924570, ExchCode = 'DEU', PermQuoteRetireDate = '2023-11-06', endDate = '2023-11-03' WHERE SecCode = 59414 AND Type_ = 10;
UPDATE model_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 69272 AND Type_ = 10;
UPDATE model_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE model_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 75416 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 76193 AND Type_ = 10;
UPDATE model_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE model_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'GANESH HOUSING LTD INR10(DEMAT)' WHERE SecCode = 78667 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78748 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81729 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 82146 AND Type_ = 10;
UPDATE model_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 84719 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL WHERE SecCode = 89466 AND Type_ = 10;
UPDATE model_universe SET RkdSEDOL = NULL WHERE SecCode = 89467 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 90284 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 90297 AND Type_ = 10;
UPDATE model_universe SET PermQuoteRetireDate = '2025-10-10' WHERE SecCode = 90958 AND Type_ = 10;
UPDATE model_universe SET PermQuoteRetireDate = '2025-10-15' WHERE SecCode = 90983 AND Type_ = 10;
UPDATE model_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE model_universe SET Name = 'DPM METALS INC COM' WHERE SecCode = 93359 AND Type_ = 1;
UPDATE model_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'AU0000417149', RkdTicker = 'SOLDA', PermIDTicker = 'SOLDA', RkdSEDOL = 'BT8NLQ', RkdRIC = 'SOLDA.AX', RkdDisplayRIC = 'SOLDA.AX', DsPrimQtSedol = 'BT8NLQ6', PermSecMapEndDate = '2025-09-15', endDate = '2025-09-15' WHERE SecCode = 95997 AND Type_ = 10;
UPDATE model_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 97525 AND Type_ = 10;
UPDATE model_universe SET RkdTicker = 'CEMPRO', PermIDTicker = 'CEMPRO', RkdRIC = 'CEMI.NS', RkdDisplayRIC = 'CEMI.NS' WHERE SecCode = 97785 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 99172 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951823.0 WHERE SecCode = 99982 AND Type_ = 10;
UPDATE model_universe SET RkdCUSIP = 'Q8329N31', Name = 'SAYONA MINING LTD NPV DFD 19/09/25 (EX-SPLIT)', SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 111747 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 112954 AND Type_ = 10;
UPDATE model_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE model_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 116434 AND Type_ = 10;
UPDATE model_universe SET Name = 'ADVANCED NANO TECH NPV DFD 13/10/17(EX-SPLT)' WHERE SecCode = 128181 AND Type_ = 10;
UPDATE model_universe SET RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 141836 AND Type_ = 10;
UPDATE model_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = 'CA28619K2083', RkdSEDOL = 'BTZP33', RkdCUSIP = '28619K20', DsPrimQtSedol = 'BTZP336' WHERE SecCode = 294232 AND Type_ = 1;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 302310 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 302433 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 320072 AND Type_ = 10;
UPDATE model_universe SET ISIN = NULL, Name = 'YUZHOU GROUP HOLDI HKD1' WHERE SecCode = 551335 AND Type_ = 10;
UPDATE model_universe SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 558354 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 898133 AND Type_ = 10;
UPDATE model_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE model_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 3037819 AND Type_ = 10;
UPDATE model_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3043688 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 3172415 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 3234669 AND Type_ = 10;
UPDATE model_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 3612339 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 3809775 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 3961773 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 4220050 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4307878 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 4482176 AND Type_ = 10;
UPDATE model_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4561851 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 4724707 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 4727655 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 4728954 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 4746790 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 4940655 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 5223194 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 5807642 AND Type_ = 10;
UPDATE model_universe SET RkdRIC = '7750.TW', RkdDisplayRIC = '7750.TW', RkdExchCode = 'TPE', ExchCode = 'TAI' WHERE SecCode = 5807735 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 5814581 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 5981831 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 5987986 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 5987988 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 5988063 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 6092920 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 6114249 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 6128250 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 6203257 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 6285562 AND Type_ = 10;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 6297427 AND Type_ = 10;
UPDATE model_universe SET OrgPermID = 5096758753, PermOrgIPODate = '2018-03-23' WHERE SecCode = 11183359 AND Type_ = 1;
UPDATE model_universe SET Name = 'STRIVE INC CL A COM', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11249437 AND Type_ = 1;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 11256311 AND Type_ = 1;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 11258687 AND Type_ = 1;
UPDATE model_universe SET COATypeCode = '' WHERE SecCode = 11272073 AND Type_ = 1;
