| key |
id |
string(100)* |
= |
Id for end-of-period financial data |
|
accountingPrinciple |
string(255) |
|
An accounting principle used to create financial statements |
| link |
accountingPrincipleId |
SnlAccountingPrinciple |
|
Lookup key used to identify accounting principles 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 |
| 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 |
|
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 |
|
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 |
|
periodEndDate |
date |
|
Date on which the fiscal period ended |
|
restatementBasisId |
long(-2147483648,2147483647) |
|
For restated financial information, indicates the latest restatement for which the financial period was updated. |
|
restatementDate |
date |
|
Date of an event that caused a restatement. This is the effective date of a pooling-of-interests merger, or the date as of which a new accounting pronouncement becomes effective. |
| link |
restatementEventId |
SnlRestatementEventType |
|
Restatement Event Reason Id |
|
restatementEventType |
string(30) |
|
A generalized reason why a financial restatement might occur |
|
restatementReason |
string(255) |
|
Reason for a restatement |
|
stockPeriodId |
long(-2147483648,2147483647) |
|
Id for end-of-period financial data |
|
unconAccountingPrinciple |
string(255) |
|
An accounting principle used to create financial statements |
| link |
unconAccountingPrincipleId |
SnlAccountingPrinciple |
|
Lookup key used to identify unconsolidated accounting principles used to create financial statements |
|
unconAccountingPrincipleShort |
string(20) |
|
An abbreviated name of an accounting principle used to create financial statements |