| key |
id |
string(20)* |
= |
The primary key for the entity. |
| timeline |
asOfDateTime |
dateTime* |
=< >= |
Date and time when the record was last updated. |
|
alternativeNames |
string(2000) |
|
The list of alternative names for this entity. Items in the list are usually separated with semicolons. |
| link |
batch |
Batch |
= |
The batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun |
= |
The BatchRun in which the data is updated. |
|
billingCode |
string(50) |
|
BillingCode for the entity. |
| filter_list |
ciqCompanyId |
long |
= |
The unique identifier created by S&P Capital IQ to identify an entity. |
|
companyNumber |
CompanyNumber |
|
The company number of this entity. |
|
country |
string(3) |
|
Country or territory code where the entity is located. Follows ISO 3166-1 alpha-3 code. |
|
currentlyCleared |
string(50)[50] |
|
Name of clearing houses where a particular reference entity is getting cleared currently. |
|
cusip6 |
string(6) |
|
The six-character CUSIP (Committee on Uniform Securities Identification Procedures) code for the reference entity. |
|
defCurrency |
string(3) |
|
The default currency of the reference entity. The expected values are - USD, EUR, GBP and JPY. |
|
defDocClause |
string(4) |
|
The default Doc clause of the reference entity. |
|
defTier |
string(8) |
|
The default tier of the reference entity. The expected values are - SNRFOR and SUBLT2. |
|
depthLevel |
string(4) |
|
Number of CDS (Credit Default Swap) pricing contributors. The expected values are - Low, Med and High. |
|
entityForm |
string(20) |
|
An entity legal form is the specific structural and legal classification of a business or organization under local laws. |
|
entityType |
string(20) |
|
Standardized classification of the reference entity. |
|
events |
Events |
|
Details of all the events applicable to the reference entity. |
|
gsibBucket |
long(1,5) |
|
The bucket in which each Global Systemically Important Banks (G-SIB) is assigned to based on how systemically important it is. |
|
holdCo |
boolean |
|
Indicates that the reference entity is a holding entity. |
|
indexConstituent |
string(50) |
|
The field is populated if the reference entity is a constintuent of any index. The expected values are - On-The-Run and Off-The-Run. |
|
isDelta |
boolean |
|
Indicates that the record is part of the latest delta file. |
|
isGsib |
boolean |
|
Indicates that the reference entity is a GSIB (Global Systemically Important Banks). The Financial Stability Board (FSB), in consultation with Basel Committee on Banking Supervision (BCBS) and national authorities publishes the global systemically important banks (G-SIBs) bank every year. GSIB are banks whose failure would pose serious risks to the global financial system. |
|
isProtocol |
string(1) |
|
International Swaps and Derivatives Association (ISDA) published a list of excluded refence entities for purposes of the ISDA 2014 Credit Derivatives Definitions Protocol. The expected field values are - N (if the reference entity is part of the excluded list) and P (if the reference entity is not part of excluded list). |
|
isdaTradingDefinition |
string(9) |
|
ISDA (International Swaps and Derivatives Association) trading definition which is applicable to the reference entity. The expected values are 1999, 2003, 2014 and 2003_2014. |
|
isdatransactiontypes |
IsdaTransactionTypes |
|
Determined by counterparties at the time of placing a trade. |
|
jurisdiction |
string(500) |
|
The legal jurisdiction or territory of the reference entity. |
|
lei |
string(20) |
|
The Legal Entity Identifier (LEI) or provisional LEI (CICI). |
|
leiStatus |
string(50) |
|
Status of the Legal Entity Identifier (LEI). |
|
name |
string(500) |
|
The full company legal name including punctuation. Uses the Latin character set, e.g. Nestle is shown with no acute accent over the last āeā. Asian names are translated to their English equivalent. |
|
orgJurisdiction |
string(300) |
|
The legal jurisdiction or territory of this entity. |
|
publicComments |
string(2000) |
|
Comment inserted by CDS (Credit Default Swap) Reference Data regarding reference entity. |
|
ratings |
Rating[1000] |
|
Rating details of the reference entity. |
|
recordDate |
date |
|
The date when A&O Shearman scrubs and legally verifies that the reference entity is in good standing. A null value indicates that the reference entity is unscrubbed and has not been legally verified. |
| filter_list |
redCode |
string(6) |
= |
The six-character RED (Reference Entity Data) code for this entity. |
|
redCodeUpdateDate |
date |
|
The date on which RED (Reference Entity Data) code was updated. |
|
region |
string(10) |
|
The region of the reference entity. |
|
sector |
string(500) |
|
Tier 2 sector classification of the reference entity. |
|
shortName |
string(100) |
|
The CDS (Credit Default Swap) Reference Data abbreviated company name based on the full legal name. |
| filter_list |
ticker |
string(30) |
= |
The CDS (Credit Default Swap) Reference Data ticker for the reference entity. |
|
validFrom |
date |
|
Date on which this entity came into existence following a corporate event. If this field in not populated, it means no entity-altering corporate events have occurred for this entity since the RED (Reference Entity Data) database was established. |
|
validTo |
date |
|
Date on which this entity ceased to exist following a corporate event. If this field is not populated, it means this company is still an active entity. |