| key |
id |
string(100)* |
= |
The unique identifier for the date on which property data was aggregated. |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the entity is sent. |
|
companyId |
long(-2147483648,2147483647) |
|
The Standard & Poor's (S&P) Cap IQ Company ID, which is a universal identifier for companies to enable comparability and linkage across datasets. |
| link |
currencyId |
Currency* |
|
The alphabetic code used to identify currencies, pursuant to the International Organization for Standardization (ISO) 4217 standard. |
|
dateEnded |
date* |
|
The date on which the fiscal period ended |
|
dateEndedStandard |
date* |
|
The 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. |
|
institutionId |
long(-2147483648,2147483647)* |
|
A unique identifier provided by Standard & Poor's (S&P) to identify institutions. Institutions are corporations, partnerships, proprietorships, not-for-profit organizations, government agencies, and any other chartered organization. |
|
institutionName |
string(80) |
|
The official name of the institution. |
| link |
measurementStandardId |
MeasurementStandard* |
|
A lookup key for measurement standards. If a lookup is not used, "0" represents United States Standard and "1" represents Metric. |
|
mostRecentSequence |
long(-32768,32767) |
|
A numerical rank indicating the recency of a record within its time series. A value of 1 denotes the most recent record, with increasing values (2, 3, etc.) representing progressively older records. The number of ranked records varies by entity, but a rank of 1 is always present. |
|
propertyAggregateDateId |
long(-2147483648,2147483647)* |
|
The unique identifier for the date on which property data was aggregated. |
|
propertyAggregateDatePriorId |
long(-2147483648,2147483647) |
|
The identifier that was previously assigned or in use for this record. |
|
propertyAggregateMarketNotes |
string(1000) |
|
Notes applying to the aggregate market data. |
|
propertyAggregateTenantNotes |
string(1000) |
|
Notes applying to the aggregate tenant data. |