| key |
id |
string(100)* |
= |
The id field uniquely identifies the entity record. |
| timeline |
lastModifiedDate |
dateTime* |
=< >= |
Last Modified Date of the record |
| filter_list |
assetClass |
string(25) |
= |
Denotes asset class of the instrument |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the reference data is updated |
|
companyId |
long(-2147483648,2147483647) |
|
Unique S&P Capital IQ company identifier |
|
countryCode |
string(3) |
|
ISO 3166 codes denoting country/territory of incorporation for the company that has issued the associated instrument. |
|
currencyCode |
string(3) |
|
ISO 4217 codes denoting the currency in which the instrument is trading |
|
exchange |
string(4) |
|
Market Identifier Code allocated to the market named in 'Market Name-Institution Description' |
|
exchangeCountry |
string(2) |
|
Alpha-2 code of the country where the market is registered |
|
exchangeName |
string(100) |
|
Known acronym of the market |
|
futureTicker |
string(10) |
|
Ticker created based on future product root along with the month and year of expiry |
|
isPrimary |
boolean |
|
Indicates that the security is the primary issue. Accepted values are TRUE, FALSE |
| filter_list |
isin |
string(12) |
= |
The ISIN (International Securities Identification Number) to which the price data applies. |
|
listingId |
string(100) |
|
This denotes the listing Id for the instrument as on ICE dataset |
|
longName |
string(200) |
|
Long description of the current instrument. This could be company name, description, etc. |
| filter_list |
productRoot |
string(4) |
= |
Primary Product Root code for a series of futures. |
| filter_list |
sedol |
string(7) |
= |
The SEDOL of an instrument traded on the listing exchange. |
|
status |
string(10) |
|
Denotes the status of the instrument |
|
symbol |
string(20) |
|
The internal symbol used while listing an instrument. |
|
ticker |
string(100) |
|
The ticker symbol used by the exchange (if available). Uniquely identifies a security within a specific exchange. By contrast, SymbolTicker may have specific prefixes, etc. |
|
type |
string(250) |
|
Instrument type name. |