| key |
id |
string(20)* |
= |
Unique identifier for each identifier row. This field is a combination of symbolid followed by _0 if identifier is sourced from symbol_tbl. _1 if the identifier is sourced from goldensecuritysymbol and _2 for identifiers sourced from goldentradingitemidentifier_tbl. |
| timeline |
changeDatetime |
dateTime |
=< >= |
Last modification date and time of a physical row in UTC format. |
|
activeFlag |
boolean |
|
Indicates that the identifier is currently active. |
| link |
ciqCompanyId |
CompanyFoundation |
= |
Unique universal identifier assigned to a company. |
| link |
ciqSecurityId |
SecurityFoundation |
= |
Unique identifier assigned to a security. |
| link |
ciqTradingItemId |
TradingItemFoundation |
= |
Unique identifier assigned to a trading item. |
|
endDate |
date |
|
End date and time for the identifier value. It is the date and time on which the identifier ceased to exist. |
|
identifierId |
long(-2147483648,2147483647) |
|
Symbol id assigned to each identifier. |
| filter_list |
identifierTypeId |
long(1,999999) |
= |
Unique identifier for each identifier type. Example DUNS, Moody's Org Id, FDIC, LEI, Local IDs etc. |
| filter_list |
identifierTypeName |
string(100) |
= |
Identifier name corresponding to IdentifierTypeID. |
| filter_list |
identifierValue |
string(100) |
= |
Alphanumeric string or code assigned to an identifier that uniquely represents a particular entity. |
|
primaryFlag |
boolean |
|
Indicates that the identifier is primary for that company or security. For example, if a company has 2 different identifiers with same identifiertype, only one can be primary. |
|
productGroupLevel |
string(100) |
|
Hierarchical mapping of identifiers to a company: Organization Level Identifiers are classified as 'Company', representing the highest level; Instrument Level Identifiers, such as CUSIP9 and ISIN, are categorized as 'Security', denoting specific financial instruments; and Listing Level Identifiers, like SEDOL, are classified as 'TradingItem', relating to trading aspects of the securities. |
|
startDate |
date |
|
Start date and time for the identifier value. This generally indicates when a vendor issued the identifier. |