| key |
id |
string(20)* |
= |
The primary key for the entity. |
| timeline |
asOfDateTime |
dateTime* |
=< >= |
Timestamp of the update. |
|
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) |
|
ISO code of the country/territory where the entity is located. For the purpose of RED reports, this field references to country or territory of the reference entity. |
|
currentlyCleared |
string(50)[50] |
|
Includes the name of clearing houses where a particular reference entity is getting cleared currently. |
|
cusip6 |
string(6) |
|
The six-character CUSIP code for this entity. |
|
defCurrency |
string(3) |
|
The default currency of the reference entity. |
|
defDocClause |
string(4) |
|
The default Doc clause of the reference entity. |
|
defTier |
string(8) |
|
The default tier of the reference entity. |
|
depthLevel |
string(4) |
|
Number of Markit CDS
pricing contributors.
Low = 0-3 contributors
Med = 4-8 contributors
High = 9 + contributors |
|
entityForm |
string(20) |
|
The entity legal form |
|
entityType |
string(20) |
|
• Corp - A corporate
• Sov - A sovereign
• State - A state, regional
government or provincial
government
• StatBody - A statutory body
• Supra - A supranational
• Insurer - An insurer
• Monoline - A monoline
insurer
• Index - A credit index
• Muni – A US municipal
entity |
|
events |
Events |
|
Describes events for the entity. |
|
holdCo |
boolean |
|
Indicates if the reference entity is a holding entity. |
|
indexConstituent |
string(50) |
|
Indicates the reference entity is a part of On/Off the run index series. |
|
isDelta |
boolean |
|
Determines is the record is part of the latest delta file. |
|
isProtocol |
string(1) |
|
Indicates the reference entity is protocol or not. |
|
isdaTradingDefinition |
string(9) |
|
Denotes the year the ISDA Definitions are applicable |
|
isdatransactiontypes |
IsdaTransactionTypes |
|
Determined by counterparties at the time of placing a trade. |
|
jurisdiction |
string(500) |
|
The legal jurisdiction/territory of this entity ie. Delaware or England & Wales |
|
lei |
string(20) |
|
The Legal Entity Identifier (LEI) or provisional LEI (CICI). |
|
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/territory of this entity ie. Delaware or England & Wales |
|
publicComments |
string(2000) |
|
Comment inserted by Markit regarding reference entity. |
|
ratings |
Rating[1000] |
|
The ratings for the entity. |
|
recordDate |
date |
|
If this tag is populated with a date, it indicates that A&O have scrubbed & legally verified that the entity in good standing as of that date. If this tag is not populated, it indicates that the entity is un-scrubbed data and has not been legally verified by A&O |
| filter_list |
redCode |
string(6) |
= |
The six-character RED code for this entity. |
|
redCodeUpdateDate |
date |
|
The date on which RED code was updated. |
|
region |
string(10) |
|
The region of the reference entity. |
|
sector |
string(500) |
|
Markit Sectors classification (Tier 2) |
|
shortName |
string(100) |
|
The Markit abbreviated company name based on the full legal name |
| filter_list |
ticker |
string(30) |
= |
The Markit ticker for this entity. |
|
validFrom |
date |
|
If this tag is included, this date is the date on which this entity came into existence following a corporate event. If this tag is not included, no entity-altering corporate events have occurred for this entity since the RED database was established. |
|
validTo |
date |
|
If this tag is included, this date is the date on which this entity ceased to exist following a corporate event.If this tag is not included, this company is an active entity. |