UPDATE data_universe_rkd SET ISIN = 'KYG200801002', SEDOL = 'BNVVWV', CUSIP = 'G2008010' WHERE SecCode = 13989 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'PTNT3.SA^F26' WHERE SecCode = 30213 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'PTNT4.SA^F26' WHERE SecCode = 30235 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'KMAG.PK^F26' WHERE SecCode = 39104 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 39896 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'MED6.PA^F26' WHERE SecCode = 55789 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'PRA.N^F26' WHERE SecCode = 57487 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'CCAP', RIC = 'CCAPC.S', DisplayRIC = 'CCAPC.S' WHERE SecCode = 65128 AND Type_ = 10; UPDATE data_universe_rkd SET SEDOL = 'BRSCTT' WHERE SecCode = 74536 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = '0724.HK^F26' WHERE SecCode = 76880 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '2686.T^F26' WHERE SecCode = 78460 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = '600696.SS^F26' WHERE SecCode = 82584 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 90518 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'RELI.PSX^F26' WHERE SecCode = 93811 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '7922.T^F26' WHERE SecCode = 94669 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '6403.T^F26' WHERE SecCode = 96476 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'AIMAX', RIC = 'AIMA.KL', DisplayRIC = 'AIMA.KL' WHERE SecCode = 112408 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '5856.T^F26' WHERE SecCode = 115380 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'AROM.BB^F26' WHERE SecCode = 136156 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'TOE.AX^F26' WHERE SecCode = 143655 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Q4281Q10' WHERE SecCode = 144424 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 188902 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'MAU.AX^F26' WHERE SecCode = 206733 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 255424 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 323478 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Q2887Z16' WHERE SecCode = 336664 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SLTP.WA^F26' WHERE SecCode = 345666 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'VNE.HM^F26' WHERE SecCode = 522937 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 556020 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'UNFC.BJ^F26' WHERE SecCode = 1459417 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'HHR.AX^F26' WHERE SecCode = 1476676 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'MID', RIC = 'MIDP.WA', DisplayRIC = 'MIDP.WA' WHERE SecCode = 2132979 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'DTI.AX^F26' WHERE SecCode = 2693646 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 2696581 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'DDG.HN^F26' WHERE SecCode = 3703402 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'JP3264880000', Ticker = '590A', SEDOL = 'BV4G4F', CUSIP = 'J1794K10', RIC = '590A.T', DisplayRIC = '590A.T' WHERE SecCode = 3961764 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'AU0000064578', Ticker = '3DA', SEDOL = 'BKRQJZ', CUSIP = 'U0207410', RIC = '3DA.AX', DisplayRIC = '3DA.AX' WHERE SecCode = 4036738 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '4494.T^F26' WHERE SecCode = 4426889 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 4605810 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'ROBUS.TL^F26' WHERE SecCode = 4969554 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = '4701.SE^F26' WHERE SecCode = 4975833 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '136A.T^F26' WHERE SecCode = 5668353 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6472001 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6590976 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 6626020 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6748880 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 6880029 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'VBB.HNO^F26' WHERE SecCode = 6927579 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6934848 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6939095 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y767UE10', PrimaryIssueType = 'EQU' WHERE SecCode = 6939102 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CNE100007RD8', PrimaryIssueType = 'EQU' WHERE SecCode = 6945359 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6945364 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'OPITQ.PK^F26' WHERE SecCode = 10906768 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 11021715 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 11131810 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'ADAD.PK^F26' WHERE SecCode = 11147394 AND Type_ = 1; UPDATE data_universe_rkd SET ShPerListing = 50.0 WHERE SecCode = 11154766 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA83208H1082', Ticker = 'SMWE', SEDOL = 'BNVVVH', CUSIP = '83208H10', RIC = 'SMWE.V', DisplayRIC = 'SMWE.V' WHERE SecCode = 11178978 AND Type_ = 1; UPDATE data_universe_rkd SET SEDOL = 'BTH26L' WHERE SecCode = 11201544 AND Type_ = 1; UPDATE data_universe_rkd SET SEDOL = 'BTH26Q' WHERE SecCode = 11205267 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA03790W1077', SEDOL = 'BVSRPF', CUSIP = '03790W10' WHERE SecCode = 11214004 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 11216267 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'KYG9411M1574', SEDOL = 'BPK46Z', CUSIP = 'G9411M15' WHERE SecCode = 11222087 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11223644 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'CNTA.OQ^F26' WHERE SecCode = 11224780 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'DEVSF', RIC = 'DEVSF.PK', DisplayRIC = 'DEVSF.PK', RkdExchCode = 'OTC' WHERE SecCode = 11235980 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US85238K1007', Ticker = 'USDE', SEDOL = 'BTH299', CUSIP = '85238K10', RIC = 'USDE.O', DisplayRIC = 'USDE.OQ', RkdExchCode = 'NASD' WHERE SecCode = 11237342 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11264556 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA66661M1023', Ticker = 'NMB', SEDOL = 'BWTYQX', CUSIP = '66661M10', RIC = 'NMB.V', DisplayRIC = 'NMB.V' WHERE SecCode = 11266759 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'JMG.A^F26' WHERE SecCode = 11289286 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11296311 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, PrimaryIssueType = 'IPO' WHERE SecCode = 11297269 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1, Ticker = 'MRCL', SEDOL = 'BPK47B', RIC = 'MRCL.PK', DisplayRIC = 'MRCL.PK', RkdExchCode = 'OTC' WHERE SecCode = 11297605 AND Type_ = 1;