UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 915 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2587 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3050 AND Type_ = 1;
UPDATE data_universe_rkd SET ShPerListing = 33743217.0 WHERE SecCode = 7197 AND Type_ = 1;
UPDATE data_universe_rkd SET DisplayRIC = 'TFC.N' WHERE SecCode = 7536 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 9272 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 9703 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10006 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10136 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10439 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10793 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11092 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11732 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 12107 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 14165 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 14379 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 16015 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 16022 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 16055 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'BGMSP.PK', DisplayRIC = 'BGMSP.PK', RkdExchCode = 'OTC' WHERE SecCode = 18201 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 19108 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 22282 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 24076 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'EXAS.OQ^C26' WHERE SecCode = 24869 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 25196 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 25368 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 26804 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 27991 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 29818 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 30142 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 30628 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 30909 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 31119 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 32861 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 38313 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 39419 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 39873 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 40000 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'CRTD', RIC = 'CRTD.PK', DisplayRIC = 'CRTD.PK' WHERE SecCode = 40083 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 41247 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 41688 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 42414 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 42614 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 43217 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 44677 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 44692 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 45301 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 45664 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 47298 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 48372 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 48499 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 49225 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 49579 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 50053 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'NGD.TO^C26' WHERE SecCode = 50228 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 50591 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 50805 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 50967 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 52615 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 52970 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 53655 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 54040 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 54180 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 54388 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 54863 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 55903 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US7240782091', SEDOL = 'BVLNNN', CUSIP = '72407820' WHERE SecCode = 56167 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 56484 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 56762 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 57373 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 57506 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 58416 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 58466 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 59241 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 59316 AND Type_ = 1;
UPDATE data_universe_rkd SET DisplayRIC = 'SGRP.OQ' WHERE SecCode = 61660 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 61797 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 64039 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 66291 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 69272 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 69450 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 69910 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 69942 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 70022 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 70226 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 70294 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 70357 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 70676 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 72694 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 72737 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 73135 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 73536 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 74667 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdListingType = 'CCR', PrimaryIssueCode = 22316.0 WHERE SecCode = 74703 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '7635.T^C26' WHERE SecCode = 75052 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 75416 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 76075 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 76193 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 76802 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 77099 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 77615 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 77890 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 77898 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'GVND.BO^D25' WHERE SecCode = 78131 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 78902 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 78903 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 78905 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 81438 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 81567 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 81568 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 81793 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 82108 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 82146 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 82531 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 83677 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueOrder = 3 WHERE SecCode = 83798 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 84445 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 84719 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 86093 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 89534 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 90471 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 91901 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 92181 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 92577 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 93459 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 93815 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 94213 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 94745 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 94891 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 96174 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 97022 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 97525 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 99138 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 99172 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 99460 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueCode = 22316.0 WHERE SecCode = 99970 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 104917 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 115142 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 115317 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 119591 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 126810 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 127092 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 132080 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 132617 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 135763 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'SAPR.BO^C26' WHERE SecCode = 135942 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 137924 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 140289 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 140452 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 147145 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 148890 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 154473 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 166170 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 168907 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 193150 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 194176 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 198347 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 198374 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 210687 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 252435 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 255424 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 256670 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 258786 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 258792 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 262559 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 284598 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 284599 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 293451 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 302310 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 302433 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 302618 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 302998 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 306178 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 306179 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 306298 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 313606 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 313772 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 318120 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 323435 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 327002 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 331214 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 335017 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 347012 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 362349 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 365241 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 376026 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 377267 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 383497 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 391326 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 391714 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 396138 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 427273 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 450695 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 480218 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 480619 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 487092 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 487986 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 521135 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 524722 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 530192 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 550827 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 555775 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 557412 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 560498 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 568329 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 692769 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 703064 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 776068 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 787656 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 839885 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 898133 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 903681 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 918649 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 940672 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1024323 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1082058 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1110147 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1153561 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1237137 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1262054 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1262130 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1270231 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1316139 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1382814 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1401827 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1459071 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1462266 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1465090 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q0R81T11' WHERE SecCode = 1465316 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1485552 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1630431 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1631904 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1643769 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1725334 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1996255 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2065778 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2152212 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2153727 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2160634 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2245478 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2259306 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2294756 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2294759 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2373426 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2461864 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2462091 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2462651 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 2518693 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2523128 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2533380 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2563183 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2747631 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2822419 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2822514 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2848454 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2852515 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2866624 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2870124 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2883464 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2928714 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2928723 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2937551 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2947814 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2959530 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2961761 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2974277 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3011192 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3018641 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3022438 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3031568 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3032282 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3037819 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3044826 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3046333 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3048457 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3049345 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3050876 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3051792 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3051797 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3064787 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3067181 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3085532 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3087022 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3113761 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3127007 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3127082 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3133501 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3145978 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3157196 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3162862 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3172341 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3172415 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3177070 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3181407 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3184000 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3212151 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3213023 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3219471 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3222837 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3225973 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3226002 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3234669 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3242484 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3245594 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3255082 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3275685 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3283859 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3283969 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3283974 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3285690 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3295160 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q8655R25' WHERE SecCode = 3296401 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3304243 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueOrder = 2, RkdListingType = NULL, ISIN = 'BRPPLAUNT007', Ticker = 'PPLA11', SEDOL = 'BF2LP8', CUSIP = 'P7S0EN13', RIC = 'PPLA11.SA', DisplayRIC = 'PPLA11.SA', RkdExchCode = 'SAO', RkdExchCtry = 'BRA' WHERE SecCode = 3306808 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3306836 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3337337 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3339577 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3339666 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3347459 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3347763 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3353718 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3357855 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3365085 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3368522 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3374472 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3387570 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3392350 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3392371 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3393831 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3395184 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3395338 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3401731 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3401776 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3402856 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3403072 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3403339 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3406470 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3407187 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3409036 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'FUTE.NS^C26' WHERE SecCode = 3409197 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3409783 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3416760 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3427864 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3429138 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3429801 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3435135 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3436252 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3436905 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3439907 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3440960 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3441470 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3445582 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3445583 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3446987 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3511850 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3513954 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3519863 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3520029 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3527769 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3550496 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3559180 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3586927 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3588090 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3593756 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3612339 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3616263 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3619208 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3625884 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3634356 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3656302 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3658717 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3658723 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3658724 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3666898 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3743405 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3745523 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3750914 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3769450 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3773445 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3784691 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3796473 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3799576 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3809775 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3814220 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3827729 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3845935 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3854679 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3858210 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3885183 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3888346 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3894813 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3901291 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3901787 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3913168 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3921296 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3922207 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3939942 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3955673 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3956843 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3978268 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4018527 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4041277 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4041393 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4046400 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4054122 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4054495 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4060785 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4081906 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4087371 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4169144 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4220050 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4310593 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4313231 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4335862 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4335864 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4339145 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4341610 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4377200 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4382912 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4421086 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4425676 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4429520 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4429539 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4446112 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4449598 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4456283 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4482176 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4485806 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4501951 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4507736 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4524357 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4527808 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4539148 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4550734 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4555955 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4557733 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4557956 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4563452 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4592043 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4598562 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4603473 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4605811 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4615772 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4615787 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4615941 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4616797 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4616827 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4620141 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4620153 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4622018 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4632973 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4638782 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4639757 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4654588 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4671303 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4677597 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4695770 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4716072 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4724707 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4724826 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4727655 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4728954 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'BRAINP.CO^C26' WHERE SecCode = 4731832 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4746790 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4786370 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4800505 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4807668 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4819743 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4819883 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4838034 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4871157 AND Type_ = 10;
UPDATE data_universe_rkd SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4893249 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4897803 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4906498 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4940655 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4969554 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4989476 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5025166 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5106909 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5122912 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5147789 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5168288 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5210233 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5223194 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5283335 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5316691 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5346395 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5347334 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5349586 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5367666 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5401708 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5434330 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5440961 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5443484 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5448755 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5466047 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5500244 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5516786 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5535014 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5563070 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5601206 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5610275 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5616087 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5658429 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5686490 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5760059 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5765177 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5804325 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5808106 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5820916 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5821016 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5825605 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5839359 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5886907 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5900313 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5936391 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5958664 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5975843 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5981831 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5985400 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5987986 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5987988 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5988063 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5999070 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6018364 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6020925 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6026126 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6039879 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6043597 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6048000 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6069728 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6092920 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6101736 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6101737 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6114249 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6117162 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6160908 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6167085 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6198589 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6203038 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6203257 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6215204 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6220150 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6223908 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6265846 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6289734 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6300607 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6324115 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6347455 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6361850 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6389703 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6389710 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6400766 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6407335 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6448288 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6450911 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6482833 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6490057 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6538858 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6538865 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6558331 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6562448 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6562602 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6571970 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6577955 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6578038 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6589182 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6590752 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6593987 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6598936 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6601641 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6605884 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6610288 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6614114 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6622333 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6622350 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6626024 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6626814 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6627229 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6627674 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6628669 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6628819 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6629614 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6631798 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6631816 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6635227 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6635229 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6638309 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6643268 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6645649 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6645652 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6645655 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6649305 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6658285 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6664664 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6672539 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6674462 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6674464 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6685955 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6694374 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6702410 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6702411 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6705491 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6705492 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6705493 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6705695 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6708243 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6710146 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6712342 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6728349 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6728353 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10773666 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10776113 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10783551 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10783628 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10783724 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10798863 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10800033 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10814361 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10899823 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10899831 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10900869 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10907354 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10908266 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10911467 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10911886 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US92852R5028', Ticker = 'VIVKD', SEDOL = 'BWTQV1', CUSIP = '92852R50', RIC = 'VIVKD.PK', DisplayRIC = 'VIVKD.PK' WHERE SecCode = 10912673 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10914032 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10924211 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10924391 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10932226 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10934016 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10960378 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10963389 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10963618 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10963946 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10963962 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10964776 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10964824 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10965049 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10965051 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10965182 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10965183 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10965184 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10965185 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10965186 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10965187 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10965188 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10965189 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10965190 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10965382 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10965568 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10968280 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10970730 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10971743 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10972703 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10976281 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10976292 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10979389 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10980733 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10983013 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10983014 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10985576 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10985917 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10987199 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10987972 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10988827 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10990193 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10999172 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11000961 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11001180 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11002515 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11002517 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11003298 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11003868 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11014039 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11015528 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11015713 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11024269 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11026044 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11030477 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US35953D4016', SEDOL = 'BWTYSN', CUSIP = '35953D40' WHERE SecCode = 11030696 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11031081 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11034669 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11036726 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11037001 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11037414 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11038457 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11046194 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 11046663 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11065309 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11110934 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11112948 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11114317 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11128045 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11129272 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11131131 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11132316 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11133407 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11133409 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11133657 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11133689 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11136855 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11137610 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11141181 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11143036 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11144122 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11144505 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11148680 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11149797 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11150446 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11151427 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11152420 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11153770 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11153789 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11155129 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11155161 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11156209 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11156283 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11158862 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11158900 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11159154 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11161040 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11161920 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11162059 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11163845 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11165973 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11166037 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11166433 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11167485 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11169166 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11170265 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11172169 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11173200 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11173274 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11173381 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11174083 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11174134 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11174613 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11174852 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11175123 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11175126 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11175340 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11175357 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11176251 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11176658 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11177211 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11177220 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11178067 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11179498 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11180458 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11183295 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11183588 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11185058 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11186151 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11186234 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11186502 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11186503 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11186810 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11186849 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11186850 AND Type_ = 1;
UPDATE data_universe_rkd SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11188500 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11188830 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'RVR.CD^C26' WHERE SecCode = 11189384 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11191099 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11192602 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11194013 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11194016 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11194907 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11197320 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11199469 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11200211 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11201276 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11202576 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11203428 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11203817 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11204685 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11204795 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11206047 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11206107 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11208281 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11208759 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11209243 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11209688 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11209821 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11210201 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11210202 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11210745 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11211452 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11211492 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11212119 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11212657 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11214658 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11214660 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11214709 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11214798 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11214919 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11214925 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11216267 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11217568 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11218134 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'FNCHQ', RIC = 'FNCHQ.PK', DisplayRIC = 'FNCHQ.PK' WHERE SecCode = 11221126 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11221451 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11221452 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11221520 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11221547 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11221662 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11221979 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11222085 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11222497 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11223176 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11223640 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11224778 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11225170 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11226009 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11226015 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11228021 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11228090 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11228130 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11228241 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11228260 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11228280 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11228444 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11229110 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11230420 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11232373 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11232519 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11232769 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11235400 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11235431 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11237780 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11238153 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11239277 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11240148 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11240190 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11241346 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11241711 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11241791 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11241800 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11241801 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11241802 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11241834 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11241835 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11242497 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11242782 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11246941 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11248048 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11249093 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11250261 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11251608 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11252800 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11255338 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11256311 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11258687 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11258995 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11260763 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11261195 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11262000 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11262695 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11262783 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11262983 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11263217 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11264492 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11264556 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11265031 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11265092 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11265856 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11266641 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11266715 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11266729 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11267840 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11268452 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11269373 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11270448 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11270942 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11271747 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11272073 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11272516 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11273407 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11274257 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275070 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275402 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275440 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275611 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275629 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275703 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275779 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275780 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275781 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275783 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275785 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275786 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275787 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275831 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275832 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275835 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275836 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275837 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275911 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275930 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275931 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275932 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275934 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275936 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275937 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275938 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275939 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275940 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275978 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275979 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276063 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276064 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276066 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276069 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276120 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276121 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276124 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276191 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276193 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276226 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276230 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276271 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276327 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276330 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276349 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276352 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276366 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276367 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276368 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276370 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276371 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276401 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276402 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276424 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276426 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276433 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276434 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276572 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276573 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276574 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276575 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276670 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276758 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276824 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276827 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276828 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276853 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276854 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276855 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276856 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11276908 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11277070 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11277134 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11277137 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11277213 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11277214 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11277215 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11277217 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11277290 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11277332 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11277359 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11277556 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11277666 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11277667 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11277741 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11277826 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11278067 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueOrder = 1 WHERE SecCode = 11278125 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11278140 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11278216 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11278293 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11278313 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11278506 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11278680 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11278789 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11279698 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11279787 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11279824 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11279893 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11280387 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11280559 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11281175 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11284024 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11284498 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11284555 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11285716 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11285809 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11287103 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11287866 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11288510 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11289033 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11289225 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11289318 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11289387 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11289422 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11290387 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11290818 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11290984 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11290991 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11291071 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11291140 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11291142 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11291253 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11291346 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11291563 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11291582 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11291636 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11291637 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11291711 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11291746 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11291750 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11291832 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11291844 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11291898 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11291899 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11292176 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11292189 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11292229 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11292240 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11292424 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11292621 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11292838 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11292930 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11292932 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11292933 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11292967 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11293198 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11293243 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11293248 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11293292 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11293310 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11293311 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11293453 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11293479 AND Type_ = 1;