UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'DLE.I^I25' WHERE SecCode = 697 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CA81222L2049', SEDOL = 'BV2JDQ', CUSIP = '81222L20' WHERE SecCode = 1679 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA9727531076', Ticker = 'WEC', SEDOL = 'BSNMLP', CUSIP = '97275310', RIC = 'WEC.V', DisplayRIC = 'WEC.V' WHERE SecCode = 2105 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'FVA', RIC = 'FVAF.L', DisplayRIC = 'FVAF.L' WHERE SecCode = 2412 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'US00808Y6041', SEDOL = 'BW5ZN1', CUSIP = '00808Y60' WHERE SecCode = 2459 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueOrder = 4 WHERE SecCode = 4537 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'EUNZ.L^J25' WHERE SecCode = 4661 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'JIGI', RIC = 'JIGI.L', DisplayRIC = 'JIGI.L' WHERE SecCode = 5037 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'BNBX', RIC = 'BNBX.O', DisplayRIC = 'BNBX.OQ' WHERE SecCode = 6067 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'SPT.L^J25' WHERE SecCode = 6779 AND Type_ = 10; 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 = 'BGFV.OQ^J25' WHERE SecCode = 9228 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PRE' WHERE SecCode = 9368 AND Type_ = 1; 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 = 0, RIC = 'RCDO.L^J25' WHERE SecCode = 10093 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 10823 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 10910 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US98873Q2093', SEDOL = 'BR4ZY5', CUSIP = '98873Q20' WHERE SecCode = 11338 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 12628 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'US15130G8731', SEDOL = 'BVMS1Z', CUSIP = '15130G87' WHERE SecCode = 12961 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueID = 2, RkdIssueCode = 182772, ISIN = 'US97785W1062', SEDOL = 'BVBFJH', CUSIP = '97785W10' WHERE SecCode = 17729 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US74738H4039', SEDOL = 'BSBK2T', CUSIP = '74738H40' WHERE SecCode = 18690 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'ENFY.PK', DisplayRIC = 'ENFY.PK', RkdExchCode = 'OTC' WHERE SecCode = 20007 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 CUSIP = 'P6245715' WHERE SecCode = 29589 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'PREVISION.SN^J25' WHERE SecCode = 30613 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'GB00BNKDVV71', SEDOL = 'BNKDVV', CUSIP = 'G5493R12' WHERE SecCode = 31464 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'GNTY.N^J25' WHERE SecCode = 31546 AND Type_ = 1; 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 = 1 WHERE SecCode = 32373 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'HAWEL.PK^J25' WHERE SecCode = 32905 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'AGRP.L^J25' WHERE SecCode = 33776 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CH1485899350', SEDOL = 'BTMRCG', CUSIP = 'H1181115' WHERE SecCode = 36418 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'JERTQ.PK^I25' WHERE SecCode = 37852 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'JEQ.N^J25' WHERE SecCode = 38252 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'KRFG', RIC = 'KRFG.PK', DisplayRIC = 'KRFG.PK' WHERE SecCode = 39727 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US2372452043', Ticker = 'DPLSD', SEDOL = 'BW2K9C', CUSIP = '23724520', RIC = 'DPLSD.PK', DisplayRIC = 'DPLSD.PK' WHERE SecCode = 39790 AND Type_ = 1; UPDATE data_universe_rkd SET CUSIP = 'X5856011' WHERE SecCode = 42270 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'X5856010' WHERE SecCode = 42310 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'US5381463091', SEDOL = 'BVBQPK', CUSIP = '53814630' WHERE SecCode = 42719 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 RkdIssueStatus = 0, RIC = 'FLYP.PA^J25' WHERE SecCode = 44329 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'DE000A40ZW05', Ticker = 'FEW0', SEDOL = 'BRBWSJ', CUSIP = 'D4529612', RIC = 'FEW0n.F', DisplayRIC = 'FEW0n.F' WHERE SecCode = 44550 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'R8992310' WHERE SecCode = 45894 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'IT0005654683', SEDOL = 'BVMJYP', CUSIP = 'T4R68016' WHERE SecCode = 46376 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'BCBC', RIC = 'BCBC.PK', DisplayRIC = 'BCBC.PK' WHERE SecCode = 46758 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'NAVBQ', RIC = 'NAVBQ.PK', DisplayRIC = 'NAVBQ.PK' WHERE SecCode = 49821 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 49878 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'US9682353092', SEDOL = 'BSDZ35', CUSIP = '96823530' WHERE SecCode = 50157 AND Type_ = 1; UPDATE data_universe_rkd SET ShPerListing = 1.0 WHERE SecCode = 50714 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 51611 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'VHC.O', DisplayRIC = 'VHC.OQ', RkdExchCode = 'NASD' WHERE SecCode = 53360 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'PEGX', RIC = 'PEGX.PK', DisplayRIC = 'PEGX.PK' WHERE SecCode = 54760 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'BRFS.N^I25' WHERE SecCode = 55088 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'FIN' WHERE SecCode = 55755 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'PHT.N^I25' WHERE SecCode = 56011 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'PHD.N^J25' WHERE SecCode = 56015 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'DUNYH.E', RIC = 'DUNYH.IS', DisplayRIC = 'DUNYH.IS' WHERE SecCode = 56148 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 56170 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'US18452H3057', SEDOL = 'BT68XJ', CUSIP = '18452H30' WHERE SecCode = 57481 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'EIFG.DE', DisplayRIC = 'EIFG.DE', RkdExchCode = 'ETR' WHERE SecCode = 57533 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'VVAGk.F^J25' WHERE SecCode = 58043 AND Type_ = 10; 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 Ticker = 'PTHH', RIC = 'PTHH.DE', DisplayRIC = 'PTHH.DE', RkdExchCode = 'ETR' WHERE SecCode = 64428 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'ERC', RIC = 'ERC.AS', DisplayRIC = 'ERC.AS' WHERE SecCode = 64798 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 66514 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'M2512515' WHERE SecCode = 67358 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 67577 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Q3482A10' WHERE SecCode = 67853 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'BMG0R33J2028', SEDOL = 'BRWFZX', CUSIP = 'G0R33J20' WHERE SecCode = 67883 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CA38074C1041', Ticker = 'GSR', SEDOL = 'BVZG6R', CUSIP = '38074C10', RIC = 'GSR.V', DisplayRIC = 'GSR.V' WHERE SecCode = 68072 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '6879.T^I25' WHERE SecCode = 68614 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'AU0000424921', Ticker = 'VMS', SEDOL = 'BW5SZ0', CUSIP = 'Q0604V18', RIC = 'VMS.AX', DisplayRIC = 'VMS.AX' WHERE SecCode = 68866 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 69916 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 RIC = 'INHM.BO', DisplayRIC = 'INHM.BO' WHERE SecCode = 70347 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Q5571710' WHERE SecCode = 70501 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SCBS.PK^J25' WHERE SecCode = 70620 AND Type_ = 1; 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 = 'PIRA.NS^I25' WHERE SecCode = 71866 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'HMTR.NS^J25' WHERE SecCode = 72133 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE305A01023', SEDOL = 'BVPGMZ', CUSIP = 'Y8T97E11' 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 RkdIssueStatus = 0, RIC = '7605.T^J25' WHERE SecCode = 72964 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'S7522U10' WHERE SecCode = 73049 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 73413 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'BMG2118J2052', SEDOL = 'BVZKGV', CUSIP = 'G2118J20' WHERE SecCode = 74285 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, Ticker = NULL, RIC = 'SMURFIT.LG^J25' WHERE SecCode = 75483 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'RAKUNIT.LG^G24' WHERE SecCode = 75687 AND Type_ = 10; UPDATE data_universe_rkd SET RkdCode = 143136, RkdIssueCode = 182720, ISIN = 'KYG1156E1026', Ticker = 'BTTC', SEDOL = 'BVYL63', CUSIP = 'G1156E10', RIC = 'BTTC.O', DisplayRIC = 'BTTC.OQ', COATypeCode = '' WHERE SecCode = 75851 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'INE629B01032', SEDOL = 'BSNMGK', CUSIP = 'Y8166W14' WHERE SecCode = 78203 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 78656 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 ISIN = 'BMG3394P4020', SEDOL = 'BSRJ2J', CUSIP = 'G3394P40' WHERE SecCode = 79747 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'JP3821300005', Ticker = '416A', SEDOL = 'BSRFNK', CUSIP = 'J1572G10', RIC = '416A.T', DisplayRIC = '416A.T' WHERE SecCode = 80309 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 81052 AND Type_ = 10; UPDATE data_universe_rkd SET RkdCode = 6771, RkdIssueCode = 9073, RkdIssueStatus = 1, ISIN = 'US2011271077', Ticker = NULL, SEDOL = NULL, CUSIP = '20112710', RIC = 'CBGR.OB^G98', DisplayRIC = 'CBGR.OB', RkdExchCode = 'OTC', PrimaryIssueType = 'PVT' WHERE SecCode = 81543 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SQCF.PK^J25' WHERE SecCode = 81567 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 82349 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 82350 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 82351 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 82352 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 82355 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '9377.T^I25' WHERE SecCode = 82838 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '000627.SZ^I25' WHERE SecCode = 83694 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = '0812.HK^I25' WHERE SecCode = 83801 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE672A01026', SEDOL = 'BW2FS5', CUSIP = 'Y8T33Y12' WHERE SecCode = 84503 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '6973.T^J25' WHERE SecCode = 85934 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 = 'PHIM.PSX^J25' WHERE SecCode = 86545 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y3230V11' WHERE SecCode = 86697 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'GREENTEC', RIC = 'GREE.KL', DisplayRIC = 'GREE.KL' WHERE SecCode = 86781 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'G4404S10' WHERE SecCode = 87058 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 87313 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 RkdIssueStatus = 0, RIC = '2809.TW^J25' WHERE SecCode = 88710 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CA27580W1005', SEDOL = 'BT691S', CUSIP = '27580W10' WHERE SecCode = 90224 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '6411.T^J25' WHERE SecCode = 90236 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'ZAE000351946', SEDOL = 'BV2FFX', CUSIP = 'S5343512' WHERE SecCode = 90348 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'AOT.H', RIC = 'AOTh.V', DisplayRIC = 'AOTh.V', RkdExchCode = 'NEX' WHERE SecCode = 90585 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '1884.T^J25' WHERE SecCode = 90958 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '9066.T^J25' WHERE SecCode = 90983 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 91115 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'NEXGBINA', RIC = 'NEXI.KL', DisplayRIC = 'NEXI.KL' WHERE SecCode = 91350 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'M7S23S11' WHERE SecCode = 91514 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 ISIN = 'CA81373W1086', SEDOL = 'BSNQCJ', CUSIP = '81373W10' WHERE SecCode = 92379 AND Type_ = 1; UPDATE data_universe_rkd SET CUSIP = 'Y2060S11' WHERE SecCode = 92811 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'TFM.H', RIC = 'TFMh.V', DisplayRIC = 'TFMh.V', RkdExchCode = 'NEX' WHERE SecCode = 92906 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 92978 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'BMG4088X2064', SEDOL = 'BR4WBJ', CUSIP = 'G4088X20' WHERE SecCode = 93588 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'V9217910' WHERE SecCode = 93732 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'AU0000423741', Ticker = 'G1C', SEDOL = 'BT7MDF', CUSIP = 'Q8046613', RIC = 'G1C.AX', DisplayRIC = 'G1C.AX' WHERE SecCode = 93734 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CA50067K3082', SEDOL = 'BVMS5L', CUSIP = '50067K30' WHERE SecCode = 93743 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '7451.T^I25' WHERE SecCode = 94005 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '005390.KS^I25' WHERE SecCode = 95444 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y7679418' WHERE SecCode = 95646 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Q8506K14' WHERE SecCode = 95744 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'AU000000SOL3', Ticker = 'SOL', SEDOL = '682180', RIC = 'SOL.AX', DisplayRIC = 'SOL.AX' WHERE SecCode = 95997 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 Ticker = 'MIT.H', RIC = 'MITh.V', DisplayRIC = 'MITh.V', RkdExchCode = 'NEX' WHERE SecCode = 96779 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 RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 97693 AND Type_ = 10; 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', CUSIP = 'Q4544E19', 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 RkdCode = 142861, RkdIssueCode = 182364, ISIN = 'JP3831110006', Ticker = '417A', SEDOL = 'BSRFNL', CUSIP = 'J0447S10', RIC = '417A.T', DisplayRIC = '417A.T', COATypeCode = '' WHERE SecCode = 99138 AND Type_ = 10; 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, RIC = 'THC.CD^I25' WHERE SecCode = 100097 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'TH.TO^I25' WHERE SecCode = 100099 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA8875228030', SEDOL = 'BR53T1', CUSIP = '88752280' WHERE SecCode = 100174 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA24344U1084', Ticker = 'WCSB', SEDOL = 'BTMJPK', CUSIP = '24344U10', RIC = 'WCSB.V', DisplayRIC = 'WCSB.V' WHERE SecCode = 100685 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 ISIN = 'NO0013682948', SEDOL = 'BW2G21', CUSIP = 'R0R77L14' WHERE SecCode = 100974 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CA25384L1067', SEDOL = 'BR53S7', CUSIP = '25384L10' WHERE SecCode = 101013 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA83013Q8719', Ticker = 'CHAI', SEDOL = 'BTVM9R', CUSIP = '83013Q87', RIC = 'CHAI.O', DisplayRIC = 'CHAI.OQ' WHERE SecCode = 101238 AND Type_ = 1; 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 Ticker = 'BLUME.E', RIC = 'BLUME.IS', DisplayRIC = 'BLUME.IS' WHERE SecCode = 103786 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'ALPAS', RIC = 'ALPAS.PA', DisplayRIC = 'ALPAS.PA' WHERE SecCode = 103908 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'VXT', RIC = 'VXT.DE', DisplayRIC = 'VXT.DE' WHERE SecCode = 104532 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'TH0753C10Z00', SEDOL = 'BV4GM6', CUSIP = 'Y973BL11' WHERE SecCode = 104987 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'J0562G10' WHERE SecCode = 105156 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'A531', SEDOL = 'BJ4TMM', RIC = 'A531.F', DisplayRIC = 'A531.F', RkdExchCode = 'FRA', RkdExchCtry = 'DEU' WHERE SecCode = 110311 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '3319.T^I25' WHERE SecCode = 111297 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'WNS.N^J25' WHERE SecCode = 111453 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'AU0000421851', Ticker = 'ELV', SEDOL = 'BVBM1M', CUSIP = 'Q8329N32', RIC = 'ELV.AX', DisplayRIC = 'ELV.AX' WHERE SecCode = 111747 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'VTL.NZ^J25' WHERE SecCode = 112939 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'IDL.CM^J25' WHERE SecCode = 114541 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'G2581C20' WHERE SecCode = 115240 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'GB00BVMTNR93', SEDOL = 'BVMTNR', CUSIP = 'G6953A10' WHERE SecCode = 115574 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 116736 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 = 'INE081B01028', SEDOL = 'BVLK8H', CUSIP = 'Y1122J13' WHERE SecCode = 126259 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 126493 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'VGL', RIC = 'VARV.NS', DisplayRIC = 'VARV.NS' WHERE SecCode = 128522 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE235C01036', SEDOL = 'BSSB6S', CUSIP = 'Y8186R20' WHERE SecCode = 130714 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y9315R13' WHERE SecCode = 132389 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Q2874S25' WHERE SecCode = 133785 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y1R95110' WHERE SecCode = 136512 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'MFIN.JK^J25' WHERE SecCode = 140273 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 ISIN = 'INE331C01025', SEDOL = 'BRBN4T' WHERE SecCode = 142568 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'SYSTMTXC', RIC = 'SYCS.NS', DisplayRIC = 'SYCS.NS', RkdExchCode = 'NSE' WHERE SecCode = 142574 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 CUSIP = 'X3071C10' WHERE SecCode = 144706 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE111F01024', SEDOL = 'BVLK82', CUSIP = 'Y6793G14' WHERE SecCode = 145481 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'GOR.AX^J25' WHERE SecCode = 145658 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'AU0000420648', Ticker = 'AXPDD', SEDOL = 'BSD4NX', CUSIP = 'Q1R39C14', RIC = 'AXPDD.AX', DisplayRIC = 'AXPDD.AX' WHERE SecCode = 146019 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'E2NG.MU^J25' WHERE SecCode = 146206 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'FHB', RIC = 'FHBP.WA', DisplayRIC = 'FHBP.WA' WHERE SecCode = 147359 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'PEK.AX^J25' WHERE SecCode = 163971 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'TH0922B10Z07', SEDOL = 'BTWQMB', CUSIP = 'Y709KB15' WHERE SecCode = 165534 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'FCCT.PK^J25' WHERE SecCode = 168907 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'WHCA.PK^I25' WHERE SecCode = 180517 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 ISIN = 'AU0000425027', Ticker = 'LIB', SEDOL = 'BW5SZ8', CUSIP = 'Q9173526', RIC = 'LIB.AX', DisplayRIC = 'LIB.AX' WHERE SecCode = 200828 AND Type_ = 10; 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 ISIN = 'CA1689301135', SEDOL = 'BTMJQB', CUSIP = '16893011' WHERE SecCode = 236801 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 Ticker = 'TRUE', RIC = 'TRUET.L', DisplayRIC = 'TRUET.L' WHERE SecCode = 277134 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SNDZ.PK^I25' WHERE SecCode = 278022 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'AU0000417842', Ticker = 'DTMDC', SEDOL = 'BVMMNW', RIC = 'DTMDC.AX', DisplayRIC = 'DTMDC.AX' WHERE SecCode = 285238 AND Type_ = 10; 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 RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 291736 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'AU0000423501', Ticker = 'L1G', SEDOL = 'BSPVFM', CUSIP = 'Q7587R11', RIC = 'L1G.AX', DisplayRIC = 'L1G.AX' WHERE SecCode = 292778 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 = 'IVXG.H^J25' WHERE SecCode = 294573 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 ISIN = 'AU0000417586', Ticker = 'PABDA', SEDOL = 'BVBH22', CUSIP = 'Q7322A27', RIC = 'PABDA.AX', DisplayRIC = 'PABDA.AX' WHERE SecCode = 300101 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'XTC.AX^J25' WHERE SecCode = 300997 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 Ticker = 'AIMV', RIC = 'AIMV.PK', DisplayRIC = 'AIMV.PK' WHERE SecCode = 303050 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 304471 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'FCCTP.PK^J25' WHERE SecCode = 306178 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'FCCTO.PK^J25' WHERE SecCode = 306179 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 CUSIP = 'P149AC58' WHERE SecCode = 311175 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'SRVL', RIC = 'SRVL.ASE', DisplayRIC = 'SRVL.ASE' WHERE SecCode = 317701 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CA48730E1051', SEDOL = 'BSNMLL', CUSIP = '48730E10' WHERE SecCode = 321708 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 Ticker = 'TAAG', RIC = 'TAAG.PK', DisplayRIC = 'TAAG.PK' WHERE SecCode = 336133 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, RIC = 'STBP3.SA^J25' WHERE SecCode = 344370 AND Type_ = 10; 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 ISIN = 'CA75974M2040', SEDOL = 'BVPWD0', CUSIP = '75974M20' WHERE SecCode = 361480 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 362805 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'FINKURVE', RIC = 'FINK.NS', DisplayRIC = 'FINK.NS', RkdExchCode = 'NSE' WHERE SecCode = 387505 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'M8T23S11' WHERE SecCode = 396044 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'HLHL.SI^I25' WHERE SecCode = 415865 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'M9895F15' WHERE SecCode = 416435 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 CUSIP = 'Y0337319' WHERE SecCode = 483868 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'P5799112' WHERE SecCode = 519382 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE814H01029', SEDOL = 'BV2DVP', CUSIP = 'Y0R13015' WHERE SecCode = 536728 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y9003510' WHERE SecCode = 548535 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'KYG9884A1022', SEDOL = 'BRJNVN', CUSIP = 'G9884A10' WHERE SecCode = 551335 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Q2156M20' WHERE SecCode = 553964 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 557267 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'VTL.HNO^J25' WHERE SecCode = 567568 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'G4742410' WHERE SecCode = 582997 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 CUSIP = 'Y2R9FE11' WHERE SecCode = 586513 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y6586P11' WHERE SecCode = 606162 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'nzhs', CUSIP = 'X5S9AN11' WHERE SecCode = 703224 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'X0R8BD11' WHERE SecCode = 703235 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'X0R3H712' WHERE SecCode = 703382 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'G989MR10' WHERE SecCode = 717246 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'S27.HNO^J25' WHERE SecCode = 817726 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'BMG2157U2281', SEDOL = 'BNVY7Y', CUSIP = 'G2157U22' WHERE SecCode = 843986 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'SYNEXO', RIC = 'SYNEXO.NGM', DisplayRIC = 'SYNEXO.NGM' WHERE SecCode = 868742 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y3R17R10' WHERE SecCode = 890632 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'AO1.AX^J25' WHERE SecCode = 1026391 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 CUSIP = 'G3954WAB' WHERE SecCode = 1128325 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 1153320 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 CUSIP = 'Q6250E10' WHERE SecCode = 1222836 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'NO0013683409', SEDOL = 'BW5T1V', CUSIP = 'R5S38812' WHERE SecCode = 1458933 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'INSEl', SEDOL = NULL, RIC = 'INSEl.BCO', DisplayRIC = 'INSEl.BCO' WHERE SecCode = 1472965 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y8T1GK11' WHERE SecCode = 1474972 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'GB00BV2FG348', SEDOL = 'BV2FG3', CUSIP = 'G1R33C10' WHERE SecCode = 1478297 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '300280.SZ^J25' WHERE SecCode = 1482575 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 1487633 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'V5704U10' WHERE SecCode = 1598739 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 CUSIP = 'X0R3H713' WHERE SecCode = 1631795 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'M7S38D11' WHERE SecCode = 1635419 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Q5376717' WHERE SecCode = 1664403 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SMC2A.PS^J25' WHERE SecCode = 1699052 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueID = 9, RkdIssueCode = 143276, RkdIssueOrder = 2 WHERE SecCode = 1699053 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SMC2C.PS^J25' WHERE SecCode = 1699054 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'VGG7223M1187', SEDOL = 'BNVY1J', CUSIP = 'G7223M11' WHERE SecCode = 1981169 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y613HU11' WHERE SecCode = 2005913 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'W8T14Q30' WHERE SecCode = 2044711 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'ASPM.CM^J25' WHERE SecCode = 2229093 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y1780H12' WHERE SecCode = 2232795 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'M2R38B11' WHERE SecCode = 2285159 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'blrep', CUSIP = 'X7T73S11' WHERE SecCode = 2289271 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^J25' 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', CUSIP = 'Y7S66M13' WHERE SecCode = 2380633 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 2399379 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'N3R93N14' WHERE SecCode = 2400932 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'PGH.AX^G25' WHERE SecCode = 2440002 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'SCHLR', RIC = 'SCHLR.MC', DisplayRIC = 'SCHLR.MC', PrimaryIssueType = 'PVT' WHERE SecCode = 2515727 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'MODI.TE^J25' WHERE SecCode = 2526047 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 2529065 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'IT0005654766', SEDOL = 'BSY6DM', CUSIP = 'T3R4KC12' WHERE SecCode = 2555896 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '6095.T^J25' WHERE SecCode = 2566806 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'MONEYBOXX', RIC = 'MONB.NS', DisplayRIC = 'MONB.NS', RkdExchCode = 'NSE' WHERE SecCode = 2574393 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'YMEI.MC^J25' WHERE SecCode = 2586429 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'FRHO.SI^J25' WHERE SecCode = 2586521 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'PPFu.BK^J25' WHERE SecCode = 2587923 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 = 'RXH.AX^J25' WHERE SecCode = 2626282 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '6026.T^I25' WHERE SecCode = 2693648 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'V3558510' WHERE SecCode = 2694699 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE976R01033', SEDOL = 'BW2FZ3', CUSIP = 'Y0R7Y314' WHERE SecCode = 2854268 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 RkdIssueStatus = 0, RIC = '6048.T^I25' WHERE SecCode = 2864442 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 PrimaryIssueCode = 103321.0 WHERE SecCode = 2918009 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'TRA', RIC = 'TRA.MC', DisplayRIC = 'TRA.MC' WHERE SecCode = 2946507 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 2950178 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'G7321A10' WHERE SecCode = 2953268 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'AHI.AX^J25' WHERE SecCode = 2956426 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE671K01027', SEDOL = 'BS81L2', CUSIP = 'Y8303M10' WHERE SecCode = 2963532 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SMC2D.PS^J25' WHERE SecCode = 2975899 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE060D01028', SEDOL = 'BS81KZ' WHERE SecCode = 3007957 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'AXX', RIC = 'AXXJ.J', DisplayRIC = 'AXXJ.J' WHERE SecCode = 3011222 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y0928N13' WHERE SecCode = 3048286 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Q0R44310' WHERE SecCode = 3076057 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'SE0026598583', SEDOL = 'BRBFS7', CUSIP = 'W989B021' WHERE SecCode = 3084587 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE314T01033', SEDOL = 'BVZG2V', CUSIP = 'Y2740H15' WHERE SecCode = 3109824 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 WHERE SecCode = 3200563 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'IGLD', RIC = 'IGLD.L', DisplayRIC = 'IGLD.L' WHERE SecCode = 3200664 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 = 'AU0000426512', Ticker = 'RIV', SEDOL = 'BRBFKZ', CUSIP = 'Q3315S19', RIC = 'RIV.AX', DisplayRIC = 'RIV.AX' WHERE SecCode = 3225986 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 3247487 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 CUSIP = 'Y2R5FP10' WHERE SecCode = 3317783 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'YAPS.MC^J25' WHERE SecCode = 3318353 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 CUSIP = 'G3392H10' WHERE SecCode = 3370825 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'KYG942971766', SEDOL = 'BV2DWC', CUSIP = 'G9429717' WHERE SecCode = 3377999 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'ENRAD.NGM', DisplayRIC = 'ENRAD.NGM', RkdExchCode = 'NGM' WHERE SecCode = 3378737 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 3392104 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'WHRW.L^J25' WHERE SecCode = 3394302 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'WORTHPERI' WHERE SecCode = 3396329 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE219Y01026', SEDOL = 'BSSB6X', CUSIP = 'Y7S04D13' WHERE SecCode = 3396332 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE947T01022', SEDOL = 'BNNRXK', CUSIP = 'Y2R2TT13' WHERE SecCode = 3396342 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = '9388.FU', DisplayRIC = '9388.FU', RkdExchCode = 'FUK' WHERE SecCode = 3402118 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'CWX.AX^J25' WHERE SecCode = 3408003 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 Ticker = 'TSFINV', RIC = 'TSFI.NS', DisplayRIC = 'TSFI.NS' WHERE SecCode = 3441472 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'AURIGROW', RIC = 'AURR.NS', DisplayRIC = 'AURR.NS' WHERE SecCode = 3495863 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 = 'KYG3962W1107', SEDOL = 'BSRJ36', CUSIP = 'G3962W11' WHERE SecCode = 3582243 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 RIC = '9275.T^I25', PrimaryIssueType = 'PVT' WHERE SecCode = 3593745 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 RkdIssueStatus = 0, Ticker = NULL, RIC = '1034.HK^J25' WHERE SecCode = 3642396 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 3648201 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 ISIN = 'AU0000419475', Ticker = 'MRZDA', SEDOL = 'BPGKBG', RIC = 'MRZDA.AX', DisplayRIC = 'MRZDA.AX' WHERE SecCode = 3824688 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE00YB01025', SEDOL = 'BS81L4' WHERE SecCode = 3883663 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'GB00BQYLVW97', SEDOL = 'BQYLVW', CUSIP = 'G6355D11' WHERE SecCode = 3906622 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'HANGJI.CY^I25' WHERE SecCode = 3948975 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 4029417 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 4038316 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 4109394 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueCode = 124389.0 WHERE SecCode = 4259228 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'NTC.HNO^J25' WHERE SecCode = 4333240 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y238AN10' WHERE SecCode = 4335864 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'FOAMIT', RIC = 'FOAMIT.HE', DisplayRIC = 'FOAMIT.HE' WHERE SecCode = 4348233 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE0A0S01028', SEDOL = 'BVLL7J', CUSIP = 'Y793D412' WHERE SecCode = 4385228 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 CUSIP = 'M4R44V18' WHERE SecCode = 4422378 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, SEDOL = NULL, RIC = 'OZONDR.MM^I25' WHERE SecCode = 4429545 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'TSI.AX^J25' WHERE SecCode = 4438375 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'KEX.BK^J25' WHERE SecCode = 4452287 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'ORTIN', RIC = 'ORTIN.ST', DisplayRIC = 'ORTIN.ST' WHERE SecCode = 4471741 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Q902A010' WHERE SecCode = 4496725 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'RHR', RIC = 'RHR.L', DisplayRIC = 'RHR.L', RkdExchCode = 'LON' WHERE SecCode = 4531654 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE418L01047', SEDOL = 'BSSB76', CUSIP = 'Y6S13X12' WHERE SecCode = 4542550 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'ROO.L^J25', DisplayRIC = 'ROO.L^J25' WHERE SecCode = 4550805 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'UFBL', RIC = 'UITF.NS', DisplayRIC = 'UITF.NS' WHERE SecCode = 4557787 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 = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 4638891 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'PLAY.IC^J25' WHERE SecCode = 4640253 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'BRWDCNACNOR2', Ticker = 'WDCN3', SEDOL = 'BVLKHM', CUSIP = 'P6S96011', RIC = 'WDCN3.SA', DisplayRIC = 'WDCN3.SA' WHERE SecCode = 4655483 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 Ticker = 'ERKA', RIC = 'ERKA.TA', DisplayRIC = 'ERKA.TA' WHERE SecCode = 4659803 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 4661142 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE645S01024', SEDOL = 'BW5T2L', CUSIP = 'Y7S23U11' WHERE SecCode = 4667075 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'CARZ.KL^J25' WHERE SecCode = 4693638 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'MARKOLINES', RIC = 'MARM.NS', DisplayRIC = 'MARM.NS', RkdExchCode = 'NSE' WHERE SecCode = 4720484 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Q9162S10' WHERE SecCode = 4777362 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'GB00BRJNW354', SEDOL = 'BRJNW3', CUSIP = 'G4674M11' WHERE SecCode = 4788580 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, Ticker = NULL, RIC = 'KES.VI^J25' WHERE SecCode = 4806715 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'US7444302084', SEDOL = 'BPK5C2', CUSIP = '74443020' WHERE SecCode = 4808877 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'ESTM', RIC = 'ESTM.MI', DisplayRIC = 'ESTM.MI' WHERE SecCode = 4811102 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'AU0000427221', Ticker = 'TR8', SEDOL = 'BW9MH4', RIC = 'TR8.AX', DisplayRIC = 'TR8.AX' WHERE SecCode = 4826112 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'SA16D0820P10', Ticker = '4146', SEDOL = 'BTXY8P', CUSIP = 'M4628Y11', RIC = '4146.SE', DisplayRIC = '4146.SE' WHERE SecCode = 4867401 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'CIRCLEb.ST^J25' WHERE SecCode = 4868601 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 ISIN = 'DE000A40ZVZ1', Ticker = 'ENG', SEDOL = 'BRBWSH', CUSIP = 'D2S1ZN10', RIC = 'ENGk.F', DisplayRIC = 'ENGk.F', RkdExchCode = 'FRA' WHERE SecCode = 4970859 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'L9894S11' WHERE SecCode = 4984245 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '9224.T^I25' WHERE SecCode = 5022239 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 RkdIssueStatus = 0, RIC = 'LIFS.L^I25' WHERE SecCode = 5072231 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 COATypeCode = 'FIN' WHERE SecCode = 5155321 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Q1R28A10' WHERE SecCode = 5261360 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '7117.T^I25' WHERE SecCode = 5316694 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '449020.KQ^J25' WHERE SecCode = 5349583 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '448740.KQ^J25' WHERE SecCode = 5351843 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '446750.KQ^J25' WHERE SecCode = 5354938 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 PrimaryIssueCode = 136857.0 WHERE SecCode = 5430796 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 RkdIssueStatus = 0, RIC = 'TLT.AS^I25' WHERE SecCode = 5816808 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 RIC = '7788.TW', DisplayRIC = '7788.TW', RkdExchCode = 'TPE' WHERE SecCode = 5974237 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 = 6082594 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6128250 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6153863 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6159033 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6164287 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6205859 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6205870 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6223905 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y614R710' WHERE SecCode = 6240405 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6285562 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y6835F10' WHERE SecCode = 6291853 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6291854 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6297427 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 = 6301989 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6303031 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'LEEA.NS', DisplayRIC = 'LEEA.NS' WHERE SecCode = 6305341 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6318887 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6339507 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6341752 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6354184 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6354186 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6356123 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CNE1000074T5', CUSIP = 'Y0S6TS10' WHERE SecCode = 6360666 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y7029M10' WHERE SecCode = 6361838 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y709P511' WHERE SecCode = 6363468 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 COATypeCode = 'IND' WHERE SecCode = 6396775 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', COATypeCode = 'IND' 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 = 6434972 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6440004 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'M6S93J10', COATypeCode = 'IND' WHERE SecCode = 6440013 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 = 6448554 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6449036 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'J3649110' WHERE SecCode = 6450912 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'CART', RIC = 'CART.V', DisplayRIC = 'CART.V', RkdExchCode = 'CVE' WHERE SecCode = 10776460 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 10902320 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'OPITS', RIC = 'OPITS.PK', DisplayRIC = 'OPITS.PK', RkdExchCode = 'OTC' WHERE SecCode = 10906768 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA5495465059', SEDOL = 'BV2JDL', CUSIP = '54954650' WHERE SecCode = 10911585 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'MAXD.PK^I25' WHERE SecCode = 10913779 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA65345J3038', SEDOL = 'BTWMP6', CUSIP = '65345J30' WHERE SecCode = 10923992 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US74039M4087', SEDOL = 'BW5YYL', CUSIP = '74039M40' WHERE SecCode = 10924184 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'HVVh.V^J25' WHERE SecCode = 10965216 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'FFH_pg.TO^J25' WHERE SecCode = 10965490 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 Ticker = 'GROO', RIC = 'GROO.PK', DisplayRIC = 'GROO.PK' WHERE SecCode = 11008400 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'MIXX.PK^J25' WHERE SecCode = 11009286 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 ISIN = 'CA14919F3051', SEDOL = 'BS55HW', CUSIP = '14919F30' WHERE SecCode = 11019872 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 ISIN = 'CA63906L1067', Ticker = 'BAD', SEDOL = 'BW2K5K', CUSIP = '63906L10', RIC = 'BAD.CD', DisplayRIC = 'BAD.CD' WHERE SecCode = 11024620 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'COOP.OQ^J25' WHERE SecCode = 11025091 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 = 'OGh.V^J25' WHERE SecCode = 11028815 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', RIC = 'BINI.PK', DisplayRIC = 'BINI.PK', RkdExchCode = 'OTC' WHERE SecCode = 11036554 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US02871P3047', Ticker = 'NFTND', SEDOL = 'BTWMPD', CUSIP = '02871P30', RIC = 'NFTND.PK', DisplayRIC = 'NFTND.PK' WHERE SecCode = 11036887 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'SINC', RIC = 'SINC.PK', DisplayRIC = 'SINC.PK' WHERE SecCode = 11037266 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 ISIN = 'CA6857881016', SEDOL = 'BVBQT2', CUSIP = '68578810' WHERE SecCode = 11045015 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'NLTAh.V^J25' WHERE SecCode = 11074055 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA54020J2002', SEDOL = 'BW5ZMN', CUSIP = '54020J20' WHERE SecCode = 11108371 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'WNHK', RIC = 'WNHK.PK', DisplayRIC = 'WNHK.PK' WHERE SecCode = 11109781 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'SLAI', RIC = 'SLAI.K', DisplayRIC = 'SLAI.N' WHERE SecCode = 11111276 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'CARM.PK', DisplayRIC = 'CARM.PK', RkdExchCode = 'OTC' WHERE SecCode = 11129194 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 ISIN = 'US29350E2037', Ticker = 'LNAI', SEDOL = 'BW5YZY', CUSIP = '29350E20', RIC = 'LNAI.O', DisplayRIC = 'LNAI.OQ' WHERE SecCode = 11142344 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'LBRA', RIC = 'LBRA.PK', DisplayRIC = 'LBRA.PK', RkdExchCode = 'OTC' WHERE SecCode = 11142838 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'EPIX.OQ^J25' WHERE SecCode = 11144375 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US81727U3032', SEDOL = 'BTMJPJ', CUSIP = '81727U30' WHERE SecCode = 11145550 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'ETSY.K', DisplayRIC = 'ETSY.N', RkdExchCode = 'NYSE' WHERE SecCode = 11147236 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA4629231032', Ticker = 'IMI', SEDOL = 'BR53SY', CUSIP = '46292310', RIC = 'IMI.V', DisplayRIC = 'IMI.V' WHERE SecCode = 11149536 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11150646 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'PRHI', RIC = 'PRHI.O', DisplayRIC = 'PRHI.OQ' WHERE SecCode = 11151122 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'LTPVQ', RIC = 'LTPVQ.PK', DisplayRIC = 'LTPVQ.PK' WHERE SecCode = 11155169 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US02919L7038', SEDOL = 'BSNMK7', CUSIP = '02919L70' WHERE SecCode = 11156315 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA01559C1068', SEDOL = 'BW5ZLD', CUSIP = '01559C10' WHERE SecCode = 11156632 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'SISI.PK', DisplayRIC = 'SISI.PK', RkdExchCode = 'OTC' WHERE SecCode = 11162909 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'VRNA.OQ^J25' WHERE SecCode = 11171830 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'HLYK', RIC = 'HLYK.PK', DisplayRIC = 'HLYK.PK' WHERE SecCode = 11172213 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = NULL, PrimaryIssueType = 'PVT' WHERE SecCode = 11174027 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US68236V4014', SEDOL = 'BW5ZKV', CUSIP = '68236V40' WHERE SecCode = 11174115 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US8169451098', SEDOL = 'BVPWCV', CUSIP = '81694510' WHERE SecCode = 11177920 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SCPH.OQ^J25' WHERE SecCode = 11178942 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 11180370 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 = 'EQU' WHERE SecCode = 11183776 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'UNBX.PK^J25' WHERE SecCode = 11184890 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11185342 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US3916572023', Ticker = 'GCAND', SEDOL = 'BW5ZK3', CUSIP = '39165720', RIC = 'GCAND.PK', DisplayRIC = 'GCAND.PK' WHERE SecCode = 11187805 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11189974 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'PVS_pg.TO^J25' WHERE SecCode = 11192150 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA93401G2036', SEDOL = 'BSNMKL', CUSIP = '93401G20' WHERE SecCode = 11192167 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 11193281 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA0556901019', Ticker = 'BPAG', SEDOL = 'BVMS5Q', CUSIP = '05569010', RIC = 'BPAG.V', DisplayRIC = 'BPAG.V' WHERE SecCode = 11194108 AND Type_ = 1; UPDATE data_universe_rkd SET ShPerListing = 0.6667 WHERE SecCode = 11197385 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 ISIN = 'CA3001447067', SEDOL = 'BVPWCX', CUSIP = '30014470' WHERE SecCode = 11200982 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 = 'CA38071C1077', Ticker = 'GRUN', SEDOL = 'BTWMP7', CUSIP = '38071C10', RIC = 'GRUN.CD', DisplayRIC = 'GRUN.CD' WHERE SecCode = 11202579 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA88770A3082', SEDOL = 'BR53SH', CUSIP = '88770A30', RIC = 'TINY.TO', DisplayRIC = 'TINY.TO', RkdExchCode = 'TSE' WHERE SecCode = 11202685 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA69867J2048', SEDOL = 'BTMJPL', CUSIP = '69867J20' WHERE SecCode = 11204720 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'ANG_pb.N^J25' WHERE SecCode = 11208589 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11209704 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'BNKK', RIC = 'BNKK.O', DisplayRIC = 'BNKK.OQ' WHERE SecCode = 11210045 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 = 11212829 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US5270642086', SEDOL = 'BVMS1H', CUSIP = '52706420' WHERE SecCode = 11214225 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 RkdIssueStatus = 0, SEDOL = NULL, RIC = 'OZONDR.MM^I25' WHERE SecCode = 11215113 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 ISIN = 'KYG9491K1397', SEDOL = 'BVPGQN', CUSIP = 'G9491K13' WHERE SecCode = 11219917 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11221183 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US62459M3051', SEDOL = 'BTMJL3', CUSIP = '62459M30' WHERE SecCode = 11221473 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11221982 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA5910882086', SEDOL = 'BVPWCQ', CUSIP = '59108820' WHERE SecCode = 11222521 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11223644 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 = 'NEUE.N^J25' WHERE SecCode = 11226158 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'FLOW.TO^J25' WHERE SecCode = 11227189 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 = 'ULIX', RIC = 'ULIX.PK', DisplayRIC = 'ULIX.PK' WHERE SecCode = 11228508 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 = 0, Ticker = NULL, RIC = 'MTAL.N^J25' WHERE SecCode = 11230316 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'AVDX.OQ^J25' WHERE SecCode = 11232126 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'ARIS.N^J25' WHERE SecCode = 11232562 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'TCBX.K', DisplayRIC = 'TCBX.N', RkdExchCode = 'NYSE' WHERE SecCode = 11233740 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'M0YA', SEDOL = 'BMFV5G', RIC = 'M0YAy.BE^I25', DisplayRIC = 'M0YAy.BE', RkdExchCode = 'BER', RkdExchCtry = 'DEU', PrimaryIssueCode = NULL, RelType = NULL WHERE SecCode = 11234013 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'READ.CD^J25' WHERE SecCode = 11236137 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'KYG507161282', SEDOL = 'BSPVK5', CUSIP = 'G5071612' WHERE SecCode = 11236365 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'RHNO', RIC = 'RHNO.PK', DisplayRIC = 'RHNO.PK' WHERE SecCode = 11237470 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 ISIN = 'KYG7308J1132', SEDOL = 'BVBQPF', CUSIP = 'G7308J11' WHERE SecCode = 11238855 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA3490242086', SEDOL = 'BW5YYM', CUSIP = '34902420' WHERE SecCode = 11239425 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US23290B2051', SEDOL = 'BW5ZJY', CUSIP = '23290B20' WHERE SecCode = 11239922 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US20678X4034', SEDOL = 'BVBQPG', CUSIP = '20678X40' WHERE SecCode = 11240122 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'ALCE', RIC = 'ALCE.PK', DisplayRIC = 'ALCE.PK' WHERE SecCode = 11240997 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'PLAOF.PK^J25' WHERE SecCode = 11241585 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'SLT', SEDOL = 'BT7HYP', RIC = 'SLT.TO', DisplayRIC = 'SLT.TO' WHERE SecCode = 11241870 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 = 'CA89103M2094', SEDOL = 'BVBQRZ', CUSIP = '89103M20' WHERE SecCode = 11244529 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 = 'CA75865D2068', SEDOL = 'BW2K5N', CUSIP = '75865D20' WHERE SecCode = 11246784 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 RIC = 'DMYY.PK', DisplayRIC = 'DMYY.PK', RkdExchCode = 'OTC' WHERE SecCode = 11247542 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 = 'KYG3109F1110', SEDOL = 'BW5YX7', CUSIP = 'G3109F11' WHERE SecCode = 11248163 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA00844N2086', SEDOL = 'BVPWCW', CUSIP = '00844N20' WHERE SecCode = 11248311 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'SLMT', RIC = 'SLMT.O', DisplayRIC = 'SLMT.OQ' WHERE SecCode = 11249174 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 = 'AQLS', RIC = 'AQLS.PK', DisplayRIC = 'AQLS.PK' WHERE SecCode = 11249737 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11250023 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 = 'KYG5084H1112', SEDOL = 'BT8PB2', CUSIP = 'G5084H11' WHERE SecCode = 11252318 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 RIC = 'FORL.PK', DisplayRIC = 'FORL.PK', RkdExchCode = 'OTC' WHERE SecCode = 11252798 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'MGRM.OQ^J25' WHERE SecCode = 11253068 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 Ticker = 'AURE', RIC = 'AURE.O', DisplayRIC = 'AURE.OQ' WHERE SecCode = 11254624 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 = 'AXG', RIC = 'AXG.O', DisplayRIC = 'AXG.OQ' WHERE SecCode = 11256986 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US66373M4087', SEDOL = 'BVMS1J', CUSIP = '66373M40' WHERE SecCode = 11257598 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'KLG.N^I25' WHERE SecCode = 11257617 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11257663 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 WHERE SecCode = 11260352 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = NULL, PrimaryIssueType = 'PVT' WHERE SecCode = 11262355 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'KYG570371149', SEDOL = 'BVBQPN', CUSIP = 'G5703711' WHERE SecCode = 11263023 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 = 'VGG003501191', SEDOL = 'BVPW8G', CUSIP = 'G0035011' WHERE SecCode = 11263502 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 ISIN = 'KYG6781F1191', SEDOL = 'BVMS1X', CUSIP = 'G6781F11' WHERE SecCode = 11267719 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'VGG7200G1182', SEDOL = 'BT68XL', CUSIP = 'G7200G11' WHERE SecCode = 11269125 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 ISIN = 'VGG2R09D1107', SEDOL = 'BTMJLK', CUSIP = 'G2R09D11' WHERE SecCode = 11270493 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11270950 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11271359 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11271495 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 RkdIssueStatus = 0, Ticker = NULL, RIC = 'GSRT.OQ^J25' WHERE SecCode = 11273297 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'KYG9876W1125', SEDOL = 'BW5YXB', CUSIP = 'G9876W11' WHERE SecCode = 11273379 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'UCFI', RIC = 'UCFI.O', DisplayRIC = 'UCFI.OQ' WHERE SecCode = 11274801 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 = 11277132 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11277553 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 = 11277924 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11279414 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'PASW', RIC = 'PASW.O', DisplayRIC = 'PASW.OQ' WHERE SecCode = 11280999 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 = 11282047 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11282097 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11282117 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11282205 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 COATypeCode = 'IND' WHERE SecCode = 11285177 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11285209 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11285221 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11285245 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11285254 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11285257 AND Type_ = 1;