| key |
id |
string(100)* |
= |
Unique identifier for a combination of documentID and PEO date |
| timeline |
updDate |
dateTime* |
=< >= |
Last modification date and time of a physical row |
|
accessionNumber |
string(100) |
|
A unique SEC or SEDAR identifier that identifies a document |
|
clickThroughLinkId |
string(100) |
|
Unique identifier assigned by the securities commission for a filing |
|
companyId |
long(-2147483648,2147483647) |
|
Unique identifier denoting a company |
|
documentDetailsId |
long(-2147483648,2147483647)* |
|
Numeric identifier for the document details record, representing a unique combination of document and period end date. |
|
documentId |
string(50) |
|
A unique CIQ identifier that identifies the source document used for this update |
|
documentPeriod |
date |
|
The period date of the financial report |
|
filingDate |
date |
|
Date the source document was filed |
|
formTypeId |
long(-2147483648,2147483647) |
|
The Type Id identifying the from type (1 = Annual; 2= Other than Annual) |
| link |
formTypeText |
FormType |
|
Indicates the type of filling from which the data is collected |
|
pressReleaseFlag |
boolean |
|
Indicates if the document is from Preliminary earnings release. This information is usually released by the company prior to the official filing or release of data. |
|
searchedForUnusualItemsTypeId |
long(0,20) |
|
0 for no, 1 for yes, 2 for not sure |
|
updOperation |
long(0,2) |
|
Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted |