| key |
id |
string(100)* |
= |
The id field uniquely identifies the entity record. |
|
annualization |
decimal{28,15}* |
|
Number by which flow financial items need to be multiplied to get an annualized figure |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the Price is calculated. |
|
ciqCompanyId |
long(-2147483648,2147483647)* |
|
Unique identifier assigned to a company |
|
currencyCodeISO3 |
string(3) |
|
Alphabetic code used to identify currencies pursuant to ISO-4217 |
|
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 |
|
dataSourcePeriod |
string(6) |
|
Together with the KeyInstn and the restatement status, completes the unique key used to identify a financial period within the DataSource. Concatenation of the Fiscal Year and Fiscal Period values, or, for derived periods, may be 'LTM' or some other designation. |
|
fiscalPeriod |
string(20) |
|
Description of this fiscal period |
|
fiscalPeriodId |
string(1) |
|
A token representing the space of this financial period with respect to the company's fiscal year. This may be the fiscal quarter, indicated by the numbers 1 through 4, but may also be any of several other indicators to represent fiscal years, entered or derived year-to-date periods, or other types of records. |
|
flowPeriodId |
long(-2147483648,2147483647)* |
|
Financial Period Key. A financial period is any period of time over which an institution's financial information is measured. Different measures of financial information may be available for the same institution and time period as the result of restatements. |
|
institutionId |
long(-2147483648,2147483647)* |
|
S&P's unique key to identify institutions. Institutions are corporations, partnerships, proprietorships, not-for-profit organizations, government agencies, and any other chartered organization. |
|
mostRecentSequence |
long(-32768,32767)* |
|
Indicates the most recent data available within a time series. Rows with this value = 1 indicate that the row is the most recent. Some objects, but not all objects, require the calculation of varying numbers of data prior to the most recent. These rows are indicated with increasing values moving back through time. For example, the most recent row has a value of 1, the next most recent, or immediately prior, has a value of 2. The next prior record has a value of 3, and so on. The number of rows flagged with these values varies from object to object, but there will always be at least the one row marked with a 1. |
|
mostRecentSequenceFiscalYears |
long(0,255)* |
|
Indicates that the row is the most recent year end |
|
originallyReportedFinl |
boolean |
|
For any financial period, originally reported data is that which was reported to the public prior to any later restatement |
|
periodEndDate |
dateTime* |
|
Ending date of the fiscal period, standardized to be the last day of the month in which the period ends. For example, if a fiscal period ends on June 29, this date will be June 30, so that there is a consistency among different companies. |
|
restated |
boolean* |
|
Indicates the financial record has been restated |
|
stockPeriodId |
long(-2147483648,2147483647)* |
|
Object key identifying end-of-period financial data |