UPDATE data_universe_rkd SET ShPerListing = 33743217.0 WHERE SecCode = 7197 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1, ISIN = 'GB00BVPJB942', Ticker = 'FGTA', SEDOL = 'BVPJB9', CUSIP = 'G6045F13', RIC = 'FGTAa.L', DisplayRIC = 'FGTAa.L' WHERE SecCode = 7679 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'CTHRQ', RIC = 'CTHRQ.PK', DisplayRIC = 'CTHRQ.PK' WHERE SecCode = 13507 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 31905 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 31907 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 31908 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 31909 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 31910 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'RWAX', RIC = 'RWAX.PK', DisplayRIC = 'RWAX.PK' WHERE SecCode = 35340 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 39905 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 52483 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE416A01051', SEDOL = 'BVY6FX', CUSIP = 'Y0194V10' WHERE SecCode = 72629 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'SOLG.L^C26' WHERE SecCode = 143539 AND Type_ = 10; UPDATE data_universe_rkd SET RkdListingType = 'GSR' WHERE SecCode = 297859 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'VGG041JN1487', SEDOL = 'BSHWN2', CUSIP = 'G041JN14' WHERE SecCode = 334615 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'CMHM.ST^C26' WHERE SecCode = 3317156 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'INTE.ST^C26' WHERE SecCode = 4627915 AND Type_ = 10; UPDATE data_universe_rkd SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '450940.KQ^C26' WHERE SecCode = 5481068 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6567906 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CA83058E1060', Ticker = 'SKEL', SEDOL = 'BSHX2N', CUSIP = '83058E10', RIC = 'SKEL.V', DisplayRIC = 'SKEL.V' WHERE SecCode = 10922742 AND Type_ = 1; UPDATE data_universe_rkd SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'ILAL', RIC = 'ILAL.PK', DisplayRIC = 'ILAL.PK' WHERE SecCode = 11194625 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'KYG720071599', SEDOL = 'BW5TRX', CUSIP = 'G7200715' WHERE SecCode = 11195616 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'TIRXF', RIC = 'TIRXF.PK', DisplayRIC = 'TIRXF.PK', RkdExchCode = 'OTC' WHERE SecCode = 11218211 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'VTYX.OQ^C26' WHERE SecCode = 11232550 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'APLV.CD^C26' WHERE SecCode = 11237202 AND Type_ = 1; UPDATE data_universe_rkd SET RkdCode = 143745, RkdIssueCode = 184502, RkdIssueStatus = 1, ISIN = 'US5309092097', Ticker = 'LLYVB', SEDOL = 'BS2FSN', CUSIP = '53090920', RIC = 'LLYVB.PK' WHERE SecCode = 11256102 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US74102N1019', SEDOL = 'BVWQGS', CUSIP = '74102N10' WHERE SecCode = 11270085 AND Type_ = 1; UPDATE data_universe_rkd SET RkdListingType = 'OSR' WHERE SecCode = 11278832 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11290954 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11292078 AND Type_ = 1;