| key |
id |
string(100)* |
= |
The id field uniquely identifies the entity record. |
| timeline |
updDate |
dateTime* |
=< >= |
Last modification date and time of a physical row |
|
amendmentFlag |
boolean |
|
Indicates that this instance reflects an amendment filing |
| link |
bsRestatementType |
FinancialRestatementType |
|
The TypeId identifying the restatement type for the balance sheet (e.g. Press Release, Original, Restated) |
|
bsRestatementTypeId |
long(-2147483648,2147483647) |
|
The TypeId identifying the restatement type for the balance sheet (e.g. Press Release, Original, Restated) |
| link |
cfRestatementType |
FinancialRestatementType |
|
The TypeId identifying the restatement type for the statement of cash flow (e.g. Press Release, Original, Restated) |
|
cfRestatementTypeId |
long(-2147483648,2147483647) |
|
The TypeId identifying the restatement type for the statement of cash flow (e.g. Press Release, Original, Restated) |
|
currencyConversionPeriodEndDate |
date |
|
The date of the currency exchange rate used for conversions |
| link |
documentDetails |
DocumentDetails |
|
Unique identifier for a combination of documentID and PEO date |
|
documentDetailsId |
long(-2147483648,2147483647) |
|
Unique identifier for a combination of documentID and PEO date |
|
filingDate |
date |
|
Date the source document was filed |
| link |
financialDataSet |
FinancialDataSetType |
|
Source of Data representing inhouse collection, vendor data etc., |
|
financialDataSetId |
long(-2147483648,2147483647) |
|
Source of Data representing inhouse collection, vendor data etc., |
|
financialInstanceId |
long(-2147483648,2147483647)* |
|
Numeric identifier for the financial instance, representing a specific filing for a given financial period. |
| link |
financialPeriod |
FinancialPeriod |
|
The unique identifier for a company-to-reporting period relationship |
|
financialPeriodId |
long(-2147483648,2147483647) |
|
The unique identifier for a company-to-reporting period relationship |
|
hasConsolidatedFinancialsFlag |
boolean |
|
Flag indicating if the instance is having consolidated financials data |
|
hasUnConsolidatedFinancialsFlag |
boolean |
|
Flag indicating if the instance is having unconsolidated financials data |
| link |
instanceType |
FinancialInstanceType |
|
The TypeId identifying the instance type (e.g. Press Release, Original Instance, Encore) |
|
instanceTypeId |
long(-2147483648,2147483647) |
|
The TypeId identifying the instance type (e.g. Press Release, Original Instance, Encore) |
| link |
isRestatementType |
FinancialRestatementType |
|
The TypeId identifying the restatement type for the income statement (e.g. Press Release, Original, Restated) |
|
isRestatementTypeId |
long(-2147483648,2147483647) |
|
The TypeId identifying the restatement type for the income statement (e.g. Press Release, Original, Restated) |
|
latestFilingForInstanceFlag |
boolean |
|
The latestFilingForInstanceFlag is used when there are multiple records in the ciqFinInstance table that have the same financialPeriodId and the same filingDate.This would occur, for example, when a company filed its press release and its 10-Q on the same day. The latestFilingForInstanceFlag flag shows you the 'best' instance to use if you are trying to select between these two instances. |
|
latestForFinancialPeriodFlag |
boolean |
|
A flag indicating that this instance is the latest one for the financial period. If there are multiple instances, 1=the latest filing that exists for the financial period and 0= other instances. The instanceTypeId=4 (Backward column of a press release) are excluded from consideration if instanceTypeIds of 2 or 3 exist (Original Instance or Encore) for that financial period, as this would be replacing a complete source (e.g., an SEC filing) with an incomplete source (e.g., a press release). To view the latest and best source for a company, always screen for latestForFinancialPeriodFlag=1. |
|
latestUnConsolidatedInstanceForFilingDateFlag |
boolean |
|
The latestFilingForInstanceFlag is used when there are multiple records in the ciqFinInstance table that have the same financialPeriodId and the same filingDate.This would occur, for example, when a company filed its press release and its 10-Q on the same day. The latestFilingForInstanceFlag flag shows you the 'best' instance to use if you are trying to select between these two instances. |
|
latestUnConsolidatedInstanceForPeriodFlag |
boolean |
|
A flag indicating that this instance is the latest one for the financial period. If there are multiple instances, 1=the latest filing that exists for the financial period and 0= other instances. The instanceTypeId=4 (Backward column of a press release) are excluded from consideration if instanceTypeIds of 2 or 3 exist (Original Instance or Encore) for that financial period, as this would be replacing a complete source (e.g., an SEC filing) with an incomplete source (e.g., a press release). To view the latest and best source for a company, always screen for latestForFinancialPeriodFlag=1. |
|
reportedCurrencyId |
long(-32768,32768) |
|
Code for reported currency |
|
reportedCurrencyIso |
string(3) |
|
ISO Code for reported currency |
|
searchedForUnusualItemsTypeId |
long(0,20) |
|
0 for no, 1 for yes, 2 for not sure |
| link |
unConsolidatedBsRestatementType |
FinancialRestatementType |
|
The TypeId identifying the restatement type for the balance sheet (e.g. Press Release, Original, Restated) |
|
unConsolidatedBsRestatementTypeId |
long(-2147483648,2147483647) |
|
The TypeId identifying the restatement type for the balance sheet (e.g. Press Release, Original, Restated) |
| link |
unConsolidatedCfRestatementType |
FinancialRestatementType |
|
The TypeId identifying the restatement type for the statement of cash flow (e.g. Press Release, Original, Restated) |
|
unConsolidatedCfRestatementTypeId |
long(-2147483648,2147483647) |
|
The TypeId identifying the restatement type for the statement of cash flow (e.g. Press Release, Original, Restated) |
| link |
unConsolidatedIsRestatementType |
FinancialRestatementType |
|
The TypeId identifying the restatement type for the income statement (e.g. Press Release, Original, Restated) |
|
unConsolidatedIsRestatementTypeId |
long(-2147483648,2147483647) |
|
The TypeId identifying the restatement type for the income statement (e.g. Press Release, Original, Restated) |
|
updOperation |
long(0,2) |
|
Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted |
|
useAsComponentFlag |
boolean |
|
Flag indicating if the instance can be used as a component in calculating missing period calculations |