UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'DLE.I^I25' WHERE SecCode = 697 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 915 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US0030111118', SEDOL = 'BVBQPD', CUSIP = '00301111' WHERE SecCode = 1676 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA81222L2049', SEDOL = 'BV2JDQ', CUSIP = '81222L20' WHERE SecCode = 1679 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA9727531076', Ticker = 'WEC', SEDOL = 'BSNMLP', CUSIP = '97275310', RIC = 'WEC.V', DisplayRIC = 'WEC.V' WHERE SecCode = 2105 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'FVA', RIC = 'FVAF.L', DisplayRIC = 'FVAF.L' WHERE SecCode = 2412 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'US00808Y6041', SEDOL = 'BW5ZN1', CUSIP = '00808Y60' WHERE SecCode = 2459 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 RkdIssueStatus = 0, RIC = 'EUNZ.L^J25' WHERE SecCode = 4661 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'JIGI', RIC = 'JIGI.L', DisplayRIC = 'JIGI.L' WHERE SecCode = 5037 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'BNBX', RIC = 'BNBX.O', DisplayRIC = 'BNBX.OQ' WHERE SecCode = 6067 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'SPT.L^J25' WHERE SecCode = 6779 AND Type_ = 10;
UPDATE data_universe_rkd SET ShPerListing = 33743217.0 WHERE SecCode = 7197 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'HET.L^I25' WHERE SecCode = 7504 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'BPPTU.PK^J25' WHERE SecCode = 7743 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 8918 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'BGFV.OQ^J25' WHERE SecCode = 9228 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 9272 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'BSYI.PK^I25' WHERE SecCode = 9451 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 RkdIssueStatus = 0, RIC = 'RNO.L^J25' WHERE SecCode = 10008 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '32ID_p.L^J25' WHERE SecCode = 10010 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'RCDO.L^J25' WHERE SecCode = 10093 AND Type_ = 10;
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, PrimaryIssueType = 'PVT' WHERE SecCode = 10823 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 10910 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11092 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US98873Q2093', SEDOL = 'BR4ZY5', CUSIP = '98873Q20' WHERE SecCode = 11338 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11732 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US1312552003', SEDOL = 'BT22P8', CUSIP = '13125520' WHERE SecCode = 11807 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 12107 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 12628 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'US15130G8731', SEDOL = 'BVMS1Z', CUSIP = '15130G87' WHERE SecCode = 12961 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'CHN.N^J25' WHERE SecCode = 13991 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US2214113092', Ticker = 'COSGD', SEDOL = 'BMDJC8', CUSIP = '22141130', RIC = 'COSGD.PK', DisplayRIC = 'COSGD.PK' WHERE SecCode = 14026 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 Ticker = 'PRBG', RIC = 'PRBG.PK', DisplayRIC = 'PRBG.PK' WHERE SecCode = 17645 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RkdIssueOrder = 2, RkdListingType = NULL, Ticker = NULL, SEDOL = 'BVBFJH', RIC = 'WOLF.N^I25' WHERE SecCode = 17729 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US74738H4039', SEDOL = 'BSBK2T', CUSIP = '74738H40' WHERE SecCode = 18690 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 19108 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'ENFY.PK', DisplayRIC = 'ENFY.PK', RkdExchCode = 'OTC' WHERE SecCode = 20007 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US40251W5076', SEDOL = 'BV9F19', CUSIP = '40251W50' WHERE SecCode = 20092 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 22282 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'ENX.A^J25' WHERE SecCode = 22909 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'EVM.A^J25' WHERE SecCode = 22912 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'MIKP.PK^I25' WHERE SecCode = 23221 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'EMBJ', RIC = 'EMBJ', DisplayRIC = 'EMBJ.N' WHERE SecCode = 23541 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, RIC = 'BRFS3.SA^I25' WHERE SecCode = 27115 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'CRJI.PK^J25' WHERE SecCode = 27507 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 RIC = NULL WHERE SecCode = 28177 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'P6245715' WHERE SecCode = 29589 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'GEVI', RIC = 'GEVI.PK', DisplayRIC = 'GEVI.PK' WHERE SecCode = 29687 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'SECURITY.SN^J25' WHERE SecCode = 30576 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'PREVISION.SN^J25' WHERE SecCode = 30613 AND Type_ = 10;
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 ISIN = 'GB00BNKDVV71', SEDOL = 'BNKDVV', CUSIP = 'G5493R12' WHERE SecCode = 31464 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'GNTY.N^J25' WHERE SecCode = 31546 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 31963 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 31964 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 32373 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 32861 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'HAWEL.PK^J25' WHERE SecCode = 32905 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'AGRP.L^J25' WHERE SecCode = 33776 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CH1485899350', SEDOL = 'BTMRCG', CUSIP = 'H1181115' WHERE SecCode = 36418 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'CCRD.N^J25' WHERE SecCode = 36452 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'JERTQ.PK^I25' WHERE SecCode = 37852 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'JEQ.N^J25' WHERE SecCode = 38252 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 Ticker = 'KRFG', RIC = 'KRFG.PK', DisplayRIC = 'KRFG.PK' WHERE SecCode = 39727 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US2372452043', Ticker = 'DPLSD', SEDOL = 'BW2K9C', CUSIP = '23724520', RIC = 'DPLSD.PK', DisplayRIC = 'DPLSD.PK' WHERE SecCode = 39790 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 CUSIP = 'X5856011' WHERE SecCode = 42270 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'X5856010' WHERE SecCode = 42310 AND Type_ = 10;
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 ISIN = 'US5381463091', SEDOL = 'BVBQPK', CUSIP = '53814630' WHERE SecCode = 42719 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 43217 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'NHH.MC^I25' WHERE SecCode = 43286 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'FLYP.PA^J25' WHERE SecCode = 44329 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'DE000A40ZW05', Ticker = 'FEW0', SEDOL = 'BRBWSJ', CUSIP = 'D4529612', RIC = 'FEW0n.F', DisplayRIC = 'FEW0n.F' WHERE SecCode = 44550 AND Type_ = 10;
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 CUSIP = 'R8992310' WHERE SecCode = 45894 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'ITLI.PK^J25' WHERE SecCode = 45903 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'IT0005654683', SEDOL = 'BVMJYP', CUSIP = 'T4R68016' WHERE SecCode = 46376 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'VENDA.OL^J25' WHERE SecCode = 46631 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'BCBC', RIC = 'BCBC.PK', DisplayRIC = 'BCBC.PK' WHERE SecCode = 46758 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 Ticker = 'NAVBQ', RIC = 'NAVBQ.PK', DisplayRIC = 'NAVBQ.PK' WHERE SecCode = 49821 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 49878 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 50053 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US9682353092', SEDOL = 'BSDZ35', CUSIP = '96823530' WHERE SecCode = 50157 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 50591 AND Type_ = 1;
UPDATE data_universe_rkd SET ShPerListing = 1.0 WHERE SecCode = 50714 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 RIC = NULL WHERE SecCode = 51611 AND Type_ = 10;
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 RIC = 'VHC.O', DisplayRIC = 'VHC.OQ', RkdExchCode = 'NASD' WHERE SecCode = 53360 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'NGSG.NGM', DisplayRIC = 'NGSG.NGM', RkdExchCode = 'NGM' WHERE SecCode = 53514 AND Type_ = 10;
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 Ticker = 'PEGX', RIC = 'PEGX.PK', DisplayRIC = 'PEGX.PK' WHERE SecCode = 54760 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 54863 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'BRFS.N^I25' WHERE SecCode = 55088 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'PECN.PK^J25' WHERE SecCode = 55564 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'FIN' WHERE SecCode = 55755 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 55903 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'PHT.N^I25' WHERE SecCode = 56011 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'PHD.N^J25' WHERE SecCode = 56015 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'DUNYH.E', RIC = 'DUNYH.IS', DisplayRIC = 'DUNYH.IS' WHERE SecCode = 56148 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 56170 AND Type_ = 10;
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 ISIN = 'US18452H3057', SEDOL = 'BT68XJ', CUSIP = '18452H30' WHERE SecCode = 57481 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 57506 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'EIFG.DE', DisplayRIC = 'EIFG.DE', RkdExchCode = 'ETR' WHERE SecCode = 57533 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 57851 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'VVAGk.F^J25' WHERE SecCode = 58043 AND Type_ = 10;
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 RkdIssueStatus = 0, RIC = '9613.HA^J25' WHERE SecCode = 59951 AND Type_ = 10;
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 Ticker = 'PTHH', RIC = 'PTHH.DE', DisplayRIC = 'PTHH.DE', RkdExchCode = 'ETR' WHERE SecCode = 64428 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'ERC', RIC = 'ERC.AS', DisplayRIC = 'ERC.AS' WHERE SecCode = 64798 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'BIGTK.E', RIC = 'BIGTK.IS', DisplayRIC = 'BIGTK.IS' WHERE SecCode = 65376 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 66291 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 66514 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'M2512515' WHERE SecCode = 67358 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 67577 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q3482A10' WHERE SecCode = 67853 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'BMG0R33J2028', SEDOL = 'BRWFZX', CUSIP = 'G0R33J20' WHERE SecCode = 67883 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CA38074C1041', Ticker = 'GSR', SEDOL = 'BVZG6R', CUSIP = '38074C10', RIC = 'GSR.V', DisplayRIC = 'GSR.V' WHERE SecCode = 68072 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '6879.T^I25' WHERE SecCode = 68614 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'AU0000424921', Ticker = 'VMS', SEDOL = 'BW5SZ0', CUSIP = 'Q0604V18', RIC = 'VMS.AX', DisplayRIC = 'VMS.AX' WHERE SecCode = 68866 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q7747618' WHERE SecCode = 68875 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 RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 69916 AND Type_ = 10;
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 Ticker = 'ZUMA', RIC = 'ZUMA.PSX', DisplayRIC = 'ZUMA.PSX' WHERE SecCode = 70321 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'INHM.BO', DisplayRIC = 'INHM.BO' WHERE SecCode = 70347 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 70357 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'TMPV' WHERE SecCode = 70401 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q5571710' WHERE SecCode = 70501 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SCBS.PK^J25' WHERE SecCode = 70620 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 70676 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SPTN.OQ^I25' WHERE SecCode = 70919 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US29405E5050', SEDOL = 'BPYV2R', CUSIP = '29405E50' WHERE SecCode = 70929 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '2830.T^J25' WHERE SecCode = 71379 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'PIRA.NS^I25' WHERE SecCode = 71866 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE258A01024', SEDOL = 'BMD7MP', CUSIP = 'Y0881N15' WHERE SecCode = 72005 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'HMTR.NS^J25' WHERE SecCode = 72133 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE305A01023', SEDOL = 'BVPGMZ', CUSIP = 'Y8T97E11' 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 RIC = NULL WHERE SecCode = 72802 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 72855 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '7605.T^J25' WHERE SecCode = 72964 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'S7522U10' WHERE SecCode = 73049 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 73135 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'TEAC.BO', DisplayRIC = 'TEAC.BO' WHERE SecCode = 73181 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 73413 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 73536 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'AU0000428302', Ticker = 'CYMDE', SEDOL = 'BV3P4M', CUSIP = 'Q3R79Z24', RIC = 'CYMDE.AX', DisplayRIC = 'CYMDE.AX' WHERE SecCode = 73540 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'BMG2118J2052', SEDOL = 'BVZKGV', CUSIP = 'G2118J20' WHERE SecCode = 74285 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 74457 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'ELDAV.TA^I25' WHERE SecCode = 75258 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 75416 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SMURFIT.LG^J25' WHERE SecCode = 75483 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'RAKUNIT.LG^G24' WHERE SecCode = 75687 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdCode = 143136, RkdIssueCode = 182720, ISIN = 'KYG1156E1026', Ticker = 'BTTC', SEDOL = 'BVYL63', CUSIP = 'G1156E10', RIC = 'BTTC.O', DisplayRIC = 'BTTC.OQ', COATypeCode = '' WHERE SecCode = 75851 AND Type_ = 1;
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 ISIN = 'INE629B01032', SEDOL = 'BSNMGK', CUSIP = 'Y8166W14' WHERE SecCode = 78203 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 78656 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'BKW.AX^I25' WHERE SecCode = 78748 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 78902 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 78903 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 78905 AND Type_ = 1;
UPDATE data_universe_rkd SET 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 ISIN = 'BMG3394P4020', SEDOL = 'BSRJ2J', CUSIP = 'G3394P40' WHERE SecCode = 79747 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'JP3821300005', Ticker = '416A', SEDOL = 'BSRFNK', CUSIP = 'J1572G10', RIC = '416A.T', DisplayRIC = '416A.T' WHERE SecCode = 80309 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 81052 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 81438 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdCode = 6771, RkdIssueCode = 9073, RkdIssueStatus = 1, ISIN = 'US2011271077', Ticker = NULL, SEDOL = NULL, CUSIP = '20112710', RIC = 'CBGR.OB^G98', DisplayRIC = 'CBGR.OB', RkdExchCode = 'OTC', PrimaryIssueType = 'PVT' WHERE SecCode = 81543 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SQCF.PK^J25', 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 RkdIssueStatus = 0 WHERE SecCode = 82349 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 82350 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 82351 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 82352 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 82355 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'KYG8917X1473', SEDOL = 'BVBS1W', CUSIP = 'G8917X14' WHERE SecCode = 82370 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 82531 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '9377.T^I25' WHERE SecCode = 82838 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 83677 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '000627.SZ^I25' WHERE SecCode = 83694 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = '0812.HK^I25' WHERE SecCode = 83801 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 84445 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE672A01026', SEDOL = 'BW2FS5', CUSIP = 'Y8T33Y12' WHERE SecCode = 84503 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 84719 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '6973.T^J25' WHERE SecCode = 85934 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '010420.KS^I25' WHERE SecCode = 86007 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'PHIM.PSX^J25' WHERE SecCode = 86545 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y3230V11' WHERE SecCode = 86697 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'GREENTEC', RIC = 'GREE.KL', DisplayRIC = 'GREE.KL' WHERE SecCode = 86781 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'G4404S10' WHERE SecCode = 87058 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 87313 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = '0226.HK^I25' WHERE SecCode = 87347 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '2809.TW^J25' WHERE SecCode = 88710 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 89534 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 90031 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CA27580W1005', SEDOL = 'BT691S', CUSIP = '27580W10' WHERE SecCode = 90224 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '6411.T^J25' WHERE SecCode = 90236 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'ZAE000351946', SEDOL = 'BV2FFX', CUSIP = 'S5343512' WHERE SecCode = 90348 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 90471 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'AOT.H', RIC = 'AOTh.V', DisplayRIC = 'AOTh.V', RkdExchCode = 'NEX' WHERE SecCode = 90585 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '1884.T^J25' WHERE SecCode = 90958 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '9066.T^J25' WHERE SecCode = 90983 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CA0555031065', SEDOL = 'BV3PB4', CUSIP = '05550310' WHERE SecCode = 91065 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 91115 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'PRYM.TO^J25' WHERE SecCode = 91213 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'NEXGBINA', RIC = 'NEXI.KL', DisplayRIC = 'NEXI.KL' WHERE SecCode = 91350 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'M7S23S11' WHERE SecCode = 91514 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 91553 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 91660 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 91901 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y0S64711' WHERE SecCode = 92081 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CA81373W1086', SEDOL = 'BSNQCJ', CUSIP = '81373W10' WHERE SecCode = 92379 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 92577 AND Type_ = 1;
UPDATE data_universe_rkd SET CUSIP = 'Y2060S11' WHERE SecCode = 92811 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'TFM.H', RIC = 'TFMh.V', DisplayRIC = 'TFMh.V', RkdExchCode = 'NEX' WHERE SecCode = 92906 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 92978 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 93459 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'BMG4088X2064', SEDOL = 'BR4WBJ', CUSIP = 'G4088X20' WHERE SecCode = 93588 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'V9217910' WHERE SecCode = 93732 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'AU0000423741', Ticker = 'G1C', SEDOL = 'BT7MDF', CUSIP = 'Q8046613', RIC = 'G1C.AX', DisplayRIC = 'G1C.AX' WHERE SecCode = 93734 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CA50067K3082', SEDOL = 'BVMS5L', CUSIP = '50067K30' WHERE SecCode = 93743 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 93815 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '7451.T^I25' WHERE SecCode = 94005 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'FN.TO^J25' WHERE SecCode = 94018 AND Type_ = 1;
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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'MAC.V^J25' WHERE SecCode = 94981 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '005390.KS^I25' WHERE SecCode = 95444 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y7679418' WHERE SecCode = 95646 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueID = 2, RkdIssueCode = 182871, ISIN = 'CA57033N1006', Ticker = 'MAXQ', SEDOL = 'BNDV6L', CUSIP = '57033N10', RIC = 'MAXQ.NLB', DisplayRIC = 'MAXQ.NLB', RkdExchCode = 'NLB', PrimaryIssueType = 'EQU' WHERE SecCode = 95673 AND Type_ = 1;
UPDATE data_universe_rkd SET CUSIP = 'Q8506K14' WHERE SecCode = 95744 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 Ticker = 'MIT.H', RIC = 'MITh.V', DisplayRIC = 'MITh.V', RkdExchCode = 'NEX' WHERE SecCode = 96779 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 97022 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CA33944M4083', SEDOL = 'BVBFJL', CUSIP = '33944M40' WHERE SecCode = 97202 AND Type_ = 1;
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 RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 97693 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'SAF.H', RIC = 'SAFh.V', DisplayRIC = 'SAFh.V', RkdExchCode = 'NEX' WHERE SecCode = 97729 AND Type_ = 1;
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 ISIN = 'AU0000421893', Ticker = 'PL9', SEDOL = 'BVBLVK', CUSIP = 'Q4544E19', RIC = 'PL9.AX', DisplayRIC = 'PL9.AX' WHERE SecCode = 99030 AND Type_ = 10;
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 RkdCode = 142861, RkdIssueCode = 182364, ISIN = 'JP3831110006', Ticker = '417A', SEDOL = 'BSRFNL', CUSIP = 'J0447S10', RIC = '417A.T', DisplayRIC = '417A.T', COATypeCode = '' WHERE SecCode = 99138 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 99172 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 99460 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'HNL.DE', DisplayRIC = 'HNL.DE' WHERE SecCode = 99529 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CH1486524122', SEDOL = 'BV5CBN', CUSIP = 'H1955W10' WHERE SecCode = 99913 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 99982 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'THC.CD^I25' WHERE SecCode = 100097 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'TH.TO^I25' WHERE SecCode = 100099 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA8875228030', SEDOL = 'BR53T1', CUSIP = '88752280' WHERE SecCode = 100174 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA24344U1084', Ticker = 'WCSB', SEDOL = 'BTMJPK', CUSIP = '24344U10', RIC = 'WCSB.V', DisplayRIC = 'WCSB.V' WHERE SecCode = 100685 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 RIC = 'VQS.V', DisplayRIC = 'VQS.V', RkdExchCode = 'CVE' WHERE SecCode = 100758 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdCode = 17605, RkdIssueCode = 25193 WHERE SecCode = 100845 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'NO0013682948', SEDOL = 'BW2G21', CUSIP = 'R0R77L14' WHERE SecCode = 100974 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CA25384L1067', SEDOL = 'BR53S7', CUSIP = '25384L10' WHERE SecCode = 101013 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA83013Q8719', Ticker = 'CHAI', SEDOL = 'BTVM9R', CUSIP = '83013Q87', RIC = 'CHAI.O', DisplayRIC = 'CHAI.OQ' WHERE SecCode = 101238 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'LEOW', RIC = 'LEOW.F', DisplayRIC = 'LEOW.F' WHERE SecCode = 101252 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 Ticker = 'BLUME.E', RIC = 'BLUME.IS', DisplayRIC = 'BLUME.IS' WHERE SecCode = 103786 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'ALPAS', RIC = 'ALPAS.PA', DisplayRIC = 'ALPAS.PA' WHERE SecCode = 103908 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'VXT', RIC = 'VXT.DE', DisplayRIC = 'VXT.DE' WHERE SecCode = 104532 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 104917 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'TH0753C10Z00', SEDOL = 'BV4GM6', CUSIP = 'Y973BL11' WHERE SecCode = 104987 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'J0562G10' WHERE SecCode = 105156 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'A531', SEDOL = 'BJ4TMM', RIC = 'A531.F', DisplayRIC = 'A531.F', RkdExchCode = 'FRA', RkdExchCtry = 'DEU' WHERE SecCode = 110311 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '3319.T^I25' WHERE SecCode = 111297 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'WNS.N^J25' WHERE SecCode = 111453 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'CLBX', RIC = 'CLBX.L', DisplayRIC = 'CLBX.L' WHERE SecCode = 111573 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'AU0000421851', Ticker = 'ELV', SEDOL = 'BVBM1M', CUSIP = 'Q8329N32', RIC = 'ELV.AX', DisplayRIC = 'ELV.AX' WHERE SecCode = 111747 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'VTL.NZ^J25' WHERE SecCode = 112939 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'IDL.CM^J25' WHERE SecCode = 114541 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 115142 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'G2581C20' WHERE SecCode = 115240 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 115317 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'GB00BVMTNR93', SEDOL = 'BVMTNR', CUSIP = 'G6953A10' WHERE SecCode = 115574 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE953E01022', SEDOL = 'BV5CVM', CUSIP = 'Y4747N12' WHERE SecCode = 115611 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 116736 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 RkdIssueStatus = 0 WHERE SecCode = 117720 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 119591 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'AU0000CSEAK0', RIC = 'IPO-EQU.AX', DisplayRIC = 'IPO-EQU.AX', PrimaryIssueType = 'IPO' WHERE SecCode = 122937 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE081B01028', SEDOL = 'BVLK8H', CUSIP = 'Y1122J13' WHERE SecCode = 126259 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 126493 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 126810 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'NSX.AX^J25' WHERE SecCode = 126884 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 127092 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'VGL', RIC = 'VARV.NS', DisplayRIC = 'VARV.NS' WHERE SecCode = 128522 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE235C01036', SEDOL = 'BSSB6S', CUSIP = 'Y8186R20' WHERE SecCode = 130714 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y9315R13' WHERE SecCode = 132389 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '3770.T^J25' WHERE SecCode = 133501 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 135763 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y1R95110' WHERE SecCode = 136512 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'MASA.JK^J25' WHERE SecCode = 137441 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 137924 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'MFIN.JK^J25' WHERE SecCode = 140273 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 = 0, RIC = 'PFC.L^J25' WHERE SecCode = 140947 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'AU0000420739', Ticker = 'CQT', SEDOL = 'BSSB50', CUSIP = 'Q2096E23', RIC = 'CQT.AX', DisplayRIC = 'CQT.AX' WHERE SecCode = 141616 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE331C01025', SEDOL = 'BRBN4T', CUSIP = 'Y9544910' WHERE SecCode = 142568 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'SYSTMTXC', RIC = 'SYCS.NS', DisplayRIC = 'SYCS.NS', RkdExchCode = 'NSE' WHERE SecCode = 142574 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 142701 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 142851 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'X3071C10' WHERE SecCode = 144706 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE111F01024', SEDOL = 'BVLK82', CUSIP = 'Y6793G14' WHERE SecCode = 145481 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'GOR.AX^J25' WHERE SecCode = 145658 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q1R39C12' WHERE SecCode = 146019 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'E2NG.MU^J25' WHERE SecCode = 146206 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'SE0026821373', SEDOL = 'BTNNQ9', CUSIP = 'W5766839' WHERE SecCode = 146237 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 146722 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'MCT_p.L^J25' WHERE SecCode = 146794 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '091090.KS^J25' WHERE SecCode = 147135 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 147145 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'FHB', RIC = 'FHBP.WA', DisplayRIC = 'FHBP.WA' WHERE SecCode = 147359 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 148890 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 154473 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'PEK.AX^J25' WHERE SecCode = 163971 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'TH0922B10Z07', SEDOL = 'BTWQMB', CUSIP = 'Y709KB15' WHERE SecCode = 165534 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 166170 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'FCCT.PK^J25', COATypeCode = '' WHERE SecCode = 168907 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'WHCA.PK^I25' WHERE SecCode = 180517 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 193150 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'US92548W2044', Ticker = 'LAAI', SEDOL = 'BV8CKZ', CUSIP = '92548W20', RIC = 'LAAI.PK', DisplayRIC = 'LAAI.PK' WHERE SecCode = 193821 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 194176 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, ISIN = 'TW0006604002', CUSIP = 'Y447LP10', RIC = '6604.TWO' WHERE SecCode = 197345 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 ISIN = 'AU0000425027', Ticker = 'LIB', SEDOL = 'BW5SZ8', CUSIP = 'Q9173526', RIC = 'LIB.AX', DisplayRIC = 'LIB.AX' WHERE SecCode = 200828 AND Type_ = 10;
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 ISIN = 'CA15643T7015', SEDOL = 'BMGDMF', CUSIP = '15643T70' WHERE SecCode = 226964 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US7583384042', Ticker = 'REEDD', CUSIP = '75833840', RIC = 'REEDD.PK', DisplayRIC = 'REEDD.PK' WHERE SecCode = 232761 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA1689301135', SEDOL = 'BTMJQB', CUSIP = '16893011' WHERE SecCode = 236801 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 RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 255617 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 Ticker = 'QCLS', RIC = 'QCLS.O', DisplayRIC = 'QCLS.OQ' WHERE SecCode = 270236 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'TRUE', RIC = 'TRUET.L', DisplayRIC = 'TRUET.L' WHERE SecCode = 277134 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SNDZ.PK^I25' WHERE SecCode = 278022 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 CUSIP = 'Q3106631' WHERE SecCode = 285238 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueCode = 62508.0 WHERE SecCode = 285430 AND Type_ = 10;
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 ISIN = 'CA98144X1087', SEDOL = 'BSLN7G', CUSIP = '98144X10' WHERE SecCode = 291245 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 291736 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'AU0000423501', Ticker = 'L1G', SEDOL = 'BSPVFM', CUSIP = 'Q7587R11', RIC = 'L1G.AX', DisplayRIC = 'L1G.AX' WHERE SecCode = 292778 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 = 0, RIC = 'HNGI.NS^I25' WHERE SecCode = 294471 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'IVXG.H^J25' WHERE SecCode = 294573 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'COSM.SI^I25' WHERE SecCode = 298972 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'XTC.AX^J25' WHERE SecCode = 300997 AND Type_ = 10;
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 ISIN = 'BRMBRFACNOR1', Ticker = 'MBRF3', SEDOL = 'BV8H6L', CUSIP = 'P6438618', RIC = 'MBRF3.SA', DisplayRIC = 'MBRF3.SA' WHERE SecCode = 302757 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 302998 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'AIMV', RIC = 'AIMV.PK', DisplayRIC = 'AIMV.PK' WHERE SecCode = 303050 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 304471 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'HNW.A^I25' WHERE SecCode = 304979 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'FCCTP.PK^J25', COATypeCode = '' WHERE SecCode = 306178 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'FCCTO.PK^J25', COATypeCode = '' WHERE SecCode = 306179 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 306298 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SSL.TO^J25' WHERE SecCode = 306523 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 CUSIP = 'P149AC58' WHERE SecCode = 311175 AND Type_ = 10;
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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'VSRV.PK^J25' WHERE SecCode = 313863 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'SRVL', RIC = 'SRVL.ASE', DisplayRIC = 'SRVL.ASE' WHERE SecCode = 317701 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 318120 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA48730E1051', SEDOL = 'BSNMLL', CUSIP = '48730E10' WHERE SecCode = 321708 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 323435 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueCode = 65625.0 WHERE SecCode = 324866 AND Type_ = 10;
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 RIC = 'FPAY.PK', DisplayRIC = 'FPAY.PK', RkdExchCode = 'OTC' WHERE SecCode = 331706 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 Ticker = 'HWNI', RIC = 'HWNI.PK', DisplayRIC = 'HWNI.PK' WHERE SecCode = 334898 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 335017 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'TAAG', RIC = 'TAAG.PK', DisplayRIC = 'TAAG.PK' WHERE SecCode = 336133 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'DALN.OQ^I25' WHERE SecCode = 336183 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'PCYS.PK^J25' WHERE SecCode = 338975 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'STBP3.SA^J25' WHERE SecCode = 344370 AND Type_ = 10;
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 RIC = NULL WHERE SecCode = 347852 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US60841T4004', Ticker = 'MOJOD', SEDOL = 'BPYS42', CUSIP = '60841T40', RIC = 'MOJOD.PK', DisplayRIC = 'MOJOD.PK' WHERE SecCode = 348147 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US7054842023', SEDOL = 'BTLP26', CUSIP = '70548420' WHERE SecCode = 351030 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'RBLK', RIC = 'RBLK.PK', DisplayRIC = 'RBLK.PK' WHERE SecCode = 358137 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA75974M2040', SEDOL = 'BVPWD0', CUSIP = '75974M20' WHERE SecCode = 361480 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 362349 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 362805 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 365241 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'ETHY', RIC = 'ETHY.ASE', DisplayRIC = 'ETHY.ASE' WHERE SecCode = 370942 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 376026 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'DHAE.NS^J25' WHERE SecCode = 376433 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 RkdIssueStatus = 1, RIC = 'BLIN.BO' WHERE SecCode = 385733 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'FINKURVE', RIC = 'FINK.NS', DisplayRIC = 'FINK.NS', RkdExchCode = 'NSE' WHERE SecCode = 387505 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 CUSIP = 'M8T23S11' WHERE SecCode = 396044 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 396138 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'HLHL.SI^I25' WHERE SecCode = 415865 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'M9895F15' WHERE SecCode = 416435 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 CUSIP = 'Y0337319' WHERE SecCode = 483868 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 CUSIP = 'P5799112' WHERE SecCode = 519382 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 521135 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'AIPC1', RIC = 'AIPC1.LM', DisplayRIC = 'AIPC1.LM' WHERE SecCode = 521900 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', CUSIP = 'Y0R13015' WHERE SecCode = 536728 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y9003510' WHERE SecCode = 548535 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 ISIN = 'KYG9884A1022', SEDOL = 'BRJNVN', CUSIP = 'G9884A10' WHERE SecCode = 551335 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q2156M20' WHERE SecCode = 553964 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 RkdIssueStatus = 0, Ticker = NULL, RIC = '8270.SE^J25' WHERE SecCode = 564815 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'VTL.HNO^J25' WHERE SecCode = 567568 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 568329 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'G4742410' WHERE SecCode = 582997 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'VE.MI^I25' WHERE SecCode = 586040 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'HDO.HNO^J25' WHERE SecCode = 586491 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y2R9FE11' WHERE SecCode = 586513 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y6586P11' WHERE SecCode = 606162 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 Ticker = 'nzhs', CUSIP = 'X5S9AN11' WHERE SecCode = 703224 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'X0R8BD11' WHERE SecCode = 703235 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'X0R3H712' WHERE SecCode = 703382 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'G989MR10' WHERE SecCode = 717246 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'RNEW11.SA^I25' WHERE SecCode = 774326 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'S27.HNO^J25' WHERE SecCode = 817726 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 839885 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'BMG2157U2281', SEDOL = 'BNVY7Y', CUSIP = 'G2157U22' WHERE SecCode = 843986 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'SYNEXO', RIC = 'SYNEXO.NGM', DisplayRIC = 'SYNEXO.NGM' WHERE SecCode = 868742 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y3R17R10' WHERE SecCode = 890632 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 ISIN = 'INE045J01034', SEDOL = 'BMDJ6L' WHERE SecCode = 1024298 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1024323 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'AO1.AX^J25' WHERE SecCode = 1026391 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'NOVKAN', RIC = 'NOVKAN.ST', DisplayRIC = 'NOVKAN.ST' WHERE SecCode = 1030653 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 CUSIP = 'G3954WAB' WHERE SecCode = 1128325 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 1153320 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 RIC = 'SRSO.BO', DisplayRIC = 'SRSO.BO' WHERE SecCode = 1204795 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1209873 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q6250E10' WHERE SecCode = 1222836 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 ISIN = 'NO0013683409', SEDOL = 'BW5T1V', CUSIP = 'R5S38812' WHERE SecCode = 1458933 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 Ticker = 'INSEl', SEDOL = NULL, RIC = 'INSEl.BCO', DisplayRIC = 'INSEl.BCO' WHERE SecCode = 1472965 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y8T1GK11' WHERE SecCode = 1474972 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'GB00BV2FG348', SEDOL = 'BV2FG3', CUSIP = 'G1R33C10' WHERE SecCode = 1478297 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '300280.SZ^J25' WHERE SecCode = 1482575 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1485552 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 1487633 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'V5704U10' WHERE SecCode = 1598739 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 CUSIP = 'X0R3H713' WHERE SecCode = 1631795 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1631904 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'M7S38D11' WHERE SecCode = 1635419 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1643769 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q5376717' WHERE SecCode = 1664403 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SMC2A.PS^J25' WHERE SecCode = 1699052 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueID = 9, RkdIssueCode = 143276, RkdIssueOrder = 2 WHERE SecCode = 1699053 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SMC2C.PS^J25' WHERE SecCode = 1699054 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1725334 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'VGG7223M1187', SEDOL = 'BNVY1J', CUSIP = 'G7223M11' WHERE SecCode = 1981169 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 CUSIP = 'Y613HU11' WHERE SecCode = 2005913 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'W8T14Q30' WHERE SecCode = 2044711 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'ASPM.CM^J25' WHERE SecCode = 2229093 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y1780H12' WHERE SecCode = 2232795 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 CUSIP = 'M2R38B11' WHERE SecCode = 2285159 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'blrep', CUSIP = 'X7T73S11' WHERE SecCode = 2289271 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, PrimaryIssueType = 'PVT' WHERE SecCode = 2295691 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'KRIS.SI^J25' WHERE SecCode = 2298762 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 ISIN = 'INE428B01021', SEDOL = 'BRVVXC', CUSIP = 'Y7S66M13' WHERE SecCode = 2380633 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'GG00BSNRFW06', SEDOL = 'BSNRFW', CUSIP = 'G4196W24' WHERE SecCode = 2382443 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 2399379 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'N3R93N14' WHERE SecCode = 2400932 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'PGH.AX^G25' WHERE SecCode = 2440002 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 Ticker = 'SCHLR', RIC = 'SCHLR.MC', DisplayRIC = 'SCHLR.MC', PrimaryIssueType = 'PVT' WHERE SecCode = 2515727 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'MODI.TE^J25' WHERE SecCode = 2526047 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 2529065 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2533380 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'IT0005654766', SEDOL = 'BSY6DM', CUSIP = 'T3R4KC12' WHERE SecCode = 2555896 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2563183 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '6095.T^J25' WHERE SecCode = 2566806 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'MONEYBOXX', RIC = 'MONB.NS', DisplayRIC = 'MONB.NS', RkdExchCode = 'NSE' WHERE SecCode = 2574393 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'YMEI.MC^J25' WHERE SecCode = 2586429 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'FRHO.SI^J25' WHERE SecCode = 2586521 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'PPFu.BK^J25' WHERE SecCode = 2587923 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 RkdIssueStatus = 0, RIC = 'RXH.AX^J25' WHERE SecCode = 2626282 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'KYG644671227', SEDOL = 'BW5S92', CUSIP = 'G6446712' WHERE SecCode = 2633144 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q9225J10' WHERE SecCode = 2688181 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '6026.T^I25' WHERE SecCode = 2693648 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'V3558510' WHERE SecCode = 2694699 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 ISIN = 'INE976R01033', SEDOL = 'BW2FZ3', CUSIP = 'Y0R7Y314' WHERE SecCode = 2854268 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 RkdIssueStatus = 0, RIC = '6048.T^I25' WHERE SecCode = 2864442 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 ISIN = 'FI4000592282', SEDOL = 'BSRJ2K', CUSIP = 'X869A610' WHERE SecCode = 2880948 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2883464 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'VEND', RIC = 'VEND.OL', DisplayRIC = 'VEND.OL' WHERE SecCode = 2907935 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'AMPLI.PA^J25' WHERE SecCode = 2915023 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 PrimaryIssueCode = 103321.0 WHERE SecCode = 2918009 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 Ticker = 'TRA', RIC = 'TRA.MC', DisplayRIC = 'TRA.MC' WHERE SecCode = 2946507 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2947814 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 2950178 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'OEC', RIC = 'OEC.MI', DisplayRIC = 'OEC.MI' WHERE SecCode = 2952368 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'G7321A10' WHERE SecCode = 2953268 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'AHI.AX^J25' WHERE SecCode = 2956426 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 ISIN = 'INE671K01027', SEDOL = 'BS81L2', CUSIP = 'Y8303M10' WHERE SecCode = 2963532 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2974277 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SMC2D.PS^J25' WHERE SecCode = 2975899 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE060D01028', SEDOL = 'BS81KZ', CUSIP = 'Y6208H13' WHERE SecCode = 3007957 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3011192 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'AXX', RIC = 'AXXJ.J', DisplayRIC = 'AXXJ.J' WHERE SecCode = 3011222 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 CUSIP = 'Y0928N13' WHERE SecCode = 3048286 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 CUSIP = 'Q0R44310' WHERE SecCode = 3076057 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'SE0026598583', SEDOL = 'BRBFS7', CUSIP = 'W989B021' WHERE SecCode = 3084587 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 ISIN = 'INE314T01033', SEDOL = 'BVZG2V', CUSIP = 'Y2740H15' WHERE SecCode = 3109824 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3113761 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'VOPE.CY^L23' WHERE SecCode = 3128125 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 RkdIssueStatus = 0, RIC = 'RESURS.ST^J25' WHERE SecCode = 3155966 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueCode = 108321.0 WHERE SecCode = 3156046 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 RkdIssueStatus = 0, RIC = 'BRANDB.NGM^I25', COATypeCode = '' WHERE SecCode = 3184000 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 3200563 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'IGLD', RIC = 'IGLD.L', DisplayRIC = 'IGLD.L' WHERE SecCode = 3200664 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 RkdIssueStatus = 0, RIC = 'PROC.SI^I25' WHERE SecCode = 3213375 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 ISIN = 'AU0000426512', Ticker = 'RIV', SEDOL = 'BRBFKZ', CUSIP = 'Q3315S19', RIC = 'RIV.AX', DisplayRIC = 'RIV.AX' WHERE SecCode = 3225986 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 RkdIssueStatus = 0 WHERE SecCode = 3247487 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3255082 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'NO0013647693', SEDOL = 'BSS92R', CUSIP = 'R2R66P10' WHERE SecCode = 3266303 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 CUSIP = 'Y2R5FP10' WHERE SecCode = 3317783 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'YAPS.MC^J25' WHERE SecCode = 3318353 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 Ticker = 'ONCIN', RIC = 'ONCIN.OL', DisplayRIC = 'ONCIN.OL' WHERE SecCode = 3320156 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'AU0000421117', Ticker = 'XRA', SEDOL = 'BSSB62', CUSIP = 'Q9093A18', RIC = 'XRA.AX', DisplayRIC = 'XRA.AX' WHERE SecCode = 3320330 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueCode = 103599.0 WHERE SecCode = 3327053 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 CUSIP = 'G3392H10' WHERE SecCode = 3370825 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 ISIN = 'KYG942971766', SEDOL = 'BV2DWC', CUSIP = 'G9429717' WHERE SecCode = 3377999 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'ENRAD.NGM', DisplayRIC = 'ENRAD.NGM', RkdExchCode = 'NGM' WHERE SecCode = 3378737 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3387570 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 3392104 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 RkdIssueStatus = 0, RIC = 'WHRW.L^J25' WHERE SecCode = 3394302 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'VTAG', RIC = 'VTAG.DE', DisplayRIC = 'VTAG.DE' WHERE SecCode = 3394982 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 Ticker = 'WORTHPERI' WHERE SecCode = 3396329 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE219Y01026', SEDOL = 'BSSB6X', CUSIP = 'Y7S04D13' WHERE SecCode = 3396332 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE947T01022', SEDOL = 'BNNRXK', CUSIP = 'Y2R2TT13' WHERE SecCode = 3396342 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE669X01032', SEDOL = 'BVLCVQ' WHERE SecCode = 3396367 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'JLG.AX^J25' WHERE SecCode = 3400256 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = '9876', RIC = '9876.HK', DisplayRIC = '9876.HK' WHERE SecCode = 3400257 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 RIC = '9388.FU', DisplayRIC = '9388.FU', RkdExchCode = 'FUK' WHERE SecCode = 3402118 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 PrimaryIssueCode = 114558.0 WHERE SecCode = 3403629 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 RkdIssueStatus = 0, RIC = 'CWX.AX^J25' WHERE SecCode = 3408003 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3409036 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'TOPR.NGM^J25' WHERE SecCode = 3409194 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3409783 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'AYOJ.J^J25' WHERE SecCode = 3409784 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 Ticker = 'TSFINV', RIC = 'TSFI.NS', DisplayRIC = 'TSFI.NS' WHERE SecCode = 3441472 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 Ticker = 'AURIGROW', RIC = 'AURR.NS', DisplayRIC = 'AURR.NS' WHERE SecCode = 3495863 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 RkdIssueStatus = 0, RIC = 'VN8.AX^J25' WHERE SecCode = 3518226 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 RkdIssueStatus = 0, RIC = 'ANXA.L^I25' WHERE SecCode = 3526140 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3527769 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 3537017 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 Ticker = 'ALWIN', RIC = 'ALWIN.PA', DisplayRIC = 'ALWIN.PA' WHERE SecCode = 3561597 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '2750.TWO^I25' WHERE SecCode = 3571379 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'KYG3962W1107', SEDOL = 'BSRJ36', CUSIP = 'G3962W11' WHERE SecCode = 3582243 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 RIC = '9275.T^I25', PrimaryIssueType = 'PVT' WHERE SecCode = 3593745 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 RkdIssueStatus = 0, Ticker = NULL, RIC = '1034.HK^J25' WHERE SecCode = 3642396 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 3648201 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q2074C10', 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 CUSIP = 'V0192K10' WHERE SecCode = 3741443 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 Ticker = 'SIN', RIC = 'SINO.TE', DisplayRIC = 'SINO.TE' WHERE SecCode = 3818090 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3827729 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = '2060.HK^J25' WHERE SecCode = 3845929 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 ISIN = 'INE00YB01025', SEDOL = 'BS81L4', CUSIP = 'Y0R1EJ15' WHERE SecCode = 3883663 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3885183 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'YHTI', RIC = 'YHTI.MC', DisplayRIC = 'YHTI.MC' WHERE SecCode = 3885199 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 ISIN = 'GB00BQYLVW97', SEDOL = 'BQYLVW', CUSIP = 'G6355D11' WHERE SecCode = 3906622 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'HANGJI.CY^I25' WHERE SecCode = 3948975 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 Ticker = 'DFH', RIC = 'DFHP.WA', DisplayRIC = 'DFHP.WA' WHERE SecCode = 3986680 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4018527 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000076Q6' WHERE SecCode = 4026038 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 4029417 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000076R4' WHERE SecCode = 4033055 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000076S2' WHERE SecCode = 4034112 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 4038316 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000076V6' WHERE SecCode = 4040150 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000076T0' WHERE SecCode = 4040153 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 ISIN = 'CNE1000076W4' WHERE SecCode = 4054127 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000076X2' WHERE SecCode = 4054381 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 RkdIssueStatus = 0 WHERE SecCode = 4109394 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000076Y0' WHERE SecCode = 4129798 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000076Z7' WHERE SecCode = 4163629 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007705' WHERE SecCode = 4168437 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4169144 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007713' WHERE SecCode = 4178606 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007721' WHERE SecCode = 4178864 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4220050 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueCode = 124389.0 WHERE SecCode = 4259228 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'SPGS', RIC = 'SPGS.TA', DisplayRIC = 'SPGS.TA' WHERE SecCode = 4272418 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 RkdIssueStatus = 0, RIC = 'BWE.AX^J25' WHERE SecCode = 4317547 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'NTC.HM', DisplayRIC = 'NTC.HM', RkdExchCode = 'HCM' WHERE SecCode = 4333240 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4335862 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y238AN10', COATypeCode = '' WHERE SecCode = 4335864 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'ACCA.OL^J25' WHERE SecCode = 4338899 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 Ticker = 'FOAMIT', RIC = 'FOAMIT.HE', DisplayRIC = 'FOAMIT.HE' WHERE SecCode = 4348233 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007739' WHERE SecCode = 4349911 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueCode = 122674.0 WHERE SecCode = 4369834 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 ISIN = 'CNE100007747' WHERE SecCode = 4383292 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007754' WHERE SecCode = 4385223 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE0A0S01028', SEDOL = 'BVLL7J', CUSIP = 'Y793D412' WHERE SecCode = 4385228 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007762' WHERE SecCode = 4388155 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'NPAPER.ST^I25' WHERE SecCode = 4388410 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007770' WHERE SecCode = 4390249 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007788' WHERE SecCode = 4394706 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007796' WHERE SecCode = 4395427 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077B6' WHERE SecCode = 4403967 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077D2' WHERE SecCode = 4408311 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077C4' WHERE SecCode = 4408312 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = '6900.HK^J25' WHERE SecCode = 4415705 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4421086 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077F7' WHERE SecCode = 4421096 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'M4R44V18' WHERE SecCode = 4422378 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077G5' WHERE SecCode = 4423819 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 ISIN = 'CNE1000077H3' WHERE SecCode = 4429526 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4429539 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, SEDOL = NULL, RIC = 'OZONDR.MM^I25' WHERE SecCode = 4429545 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077J9' WHERE SecCode = 4432472 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'TSI.AX^J25' WHERE SecCode = 4438375 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077K7' WHERE SecCode = 4441387 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077L5' WHERE SecCode = 4443968 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077M3' WHERE SecCode = 4444668 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 ISIN = 'CNE1000077N1' WHERE SecCode = 4449609 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077P6' WHERE SecCode = 4451127 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'KEX.BK^J25' WHERE SecCode = 4452287 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077Q4' WHERE SecCode = 4453360 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077R2' WHERE SecCode = 4456233 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4456283 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077S0' WHERE SecCode = 4457141 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'ORTIN', RIC = 'ORTIN.ST', DisplayRIC = 'ORTIN.ST' WHERE SecCode = 4471741 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4482176 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077T8' WHERE SecCode = 4484327 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4485806 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077V4' WHERE SecCode = 4495551 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q902A010' WHERE SecCode = 4496725 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4501951 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = '6606.HK^J25' WHERE SecCode = 4502481 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4507736 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077W2' WHERE SecCode = 4524355 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 Ticker = 'RHR', RIC = 'RHR.L', DisplayRIC = 'RHR.L', RkdExchCode = 'LON' WHERE SecCode = 4531654 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4539148 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE418L01047', SEDOL = 'BSSB76', CUSIP = 'Y6S13X12' WHERE SecCode = 4542550 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077X0' WHERE SecCode = 4546440 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4550734 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'ROO.L^J25', DisplayRIC = 'ROO.L^J25' WHERE SecCode = 4550805 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 Ticker = 'UFBL', RIC = 'UITF.NS', DisplayRIC = 'UITF.NS' WHERE SecCode = 4557787 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 RkdIssueStatus = 0, Ticker = NULL, RIC = '0589.HK^J25' WHERE SecCode = 4574924 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 4590515 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 ISIN = 'CNE1000077Y8' WHERE SecCode = 4598587 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 RIC = 'GRAO3.SA^I25' WHERE SecCode = 4624288 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 RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 4638891 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4639757 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'PLAY.IC^J25' WHERE SecCode = 4640253 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077Z5' WHERE SecCode = 4641478 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007804' WHERE SecCode = 4645342 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'MIO.MC^J25' WHERE SecCode = 4645549 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4654588 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'VQLA.VI^J25' WHERE SecCode = 4655472 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'BRWDCNACNOR2', Ticker = 'WDCN3', SEDOL = 'BVLKHM', CUSIP = 'P6S96011', RIC = 'WDCN3.SA', DisplayRIC = 'WDCN3.SA' WHERE SecCode = 4655483 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 Ticker = 'ERKA', RIC = 'ERKA.TA', DisplayRIC = 'ERKA.TA' WHERE SecCode = 4659803 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE645S01024', SEDOL = 'BW5T2L', CUSIP = 'Y7S23U11' WHERE SecCode = 4667075 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'SA16D04HUQH1', Ticker = '4021', SEDOL = 'BT3CS4', CUSIP = 'M2057P11', RIC = '4021.SE', DisplayRIC = '4021.SE' WHERE SecCode = 4675090 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4677597 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'CARZ.KL^J25' WHERE SecCode = 4693638 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 Ticker = 'MARKOLINES', RIC = 'MARM.NS', DisplayRIC = 'MARM.NS', RkdExchCode = 'NSE' WHERE SecCode = 4720484 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 RkdIssueStatus = 0, RIC = 'M0YAy.BE^I25' WHERE SecCode = 4771748 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q9162S10' WHERE SecCode = 4777362 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4786370 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'GB00BRJNW354', Ticker = 'NRGB', SEDOL = 'BRJNW3', CUSIP = 'G4674M11', RIC = 'NRGB.ASE', DisplayRIC = 'NRGB.ASE' WHERE SecCode = 4788580 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'DMRE.BO', DisplayRIC = 'DMRE.BO' WHERE SecCode = 4796251 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4800505 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'KES.VI^J25' WHERE SecCode = 4806715 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4807668 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'US7444302084', SEDOL = 'BPK5C2', CUSIP = '74443020' WHERE SecCode = 4808877 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'ESTM', RIC = 'ESTM.MI', DisplayRIC = 'ESTM.MI' WHERE SecCode = 4811102 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'GB00BW9N7242', SEDOL = 'BW9N72' WHERE SecCode = 4815285 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 ISIN = 'AU0000427221', Ticker = 'TR8', SEDOL = 'BW9MH4', CUSIP = 'Q6486E13', RIC = 'TR8.AX', DisplayRIC = 'TR8.AX' WHERE SecCode = 4826112 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4838034 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007812' WHERE SecCode = 4846914 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'SA16D0820P10', Ticker = '4146', SEDOL = 'BTXY8P', CUSIP = 'M4628Y11', RIC = '4146.SE', DisplayRIC = '4146.SE' WHERE SecCode = 4867401 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'CIRCLEb.ST^J25' WHERE SecCode = 4868601 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4871157 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'AU0000428864', Ticker = 'KLV', SEDOL = 'BVBKRW', CUSIP = 'Q6S89815', RIC = 'KLV.AX', DisplayRIC = 'KLV.AX' WHERE SecCode = 4871191 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 RkdIssueStatus = 0, RIC = 'RIGHTB.ST^I25' WHERE SecCode = 4895650 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4897803 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q1636X10' WHERE SecCode = 4898106 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 ISIN = 'DE000A40ZVZ1', Ticker = 'ENG', SEDOL = 'BRBWSH', CUSIP = 'D2S1ZN10', RIC = 'ENGk.F', DisplayRIC = 'ENGk.F', RkdExchCode = 'FRA' WHERE SecCode = 4970859 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'L9894S11' WHERE SecCode = 4984245 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4989476 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '9224.T^I25' WHERE SecCode = 5022239 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5025166 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'LLL.AX^I25' WHERE SecCode = 5054835 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'LIFS.L^I25' WHERE SecCode = 5072231 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'TKG.HNO^J25' WHERE SecCode = 5135966 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'RHETAN', RIC = 'RHET.NS', DisplayRIC = 'RHET.NS', RkdExchCode = 'NSE' WHERE SecCode = 5144072 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5147789 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'FIN' WHERE SecCode = 5155321 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5168288 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'EMPIRE', RIC = 'EMPIREm.BK', DisplayRIC = 'EMPIREm.BK' WHERE SecCode = 5178470 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 CUSIP = 'Q1R28A10' WHERE SecCode = 5261360 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5283335 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'INIB.NS^J25' WHERE SecCode = 5286263 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5316691 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '7117.T^I25' WHERE SecCode = 5316694 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 RkdIssueStatus = 0, RIC = '449020.KQ^J25' WHERE SecCode = 5349583 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5349586 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '448740.KQ^J25' WHERE SecCode = 5351843 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '446750.KQ^J25' WHERE SecCode = 5354938 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '442900.KQ^J25' WHERE SecCode = 5362441 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5367666 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '7163.T^I25' WHERE SecCode = 5380510 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5401708 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueCode = 136857.0 WHERE SecCode = 5430796 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007820' WHERE SecCode = 5434296 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5434330 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007838' WHERE SecCode = 5437844 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5440961 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q6747211', COATypeCode = '' WHERE SecCode = 5443484 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007846' WHERE SecCode = 5453394 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007853' WHERE SecCode = 5466115 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007861' WHERE SecCode = 5473213 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007879' WHERE SecCode = 5474571 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'ORAO.ASE^I25' WHERE SecCode = 5474601 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '9164.T^I25' WHERE SecCode = 5478193 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007887' WHERE SecCode = 5478195 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007895' WHERE SecCode = 5479901 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078B4' WHERE SecCode = 5482519 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078C2' WHERE SecCode = 5493160 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '454750.KQ^J25' WHERE SecCode = 5493582 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078D0' WHERE SecCode = 5498252 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078F5' WHERE SecCode = 5499288 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5500244 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078G3' WHERE SecCode = 5500262 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, ISIN = 'DE000A40ZVP2', Ticker = 'XX10', SEDOL = 'BS4627', CUSIP = 'D0R5H310', 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'CAVT.MZ^J25' WHERE SecCode = 5604429 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5610275 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'SBAR', RIC = 'SBAR.L', DisplayRIC = 'SBAR.L', RkdExchCode = 'LON', 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 RkdIssueStatus = 0, RIC = 'TLT.AS^I25' WHERE SecCode = 5816808 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 Ticker = 'EFOR.E', RIC = 'EFOR.IS', DisplayRIC = 'EFOR.IS' WHERE SecCode = 5827159 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5839359 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000074S7', CUSIP = 'Y9804U10' WHERE SecCode = 5883249 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 ISIN = 'CNE1000078H1' WHERE SecCode = 5894867 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 5896458 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078J7' WHERE SecCode = 5903111 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078K5' WHERE SecCode = 5923809 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = '4585.TW', DisplayRIC = '4585.TW', RkdExchCode = 'TPE' WHERE SecCode = 5931893 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078L3' WHERE SecCode = 5931895 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'BAC', RIC = 'BACJ.J', DisplayRIC = 'BACJ.J' WHERE SecCode = 5954213 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5958664 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = '7788.TW', DisplayRIC = '7788.TW', RkdExchCode = 'TPE' WHERE SecCode = 5974237 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 RIC = '7791.TW', DisplayRIC = '7791.TW', RkdExchCode = 'TPE' WHERE SecCode = 6012727 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 RkdIssueStatus = 0, Ticker = 'ONCOI', RIC = 'ONCOI.OL^J25', DisplayRIC = 'ONCOI.OL' WHERE SecCode = 6039856 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6069728 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' 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 = 'IND' WHERE SecCode = 6128250 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6141555 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6153863 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6159033 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' 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 PrimaryIssueType = 'EQU' WHERE SecCode = 6205859 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6205869 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' 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 = 'IND' WHERE SecCode = 6223905 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y614R710' WHERE SecCode = 6240405 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 = 'IND' WHERE SecCode = 6285554 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6285562 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y6835F10' WHERE SecCode = 6291853 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6291854 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6297427 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6297438 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6301989 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6303031 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'LEEA.NS', DisplayRIC = 'LEEA.NS' WHERE SecCode = 6305341 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 = 'IND' 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 = 'IND' WHERE SecCode = 6339507 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6339508 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6341752 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6347455 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6354184 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6354186 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6356123 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000074T5', CUSIP = 'Y0S6TS10' WHERE SecCode = 6360666 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y7029M10' WHERE SecCode = 6361838 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' 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 CUSIP = 'Y709P511' WHERE SecCode = 6363468 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6366692 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 ISIN = 'CNE1000074V1', CUSIP = 'Y312GC10' WHERE SecCode = 6371482 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6377047 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6377048 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000074W9', CUSIP = 'Y897S510' WHERE SecCode = 6379417 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 = 'IND' WHERE SecCode = 6396775 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000074X7', CUSIP = 'Y973BJ10' WHERE SecCode = 6405363 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU', COATypeCode = 'IND' 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 = 'IND' WHERE SecCode = 6434972 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6434975 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6440004 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'M6S93J10', COATypeCode = 'IND' WHERE SecCode = 6440013 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6441631 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'MYQ0371OO003', Ticker = 'CAMAROE', CUSIP = 'Y1672J10', RIC = 'CAMR.KL', DisplayRIC = 'CAMR.KL', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 6441634 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 ISIN = 'CNE1000078M1', PrimaryIssueType = 'EQU' WHERE SecCode = 6443242 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000074Y5', CUSIP = 'Y445VA10' WHERE SecCode = 6445468 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'GG00BW5S7K10', SEDOL = 'BW5S7K', CUSIP = 'G8436920' WHERE SecCode = 6445654 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6448554 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6448820 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000076J1', CUSIP = 'Y445VS10' WHERE SecCode = 6449028 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6449036 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6450902 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'J3649110' WHERE SecCode = 6450912 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6451094 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 = 6457821 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6457843 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6460614 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6460617 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6460629 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6462835 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6467522 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y5928C10' WHERE SecCode = 6467524 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y447LF10' WHERE SecCode = 6467526 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y238AJ10', COATypeCode = 'IND' WHERE SecCode = 6469316 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6469317 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 6472001 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6474327 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'DELIA', RIC = 'DELIA.OL', DisplayRIC = 'DELIA.OL', RkdExchCode = 'OSL', RkdExchCtry = 'NOR' WHERE SecCode = 6474420 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6478346 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6478352 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6478390 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6482676 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6482677 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6482678 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6482679 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'G1140S10' WHERE SecCode = 6482833 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6485265 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6485266 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y129T310' WHERE SecCode = 6487488 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6487495 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6487499 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6487500 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6490055 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6490061 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6490064 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6490068 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6490070 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6495240 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6501029 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6503804 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078N9' WHERE SecCode = 6507142 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6509306 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6509309 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y9407710' WHERE SecCode = 6513221 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y8802Y10' WHERE SecCode = 6515952 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078P4' WHERE SecCode = 6518463 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6520650 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y7032310' WHERE SecCode = 6522467 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 Ticker = 'CART', RIC = 'CART.V', DisplayRIC = 'CART.V', RkdExchCode = 'CVE' WHERE SecCode = 10776460 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 Ticker = 'OPITQ', RIC = 'OPITQ.PK', DisplayRIC = 'OPITQ.PK', RkdExchCode = 'OTC' WHERE SecCode = 10906768 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 ISIN = 'CA5495465059', SEDOL = 'BV2JDL', CUSIP = '54954650' WHERE SecCode = 10911585 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10911886 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'MAXD.PK^I25' WHERE SecCode = 10913779 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10914032 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA65345J3038', SEDOL = 'BTWMP6', CUSIP = '65345J30' WHERE SecCode = 10923992 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US74039M4087', SEDOL = 'BW5YYL', CUSIP = '74039M40' WHERE SecCode = 10924184 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', SEDOL = 'BSBK2L', CUSIP = '80512Q50' WHERE SecCode = 10925121 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 10928401 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'HVVh.V^J25' WHERE SecCode = 10965216 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10965382 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'FFH_pg.TO^J25' WHERE SecCode = 10965490 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10965568 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'G.TO^J25' WHERE SecCode = 10966219 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10968280 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10970730 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 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 ISIN = 'CA67053L7025', SEDOL = 'BVBCNC', CUSIP = '67053L70' WHERE SecCode = 10980732 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 10980733 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA98956K1030', Ticker = 'TRR', SEDOL = 'BMGDL0', CUSIP = '98956K10', RIC = 'TRR.V', DisplayRIC = 'TRR.V' WHERE SecCode = 10982696 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 ISIN = 'US53814X3008', SEDOL = 'BVBFGJ', CUSIP = '53814X30' WHERE SecCode = 11002865 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 Ticker = 'GMI.H', RIC = 'GMIh.V', DisplayRIC = 'GMIh.V', RkdExchCode = 'NEX' WHERE SecCode = 11005365 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA3821132071', SEDOL = 'BVK6C7', CUSIP = '38211320' WHERE SecCode = 11005822 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11005855 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'GROO', RIC = 'GROO.PK', DisplayRIC = 'GROO.PK' WHERE SecCode = 11008400 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'COOL.CD^I25' WHERE SecCode = 11009046 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'MIXX.PK^J25' WHERE SecCode = 11009286 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11014039 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US9630257965', SEDOL = 'BLDCLW', CUSIP = '96302579' WHERE SecCode = 11015187 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 ISIN = 'CA14919F3051', SEDOL = 'BS55HW', CUSIP = '14919F30' WHERE SecCode = 11019872 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'ASE.V', DisplayRIC = 'ASE.V', RkdExchCode = 'CVE' WHERE SecCode = 11023364 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA63906L1067', Ticker = 'BAD', SEDOL = 'BW2K5K', CUSIP = '63906L10', RIC = 'BAD.CD', DisplayRIC = 'BAD.CD' WHERE SecCode = 11024620 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'LPC.V^J25' WHERE SecCode = 11025050 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'COOP.OQ^J25' WHERE SecCode = 11025091 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA2798521076', Ticker = 'EDCU', CUSIP = '27985210', RIC = 'EDCU.V', DisplayRIC = 'EDCU.V' WHERE SecCode = 11025361 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'OGh.V^J25' WHERE SecCode = 11028815 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'JPI.N^I25' WHERE SecCode = 11033942 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'PHLT.OQ^J25' WHERE SecCode = 11034341 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11034669 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'HCU.V^J25' WHERE SecCode = 11036395 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US62526P8775', SEDOL = 'BSBK03', CUSIP = '62526P87', RIC = 'BINI.PK', DisplayRIC = 'BINI.PK', RkdExchCode = 'OTC' WHERE SecCode = 11036554 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11036726 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US02871P3047', Ticker = 'NFTND', SEDOL = 'BTWMPD', CUSIP = '02871P30', RIC = 'NFTND.PK', DisplayRIC = 'NFTND.PK' WHERE SecCode = 11036887 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = NULL, RIC = 'LTUU.PK^J25' WHERE SecCode = 11036996 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11037001 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'SINC', RIC = 'SINC.PK', DisplayRIC = 'SINC.PK' WHERE SecCode = 11037266 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11037414 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US37954A3032', SEDOL = 'BW0WPK', 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 ISIN = 'CA6857881016', SEDOL = 'BVBQT2', CUSIP = '68578810' WHERE SecCode = 11045015 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 ISIN = 'CA55067G1081', Ticker = 'LXM', SEDOL = 'BRWD7W', CUSIP = '55067G10', RIC = 'LXM.V', DisplayRIC = 'LXM.V' WHERE SecCode = 11072382 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'NLTAh.V^J25' WHERE SecCode = 11074055 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US67091J8009', Ticker = 'LGMKD', SEDOL = 'BVBHFM', CUSIP = '67091J80', RIC = 'LGMKD.PK', DisplayRIC = 'LGMKD.PK' WHERE SecCode = 11103983 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'PBPB.OQ^J25' WHERE SecCode = 11107047 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA54020J2002', SEDOL = 'BW5ZMN', CUSIP = '54020J20' WHERE SecCode = 11108371 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'HUTN.PK^J25' WHERE SecCode = 11109689 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'WNHK', RIC = 'WNHK.PK', DisplayRIC = 'WNHK.PK' WHERE SecCode = 11109781 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11110934 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SPRZ.PK^J25' WHERE SecCode = 11111083 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'SLAI', RIC = 'SLAI.K', DisplayRIC = 'SLAI.N' WHERE SecCode = 11111276 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'VNCE.O', DisplayRIC = 'VNCE.OQ', RkdExchCode = 'NASD' WHERE SecCode = 11111352 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 RIC = 'CARM.PK', DisplayRIC = 'CARM.PK', RkdExchCode = 'OTC' WHERE SecCode = 11129194 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 ShPerListing = 250.0 WHERE SecCode = 11131840 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'VBTX.OQ^J25' WHERE SecCode = 11140942 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 ISIN = 'US29350E2037', Ticker = 'LNAI', SEDOL = 'BW5YZY', CUSIP = '29350E20', RIC = 'LNAI.O', DisplayRIC = 'LNAI.OQ' WHERE SecCode = 11142344 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'LBRA', RIC = 'LBRA.PK', DisplayRIC = 'LBRA.PK', RkdExchCode = 'OTC' WHERE SecCode = 11142838 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 RkdIssueStatus = 0, RIC = 'EPIX.OQ^J25' WHERE SecCode = 11144375 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11144505 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA62849F4087', SEDOL = 'BMGDM9', CUSIP = '62849F40' WHERE SecCode = 11145231 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US81727U3032', SEDOL = 'BTMJPJ', CUSIP = '81727U30' WHERE SecCode = 11145550 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'ETSY.K', DisplayRIC = 'ETSY.N', RkdExchCode = 'NYSE' WHERE SecCode = 11147236 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'ADAPY', RIC = 'ADAPY.PK', DisplayRIC = 'ADAPY.PK', RkdExchCode = 'OTC' WHERE SecCode = 11148019 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11148680 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA4629231032', Ticker = 'IMI', SEDOL = 'BR53SY', CUSIP = '46292310', RIC = 'IMI.V', DisplayRIC = 'IMI.V' WHERE SecCode = 11149536 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 RIC = NULL WHERE SecCode = 11150646 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'PRHI', RIC = 'PRHI.O', DisplayRIC = 'PRHI.OQ' WHERE SecCode = 11151122 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 Ticker = 'LTPVQ', RIC = 'LTPVQ.PK', DisplayRIC = 'LTPVQ.PK' WHERE SecCode = 11155169 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 ISIN = 'US02919L7038', SEDOL = 'BSNMK7', CUSIP = '02919L70' WHERE SecCode = 11156315 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA01559C1068', SEDOL = 'BW5ZLD', CUSIP = '01559C10' WHERE SecCode = 11156632 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 RkdIssueID = 9, RkdIssueCode = 138800, RkdIssueOrder = 4 WHERE SecCode = 11161389 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11161920 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'SISI.PK', DisplayRIC = 'SISI.PK', RkdExchCode = 'OTC' WHERE SecCode = 11162909 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'VRNA.OQ^J25' WHERE SecCode = 11171830 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11172169 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'HLYK', RIC = 'HLYK.PK', DisplayRIC = 'HLYK.PK' WHERE SecCode = 11172213 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 ISIN = 'US68236V4014', SEDOL = 'BW5ZKV', CUSIP = '68236V40' WHERE SecCode = 11174115 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 ISIN = 'VGG752711330', CUSIP = 'G7527113' WHERE SecCode = 11176237 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 ISIN = 'US3724463027', SEDOL = 'BT04GQ', CUSIP = '37244630' WHERE SecCode = 11177776 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US8169451098', SEDOL = 'BVPWCV', CUSIP = '81694510' WHERE SecCode = 11177920 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11178067 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA88831L2021', CUSIP = '88831L20' WHERE SecCode = 11178148 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA0976924047', SEDOL = 'BMGCPB', CUSIP = '09769240' WHERE SecCode = 11178737 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SCPH.OQ^J25' WHERE SecCode = 11178942 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11179498 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'EXRO.TO^J25' WHERE SecCode = 11179624 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 11180370 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 = 'EQU' WHERE SecCode = 11183776 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'IN', RIC = 'IN.V', DisplayRIC = 'IN.V' WHERE SecCode = 11184696 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'UNBX.PK^J25' WHERE SecCode = 11184890 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11185058 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'BZAMF.PK^J25' WHERE SecCode = 11185104 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11185342 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA3751301019', Ticker = 'BEEP', SEDOL = 'BV3PBP', CUSIP = '37513010', RIC = 'BEEP.V', DisplayRIC = 'BEEP.V' WHERE SecCode = 11185572 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 ISIN = 'US3916572023', Ticker = 'GCAND', SEDOL = 'BW5ZK3', CUSIP = '39165720', RIC = 'GCAND.PK', DisplayRIC = 'GCAND.PK' WHERE SecCode = 11187805 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA86419L2066', SEDOL = 'BV3PBB', CUSIP = '86419L20' WHERE SecCode = 11187906 AND Type_ = 1;
UPDATE data_universe_rkd SET ShPerListing = 13.33333, PrimaryIssueType = 'PVT' 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 PrimaryIssueType = 'PVT' WHERE SecCode = 11189974 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 ISIN = 'CA75865L1094', SEDOL = 'BPYV2J', CUSIP = '75865L10' WHERE SecCode = 11190644 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'PVS_pg.TO^J25' WHERE SecCode = 11192150 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA93401G2036', SEDOL = 'BSNMKL', CUSIP = '93401G20' WHERE SecCode = 11192167 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11192602 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'ADNH', RIC = 'ADNH.PK', DisplayRIC = 'ADNH.PK', RkdExchCode = 'OTC' WHERE SecCode = 11192985 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 11193281 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US8314455077', SEDOL = 'BV9F17', CUSIP = '83144550' WHERE SecCode = 11193348 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 ISIN = 'CA0556901019', Ticker = 'BPAG', SEDOL = 'BVMS5Q', CUSIP = '05569010', RIC = 'BPAG.V', DisplayRIC = 'BPAG.V' WHERE SecCode = 11194108 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA65345P2008', SEDOL = 'BMGDKK', CUSIP = '65345P20' WHERE SecCode = 11194297 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11194907 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA60306F2008', SEDOL = 'BMGDML', CUSIP = '60306F20' WHERE SecCode = 11196310 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US83548F4081', SEDOL = 'BV9F2Q', CUSIP = '83548F40' WHERE SecCode = 11196781 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11197320 AND Type_ = 1;
UPDATE data_universe_rkd SET ShPerListing = 0.6667 WHERE SecCode = 11197385 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SRES.V^I25' WHERE SecCode = 11199506 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA62930A1021', SEDOL = 'BVBCQW', CUSIP = '62930A10' WHERE SecCode = 11199713 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11200211 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA3001447067', SEDOL = 'BVPWCX', CUSIP = '30014470' WHERE SecCode = 11200982 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'ETNB.OQ^J25' WHERE SecCode = 11202140 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11202576 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA38071C1077', Ticker = 'GRUN', SEDOL = 'BTWMP7', CUSIP = '38071C10', RIC = 'GRUN.CD', DisplayRIC = 'GRUN.CD' WHERE SecCode = 11202579 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA88770A3082', SEDOL = 'BR53SH', CUSIP = '88770A30', RIC = 'TINY.TO', DisplayRIC = 'TINY.TO', RkdExchCode = 'TSE' WHERE SecCode = 11202685 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11203428 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11203817 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'NBP', RIC = 'NBP.O', DisplayRIC = 'NBP.OQ' WHERE SecCode = 11204015 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11204685 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA69867J2048', SEDOL = 'BTMJPL', CUSIP = '69867J20' WHERE SecCode = 11204720 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 = 'US36253J3041', Ticker = 'ACATD', SEDOL = 'BRCDFG', CUSIP = '36253J30', RIC = 'ACATD.PK', DisplayRIC = 'ACATD.PK' WHERE SecCode = 11206829 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 ISIN = 'US0070258852', CUSIP = '00702588' WHERE SecCode = 11207780 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11208281 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'ANG_pb.N^J25' WHERE SecCode = 11208589 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 PrimaryIssueType = 'PVT' WHERE SecCode = 11209704 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11209995 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'BNKK', RIC = 'BNKK.O', DisplayRIC = 'BNKK.OQ' WHERE SecCode = 11210045 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 ISIN = 'US67012M2052', SEDOL = 'BVMS1W', CUSIP = '67012M20' WHERE SecCode = 11211233 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 Ticker = 'AMBIQ', SEDOL = NULL, RIC = 'AMBIQ.PK', DisplayRIC = 'AMBIQ.PK', RkdExchCode = 'OTC' WHERE SecCode = 11212108 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 ISIN = 'CA07135M3021', SEDOL = 'BQ3QCL', CUSIP = '07135M30' WHERE SecCode = 11212317 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11212657 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11212829 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'CCC', RIC = 'CCC.O', DisplayRIC = 'CCC.OQ' WHERE SecCode = 11213430 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US5270642086', SEDOL = 'BVMS1H', CUSIP = '52706420' WHERE SecCode = 11214225 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'STGC.PK^I25' WHERE SecCode = 11214335 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 RIC = 'CMPO.K', DisplayRIC = 'CMPO.N', RkdExchCode = 'NYSE' WHERE SecCode = 11214926 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CH1442297896', Ticker = 'NCEL', SEDOL = 'BWD64R', CUSIP = 'H5835A10', RIC = 'NCEL.O', DisplayRIC = 'NCEL.OQ' WHERE SecCode = 11215111 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, SEDOL = NULL, RIC = 'OZONDR.MM^I25' WHERE SecCode = 11215113 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11216267 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'KUKEY', SEDOL = NULL, RIC = 'KUKEY.PK', DisplayRIC = 'KUKEY.PK', RkdExchCode = 'OTC' WHERE SecCode = 11217325 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11217568 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11218134 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US9290332074', SEDOL = 'BRJJYT', CUSIP = '92903320' WHERE SecCode = 11218924 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'KYG9491K1397', SEDOL = 'BVPGQN', CUSIP = 'G9491K13' WHERE SecCode = 11219917 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11221183 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 ISIN = 'US62459M3051', SEDOL = 'BTMJL3', CUSIP = '62459M30' WHERE SecCode = 11221473 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 RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 11221887 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11221979 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11221982 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11222085 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SHMY.PK^J25' WHERE SecCode = 11222284 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11222497 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA5910882086', SEDOL = 'BVPWCQ', CUSIP = '59108820' WHERE SecCode = 11222521 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 PrimaryIssueType = 'EQU' WHERE SecCode = 11223644 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US46265P2065', SEDOL = 'BV9F1T', CUSIP = '46265P20' WHERE SecCode = 11223868 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'TRML.OQ^J25' WHERE SecCode = 11223882 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 RkdIssueStatus = 0, RIC = 'GET.CD^I25' WHERE SecCode = 11226120 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'NEUE.N^J25' WHERE SecCode = 11226158 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'FLOW.TO^J25' WHERE SecCode = 11227189 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA64136J1012', Ticker = 'NTLX', SEDOL = 'BVBCQ9', CUSIP = '64136J10', RIC = 'NTLX.V', DisplayRIC = 'NTLX.V' WHERE SecCode = 11227498 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'BASE.OQ^I25' WHERE SecCode = 11227644 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'MLNK.N^J25' WHERE SecCode = 11227947 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 Ticker = 'ULIX', RIC = 'ULIX.PK', DisplayRIC = 'ULIX.PK' WHERE SecCode = 11228508 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11229110 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'FAASF', RIC = 'FAASF.PK', DisplayRIC = 'FAASF.PK', RkdExchCode = 'OTC' WHERE SecCode = 11229729 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'MTAL.N^J25' WHERE SecCode = 11230316 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA76134P1036', Ticker = 'RESO', SEDOL = 'BVK6CR', CUSIP = '76134P10', RIC = 'RESO.CD', DisplayRIC = 'RESO.CD' WHERE SecCode = 11230347 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11230420 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'AVDX.OQ^J25' WHERE SecCode = 11232126 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA74841F3025', Ticker = 'SICO', SEDOL = 'BTMNSX', CUSIP = '74841F30', RIC = 'SICO.V', DisplayRIC = 'SICO.V' WHERE SecCode = 11232250 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'ARIS.N^J25' WHERE SecCode = 11232562 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11232769 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US7469623075', SEDOL = 'BPYS4H', CUSIP = '74696230' WHERE SecCode = 11233331 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'TCBX.K', DisplayRIC = 'TCBX.N', RkdExchCode = 'NYSE' WHERE SecCode = 11233740 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'M0YA', SEDOL = 'BMFV5G', RIC = 'M0YAy.BE^I25', DisplayRIC = 'M0YAy.BE', RkdExchCode = 'BER', RkdExchCtry = 'DEU', PrimaryIssueCode = NULL, RelType = NULL WHERE SecCode = 11234013 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'CERO.PK', DisplayRIC = 'CERO.PK', RkdExchCode = 'OTC' WHERE SecCode = 11234695 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'IE000UPDVNX9', SEDOL = 'BTMNPN', CUSIP = 'G8267K18' WHERE SecCode = 11235178 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'READ.CD^J25' WHERE SecCode = 11236137 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'KYG0231P1081', Ticker = 'ALPS', SEDOL = 'BSLN5T', CUSIP = 'G0231P10', RIC = 'ALPS.O', DisplayRIC = 'ALPS.OQ', RkdExchCode = 'NASD' WHERE SecCode = 11236204 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'KYG507161282', SEDOL = 'BSPVK5', CUSIP = 'G5071612' WHERE SecCode = 11236365 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'KYG4465R1294', CUSIP = 'G4465R12' WHERE SecCode = 11236809 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'RHNO', RIC = 'RHNO.PK', DisplayRIC = 'RHNO.PK' WHERE SecCode = 11237470 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'ZIMV.OQ^J25' WHERE SecCode = 11238498 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'KYG7308J1132', SEDOL = 'BVBQPF', CUSIP = 'G7308J11' WHERE SecCode = 11238855 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11239277 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US0008472021', CUSIP = '00084720' WHERE SecCode = 11239312 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US36118R1032', Ticker = 'FUSE', SEDOL = 'BV3P6X', CUSIP = '36118R10', RIC = 'FUSE.O', DisplayRIC = 'FUSE.OQ', RkdExchCode = 'NASD' WHERE SecCode = 11239371 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA3490242086', SEDOL = 'BW5YYM', CUSIP = '34902420' WHERE SecCode = 11239425 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US23290B2051', SEDOL = 'BW5ZJY', CUSIP = '23290B20' WHERE SecCode = 11239922 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US20678X4034', SEDOL = 'BVBQPG', CUSIP = '20678X40' WHERE SecCode = 11240122 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 ISIN = 'US95758L3050', SEDOL = 'BV9F16', CUSIP = '95758L30' WHERE SecCode = 11240837 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'ALCE', RIC = 'ALCE.PK', DisplayRIC = 'ALCE.PK' WHERE SecCode = 11240997 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA28619V1058', Ticker = 'EONE', SEDOL = 'BRCDG7', CUSIP = '28619V10', RIC = 'EONE.CD', DisplayRIC = 'EONE.CD' WHERE SecCode = 11241066 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'PLAOF.PK^J25' WHERE SecCode = 11241585 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueCode = 124389.0, RelType = 1.0 WHERE SecCode = 11241711 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11241791 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11241800 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11241801 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11241802 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11241834 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11241835 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'SLT', SEDOL = 'BT7HYP', RIC = 'SLT.TO', DisplayRIC = 'SLT.TO' WHERE SecCode = 11241870 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US81686G1058', Ticker = 'SMNR', SEDOL = 'BV8CPF', CUSIP = '81686G10', RIC = 'SMNR.PK', DisplayRIC = 'SMNR.PK' WHERE SecCode = 11242359 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 ISIN = 'VGG5851A1416', SEDOL = 'BVMS5F', CUSIP = 'G5851A14' WHERE SecCode = 11242832 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 11243952 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA89103M2094', Ticker = 'RZL', SEDOL = 'BVBQRZ', CUSIP = '89103M20', RIC = 'RZL.V', DisplayRIC = 'RZL.V' WHERE SecCode = 11244529 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 = 'CA75865D2068', SEDOL = 'BW2K5N', CUSIP = '75865D20' WHERE SecCode = 11246784 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'SVIIF', RIC = 'SVIIF.PK', DisplayRIC = 'SVIIF.PK', RkdExchCode = 'OTC' WHERE SecCode = 11246941 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 RIC = 'DMYY.PK', DisplayRIC = 'DMYY.PK', RkdExchCode = 'OTC' WHERE SecCode = 11247542 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 ISIN = 'KYG3109F1110', SEDOL = 'BW5YX7', CUSIP = 'G3109F11' WHERE SecCode = 11248163 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA00844N2086', SEDOL = 'BVPWCW', CUSIP = '00844N20' WHERE SecCode = 11248311 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11249093 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'SLMT', RIC = 'SLMT.O', DisplayRIC = 'SLMT.OQ' WHERE SecCode = 11249174 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 Ticker = 'AQLS', RIC = 'AQLS.PK', DisplayRIC = 'AQLS.PK' WHERE SecCode = 11249737 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11250023 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11250261 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'LSBCF', RIC = 'LSBCF.PK', DisplayRIC = 'LSBCF.PK', RkdExchCode = 'OTC' WHERE SecCode = 11250503 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA6438181076', Ticker = 'EATH', SEDOL = 'BRJK39', CUSIP = '64381810', RIC = 'EATH.CD', DisplayRIC = 'EATH.CD' WHERE SecCode = 11251487 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'GSOL.K', DisplayRIC = 'GSOL.P', RkdExchCode = 'PAC' WHERE SecCode = 11251501 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 = 'KYG5084H1112', SEDOL = 'BT8PB2', CUSIP = 'G5084H11' WHERE SecCode = 11252318 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 RIC = 'FORL.PK', DisplayRIC = 'FORL.PK', RkdExchCode = 'OTC' WHERE SecCode = 11252798 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11252800 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'MGRM.OQ^J25' WHERE SecCode = 11253068 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US5000811043', Ticker = 'KDK', SEDOL = 'BVBFG4', CUSIP = '50008110', RIC = 'KDK.O', DisplayRIC = 'KDK.OQ', RkdExchCode = 'NASD' WHERE SecCode = 11253494 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'AURE', RIC = 'AURE.O', DisplayRIC = 'AURE.OQ' WHERE SecCode = 11254624 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA0293642058', SEDOL = 'BV5CT4', CUSIP = '02936420' WHERE SecCode = 11255289 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11255338 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'KYG351501385', SEDOL = 'BLDCLZ', CUSIP = 'G3515013' WHERE SecCode = 11256200 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11256311 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11256627 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'AXG', RIC = 'AXG.O', DisplayRIC = 'AXG.OQ' WHERE SecCode = 11256986 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US66373M4087', SEDOL = 'BVMS1J', CUSIP = '66373M40' WHERE SecCode = 11257598 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'KLG.N^I25' WHERE SecCode = 11257617 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11257663 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 RIC = NULL WHERE SecCode = 11260352 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 ISIN = 'KYG570371149', SEDOL = 'BVBQPN', CUSIP = 'G5703711' WHERE SecCode = 11263023 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 ISIN = 'VGG003501191', SEDOL = 'BVPW8G', CUSIP = 'G0035011' WHERE SecCode = 11263502 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'KYG622641259', SEDOL = 'BVZL0B', CUSIP = 'G6226412' WHERE SecCode = 11264180 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 ShPerListing = 12.0 WHERE SecCode = 11267607 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11267641 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'KYG6781F1191', SEDOL = 'BVMS1X', CUSIP = 'G6781F11' WHERE SecCode = 11267719 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 ISIN = 'KYG9767H1175', SEDOL = 'BT04FL', CUSIP = 'G9767H11' WHERE SecCode = 11268688 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'VGG7200G1182', SEDOL = 'BT68XL', CUSIP = 'G7200G11' WHERE SecCode = 11269125 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 CUSIP = 'Q4933C13' WHERE SecCode = 11270044 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'FTW', RIC = 'FTW', DisplayRIC = 'FTW.N' WHERE SecCode = 11270085 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11270448 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'VGG2R09D1107', SEDOL = 'BTMJLK', CUSIP = 'G2R09D11' WHERE SecCode = 11270493 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US8814541020', Ticker = 'IMSR', SEDOL = 'BVK6BG', CUSIP = '88145410', RIC = 'IMSR.O', DisplayRIC = 'IMSR.OQ' WHERE SecCode = 11270517 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11270942 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11270950 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11271747 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'IPST', RIC = 'IPST.O', DisplayRIC = 'IPST.OQ' WHERE SecCode = 11271912 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'GSRT.OQ^J25' WHERE SecCode = 11273297 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'KYG9876W1125', SEDOL = 'BW5YXB', CUSIP = 'G9876W11' WHERE SecCode = 11273379 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'BYAH', RIC = 'BYAH.O', DisplayRIC = 'BYAH.OQ' WHERE SecCode = 11273567 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11273643 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11274257 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'UCFI', RIC = 'UCFI.O', DisplayRIC = 'UCFI.OQ' WHERE SecCode = 11274801 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11275070 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'RHLD.K', DisplayRIC = 'RHLD.N', RkdExchCode = 'NYSE' WHERE SecCode = 11275118 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 = 'IND' 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 = 'IND' 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 = 'IND' 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 = 11278867 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11279414 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'XRPN', RIC = 'XRPN.O', DisplayRIC = 'XRPN.OQ' WHERE SecCode = 11279726 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 Ticker = 'PASW', RIC = 'PASW.O', DisplayRIC = 'PASW.OQ' WHERE SecCode = 11280999 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11281175 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'BNK' 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 = 'IND' WHERE SecCode = 11282047 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11282097 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11282117 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11282205 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11282219 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11284024 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA38447A1084', Ticker = 'GFT', SEDOL = 'BRVW9V', CUSIP = '38447A10', RIC = 'GFT.CD', DisplayRIC = 'GFT.CD' WHERE SecCode = 11284198 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11284220 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11284225 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11284287 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 = 'IND' 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 = 'IND' WHERE SecCode = 11285173 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11285177 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11285209 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11285212 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11285221 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11285245 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11285254 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11285257 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11285376 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11285378 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11285415 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11285431 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11285479 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, SEDOL = 'BPK5Q2', RIC = 'EMISU.OQ^J25' WHERE SecCode = 11285503 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11285547 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11285843 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11285908 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11285979 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11286100 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11286111 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11286168 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11286286 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11286287 AND Type_ = 1;
UPDATE data_universe_rkd SET SEDOL = 'BR53ST' WHERE SecCode = 11286422 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11286424 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11286862 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11286916 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11287079 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'SOLS', RIC = 'SOLS.O', DisplayRIC = 'SOLS.OQ' WHERE SecCode = 11287136 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'Q', DisplayRIC = 'Q.N' WHERE SecCode = 11287310 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT', COATypeCode = 'IND' WHERE SecCode = 11287404 AND Type_ = 1;