INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (5318, 1, 'ACF', 129778, 1, 164532, 'C', 1, 1, 'OSR', 'US03060R1014', 'ACF', '292610', '03060R10', 'ACF.N^J10', 'ACF.N', 'NYSE', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11235, 10, '@SPERA1', 28627, 1, 38926, 'C', 0, 2, NULL, 'GB00BG48FB77', 'TEA', 'BG48FB', 'G8707W10', 'TEA.L^F16', 'TEA.L', 'SEA', 'GBR', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (58428, 1, '74726210', 3842, 1, 4886, 'C', 0, 2, NULL, 'US7472621033', NULL, NULL, '74726210', 'QVCN.O^B95', 'QVCN.OQ', 'NASD', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (115645, 10, '@COMPR8', 45565, 1, 59638, 'C', 1, 1, 'OSR', 'PLCOMP000017', 'COR', 'B0302H', 'X1721110', 'COZW.WA^A07', 'COZW.WA', 'WAR', 'POL', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (313766, 1, '04410340', 34576, 4, 45895, 'P', 1, 3, NULL, 'US0441034065', 'AHT PRD', 'B23NM2', '04410340', 'AHT_pd', 'AHT_pd.N', 'NYSE', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (7086798, 10, '@COMPL25', 145526, 1, 186306, 'C', 1, 1, 'OSR', 'INE2K6801014', '544900', 'BVBQ0F', 'Y169GH10', 'COML.BO', 'COML.BO', 'BOM', 'IND', NULL, 'EQU', NULL, NULL, ''); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (7098754, 10, '@SHANG564', 145213, 1, 185816, 'C', 1, 1, 'OSR', NULL, '688801', 'BV9C7V', NULL, '688801.SS', '688801.SS', 'SHA', 'CHN', NULL, 'EQU', NULL, NULL, 'IND'); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (7098759, 10, '@KOMPE1', 145413, 1, 186133, 'C', 1, 1, 'OSR', 'JP3306480009', '618A', 'BXFHB5', 'J3593S10', '618A.T', '618A.T', 'TYO', 'JPN', NULL, 'EQU', NULL, NULL, 'IND'); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11160626, 1, '04410360', 34576, 6, 138693, 'P', 1, 5, NULL, 'US0441036045', 'AHT PRF', 'BZ77ZD', '04410360', 'AHT_pf', 'AHT_pf.N', 'NYSE', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11176004, 1, '04410380', 34576, 8, 147715, 'P', 1, 7, NULL, 'US0441038025', 'AHT PRH', 'BF2N6M', '04410380', 'AHT_ph', 'AHT_ph.N', 'NYSE', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11176893, 1, '28907420', 1605, 2, 144576, 'P', 1, 1, NULL, 'US2890742057', 'ECF PRA', 'BF7J7S', '28907420', 'ECF_pa', 'ECF_pa.A', 'ASE', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11178972, 1, '04410388', 34576, 9, 147716, 'P', 1, 8, NULL, 'US0441038850', 'AHT PRI', 'BZ7MMX', '04410388', 'AHT_pi', 'AHT_pi.N', 'NYSE', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11189948, 1, '74726230', 3842, 2, 169480, 'P', 0, 1, NULL, 'US7472623013', 'QVCDQ', 'BF5K8M', '74726230', 'QVCDQ.PK^H26', 'QVCDQ.PK', 'OTC', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11194816, 1, 'CHAC', 118138, 2, 154457, 'C', 1, 1, 'OSR', 'US09090D6085', 'HLSQ', 'BXXNMS', '09090D60', 'HLSQ.K', 'HLSQ.A', 'ASE', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11202462, 1, '74726240', 3842, 3, 171392, 'P', 0, 2, NULL, 'US7472624003', 'QVCCQ', 'BKVHZH', '74726240', 'QVCCQ.PK^H26', 'QVCCQ.PK', 'OTC', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11223868, 1, '46265P10', 126880, 1, 160704, 'C', 1, 1, 'OSR', 'US46265P4046', 'IPW', 'BT6ML7', '46265P40', 'IPW.O', 'IPW.OQ', 'NASD', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11250501, 1, 'OMH', 136007, 1, 172892, 'C', 1, 1, 'OSR', 'KYG6S38M1318', 'OMH', 'BVPTKZ', 'G6S38M13', 'OMH.O', 'OMH.OQ', 'NASD', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11297842, 1, 'MCAH', 144796, 1, 185175, 'C', 1, 1, 'OSR', 'VGG629801009', 'MCAH', 'BRSCV0', 'G6298010', 'MCAH.O', 'MCAH.OQ', 'NASD', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11298874, 1, 'G6332510', 144785, 1, 185162, 'C', 1, 1, 'OSR', 'KYG633251072', 'ALPX', 'BVMYCS', 'G6332510', 'ALPX.O', 'ALPX.OQ', 'NASD', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11299661, 1, 'FTRA', 145035, 1, 185545, 'C', 1, 1, 'OSR', 'KYG373071086', 'FTRA', 'BQ0H24', 'G3730710', 'FTRA.K', 'FTRA.N', 'NYSE', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11300011, 1, 'TRSB', 145531, 1, 186318, 'C', 1, 1, 'OSR', 'US89839L1035', 'TRSB', 'BX7WKC', '89839L10', 'TRSB.PK', 'TRSB.PK', 'OTC', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11300033, 1, 'FDMM', 144964, 1, 185432, 'C', 1, 1, 'OSR', 'KYG255071071', 'FDMM', 'BX7WKQ', 'G2550710', 'FDMM.O', 'FDMM.OQ', 'NASD', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11300122, 1, 'JAB', 144985, 1, 185457, 'C', 1, 1, 'OSR', 'KYG500041036', 'ATLQ', 'C084D3', 'G5000410', 'ATLQ.O', 'ATLQ.OQ', 'NASD', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11300197, 1, 'QVC', 3842, 4, 186320, 'C', 1, 1, 'OSR', 'US7472921003', 'QVCG', 'BT6MK2', '74729210', 'QVCG.O', 'QVCG.OQ', 'NASD', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11300311, 1, 'WLCO', 144969, 1, 185437, 'C', 1, 1, 'OSR', 'KYG9640P1046', 'WLCO', 'C08GDH', 'G9640P10', 'WLCO.O', 'WLCO.OQ', 'NASD', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11300369, 1, 'FOIL', 145528, 1, 186310, 'C', 1, 1, 'ADR', 'US54179A1097', 'FOIL', 'C08GLZ', '54179A10', 'FOIL.K', 'FOIL.N', 'NYSE', 'USA', 5.0, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11300574, 1, 'G6004M10', 144408, 3, 186307, 'C', 1, 1, 'OSR', 'KYG6004M1078', 'MRCO', 'BT1BLL', 'G6004M10', 'MRCO.O', 'MRCO.OQ', 'NASD', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11301064, 1, 'G7359111', 145530, 1, 186314, 'C', 1, 1, 'OSR', 'KYG735911102', 'RNAQU', 'BNGH39', 'G7359111', 'RNAQU.O', 'RNAQU.OQ', 'NASD', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11301108, 1, 'G4791812', 145527, 1, 186309, 'C', 1, 1, 'OSR', 'KYG479181268', 'IPHXU', 'BVPTJ2', 'G4791812', 'IPHXU.O', 'IPHXU.OQ', 'NASD', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11301363, 1, 'JONE', 145153, 1, 185737, 'C', 1, 1, 'OSR', 'KYG517761055', 'JONE', 'BWJJD2', 'G5177610', 'JONE.O', 'JONE.OQ', 'NASD', 'USA', NULL, NULL, NULL, NULL, NULL);