UPDATE data_universe_rkd SET RkdIssueOrder = 4 WHERE SecCode = 4537 AND Type_ = 1; 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 = 'BSYI.PK^I25' WHERE SecCode = 9451 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 10823 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'US74738H4039', Ticker = 'QDMID', SEDOL = 'BSBK2T', CUSIP = '74738H40', RIC = 'QDMID.PK', DisplayRIC = 'QDMID.PK' WHERE SecCode = 18690 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 RkdIssueStatus = 0, RIC = 'BRFS3.SA^I25' WHERE SecCode = 27115 AND Type_ = 10; 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 Ticker = 'GEVI', RIC = 'GEVI.PK', DisplayRIC = 'GEVI.PK' WHERE SecCode = 29687 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'GB00BNKDVV71', SEDOL = 'BNKDVV', CUSIP = 'G5493R12' WHERE SecCode = 31464 AND Type_ = 10; 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 = 0, Ticker = NULL, RIC = 'NHH.MC^I25' WHERE SecCode = 43286 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'US9682353092', Ticker = 'WHLMD', SEDOL = 'BSDZ35', CUSIP = '96823530', RIC = 'WHLMD.PK', DisplayRIC = 'WHLMD.PK' WHERE SecCode = 50157 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'VHC.O', DisplayRIC = 'VHC.OQ', RkdExchCode = 'NASD' WHERE SecCode = 53360 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'PHT.N^I25' WHERE SecCode = 56011 AND Type_ = 1; 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 RkdIssueStatus = 0, RIC = '1757.T^I25' WHERE SecCode = 69984 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SPTN.OQ^I25' WHERE SecCode = 70919 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '9613.T^I25' WHERE SecCode = 71468 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 = 'INE305A01023', SEDOL = 'BVPGMZ' 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 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, 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 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 = '0226.HK^I25' WHERE SecCode = 87347 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'NEXGBINA', RIC = 'NEXI.KL', DisplayRIC = 'NEXI.KL' WHERE SecCode = 91350 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 RkdIssueStatus = 0, RIC = '7451.T^I25' WHERE SecCode = 94005 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Q8506K14' WHERE SecCode = 95744 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 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 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 Ticker = 'TRA.H', RIC = 'TRAh.V', DisplayRIC = 'TRAh.V', RkdExchCode = 'NEX' WHERE SecCode = 98247 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'AU0000421893', Ticker = 'PL9', SEDOL = 'BVBLVK', 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 RIC = 'HNL.DE', DisplayRIC = 'HNL.DE' WHERE SecCode = 99529 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 WHERE SecCode = 100097 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 RkdCode = 17605, RkdIssueCode = 25193 WHERE SecCode = 100845 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 RkdIssueStatus = 0, Ticker = NULL WHERE SecCode = 110311 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'AU0000421851', Ticker = 'ELV', SEDOL = 'BVBM1M', CUSIP = 'Q8329N30', RIC = 'ELV.AX', DisplayRIC = 'ELV.AX' WHERE SecCode = 111747 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 = 'AU0000413502', Ticker = 'OB1DD', SEDOL = 'BTQM15', CUSIP = 'Q9842S24', RIC = 'OB1DD.AX', DisplayRIC = 'OB1DD.AX' WHERE SecCode = 140027 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 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 PrimaryIssueType = 'PVT' WHERE SecCode = 153607 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US92548W2044', Ticker = 'VESTD', SEDOL = 'BV8CKZ', CUSIP = '92548W20', RIC = 'VESTD.PK', DisplayRIC = 'VESTD.PK' WHERE SecCode = 193821 AND Type_ = 1; 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 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 SEDOL = 'BH3T3L', RIC = 'FLNG.K', DisplayRIC = 'FLNG.N', RkdExchCode = 'NYSE', RkdExchCtry = 'USA' WHERE SecCode = 286050 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 = 'COSM.SI^I25' WHERE SecCode = 298972 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'HNW.A^I25' WHERE SecCode = 304979 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 Ticker = 'YDKG', RIC = 'YDKG.O', DisplayRIC = 'YDKG.OQ' WHERE SecCode = 331506 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'DALN.OQ^I25' WHERE SecCode = 336183 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 345744 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US7054842023', Ticker = 'PTOPD', SEDOL = 'BTLP26', CUSIP = '70548420', RIC = 'PTOPD.PK', DisplayRIC = 'PTOPD.PK' 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 RkdIssueStatus = 0, RIC = 'HLHL.SI^I25' WHERE SecCode = 415865 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 ISIN = 'INE814H01029', SEDOL = 'BV2DVP' WHERE SecCode = 536728 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y9003510' WHERE SecCode = 548535 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 557267 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, RIC = 'RNEW11.SA^I25' WHERE SecCode = 774326 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 RIC = 'GRAK.BO', DisplayRIC = 'GRAK.BO' WHERE SecCode = 1175373 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 RkdIssueStatus = 0, RIC = 'PHXM.PA^I25' WHERE SecCode = 2217733 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'GG00BT26K977', SEDOL = 'BT26K9', CUSIP = 'G9519V11' WHERE SecCode = 2240516 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^I25' 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 ISIN = 'INE428B01021', SEDOL = 'BRVVXC' WHERE SecCode = 2380633 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'SCHLR' WHERE SecCode = 2515727 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 2529065 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 = 'EFIDq.L^I25' WHERE SecCode = 2860623 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 RkdIssueStatus = 0, RIC = 'APAX.L^I25' WHERE SecCode = 2915745 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 PrimaryIssueCode = 108321.0 WHERE SecCode = 3156046 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, RIC = 'PROC.SI^I25' WHERE SecCode = 3213375 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 Ticker = 'EWICAP', RIC = 'EWIC.KL', DisplayRIC = 'EWIC.KL' WHERE SecCode = 3319768 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 ISIN = 'INE219Y01026', SEDOL = 'BSSB6X' WHERE SecCode = 3396332 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 = '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 RkdIssueStatus = 0, RIC = '2750.TWO^I25' WHERE SecCode = 3571379 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 RkdIssueStatus = 0, RIC = '3497.T^I25' WHERE SecCode = 3634457 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 RkdIssueStatus = 0, RIC = 'NPAPER.ST^I25' WHERE SecCode = 4388410 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 = 'INE418L01047', SEDOL = 'BSSB76' WHERE SecCode = 4542550 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 4590515 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'GRAO3.SA^I25' WHERE SecCode = 4624288 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 RIC = 'DMRE.BO', DisplayRIC = 'DMRE.BO' WHERE SecCode = 4796251 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 RkdIssueStatus = 0, RIC = 'LLL.AX^I25' WHERE SecCode = 5054835 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 RkdIssueStatus = 0, RIC = '7163.T^I25' WHERE SecCode = 5380510 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 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 Ticker = 'SBAR', RIC = 'SBAR.L', DisplayRIC = 'SBAR.L', RkdExchCode = 'LON' WHERE SecCode = 5616087 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 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 COATypeCode = 'IND' WHERE SecCode = 5896458 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 Ticker = 'BAC', RIC = 'BACJ.J', DisplayRIC = 'BACJ.J' WHERE SecCode = 5954213 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 COATypeCode = 'IND' WHERE SecCode = 6285562 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 = 6354184 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CNE1000074T5', CUSIP = 'Y0S6TS10' WHERE SecCode = 6360666 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 ISIN = 'CNE1000074X7', CUSIP = 'Y973BJ10' WHERE SecCode = 6405363 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' 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 = 6440004 AND Type_ = 10; UPDATE data_universe_rkd SET 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 = 6449036 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 10902320 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 ISIN = 'CA73015G1046', SEDOL = 'BRJJYV', CUSIP = '73015G10' WHERE SecCode = 10933062 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 10968478 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 10971989 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 10979586 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 RIC = NULL WHERE SecCode = 11005855 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 ISIN = 'US9630257965', SEDOL = 'BLDCLW', CUSIP = '96302579' WHERE SecCode = 11015187 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 Ticker = 'GROW.H', RIC = 'GROWh.V', DisplayRIC = 'GROWh.V', RkdExchCode = 'NEX' WHERE SecCode = 11024834 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 = 'JPI.N^I25' WHERE SecCode = 11033942 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US62526P8775', SEDOL = 'BSBK03', CUSIP = '62526P87' WHERE SecCode = 11036554 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 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 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 RIC = NULL WHERE SecCode = 11141176 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = NULL, PrimaryIssueType = 'PVT' WHERE SecCode = 11174027 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11178780 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 = 'PVT' WHERE SecCode = 11183746 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 PrimaryIssueType = 'PVT' WHERE SecCode = 11196231 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11196721 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11198674 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 RIC = 'GDLC.K', DisplayRIC = 'GDLC.P', RkdExchCode = 'PAC' WHERE SecCode = 11201199 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 PrimaryIssueType = 'PVT' WHERE SecCode = 11210480 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US67012M2052', Ticker = 'BHICD', SEDOL = 'BVMS1W', CUSIP = '67012M20', RIC = 'BHICD.PK', DisplayRIC = 'BHICD.PK' WHERE SecCode = 11211233 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 PrimaryIssueType = 'PVT' WHERE SecCode = 11213739 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 PrimaryIssueType = 'PVT' WHERE SecCode = 11215640 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11216802 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11217686 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11217696 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11218535 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 PrimaryIssueType = 'EQU' WHERE SecCode = 11223644 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11224473 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 = 'BASE.OQ^I25' WHERE SecCode = 11227644 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 = 1, Ticker = 'M0YA', SEDOL = 'BMFV5G', RIC = 'M0YAy.BE', DisplayRIC = 'M0YAy.BE', RkdExchCode = 'BER', RkdExchCtry = 'DEU', PrimaryIssueCode = NULL, RelType = NULL WHERE SecCode = 11234013 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 = 'HLVX.OQ^I25' WHERE SecCode = 11241414 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', Ticker = 'LYTHD', SEDOL = 'BVMS5F', CUSIP = 'G5851A14', RIC = 'LYTHD.PK', DisplayRIC = 'LYTHD.PK' 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 = '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 = 'CA87670N5010', SEDOL = 'BTZNZ8', CUSIP = '87670N50' WHERE SecCode = 11247040 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 = 'CA69639G1081', SEDOL = 'BPCR7M', CUSIP = '69639G10' WHERE SecCode = 11249518 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 ISIN = 'VGG982181114', SEDOL = 'BTZNZL', CUSIP = 'G9821811' WHERE SecCode = 11251558 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 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 ISIN = 'KYG351501385', SEDOL = 'BLDCLZ', CUSIP = 'G3515013' WHERE SecCode = 11256200 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, PrimaryIssueType = 'PVT' WHERE SecCode = 11262355 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 = 'KYG622641259', SEDOL = 'BVZL0B', CUSIP = 'G6226412' WHERE SecCode = 11264180 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 = 'IPST', RIC = 'IPST.O', DisplayRIC = 'IPST.OQ' WHERE SecCode = 11271912 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 = 11277668 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11279414 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 = 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 = 11285141 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11285257 AND Type_ = 1;