UPDATE data_universe_rkd SET ShPerListing = 33743217.0 WHERE SecCode = 7197 AND Type_ = 1; UPDATE data_universe_rkd SET DisplayRIC = 'FITB.N', RkdExchCode = 'NYSE' WHERE SecCode = 26099 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'REBRISA-B.SN', DisplayRIC = 'REBRISA-B.SN' WHERE SecCode = 27616 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'REBRISA-A.SN', DisplayRIC = 'REBRISA-A.SN' WHERE SecCode = 27655 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'EMBONOR-A.SN', DisplayRIC = 'EMBONOR-A.SN' WHERE SecCode = 27668 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'AGUAS-A.SN', DisplayRIC = 'AGUAS-A.SN' WHERE SecCode = 28629 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'ANDINA-A.SN', DisplayRIC = 'ANDINA-A.SN' WHERE SecCode = 28640 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'ANDINA-B.SN', DisplayRIC = 'ANDINA-B.SN' WHERE SecCode = 28641 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'ESVAL-A.SN', DisplayRIC = 'ESVAL-A.SN' WHERE SecCode = 29108 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'EMBONOR-B.SN', DisplayRIC = 'EMBONOR-B.SN' WHERE SecCode = 29154 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'AGUAS-B.SN', DisplayRIC = 'AGUAS-B.SN' WHERE SecCode = 29162 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'COUNTRY-A.SN', DisplayRIC = 'COUNTRY-A.SN' WHERE SecCode = 30321 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'SQM-B.SN', DisplayRIC = 'SQM-B.SN' WHERE SecCode = 30385 AND Type_ = 10; UPDATE data_universe_rkd SET SEDOL = NULL WHERE SecCode = 30658 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'SQM-A.SN', DisplayRIC = 'SQM-A.SN' WHERE SecCode = 30743 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'IT0005712671', SEDOL = 'BXNT95', CUSIP = 'T9277813' WHERE SecCode = 53292 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 74558 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 83476 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 84036 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 84049 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 85955 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CA47208P2044', CUSIP = '47208P20' WHERE SecCode = 98025 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 99233 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'ETIND', RIC = 'ETIND.NFF', DisplayRIC = 'ETIND.NFF' WHERE SecCode = 104577 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'BYLD.BO', DisplayRIC = 'BYLD.BO' WHERE SecCode = 137019 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'NYOR', RIC = 'NYOR.ST', DisplayRIC = 'NYOR.ST' WHERE SecCode = 141644 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'AVIM.NS', DisplayRIC = 'AVIM.NS' WHERE SecCode = 143094 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 333489 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'ESSBIO-C.SN', DisplayRIC = 'ESSBIO-C.SN' WHERE SecCode = 337125 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 358420 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'ESVAL-C.SN', DisplayRIC = 'ESVAL-C.SN' WHERE SecCode = 375784 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 391857 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'ESSBIO-B.SN', DisplayRIC = 'ESSBIO-B.SN' WHERE SecCode = 492167 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'ESSBIO-A.SN', DisplayRIC = 'ESSBIO-A.SN' WHERE SecCode = 492168 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'CSACOL.CN^F26' WHERE SecCode = 520495 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 866487 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'ESVAL-B.SN', DisplayRIC = 'ESVAL-B.SN' WHERE SecCode = 1231990 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'COLCRAIG-B.SN', DisplayRIC = 'COLCRAIG-B.SN' WHERE SecCode = 1425684 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'POTASIOS-A.SN', DisplayRIC = 'POTASIOS-A.SN' WHERE SecCode = 1488277 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'POTASIOS-B.SN', DisplayRIC = 'POTASIOS-B.SN' WHERE SecCode = 1493776 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 1641477 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'FR00140182K6', SEDOL = 'BQS7SF', CUSIP = 'F9867T37' WHERE SecCode = 2580216 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'SE0029279066', SEDOL = 'BVY45M', CUSIP = 'W3398U19' WHERE SecCode = 3174282 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'AU000000IS34', Ticker = 'IS3', SEDOL = 'BZ13FV', CUSIP = 'Q4978J10', RIC = 'IS3.AX', DisplayRIC = 'IS3.AX' WHERE SecCode = 3319350 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'SE0029301191', SEDOL = 'BVMWDM', CUSIP = 'W9821U10' WHERE SecCode = 4524561 AND Type_ = 10; UPDATE data_universe_rkd SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'FRACCION-X.SN', DisplayRIC = 'FRACCION-X.SN' WHERE SecCode = 5760059 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'VIBE', SEDOL = 'BT9QVK', RIC = 'VIBE.CD', DisplayRIC = 'VIBE.CD', RkdExchCode = 'CNQ', RkdExchCtry = 'CAN' WHERE SecCode = 5885543 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'R1R56V10' WHERE SecCode = 6474420 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6694374 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'HMMC.TO', DisplayRIC = 'HMMC.TO', RkdExchCode = 'TSE' WHERE SecCode = 10776460 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'WNFT', RIC = 'WNFT.PK', DisplayRIC = 'WNFT.PK' WHERE SecCode = 11021638 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'VIBE', SEDOL = 'BT9QVK', RIC = 'VIBE.CD', DisplayRIC = 'VIBE.CD', RkdExchCode = 'CNQ', RkdExchCtry = 'CAN' WHERE SecCode = 11024402 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'BOTX', RIC = 'BOTX.PK', DisplayRIC = 'BOTX.PK' WHERE SecCode = 11166544 AND Type_ = 1; UPDATE data_universe_rkd SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US0209522061', CUSIP = '02095220' WHERE SecCode = 11232929 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'SLBT', DisplayRIC = 'SLBT.OQ' WHERE SecCode = 11274684 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11294781 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11295152 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11296509 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11297059 AND Type_ = 1;