UPDATE data_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 data_universe SET COATypeCode = '' WHERE SecCode = 915 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2587 AND Type_ = 10;
UPDATE data_universe SET RkdIssueOrder = 4.0 WHERE SecCode = 4537 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 9703 AND Type_ = 10;
UPDATE data_universe SET Name = 'BIO GREEN MED SOLUTION  INC COM JUNE 2025' WHERE SecCode = 18200 AND Type_ = 1;
UPDATE data_universe SET Name = 'BIO GREEN MED SOLUTION  INC PFD CONV EX 6%' WHERE SecCode = 18201 AND Type_ = 1;
UPDATE data_universe SET Name = 'DURECT CORP COM NEW' WHERE SecCode = 22244 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 41247 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL, IsPrimaryInstr = 0.0 WHERE SecCode = 45120 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 45301 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21532854931.0, ExchCode = 'AQX' WHERE SecCode = 45820 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 53655 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 56762 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-15', endDate = '2025-09-15' WHERE SecCode = 59308 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BTBB', QuotePermID = 21474924570.0, ExchCode = 'DEU', PermQuoteRetireDate = '2023-11-06', endDate = '2023-11-03' WHERE SecCode = 59414 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 64039 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 66291 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 69272 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 69942 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000419624', RkdTicker = 'GA8', PermIDTicker = 'GA8', RkdSEDOL = 'BVPGHD', RkdRIC = 'GA8.AX', RkdDisplayRIC = 'GA8.AX', DsPrimQtSedol = 'BVPGHD1' WHERE SecCode = 74740 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75258 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 75416 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75698 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 76193 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'GANESH HOUSING LTD INR10(DEMAT)' WHERE SecCode = 78667 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78748 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81287 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 81438 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 81568 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81729 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 82108 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 82146 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 84719 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL WHERE SecCode = 89466 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 89467 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 90284 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 90297 AND Type_ = 10;
UPDATE data_universe SET Name = 'APOLLO SILVER CORP COM NEW', SecMapEndDate = '2079-06-06', endDate = '2025-09-13' WHERE SecCode = 90372 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2025-10-10' WHERE SecCode = 90958 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-10-15' WHERE SecCode = 90983 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 92577 AND Type_ = 1;
UPDATE data_universe SET Name = 'DPM METALS INC COM' WHERE SecCode = 93359 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q8506K14' WHERE SecCode = 95744 AND Type_ = 10;
UPDATE data_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 data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 97525 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'CEMPRO', PermIDTicker = 'CEMPRO', RkdRIC = 'CEMI.NS', RkdDisplayRIC = 'CEMI.NS' WHERE SecCode = 97785 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 99172 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 99460 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951823.0 WHERE SecCode = 99982 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-09-15' WHERE SecCode = 100312 AND Type_ = 1;
UPDATE data_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 data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 112954 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 116434 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 119591 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 126810 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 127092 AND Type_ = 10;
UPDATE data_universe SET Name = 'ADVANCED NANO TECH NPV DFD 13/10/17(EX-SPLT)' WHERE SecCode = 128181 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 135763 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 141836 AND Type_ = 10;
UPDATE data_universe SET Name = 'BEVERLY WILSHIRE NPV (POST-SPLT)' WHERE SecCode = 144934 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 194176 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE809Q01020', RkdSEDOL = 'BMYS0F', RkdCUSIP = 'Y271BT10', DsPrimQtSedol = 'BMYS0F8', PermSecMapEndDate = '2025-09-15', endDate = '2025-09-15' WHERE SecCode = 214104 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 252435 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 255424 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 258786 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 258792 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'FLNG.OL^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-16', SecMapEndDate = '2025-09-15', PermQuoteRetireDate = '2025-09-16', endDate = '2025-09-15' WHERE SecCode = 286050 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 293451 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA28619K2083', RkdSEDOL = 'BTZP33', RkdCUSIP = '28619K20', DsPrimQtSedol = 'BTZP336' WHERE SecCode = 294232 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 302310 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 302433 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 319114 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 320072 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 331648 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 1004365381.0 WHERE SecCode = 336707 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 345744 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 347012 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 376026 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 383497 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 391897 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 396138 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 450695 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 521135 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 535628 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 549234 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 550827 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'YUZHOU GROUP HOLDI HKD1' WHERE SecCode = 551335 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 558354 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 559630 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 692769 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 703064 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 767057 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 776068 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 839885 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BLINDATA LIMITED ORD EUR 0.01' WHERE SecCode = 844012 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 898133 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 918649 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 940672 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1082058 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1110147 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1209873 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1262130 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1270231 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1316139 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1382814 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21481777624.0, ExchCode = 'QMF', PermQuoteRetireDate = '2014-01-13', endDate = '2014-01-13' WHERE SecCode = 1453952 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BLIT', QuotePermID = 21482228292.0, ExchCode = 'STO', PermQuoteRetireDate = '2014-04-29' WHERE SecCode = 1456636 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1630431 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'SKYI.SI', RkdDisplayRIC = 'SKYI.SI' WHERE SecCode = 1631746 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1631904 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1643769 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1725334 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1997858 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2065778 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2152212 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GA8', DsPrimQtSedol = 'BVPGHD1' WHERE SecCode = 2255680 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2294759 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'TIGERLOGS', RkdRIC = 'TIGE.NS', RkdDisplayRIC = 'TIGE.NS', RkdExchCode = 'NSE' WHERE SecCode = 2349750 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2373426 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2025-08-25' WHERE SecCode = 2378956 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2461864 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2462091 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-08-21', PermSecMapEndDate = '2025-09-14', endDate = '2025-08-21' WHERE SecCode = 2483617 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2514702 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2529648 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2533380 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2563183 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GA8', DsPrimQtSedol = 'BVPGHD1' WHERE SecCode = 2800403 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL WHERE SecCode = 2832701 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2870124 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2928723 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2937551 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2947814 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2950178 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2959530 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2961761 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2974277 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3011192 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3018641 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3022438 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3037819 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3043688 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3044826 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3048457 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3049345 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3050876 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3051792 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3051797 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3064787 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3067181 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3087022 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3113761 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3133501 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3157196 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3160080 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3162862 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3172341 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3172415 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3177070 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3181407 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3184000 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3212151 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3213023 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3234669 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3242484 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3275685 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3283859 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3283969 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3285690 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3295160 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-09-09', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-15', endDate = '2025-09-09' WHERE SecCode = 3338654 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3347459 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3347763 AND Type_ = 10;
UPDATE data_universe SET Name = 'FONCIERE IMMOB TUN NPV' WHERE SecCode = 3349716 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3365085 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3368522 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3374472 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3375335 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3387570 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3392350 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3393831 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3395184 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3401731 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3401776 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3402856 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3407187 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3409783 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3435135 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3441470 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3445582 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3445583 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3504370 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3511850 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3520029 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3527769 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3559180 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3586927 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE467X01023' WHERE SecCode = 3587036 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3588090 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3593756 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3612339 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3651875 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3671059 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3745523 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3750914 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3773445 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3784691 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3799576 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3809775 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3827729 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3901291 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3919538 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3939942 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 3961773 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3972133 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3978268 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4041269 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4041320 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4046400 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4054122 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4054495 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4060785 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4081906 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4087371 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4220050 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4286258 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4307878 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4310593 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4313231 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4335862 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4339145 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4341610 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4377200 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4382912 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4421086 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4446112 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4456283 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4482176 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4550734 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4557733 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4561851 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4592043 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4603473 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4615772 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4615787 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4615941 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4616797 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4616827 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4620141 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4622018 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4638782 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4639757 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4716072 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4724707 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4724826 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4727655 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4728954 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4746790 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4786370 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4798499 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4800505 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4807668 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4893249 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4897803 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4940655 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4989476 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5025166 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5104594 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5122912 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5168288 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5223194 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5283335 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5316691 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5347334 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5367666 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5434330 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5440961 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5443484 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5500244 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5516786 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5535014 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5563070 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5610275 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5616087 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5658429 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5686490 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5804325 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5807642 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7750.TW', RkdDisplayRIC = '7750.TW', RkdExchCode = 'TPE', ExchCode = 'TAI' WHERE SecCode = 5807735 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5814581 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5820916 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5822373 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5839359 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5886911 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 5886937 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5981831 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5985400 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5987986 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5987988 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5988063 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5999070 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6018364 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6020925 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6082594 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6092920 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6114249 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6117162 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6128250 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6141555 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6159033 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6164287 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6203257 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6205869 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6205870 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6215205 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6220150 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6223905 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6253475 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6272209 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6285562 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6291854 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6297427 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6297438 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6301989 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6303031 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6310627 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6318878 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6318887 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6322343 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6336207 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6339507 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6339508 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6341752 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6347455 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951799.0 WHERE SecCode = 6351573 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6354184 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6354186 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6356123 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6361849 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6361850 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6361852 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6366713 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6389710 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6389714 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6396775 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6405360 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6414079 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6422982 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6434972 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6440004 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6440013 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6448554 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6449036 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6450902 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 10934016 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 10963618 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 10979389 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 10983013 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 10985917 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 10990193 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 100.0 WHERE SecCode = 11002303 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11002517 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11003868 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 11020243 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11031081 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11046194 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11143036 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11153770 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11158900 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11159154 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11165973 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11166433 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11169166 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11174613 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11176658 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11180458 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA0500591049', RkdSEDOL = 'BTZP31', RkdCUSIP = '05005910', DsPrimQtSedol = 'BTZP314' WHERE SecCode = 11181676 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11183295 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5096758753.0, PermOrgIPODate = '2018-03-23' WHERE SecCode = 11183359 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11186234 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11186810 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11192602 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11194907 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11203428 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11204795 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US9618843018', RkdSEDOL = 'BTZNZT', RkdCUSIP = '96188430', DsPrimQtSedol = 'BTZNZT0' WHERE SecCode = 11206889 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2025-09-12', PermSecMapEndDate = '2025-09-15', endDate = '2025-09-12' WHERE SecCode = 11208299 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11209243 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2025-09-12', PermSecMapEndDate = '2025-09-15', endDate = '2025-09-12' WHERE SecCode = 11209772 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11211492 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11214658 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11214925 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11226015 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11235400 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2022-06-20', startDate = '2022-06-20' WHERE SecCode = 11243073 AND Type_ = 1;
UPDATE data_universe SET Name = 'STRIVE INC CL A COM', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11249437 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11250261 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG982181114', RkdSEDOL = 'BTZNZL', RkdCUSIP = 'G9821811', DsPrimQtSedol = 'BTZNZL2' WHERE SecCode = 11251558 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FDXTF' WHERE SecCode = 11251873 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11256311 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11258687 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11258995 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11262695 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11265031 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11266729 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11267641 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11269373 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11272073 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11273643 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11275070 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11276362 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11276401 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11277132 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11277332 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11277553 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11277668 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11277924 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 11278193 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11278441 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11279414 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11279787 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11282049 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11282097 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11282117 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11282205 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11282219 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11284220 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11284225 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11284287 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11284441 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11284555 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11284951 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PVS.PR.U', QuotePermID = 236795699218.0, InstrPermID = 232898321106.0, OrgPermID = 4295860712.0, PriValQuotePermID = 236795699218.0, PriInstrPermID = 192818697641.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TOR', QuoteClass = 'PREFERRED', InstrClass = 'PREFERRED', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951362.0, PermOrgIPODate = '2015-10-29', PermSecMapStartDate = '2025-09-10', startDate = '2025-09-10' WHERE SecCode = 11285114 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11285141 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2025-09-11', startDate = '2025-09-11' WHERE SecCode = 11285148 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11285173 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2025-09-11', startDate = '2025-09-11' WHERE SecCode = 11285175 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11285177 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11285221 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'VIA', COATypeCode = '', QuotePermID = 236795698805.0, InstrPermID = 232895278183.0, OrgPermID = 5043315335.0, PriTrdQuotePermID = 236795698805.0, PriValQuotePermID = 25727062349.0, PriInstrPermID = 232895278183.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951205.0, PermOrgIPODate = '2025-09-12', PermSecMapStartDate = '2025-09-10', startDate = '2025-09-10' WHERE SecCode = 11285245 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '', PermOrgIPODate = '2025-09-12' WHERE SecCode = 11285254 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ONCH', ModelCntry = 'US', QuotePermID = 236795754566.0, InstrPermID = 232880117527.0, OrgPermID = 5095647428.0, PriTrdQuotePermID = 236795754566.0, PriValQuotePermID = 25727062090.0, PriInstrPermID = 232880117527.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2025-07-02', PermSecMapStartDate = '2025-09-11', startDate = '2025-07-02' WHERE SecCode = 11285255 AND Type_ = 1;
