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 RkdIssueOrder = 4 WHERE SecCode = 4537 AND Type_ = 1;
UPDATE data_universe_rkd SET ShPerListing = 33743217.0 WHERE SecCode = 7197 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 RkdIssueStatus = 1 WHERE SecCode = 10823 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 ISIN = 'US74738H4039', Ticker = 'QDMID', SEDOL = 'BSBK2T', CUSIP = '74738H40', RIC = 'QDMID.PK', DisplayRIC = 'QDMID.PK' WHERE SecCode = 18690 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 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 RkdIssueStatus = 0 WHERE SecCode = 27606 AND Type_ = 10;
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 RkdIssueStatus = 0, ISIN = 'US68235B2088', Ticker = NULL, CUSIP = '68235B20', RIC = 'TURN.OQ^I25', DisplayRIC = 'TURN.OQ' WHERE SecCode = 32562 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 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 ISIN = 'US9682353092', Ticker = 'WHLMD', CUSIP = '96823530', RIC = 'WHLMD.PK', DisplayRIC = 'WHLMD.PK' WHERE SecCode = 50157 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 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 RIC = 'DGRG.F', DisplayRIC = 'DGRG.F', RkdExchCode = 'FRA' WHERE SecCode = 59308 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 59316 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'MYTr.AT^I25' WHERE SecCode = 64418 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 RkdIssueStatus = 0, RIC = '1757.T^I25' WHERE SecCode = 69984 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 ISIN = 'INE305A01023', SEDOL = 'BVPGMZ' WHERE SecCode = 72200 AND Type_ = 10;
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 ISIN = 'AU0000419624', Ticker = 'GA8', SEDOL = 'BVPGHD', CUSIP = 'Q9118P22', RIC = 'GA8.AX', DisplayRIC = 'GA8.AX' WHERE SecCode = 74740 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 = 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 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 Ticker = 'ANTELOPUS', RIC = 'ANTL.NS', DisplayRIC = 'ANTL.NS' WHERE SecCode = 79139 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE768C01028', SEDOL = 'BMYS75', CUSIP = 'Y9896K11' WHERE SecCode = 79392 AND Type_ = 10;
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 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 ISIN = 'INE133B01027', SEDOL = 'BMVD3V', CUSIP = 'Y4S6DW13' WHERE SecCode = 86206 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 = 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 CUSIP = 'Q8506K14' WHERE SecCode = 95744 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'AU0000417149', Ticker = 'SOLDA', SEDOL = 'BT8NLQ', RIC = 'SOLDA.AX', DisplayRIC = 'SOLDA.AX' WHERE SecCode = 95997 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 96174 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'MNX.H', RIC = 'MNXh.V', DisplayRIC = 'MNXh.V', RkdExchCode = 'NEX' WHERE SecCode = 96381 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 97022 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CA98956J1066', SEDOL = 'BVN5M6', CUSIP = '98956J10' WHERE SecCode = 97479 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 97525 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'CEMPRO', RIC = 'CEMI.NS', DisplayRIC = 'CEMI.NS' WHERE SecCode = 97785 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'TRA.H', RIC = 'TRAh.V', DisplayRIC = 'TRAh.V', RkdExchCode = 'NEX' WHERE SecCode = 98247 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'WAGR.H', RIC = 'WAGRh.V', DisplayRIC = 'WAGRh.V', RkdExchCode = 'NEX' WHERE SecCode = 99087 AND Type_ = 1;
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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'NF.CD^I25' WHERE SecCode = 100742 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdCode = 17605, RkdIssueCode = 25193 WHERE SecCode = 100845 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'KEPr.AT^I25' WHERE SecCode = 102103 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'ALXIL', RIC = 'ALXIL.PA', DisplayRIC = 'ALXIL.PA' WHERE SecCode = 102258 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 104917 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'AU000000SYA5', Ticker = 'SYA', SEDOL = 'BBX4LR', CUSIP = 'Q8329N30', RIC = 'SYA.AX', DisplayRIC = 'SYA.AX' WHERE SecCode = 111747 AND Type_ = 10;
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 RkdIssueStatus = 0, RIC = 'ALCAP.PA^I25' WHERE SecCode = 116794 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 = 135763 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 137924 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'AU0000413502', Ticker = 'OB1DD', SEDOL = 'BTQM15', RIC = 'OB1DD.AX', DisplayRIC = 'OB1DD.AX' WHERE SecCode = 140027 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 RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 142851 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 PrimaryIssueType = 'PVT' WHERE SecCode = 153607 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 RkdIssueStatus = 0, RIC = 'MLEDU.EUA^I25' WHERE SecCode = 202318 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 210687 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'INE809Q01020', SEDOL = 'BMYS0F', CUSIP = 'Y271BT10' WHERE SecCode = 214104 AND Type_ = 10;
UPDATE data_universe_rkd SET DisplayRIC = 'MLCO.Z' WHERE SecCode = 224179 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 SEDOL = 'BH3T3L', RIC = 'FLNG.K', DisplayRIC = 'FLNG.N', RkdExchCode = 'NYSE', RkdExchCtry = 'USA' WHERE SecCode = 286050 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 293451 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA28619K2083', SEDOL = 'BTZP33', CUSIP = '28619K20' WHERE SecCode = 294232 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 301895 AND Type_ = 10;
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 Ticker = 'SBM.H', RIC = 'SBMh.V', DisplayRIC = 'SBMh.V', RkdExchCode = 'NEX' WHERE SecCode = 306578 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 Ticker = 'YDKG', RIC = 'YDKG.O', DisplayRIC = 'YDKG.OQ' WHERE SecCode = 331506 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, SEDOL = NULL, RIC = 'XIN.N^I25' WHERE SecCode = 334399 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 335017 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 345744 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 347012 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'RBLK', RIC = 'RBLK.PK', DisplayRIC = 'RBLK.PK' WHERE SecCode = 358137 AND Type_ = 1;
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 RIC = 'CRZK.F', DisplayRIC = 'CRZK.F', RkdExchCode = 'FRA' WHERE SecCode = 427461 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 = 535628 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE814H01029', SEDOL = 'BV2DVP' WHERE SecCode = 536728 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 549234 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 RkdIssueStatus = 0 WHERE SecCode = 557267 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 RIC = 'GRAK.BO', DisplayRIC = 'GRAK.BO' WHERE SecCode = 1175373 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1209873 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 COATypeCode = '' WHERE SecCode = 1485552 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1630431 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'SKYI.SI', DisplayRIC = 'SKYI.SI' WHERE SecCode = 1631746 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 = 1997858 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 RkdIssueStatus = 0, RIC = 'PHXM.PA^I25' WHERE SecCode = 2217733 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 RkdIssueStatus = 1 WHERE SecCode = 2295691 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = NULL, RIC = 'NAMA.DS^L24', PrimaryIssueType = 'PVT' WHERE SecCode = 2338207 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'TIGERLOGS', RIC = 'TIGE.NS', DisplayRIC = 'TIGE.NS', RkdExchCode = 'NSE' WHERE SecCode = 2349750 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 COATypeCode = '' WHERE SecCode = 2514702 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'BGLFF.PK^I25' WHERE SecCode = 2600077 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 RkdIssueStatus = 0, RIC = 'EFIDq.L^I25' WHERE SecCode = 2860623 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 RkdIssueStatus = 0, RIC = 'APAX.L^I25' WHERE SecCode = 2915745 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 = 2950178 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 = 3119749 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 = 3160080 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 RkdIssueStatus = 0 WHERE SecCode = 3266306 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 COATypeCode = '' WHERE SecCode = 3304243 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3306836 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'EWICAP', RIC = 'EWIC.KL', DisplayRIC = 'EWIC.KL' WHERE SecCode = 3319768 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 = 3375335 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 = 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 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 RkdIssueStatus = 0, Ticker = NULL, RIC = '2292.HK^I25' WHERE SecCode = 3429657 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 ISIN = 'INE467X01023', SEDOL = 'BV2FG0', CUSIP = 'Y7T16H10' WHERE SecCode = 3587036 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 RkdIssueStatus = 0, RIC = '3497.T^I25' WHERE SecCode = 3634457 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3648201 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 RkdIssueStatus = 0, RIC = 'ILTY.MI^I25' WHERE SecCode = 3779974 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 = 3919538 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 = 4041269 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4041320 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 RkdIssueStatus = 0, RIC = 'SPOT.OL^I25' WHERE SecCode = 4447189 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 RkdIssueStatus = 0, RIC = '7379.T^I25' WHERE SecCode = 4655498 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 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 = 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 RkdIssueStatus = 1, Ticker = 'XX10', SEDOL = NULL, RIC = 'XX10k.H', DisplayRIC = 'XX10k.H' WHERE SecCode = 5536057 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5563070 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 = 5648614 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 = 5804325 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5807642 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = '7750.TW', DisplayRIC = '7750.TW', RkdExchCode = 'TPE' WHERE SecCode = 5807735 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5808106 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5814581 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5820916 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5822373 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 = 5886911 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 5886937 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 5896458 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5958664 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 RkdIssueStatus = 1, RkdExchCode = 'BAK', RkdExchCtry = 'THA' WHERE SecCode = 6006780 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'BLAK.NS', DisplayRIC = 'BLAK.NS' WHERE SecCode = 6008774 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 6010815 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 = 6035207 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6069728 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6082594 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6092920 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6101737 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6112272 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 = 6128250 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6141555 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6153863 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6159033 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6164287 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6167085 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6203257 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6205869 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6205870 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6215204 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6215205 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6220150 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6223905 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6253475 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6265845 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6272209 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6285554 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6285562 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6291854 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6297427 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6297438 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6301989 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6303031 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6310627 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6318878 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6318887 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6322343 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6336207 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6339507 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6339508 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6341752 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6347455 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6354184 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6354186 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6356123 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6361849 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6361850 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6361852 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6366713 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6368633 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6389710 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6389714 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6396775 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6411862 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6414079 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6422982 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6434972 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6440004 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6440013 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE1DRH01011', Ticker = '544514', CUSIP = 'Y4S86M10', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 6443241 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6448554 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6449036 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6450902 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'M9563J10', COATypeCode = 'IND' WHERE SecCode = 6453919 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6460617 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 = 10817301 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 RIC = NULL WHERE SecCode = 10902320 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 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 ISIN = 'US80512Q5018' WHERE SecCode = 10925121 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10932226 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA73015G1046', SEDOL = 'BRJJYV', CUSIP = '73015G10' WHERE SecCode = 10933062 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 PrimaryIssueType = 'PVT' WHERE SecCode = 10968478 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10970730 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10971474 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 RkdIssueStatus = 0 WHERE SecCode = 10979586 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 ISIN = 'US63108T1051', Ticker = 'NASC', SEDOL = 'BVN5J7', CUSIP = '63108T10', RIC = 'NASC.PK', DisplayRIC = 'NASC.PK' WHERE SecCode = 10990101 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 ISIN = 'US8173234050', SEDOL = 'BVBHF9', CUSIP = '81732340', ShPerListing = 100.0 WHERE SecCode = 11002303 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 RIC = NULL WHERE SecCode = 11005855 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 Ticker = 'GROW.H', RIC = 'GROWh.V', DisplayRIC = 'GROWh.V', RkdExchCode = 'NEX' WHERE SecCode = 11024834 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11026044 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11027711 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11030477 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 ISIN = 'US62526P8775' WHERE SecCode = 11036554 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 PrimaryIssueType = 'PVT' WHERE SecCode = 11037077 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11037414 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US37954A3032', CUSIP = '37954A30' WHERE SecCode = 11037925 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 COATypeCode = '' WHERE SecCode = 11065309 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'SPP.H', RIC = 'SPPh.V', DisplayRIC = 'SPPh.V', RkdExchCode = 'NEX' WHERE SecCode = 11069199 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 RIC = NULL WHERE SecCode = 11136748 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 RIC = NULL WHERE SecCode = 11137813 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11141176 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 = 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 = 11171686 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 RIC = NULL, PrimaryIssueType = 'PVT' WHERE SecCode = 11174027 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 ISIN = 'CA0500591049', SEDOL = 'BTZP31', CUSIP = '05005910' WHERE SecCode = 11181676 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11183295 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11183746 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 = 'YMAB.OQ^I25' WHERE SecCode = 11189988 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 PrimaryIssueType = 'PVT' WHERE SecCode = 11196231 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11196721 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11197320 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11198674 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11200211 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'GDLC.K', DisplayRIC = 'GDLC.P', RkdExchCode = 'PAC' WHERE SecCode = 11201199 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 PrimaryIssueType = 'PVT' WHERE SecCode = 11203600 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 ISIN = 'US9618843018', SEDOL = 'BTZNZT', CUSIP = '96188430' WHERE SecCode = 11206889 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 = 11209995 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 PrimaryIssueType = 'PVT' WHERE SecCode = 11210480 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 ISIN = 'US04746L2034', SEDOL = 'BQT3G4', CUSIP = '04746L20' WHERE SecCode = 11212286 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11212657 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11213739 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11214658 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 PrimaryIssueType = 'PVT' WHERE SecCode = 11216802 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11217568 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11217686 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11217696 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11218134 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US9290332074', SEDOL = 'BRJJYT', CUSIP = '92903320' WHERE SecCode = 11218924 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'FAAS.OQ^I25' WHERE SecCode = 11229729 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 RkdIssueStatus = 1, Ticker = 'M0YA', SEDOL = 'BMFV5G', RIC = 'M0YAy.BE', DisplayRIC = 'M0YAy.BE', RkdExchCode = 'BER', RkdExchCtry = 'DEU', PrimaryIssueCode = NULL, RelType = NULL WHERE SecCode = 11234013 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11235392 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 RkdCode = 142993, RkdIssueCode = 182544, ISIN = NULL, CUSIP = NULL, RIC = 'ANGX.N', PrimaryIssueType = 'PVT', 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'HLVX.OQ^I25' WHERE SecCode = 11241414 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 = 11242467 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 RkdIssueStatus = 1 WHERE SecCode = 11243952 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US09076W3079', SEDOL = 'BRJJLZ', CUSIP = '09076W30' WHERE SecCode = 11244579 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'LUXHQ', RIC = 'LUXHQ.PK', DisplayRIC = 'LUXHQ.PK' WHERE SecCode = 11244678 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA87670N5010', SEDOL = 'BTZNZ8', CUSIP = '87670N50' WHERE SecCode = 11247040 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11247972 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US27877D2036', SEDOL = 'BQT3HR', CUSIP = '27877D20' WHERE SecCode = 11248018 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 ISIN = 'CA69639G1081', SEDOL = 'BPCR7M', CUSIP = '69639G10' WHERE SecCode = 11249518 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11250261 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'LSB.OQ' WHERE SecCode = 11250503 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA6438181076', CUSIP = '64381810' WHERE SecCode = 11251487 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'VGG982181114', SEDOL = 'BTZNZL', CUSIP = 'G9821811' WHERE SecCode = 11251558 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11251608 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA42804X3058', SEDOL = 'BQT3HL', CUSIP = '42804X30' WHERE SecCode = 11252776 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 Ticker = 'LUXPQ', RIC = 'LUXPQ.PK', DisplayRIC = 'LUXPQ.PK' WHERE SecCode = 11258091 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 Ticker = 'ZOG.X', RIC = 'ZOGx.CD', DisplayRIC = 'ZOGx.CD' WHERE SecCode = 11260136 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 RIC = NULL, PrimaryIssueType = 'PVT' WHERE SecCode = 11262355 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'NCLR.CD^I25' WHERE SecCode = 11263056 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 = 11267641 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'BGLFF.PK^I25' WHERE SecCode = 11270043 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 Ticker = 'IPST', DisplayRIC = 'IPST.OQ' WHERE SecCode = 11271912 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11272056 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 = 11273643 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 = 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 = 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 = 'IND' WHERE SecCode = 11276362 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 = 11276426 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 = 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 = 11277132 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 = 11277553 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 = 'IND' WHERE SecCode = 11277668 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 = 11277924 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11278067 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11278140 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11278293 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 = 'IND' WHERE SecCode = 11279414 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 = 11281175 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11281419 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11281693 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11282047 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11282049 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11282097 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11282117 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11282205 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11282219 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11284024 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11284220 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11284225 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11284287 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11284441 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 = 11284951 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11285141 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11285173 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11285177 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11285209 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11285212 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11285221 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11285245 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11285254 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11285257 AND Type_ = 1;