Type PropertyAggregateDate
Type category Entity
Description Contains property aggregate data, specifying the date and company for which the various aggregates are measured.
Fields
Name Type Filters Description
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.
15 rows of 15 total
API Open API Specification