UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'CFIN.PK^F26' WHERE SecCode = 14577 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 31501 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'mvzm' WHERE SecCode = 49805 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'D1178M10' WHERE SecCode = 51554 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '7229.T^F26' WHERE SecCode = 69402 AND Type_ = 10;
UPDATE data_universe_rkd SET ShPerListing = 0.08333 WHERE SecCode = 82759 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Q1714E10' WHERE SecCode = 83612 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '7999.T^F26' WHERE SecCode = 89948 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'BMG2125A3043', SEDOL = 'BXGT6V', CUSIP = 'G2125A30' WHERE SecCode = 90242 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'TEA.H', RIC = 'TEAh.V', DisplayRIC = 'TEAh.V', RkdExchCode = 'NEX' WHERE SecCode = 99954 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 100359 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdExchCode = 'TSE', RkdExchCtry = 'CAN' WHERE SecCode = 100361 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'dorf' WHERE SecCode = 101069 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'yars' WHERE SecCode = 102229 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'pmzv' WHERE SecCode = 102413 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'comz' WHERE SecCode = 102537 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'poek' WHERE SecCode = 102628 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'ptpap' WHERE SecCode = 102635 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'pzkmp' WHERE SecCode = 102637 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'pzkm' WHERE SecCode = 102642 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'uzem' WHERE SecCode = 102737 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'elar' WHERE SecCode = 102983 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'nsng' WHERE SecCode = 103159 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'galo' WHERE SecCode = 103162 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'msbo' WHERE SecCode = 103818 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'kabep' WHERE SecCode = 104425 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'WIMP.NS^F26' WHERE SecCode = 142567 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'atlm' WHERE SecCode = 519169 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'atlmp' WHERE SecCode = 519171 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'acbk' WHERE SecCode = 519564 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'benrp' WHERE SecCode = 534984 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'EVOL.SI', DisplayRIC = 'EVOL.SI' WHERE SecCode = 549697 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'SHR', RIC = 'SHRS.L', DisplayRIC = 'SHRS.L' WHERE SecCode = 551009 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'gybb' WHERE SecCode = 554246 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'fpbn' WHERE SecCode = 557679 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'KYG9375G1626', SEDOL = 'BW7YYW', CUSIP = 'G9375G16' WHERE SecCode = 703142 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'acnd' WHERE SecCode = 703147 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'bchv' WHERE SecCode = 703153 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'mlnk' WHERE SecCode = 703177 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'pgmt' WHERE SecCode = 703186 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'brarp' WHERE SecCode = 703218 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'uramp' WHERE SecCode = 703232 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'ritm' WHERE SecCode = 703239 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'vorgp' WHERE SecCode = 703254 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'kbkc' WHERE SecCode = 703288 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'gtngp' WHERE SecCode = 703302 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'iznm' WHERE SecCode = 703308 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'ktyr' WHERE SecCode = 703310 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'krgmp' WHERE SecCode = 703385 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'zsgp' WHERE SecCode = 703440 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'oksa' WHERE SecCode = 703484 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'bstdp' WHERE SecCode = 706299 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'SCCMM', RIC = 'SCCMM.MC', DisplayRIC = 'SCCMM.MC' WHERE SecCode = 940796 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'vorg' WHERE SecCode = 1012880 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '140910.KS^F26' WHERE SecCode = 1226331 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'pekrp' WHERE SecCode = 1538563 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'uram' WHERE SecCode = 1631784 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'kzmk' WHERE SecCode = 1631787 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'ymnp' WHERE SecCode = 1631802 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'nefzp' WHERE SecCode = 1631808 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'btsmp' WHERE SecCode = 1631813 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'okesp' WHERE SecCode = 1631816 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'tatf' WHERE SecCode = 1631832 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'elvp' WHERE SecCode = 1631853 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'elvpp' WHERE SecCode = 1631854 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'mstf' WHERE SecCode = 1631885 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'trmz' WHERE SecCode = 1631911 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'uizk' WHERE SecCode = 1631926 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'uizkp' WHERE SecCode = 1631927 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'pbtf' WHERE SecCode = 1631928 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'yasn' WHERE SecCode = 1631976 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'pren' WHERE SecCode = 1631981 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'prenp' WHERE SecCode = 1631982 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'zsme' WHERE SecCode = 1631986 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'akbr' WHERE SecCode = 1632003 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'buthp' WHERE SecCode = 1632019 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'ffsp' WHERE SecCode = 1632024 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'tmpap', SEDOL = NULL WHERE SecCode = 1632047 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'tmhp' WHERE SecCode = 1633675 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'trmzp' WHERE SecCode = 1633677 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'chge' WHERE SecCode = 1647855 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'iznmp' WHERE SecCode = 1673137 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'iskz' WHERE SecCode = 1694050 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'tavrp' WHERE SecCode = 1703167 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'kzkmp' WHERE SecCode = 1703205 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'tafnp' WHERE SecCode = 1705621 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'hmtz' WHERE SecCode = 1708945 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'vngfp' WHERE SecCode = 1713647 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'gips' WHERE SecCode = 1721140 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'gipsp' WHERE SecCode = 1721141 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'ugrb' WHERE SecCode = 2160634 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'kzbg' WHERE SecCode = 2164415 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'plzip' WHERE SecCode = 2217667 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'rkch' WHERE SecCode = 2251490 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'tzkm' WHERE SecCode = 2251493 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'tzkmp' WHERE SecCode = 2251494 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'bzavp' WHERE SecCode = 2251498 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'ozga' WHERE SecCode = 2251500 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'irpap' WHERE SecCode = 2282834 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'tnzr' WHERE SecCode = 2282837 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'tnzrp' WHERE SecCode = 2282838 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'kvet' WHERE SecCode = 2350924 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'kvetp' WHERE SecCode = 2350931 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'tmeup' WHERE SecCode = 2583484 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'kchu' WHERE SecCode = 2601941 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueCode = 96743.0 WHERE SecCode = 2905774 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'sogs' WHERE SecCode = 3213381 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'KEOC', RIC = 'KEOC.ST', DisplayRIC = 'KEOC.ST' WHERE SecCode = 3219525 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'KYG981251260', SEDOL = 'BVMWFD', CUSIP = 'G9812512' WHERE SecCode = 3289743 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'prsk' WHERE SecCode = 3316989 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'TBX0.F^F26' WHERE SecCode = 3339539 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'CULT.MI^F26' WHERE SecCode = 3377791 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'kbvp' WHERE SecCode = 3440258 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'psol' WHERE SecCode = 3501408 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'ESYS.L^F26' WHERE SecCode = 3848178 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'G5413M10' WHERE SecCode = 4511509 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = '688287.SS^F26' WHERE SecCode = 5019011 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '451700.KQ^F26' WHERE SecCode = 5450871 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueCode = NULL WHERE SecCode = 5491796 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'DIAD.MI^F26' WHERE SecCode = 5859846 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'E8S35R14' WHERE SecCode = 6092923 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueCode = 130012.0, RelType = 4.0 WHERE SecCode = 6802675 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'TKU.V^F26' WHERE SecCode = 11028391 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11180183 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'TRUL.CD^F26' WHERE SecCode = 11190437 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA0037352063', SEDOL = 'BTBLDQ', CUSIP = '00373520' WHERE SecCode = 11198984 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA52637P1062', SEDOL = 'BSGZH0', CUSIP = '52637P10' WHERE SecCode = 11199570 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA0529421095', Ticker = 'AREE', SEDOL = 'BVMH71', CUSIP = '05294210', RIC = 'AREE.CD', DisplayRIC = 'AREE.CD' WHERE SecCode = 11243216 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11249078 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdListingType = 'ADR', ISIN = 'US28256A1097', Ticker = 'ENRD', SEDOL = 'BVTD8P', CUSIP = '28256A10', RIC = 'ENRD.O', DisplayRIC = 'ENRD.OQ', RkdExchCode = 'NASD', ShPerListing = 0.0 WHERE SecCode = 11263764 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11295910 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11295942 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdCode = 127802, RkdIssueCode = 161932, RkdIssueStatus = 0, ISIN = NULL, Ticker = 'APCPU', CUSIP = NULL, RIC = 'APCPU.K', DisplayRIC = 'APCPU.N', RkdExchCode = 'NYSE', PrimaryIssueType = 'IPO' WHERE SecCode = 11296309 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueID = 2, RkdIssueCode = 185332, RkdIssueOrder = 2, RkdListingType = NULL, ISIN = NULL, CUSIP = NULL, RIC = 'SPCX.OQ' WHERE SecCode = 11296754 AND Type_ = 1;
