| key |
id |
string(100)* |
= |
Id for end-of-period financial data |
|
accountingPrinciple |
string(255) |
|
An accounting principle used to create financial statements |
|
accountingPrincipleShort |
string(20) |
|
An abbreviated name of an accounting principle used to create financial statements |
| link |
batch |
Batch* |
= |
Definition of a batch, representing a set of updates linked to a particular condition. |
| link |
batchRun |
BatchRun* |
= |
Defines an instance of a Batch. Where a Batch has a fixed definition over time, a BatchRun represents a specific Version of the Batch on a specific asOf. |
|
ciqCompanyId |
long(-2147483648,2147483647) |
|
Unique identifier assigned to a company |
|
collectionCompletionAsOf |
dateTime |
|
Date and time when collection of the financials is complete |
| link |
currencyCodeISO3 |
SnlCurrency |
|
Alphabetic code used to identify currencies pursuant to ISO-4217 |
|
currencyMultiplier |
long(0,255) |
|
Power of 10 to multiply the magnitude by for display purposes. |
|
currencyName |
string(80) |
|
A currency used for monetary transactions |
|
currentFinl |
boolean |
|
For any financial period, current data is the most up-to-date financial information available |
|
dateEndedStandard |
date |
|
Ending date of the fiscal period, standardized to be the last day of the month in which the period ends. |
|
earningsReleaseDate |
date |
|
Date on which earnings were first released to the public via news release, securities filing, or other public disclosure |
|
globalRegionId |
long(-128,127)* |
|
Identifies the global geographic region associated with the record. Valid values: 0 = Africa; 1 = Asia-Pacific; 2 = Europe; 3 = Latin America and the Caribbean; 4 = United States and Canada; and 5 = Middle East. |
|
institutionId |
long(-2147483648,2147483647) |
|
S&P's unique key to identify institutions. |
|
isCurrent |
boolean |
|
For any financial period, current data is the most up-to-date financial information available |
|
isOriginal |
boolean |
|
For any financial period, originally reported data is that which was reported to the public prior to any later restatement |
|
mostRecentOriginal |
long(0,255) |
|
Indicates the most recent originally reported data within a time series. Records with this value = 1 indicate that the row is the most recent. |
|
mostRecentOriginalHalfYear |
long(0,255) |
|
Indicates that the row is the most recent originally reported half year |
|
mostRecentOriginalYear |
long(0,255) |
|
Indicates that the row is the most recent originally reported year end |
|
mostRecentSequence |
long(-32768,32767) |
|
Indicates the most recent data available within a time series |
|
mostRecentSequenceFiscalYears |
long(0,255) |
|
Indicates that the row is the most recent year end |
|
mostRecentSequenceHalfYears |
long(0,255) |
|
Indicates that the row is the most recent half year |
|
originallyReportedFinl |
boolean |
|
For any financial period, originally reported data is that which was reported to the public prior to any later restatement |
|
periodEndDate |
date |
|
Date on which the fiscal period ended |
|
prelimCollectionCompletionAsOf |
dateTime |
|
Date and time when the preliminary collection of financials is complete |
|
restatementBasisId |
long(-2147483648,2147483647) |
|
For restated financial information, indicates the latest restatement for which the financial period was updated. |
|
stockPeriodId |
long(-2147483648,2147483647) |
|
Id for end-of-period financial data |
|
unconAccountingPrinciple |
string(255) |
|
An accounting principle used to create financial statements |
|
unconAccountingPrincipleShort |
string(20) |
|
An abbreviated name of an accounting principle used to create financial statements |