| key |
id |
string(100)* |
= |
The id field uniquely identifies the entity record. |
| timeline |
updDate |
dateTime* |
=< >= |
Last modification date and time of a physical row |
|
calendarQuarter |
long(1,4) |
|
The calendar quarter of the audit |
|
calendarYear |
long(1900,3000) |
|
The calendar year of the audit |
|
companyId |
long(-2147483648,2147483647) |
|
Unique identifier denoting a company |
|
financialPeriodId |
long(-2147483648,2147483647)* |
|
Numeric identifier for the financial reporting period associated with a company. |
|
fiscalChainSeriesId |
long(-2147483648,2147483647) |
|
The fiscal chain series is used to flag fiscal year changes. The value increments each time a fiscal year change occurs. |
|
fiscalQuarter |
long(1,4) |
|
The fiscal quarter for this financial period |
|
fiscalYear |
long(1900,3000) |
|
The fiscal year for this financial period |
| link |
periodType |
FinancialPeriodType |
|
Denotes whether a period is a quarter, annual, semi-annual, LTM, or YTD |
|
periodTypeId |
long(-2147483648,2147483647) |
|
Denotes whether a period is a quarter, annual, semi-annual, LTM, or YTD |
|
updOperation |
long(0,2) |
|
Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted |