UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'DLE.I^I25' WHERE SecCode = 697 AND Type_ = 10;
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 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 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 RkdIssueStatus = 1 WHERE SecCode = 8022 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 8025 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 8026 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 8099 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'BSYI.PK^I25' WHERE SecCode = 9451 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 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 ISIN = 'US98873Q2093', SEDOL = 'BR4ZY5', CUSIP = '98873Q20' WHERE SecCode = 11338 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 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 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 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 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.K', DisplayRIC = 'EMBJ.N' WHERE SecCode = 23541 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 RIC = NULL WHERE SecCode = 28177 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdExchCode = 'NA', RkdExchCtry = NULL WHERE SecCode = 29184 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 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 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 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 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 RkdIssueStatus = 1, RkdListingType = 'OSR', ISIN = NULL, CUSIP = NULL, RIC = NULL, RkdExchCode = 'NA', RkdExchCtry = NULL, ShPerListing = NULL, PrimaryIssueType = 'IPO', PrimaryIssueCode = NULL, RelType = NULL WHERE SecCode = 40000 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 ISIN = 'US5381463091', SEDOL = 'BVBQPK', CUSIP = '53814630' WHERE SecCode = 42719 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 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 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 ISIN = 'US9682353092', SEDOL = 'BSDZ35', CUSIP = '96823530' WHERE SecCode = 50157 AND Type_ = 1;
UPDATE data_universe_rkd SET ShPerListing = 1.0 WHERE SecCode = 50714 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 51611 AND Type_ = 10;
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 Ticker = 'PEGX', RIC = 'PEGX.PK', DisplayRIC = 'PEGX.PK' WHERE SecCode = 54760 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 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 RkdIssueStatus = 0, RIC = 'IARb.ST^K25' WHERE SecCode = 57242 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 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 RIC = 'DGRG.F', DisplayRIC = 'DGRG.F', RkdExchCode = 'FRA' WHERE SecCode = 59308 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 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 RkdIssueStatus = 0, Ticker = NULL, RIC = '1185.HK^K25' WHERE SecCode = 67930 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 RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 69916 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 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 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 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 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 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 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 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'SPY.NZ^K25' WHERE SecCode = 76345 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'GBLI.O', DisplayRIC = 'GBLI.OQ', RkdExchCode = 'NASD' WHERE SecCode = 77931 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 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 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' WHERE SecCode = 81567 AND Type_ = 1;
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 RkdIssueStatus = 0, RIC = '9377.T^I25' WHERE SecCode = 82838 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'MNGL.NS^K25' WHERE SecCode = 83605 AND Type_ = 10;
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 ISIN = 'INE672A01026', SEDOL = 'BW2FS5', CUSIP = 'Y8T33Y12' WHERE SecCode = 84503 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '6416.T^K25' WHERE SecCode = 85286 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 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 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 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 RkdExchCode = 'NA', RkdExchCtry = NULL WHERE SecCode = 91731 AND Type_ = 1;
UPDATE data_universe_rkd SET CUSIP = 'Y0S64711' WHERE SecCode = 92081 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'KNMP.KL^K25' WHERE SecCode = 92128 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 Ticker = 'MRZL', CUSIP = NULL, RIC = 'MRZL.V', DisplayRIC = 'MRZL.V' WHERE SecCode = 92563 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 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 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'RCG.TO^K25' WHERE SecCode = 94226 AND Type_ = 1;
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 ISIN = 'AU000000SOL3', Ticker = 'SOL', SEDOL = '682180', RIC = 'SOL.AX', DisplayRIC = 'SOL.AX' WHERE SecCode = 95997 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 96052 AND Type_ = 10;
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 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 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'PKI.TO^K25' WHERE SecCode = 97829 AND Type_ = 1;
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 RIC = NULL WHERE SecCode = 98889 AND Type_ = 10;
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 ISIN = 'CA8282293023', SEDOL = 'BTJY2H', CUSIP = '82822930' WHERE SecCode = 99313 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 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 CUSIP = 'G2581C20' WHERE SecCode = 115240 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 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 RkdIssueStatus = 0, RIC = 'NSX.AX^J25' WHERE SecCode = 126884 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 CUSIP = 'Q2874S25' WHERE SecCode = 133785 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 RkdIssueStatus = 0, RIC = 'AMSCM.OL^K25' WHERE SecCode = 137922 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 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 ISIN = 'BREMBJACNOR1', Ticker = 'EMBJ3', SEDOL = 'BTRD97', RIC = 'EMBJ3.SA', DisplayRIC = 'EMBJ3.SA' WHERE SecCode = 146014 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 Ticker = 'FHB', RIC = 'FHBP.WA', DisplayRIC = 'FHBP.WA' WHERE SecCode = 147359 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'AU0000423089', Ticker = 'AMADA', SEDOL = 'BVLKB0', RIC = 'AMADA.AX', DisplayRIC = 'AMADA.AX' WHERE SecCode = 161050 AND Type_ = 10;
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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'FCCT.PK^J25' 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 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 RkdIssueStatus = 1, ISIN = 'TW0006604002', CUSIP = 'Y447LP10', RIC = '6604.TWO' WHERE SecCode = 197345 AND Type_ = 10;
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 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', SEDOL = 'BSNRDG', 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 RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 255617 AND Type_ = 10;
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 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 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 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 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' WHERE SecCode = 306178 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'FCCTO.PK^J25' WHERE SecCode = 306179 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 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 ISIN = 'CA48730E1051', SEDOL = 'BSNMLL', CUSIP = '48730E10' WHERE SecCode = 321708 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueCode = 65625.0 WHERE SecCode = 324866 AND Type_ = 10;
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 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 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 RkdIssueStatus = 0 WHERE SecCode = 362805 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'ETHY', RIC = 'ETHY.ASE', DisplayRIC = 'ETHY.ASE' WHERE SecCode = 370942 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 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 CUSIP = 'M8T23S11' WHERE SecCode = 396044 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 RIC = 'CRZK.F', DisplayRIC = 'CRZK.F', RkdExchCode = 'FRA' WHERE SecCode = 427461 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y0337319' WHERE SecCode = 483868 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'P5799112' WHERE SecCode = 519382 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 RkdIssueStatus = 0 WHERE SecCode = 532619 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 RkdIssueStatus = 0 WHERE SecCode = 545500 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y9003510' WHERE SecCode = 548535 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 RkdIssueStatus = 0 WHERE SecCode = 557267 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 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 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 ISIN = 'KYG4772A1168', SEDOL = 'BVK6JT', CUSIP = 'G4772A11' WHERE SecCode = 788509 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 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 RIC = 'ALPA.SI', DisplayRIC = 'ALPA.SI' WHERE SecCode = 888232 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y3R17R10' WHERE SecCode = 890632 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE045J01034', SEDOL = 'BMDJ6L', CUSIP = 'Y2494F15' WHERE SecCode = 1024298 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 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 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 CUSIP = 'Q6250E10' WHERE SecCode = 1222836 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 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 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 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 CUSIP = 'M7S38D11' WHERE SecCode = 1635419 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q5376717' WHERE SecCode = 1664403 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '9386.T^K25' WHERE SecCode = 1665211 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 ISIN = 'AU0000422388', Ticker = 'JAVDH', SEDOL = 'BVBM53', RIC = 'JAVDH.AX', DisplayRIC = 'JAVDH.AX' WHERE SecCode = 1712306 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 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 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'KDST.TA^K25' WHERE SecCode = 2267530 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 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 PrimaryIssueCode = 95391.0 WHERE SecCode = 2349785 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'AU0000421455', Ticker = 'ENXDA', SEDOL = 'BVZKYZ', RIC = 'ENXDA.AX', DisplayRIC = 'ENXDA.AX' WHERE SecCode = 2372641 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 = 0, RIC = 'PLUND.ST^K25' WHERE SecCode = 2383400 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 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 ISIN = 'IT0005654766', SEDOL = 'BSY6DM', CUSIP = 'T3R4KC12' WHERE SecCode = 2555896 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 RkdIssueStatus = 0, Ticker = NULL, RIC = '8363.HK^K25' WHERE SecCode = 2655880 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 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 ISIN = 'FI4000592282', SEDOL = 'BSRJ2K', CUSIP = 'X869A610' WHERE SecCode = 2880948 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 = '3136.SP^K25' WHERE SecCode = 2909882 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 Ticker = 'TRA', RIC = 'TRA.MC', DisplayRIC = 'TRA.MC' WHERE SecCode = 2946507 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 ISIN = 'INE671K01027', SEDOL = 'BS81L2', CUSIP = 'Y8303M10' WHERE SecCode = 2963532 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 Ticker = 'AXX', RIC = 'AXXJ.J', DisplayRIC = 'AXXJ.J' WHERE SecCode = 3011222 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y0928N13' WHERE SecCode = 3048286 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = '3326.HK^K25' WHERE SecCode = 3055015 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'NO0013685750', SEDOL = 'BTSL30', CUSIP = 'R1R76R25' WHERE SecCode = 3067176 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 ISIN = 'INE314T01033', SEDOL = 'BVZG2V', CUSIP = 'Y2740H15' WHERE SecCode = 3109824 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 3119749 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 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 PrimaryIssueCode = 96794.0 WHERE SecCode = 3177804 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'BRANDB.NGM^I25' 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 RkdIssueStatus = 0, RIC = 'PROC.SI^I25' WHERE SecCode = 3213375 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 RkdIssueStatus = 0 WHERE SecCode = 3247487 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 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 RkdIssueStatus = 0, RIC = 'ALPH.L^K25' WHERE SecCode = 3321165 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueCode = 103599.0 WHERE SecCode = 3327053 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'G3392H10' WHERE SecCode = 3370825 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 RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 3392104 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 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', CUSIP = 'Y2688F14' 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 RIC = '9388.FU', DisplayRIC = '9388.FU', RkdExchCode = 'FUK' WHERE SecCode = 3402118 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueCode = 114558.0 WHERE SecCode = 3403629 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 RkdIssueStatus = 0, RIC = 'TOPR.NGM^J25' WHERE SecCode = 3409194 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 RkdIssueStatus = 0, Ticker = NULL, RIC = '1730.HK^K25' WHERE SecCode = 3416767 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 RkdIssueStatus = 0, RIC = 'HRCW.CO^K25' WHERE SecCode = 3434717 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'KYG7396H1442', SEDOL = 'BW9MHD', CUSIP = 'G7396H14' WHERE SecCode = 3434993 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 PrimaryIssueType = 'PVT' WHERE SecCode = 3493632 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 RkdIssueStatus = 0, RIC = 'VN8.AX^J25' WHERE SecCode = 3518226 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 RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 3537017 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 ISIN = 'INE467X01023', SEDOL = 'BV2FG0', CUSIP = 'Y7T16H10' WHERE SecCode = 3587036 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 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' WHERE SecCode = 3656302 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'GRAN.SI^K25' WHERE SecCode = 3740588 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'V0192K10' WHERE SecCode = 3741443 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 RIC = 'TUFG.DE', DisplayRIC = 'TUFG.DE', RkdExchCode = 'ETR' WHERE SecCode = 3796394 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 RkdIssueStatus = 0, Ticker = NULL, RIC = '2060.HK^J25' WHERE SecCode = 3845929 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 Ticker = 'YHTI', RIC = 'YHTI.MC', DisplayRIC = 'YHTI.MC' WHERE SecCode = 3885199 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'HANGJI.CY^I25' WHERE SecCode = 3948975 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078R0' WHERE SecCode = 3948980 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 ISIN = 'CNE1000076Q6', CUSIP = 'Y2S37710' 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', CUSIP = 'Y1571T10' WHERE SecCode = 4033055 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078W0' WHERE SecCode = 4033061 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000076S2', CUSIP = 'Y709Y810' 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', CUSIP = 'Y3033L10' WHERE SecCode = 4040150 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000076T0', CUSIP = 'Y4S3R810' WHERE SecCode = 4040153 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000076W4', CUSIP = 'Y0S73010' WHERE SecCode = 4054127 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000076X2', CUSIP = 'Y7T8GA10' WHERE SecCode = 4054381 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 4109394 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000076Y0', CUSIP = 'Y973C010' WHERE SecCode = 4129798 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000076Z7', CUSIP = 'Y7S0B910' WHERE SecCode = 4163629 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007705', CUSIP = 'Y990EK10' WHERE SecCode = 4168437 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007713', CUSIP = 'Y3R6TR10' WHERE SecCode = 4178606 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007721', CUSIP = 'Y901LY10' WHERE SecCode = 4178864 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 ISIN = 'CNE1000078X8' WHERE SecCode = 4291234 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 CUSIP = 'Y238AN10' 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 Ticker = 'FOAMIT', RIC = 'FOAMIT.HE', DisplayRIC = 'FOAMIT.HE' WHERE SecCode = 4348233 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007739', CUSIP = 'Y990ER10' 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 ISIN = 'CNE100007747', CUSIP = 'Y669C410' WHERE SecCode = 4383292 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007754', CUSIP = 'Y990EL10' 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', CUSIP = 'Y129TB10' 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', CUSIP = 'Y2122D10' WHERE SecCode = 4390249 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007788', CUSIP = 'Y6306A10' WHERE SecCode = 4394706 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007796', CUSIP = 'Y973BZ10' WHERE SecCode = 4395427 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077B6', CUSIP = 'Y196DG10' WHERE SecCode = 4403967 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077D2', CUSIP = 'Y293BC10' WHERE SecCode = 4408311 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077C4', CUSIP = 'Y445W010' 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 ISIN = 'CNE1000077F7', CUSIP = 'Y603L510' 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', CUSIP = 'Y990EQ10' WHERE SecCode = 4423819 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077H3', CUSIP = 'Y092MA10' WHERE SecCode = 4429526 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', CUSIP = 'Y445VZ10' 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 RkdIssueStatus = 0, RIC = 'DORE.L^K25' WHERE SecCode = 4440344 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077K7', CUSIP = 'Y3046010' WHERE SecCode = 4441387 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078S8' WHERE SecCode = 4443967 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077L5', CUSIP = 'Y9544G10' WHERE SecCode = 4443968 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077M3', CUSIP = 'Y971KS10' WHERE SecCode = 4444668 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 ISIN = 'CNE1000077N1', CUSIP = 'Y257M310' WHERE SecCode = 4449609 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077P6', CUSIP = 'Y2649D10' 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', CUSIP = 'Y013MM10' WHERE SecCode = 4453360 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077R2', CUSIP = 'Y445VY10' WHERE SecCode = 4456233 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077S0', CUSIP = 'Y990EN10' 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 ISIN = 'CNE1000077T8', CUSIP = 'Y9261610' WHERE SecCode = 4484327 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077V4', CUSIP = 'Y130LC10' WHERE SecCode = 4495551 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q902A010' WHERE SecCode = 4496725 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 ISIN = 'CNE1000077W2', CUSIP = 'Y774TR10' WHERE SecCode = 4524355 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 ISIN = 'INE418L01047', SEDOL = 'BSSB76', CUSIP = 'Y6S13X12' WHERE SecCode = 4542550 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000077X0', CUSIP = 'Y2S37910' WHERE SecCode = 4546440 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 Ticker = 'UFBL', RIC = 'UITF.NS', DisplayRIC = 'UITF.NS' WHERE SecCode = 4557787 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = NULL 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 ISIN = 'CNE1000077Y8', CUSIP = 'Y7011R10' WHERE SecCode = 4598587 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'SOZAP.ST^K25' WHERE SecCode = 4616797 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'GRAO3.SA^I25' WHERE SecCode = 4624288 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 4638891 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', CUSIP = 'Y6T03D10' WHERE SecCode = 4641478 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007804', CUSIP = 'Y774TQ10' 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 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 RkdIssueStatus = 0, RIC = 'CARZ.KL^J25' WHERE SecCode = 4693638 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 CUSIP = 'Q9162S10' WHERE SecCode = 4777362 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'KES.VI^J25' WHERE SecCode = 4806715 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', CUSIP = 'G933RZ10' WHERE SecCode = 4815285 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 ISIN = 'CNE100007812', CUSIP = 'Y013ML10' 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 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 RkdIssueStatus = 0, RIC = 'RIGHTB.ST^I25' WHERE SecCode = 4895650 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q1636X10' WHERE SecCode = 4898106 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078T6' WHERE SecCode = 4918591 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078V2' WHERE SecCode = 4970744 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 RkdIssueStatus = 0, RIC = '9224.T^I25' WHERE SecCode = 5022239 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 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 = 'FIN' WHERE SecCode = 5155321 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 CUSIP = 'Q1R28A10' WHERE SecCode = 5261360 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'S247.L^K25' WHERE SecCode = 5275348 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 RkdIssueStatus = 0, RIC = '7117.T^I25' WHERE SecCode = 5316694 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 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 RkdIssueStatus = 0, RIC = '7163.T^I25' WHERE SecCode = 5380510 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueCode = 136857.0 WHERE SecCode = 5430796 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007820', CUSIP = 'Y1519Z10' WHERE SecCode = 5434296 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007838', CUSIP = 'Y990EM10' WHERE SecCode = 5437844 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q6747211' WHERE SecCode = 5443484 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007846', CUSIP = 'Y293BD10' WHERE SecCode = 5453394 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007853', CUSIP = 'Y774TS10' WHERE SecCode = 5466115 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007861', CUSIP = 'Y312GT10' WHERE SecCode = 5473213 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007879', CUSIP = 'Y7T8GB10' 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', CUSIP = 'Y832F110' WHERE SecCode = 5478195 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007895', CUSIP = 'Y9544F10' WHERE SecCode = 5479901 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078B4', CUSIP = 'Y971KR10' WHERE SecCode = 5482519 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078C2', CUSIP = 'Y0S73110' 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', CUSIP = 'Y1R9TJ10' WHERE SecCode = 5498252 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078F5', CUSIP = 'Y774TT10' WHERE SecCode = 5499288 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078G3', CUSIP = 'Y832F210' WHERE SecCode = 5500262 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'CAVT.MZ^J25' WHERE SecCode = 5604429 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'SBAR', RIC = 'SBAR.L', DisplayRIC = 'SBAR.L', RkdExchCode = 'LON' WHERE SecCode = 5616087 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = '7730.TW', DisplayRIC = '7730.TW', RkdExchCode = 'TPE' WHERE SecCode = 5691155 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 RkdIssueStatus = 0, RIC = 'TLT.AS^I25' WHERE SecCode = 5816808 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 ISIN = 'CNE1000074S7', CUSIP = 'Y9804U10' WHERE SecCode = 5883249 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 5886937 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078H1', CUSIP = 'Y7T92410' 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', CUSIP = 'Y768TY10' WHERE SecCode = 5903111 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000078K5', CUSIP = 'Y990EP10' 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', CUSIP = 'Y4108U10' 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 RIC = '7788.TW', DisplayRIC = '7788.TW', RkdExchCode = 'TPE' WHERE SecCode = 5974237 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 RkdIssueStatus = 0, Ticker = 'ONCOI', RIC = 'ONCOI.OL^J25', DisplayRIC = 'ONCOI.OL' WHERE SecCode = 6039856 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6082594 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6128250 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 PrimaryIssueType = 'EQU' WHERE SecCode = 6205859 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6205870 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 = 'IND' WHERE SecCode = 6253475 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 = 'IND' WHERE SecCode = 6318887 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6339507 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6341752 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 CUSIP = 'Y709P511' WHERE SecCode = 6363468 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000074V1', CUSIP = 'Y312GC10' WHERE SecCode = 6371482 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE1000074W9', CUSIP = 'Y897S510' WHERE SecCode = 6379417 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 = 'IND' WHERE SecCode = 6434972 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 ISIN = 'CNE1000078M1', CUSIP = 'Y7694710', 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 COATypeCode = 'IND' WHERE SecCode = 6448554 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 CUSIP = 'J3649110' WHERE SecCode = 6450912 AND Type_ = 10;
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 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 ISIN = 'CA5495465059', SEDOL = 'BV2JDL', CUSIP = '54954650' WHERE SecCode = 10911585 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 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 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 ISIN = 'CA73015G1046', SEDOL = 'BRJJYV', CUSIP = '73015G10' WHERE SecCode = 10933062 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'FFH_pg.TO^J25' WHERE SecCode = 10965490 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 Ticker = 'SCMI', RIC = 'SCMI.V', DisplayRIC = 'SCMI.V', RkdExchCode = 'CVE' WHERE SecCode = 10968943 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 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 Ticker = 'YAK.H', RIC = 'YAKh.V', DisplayRIC = 'YAKh.V', RkdExchCode = 'NEX' WHERE SecCode = 10987445 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'RCG_pb.TO^K25' WHERE SecCode = 10988744 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 ISIN = 'US8173234050', SEDOL = 'BVBHF9', CUSIP = '81732340', ShPerListing = 100.0 WHERE SecCode = 11002303 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 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 ISIN = 'US9630257965', SEDOL = 'BLDCLW', CUSIP = '96302579' WHERE SecCode = 11015187 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 11019126 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', SEDOL = 'BSLN6J', CUSIP = '27985210', RIC = 'EDCU.V', DisplayRIC = 'EDCU.V' WHERE SecCode = 11025361 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 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 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 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 Ticker = 'SINC', RIC = 'SINC.PK', DisplayRIC = 'SINC.PK' WHERE SecCode = 11037266 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 ISIN = 'CA6857881016', SEDOL = 'BVBQT2', CUSIP = '68578810' WHERE SecCode = 11045015 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdExchCode = 'NA', RkdExchCtry = NULL WHERE SecCode = 11061807 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 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 RIC = 'CARM.PK', DisplayRIC = 'CARM.PK', RkdExchCode = 'OTC' WHERE SecCode = 11129194 AND Type_ = 1;
UPDATE data_universe_rkd SET ShPerListing = 250.0 WHERE SecCode = 11131840 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11136748 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 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 RkdIssueStatus = 0, RIC = 'EPIX.OQ^J25' WHERE SecCode = 11144375 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 ISIN = 'US0813605054', Ticker = 'BMXCD', SEDOL = 'BVV57C', CUSIP = '08136050', RIC = 'BMXCD.PK', DisplayRIC = 'BMXCD.PK' WHERE SecCode = 11146482 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 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 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 Ticker = 'LTPVQ', RIC = 'LTPVQ.PK', DisplayRIC = 'LTPVQ.PK' WHERE SecCode = 11155169 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 RkdIssueID = 9, RkdIssueCode = 138800, RkdIssueOrder = 4 WHERE SecCode = 11161389 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'VRNA.OQ^J25' WHERE SecCode = 11171830 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 RIC = NULL, PrimaryIssueType = 'PVT' WHERE SecCode = 11174027 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 ISIN = 'VGG752711330', SEDOL = 'BSLN60', CUSIP = 'G7527113' WHERE SecCode = 11176237 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 ISIN = 'CA88831L2021', SEDOL = 'BSLN6F', 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 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 ISIN = 'CA0500591049', SEDOL = 'BTZP31', CUSIP = '05005910' WHERE SecCode = 11181676 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 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 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 PrimaryIssueType = 'PVT' WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA95827R2000', SEDOL = 'BTJXR0', CUSIP = '95827R20' WHERE SecCode = 11189820 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 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 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 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 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 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'ETNB.OQ^J25' WHERE SecCode = 11202140 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'AND.TO^K25' WHERE SecCode = 11203092 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA36315L1076', Ticker = 'GGAU', SEDOL = 'BVSWF4', CUSIP = '36315L10', RIC = 'GGAU.V', DisplayRIC = 'GGAU.V' WHERE SecCode = 11203364 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 ISIN = 'CA69867J2048', SEDOL = 'BTMJPL', CUSIP = '69867J20' WHERE SecCode = 11204720 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', SEDOL = 'BSLN5R', CUSIP = '00702588' WHERE SecCode = 11207780 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 PrimaryIssueType = 'PVT' WHERE SecCode = 11209704 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 PrimaryIssueType = 'PVT' WHERE SecCode = 11210480 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 Ticker = 'AMBIQ', SEDOL = NULL, RIC = 'AMBIQ.PK', DisplayRIC = 'AMBIQ.PK', RkdExchCode = 'OTC' WHERE SecCode = 11212108 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 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 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 Ticker = 'KUKEY', SEDOL = NULL, RIC = 'KUKEY.PK', DisplayRIC = 'KUKEY.PK', RkdExchCode = 'OTC' WHERE SecCode = 11217325 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11217686 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, SEDOL = NULL, RIC = 'TIXT.TO^K25', DisplayRIC = 'TIXT.TO^K25' WHERE SecCode = 11218641 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 = 'US92339H1014', SEDOL = 'BTJY2J', CUSIP = '92339H10' WHERE SecCode = 11219488 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 ISIN = 'US62459M3051', SEDOL = 'BTMJL3', CUSIP = '62459M30' WHERE SecCode = 11221473 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 11221887 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11221982 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 ISIN = 'CA5910882086', SEDOL = 'BVPWCQ', CUSIP = '59108820' WHERE SecCode = 11222521 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 11222694 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'HECO.CD^K25' WHERE SecCode = 11225503 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 Ticker = 'ULIX', RIC = 'ULIX.PK', DisplayRIC = 'ULIX.PK' WHERE SecCode = 11228508 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'AVDX.OQ^J25' WHERE SecCode = 11232126 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA8279241019', Ticker = 'SICO', SEDOL = 'BTJXR5', CUSIP = '82792410', RIC = 'SICO.V', DisplayRIC = 'SICO.V' WHERE SecCode = 11232250 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 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 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', SEDOL = 'BSMLKZ', CUSIP = 'G4465R12' WHERE SecCode = 11236809 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'CFSB.OQ^K25' WHERE SecCode = 11236999 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 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 ISIN = 'US0008472021', SEDOL = 'BSLN5L', 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 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 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 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 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 ISIN = 'US27877D2036', SEDOL = 'BQT3HR', CUSIP = '27877D20' WHERE SecCode = 11248018 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 PrimaryIssueType = 'PVT' WHERE SecCode = 11249078 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 Ticker = 'NIOB', RIC = 'NIOB.CD', DisplayRIC = 'NIOB.CD' WHERE SecCode = 11249876 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11250023 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 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 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 ISIN = 'KYG351501385', SEDOL = 'BLDCLZ', CUSIP = 'G3515013' WHERE SecCode = 11256200 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 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 RIC = NULL, PrimaryIssueType = 'PVT' WHERE SecCode = 11262355 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 ISIN = 'US3439273075', SEDOL = 'BTJW95', CUSIP = '34392730' WHERE SecCode = 11265881 AND Type_ = 1;
UPDATE data_universe_rkd SET ShPerListing = 12.0 WHERE SecCode = 11267607 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' 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 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 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 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 PrimaryIssueType = 'EQU' WHERE SecCode = 11270950 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US42727R2031', Ticker = 'IPST', SEDOL = 'BVSWCC', CUSIP = '42727R20', RIC = 'IPST.O', DisplayRIC = 'IPST.OQ' WHERE SecCode = 11271912 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 Ticker = 'UCFI', RIC = 'UCFI.O', DisplayRIC = 'UCFI.OQ' WHERE SecCode = 11274801 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 = 'IND' WHERE SecCode = 11276362 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11277132 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11277553 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11277668 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11277924 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 Ticker = 'PASW', RIC = 'PASW.O', DisplayRIC = 'PASW.OQ' WHERE SecCode = 11280999 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 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 = 11284225 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11284287 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;