Type PropertyAggregateEOPFlat
Type category Entity
Description The aggregate end-of-period information for real estate property portfolios.
Fields
Name Type Filters Description
key id string(100)* = The identifier for Property Aggregate End Of Period (EOP) Flat.
link batch Batch* = The Batch for which this BatchRun is an instance.
link batchRun BatchRun* = The BatchRun in which the entity is sent.
filter_list 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.
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.
propertyAggPipelineUnfunded long(-2147483648,2147483647) The publicly stated projection of the total costs to be incurred in the construction of new real estate developments, specifically those amounts that are still outstanding. (Magnitude: $000)
propertyAggregateEOPFlatId long(-2147483648,2147483647)* The identifier for Property Aggregate End Of Period (EOP) Flat.
propertyAggregateEOPPriorId long(-2147483648,2147483647) The prior identifier.
propertyAggregatePipeline long(-2147483648,2147483647) The publicly stated projection of the total costs to be incurred in the construction of new real estate developments. (Magnitude: $000)
propertyAggregatePipelineCost long(-2147483648,2147483647) The publicly stated projection of the total costs to be incurred in the construction of new real estate developments, specifically those amounts that have already been incurred. (Magnitude: $000)
propertyCount long(-2147483648,2147483647) The aggregate property count of in-service owned assets as of the end of the period, as reported by the company. This represents the number of wholly in-service owned, joint venture, and operated or leased properties in which the company has an equity interest. It does not include franchised or managed-only properties. (Magnitude: actual)
propertyCountHealthcare long(-32768,32767) The aggregate property count of in-service owned health-care assets as of the end of the period, as reported by the company. (Magnitude: actual)
propertyCountHotel long(-32768,32767) The aggregate property count of in-service owned hotel assets as of the end of the period, as reported by the company. (Magnitude: actual)
propertyCountIndustrial long(-32768,32767) The aggregate property count of in-service owned industrial assets as of the end of the period, as reported by the company. (Magnitude: actual)
propertyCountMall long(-32768,32767) The aggregate property count of in-service owned enclosed mall assets as of the end of the period, as reported by the company. (Magnitude: actual)
propertyCountManufacturedHousing long(-32768,32767) The aggregate property count of in-service owned manufactured housing assets as of the end of the period, as reported by the company. (Magnitude: actual)
propertyCountMovieTheater long(-32768,32767) The aggregate property count of in-service owned theater assets as of the end of the period, as reported by the company. (Magnitude: actual)
propertyCountMultifamily long(-2147483648,2147483647) The aggregate property count of in-service owned multifamily assets as of the end of the period, as reported by the company. (Magnitude: actual)
propertyCountOffice long(-32768,32767) The aggregate property count of in-service owned office assets as of the end of the period, as reported by the company. (Magnitude: actual)
propertyCountOther long(-2147483648,2147483647) The aggregate property count of in-service owned diversified assets as of the end of the period, as reported by the company. (Magnitude: actual)
propertyCountOutletCenter long(-32768,32767) The aggregate property count of in-service owned outlet center assets as of the end of the period, as reported by the company. (Magnitude: actual)
propertyCountPowerCenter long(-32768,32767) The aggregate property count of in-service owned power center assets as of the end of the period, as reported by the company. (Magnitude: actual)
propertyCountRestaurant long(-32768,32767) The aggregate property count of in-service owned restaurant assets as of the end of the period, as reported by the company. (Magnitude: actual)
propertyCountRetail long(-32768,32767) The aggregate property count of in-service owned retail assets as of the end of the period, as reported by the company. (Magnitude: actual)
propertyCountSelfStorage long(-32768,32767) The aggregate property count of in-service owned self-storage assets as of the end of the period, as reported by the company. (Magnitude: actual)
propertyCountShoppingCenter long(-32768,32767) The aggregate property count of in-service owned shopping center assets as of the end of the period, as reported by the company. (Magnitude: actual)
propertyCountSingleTenant long(-32768,32767) The aggregate property count of in-service owned single-tenant retail assets as of the end of the period, as reported by the company. (Magnitude: actual)
propertySizeAreaMultifamily long(-2147483648,2147483647) The aggregate area contained in owned residential assets as of the end of the period, as reported by the company. (Magnitude: sq. ft.)
propertySizeBeds long(-2147483648,2147483647) The number of beds in a health-care or student housing facility. (Magnitude: actual)
propertySizeGLA decimal{22,8} The total area of the property as reported by the company. If total area is not reported by the company but owned gross leasable area is disclosed, owned gross leasable area is presented if applicable. (Magnitude: sq. ft.)
propertySizeMovieScreens long(-2147483648,2147483647) The number of movie screens. (Magnitude: actual)
propertySizeRooms long(-2147483648,2147483647) The size of a hotel or hotels measured in number of rooms and suites. (Magnitude: rooms)
propertySizeSqFtHealthcare decimal{22,8} The aggregate area contained in owned health-care assets as of the end of the period, as reported by the company. (Magnitude: sq. ft.)
propertySizeSqFtIndustrial decimal{22,8} The aggregate area contained in owned industrial assets as of the end of the period, as reported by the company. (Magnitude: sq. ft.)
propertySizeSqFtMall decimal{22,8} The aggregate area contained in owned enclosed mall assets as of the end of the period, as reported by the company. (Magnitude: sq. ft.)
propertySizeSqFtMovieTheater decimal{22,8} The aggregate area contained in owned theater assets as of the end of the period, as reported by the company. (Magnitude: sq. ft.)
propertySizeSqFtMultifamily decimal{22,8} The aggregate area contained in owned residential assets as of the end of the period, as reported by the company. (Magnitude: sq. ft.)
propertySizeSqFtOffice decimal{22,8} The aggregate area contained in owned office assets as of the end of the period, as reported by the company. (Magnitude: sq. ft.)
propertySizeSqFtOther decimal{22,8} The aggregate area contained in owned diversified assets as of the end of the period, as reported by the company. (Magnitude: sq. ft.)
propertySizeSqFtOutletCenter decimal{22,8} The aggregate area contained in owned outlet center assets as of the end of the period, as reported by the company. (Magnitude: sq. ft.)
propertySizeSqFtPowerCenter decimal{22,8} The aggregate area contained in owned power center assets as of the end of the period, as reported by the company. (Magnitude: sq. ft.)
propertySizeSqFtRestaurant decimal{22,8} The aggregate area contained in owned restaurant assets as of the end of the period, as reported by the company. (Magnitude: sq. ft.)
propertySizeSqFtRetail decimal{22,8} The aggregate area contained in owned retail assets as of the end of the period, as reported by the company. (Magnitude: sq. ft.)
propertySizeSqFtSelfStorage decimal{22,8} The aggregate area contained in owned self-storage assets as of the end of the period, as reported by the company. (Magnitude: sq. ft.)
propertySizeSqFtShoppingCenter decimal{22,8} The aggregate area contained in owned shopping center assets as of the end of the period, as reported by the company. (Magnitude: sq. ft.)
propertySizeSqFtSingleTenant decimal{22,8} The aggregate area contained in owned single-tenant retail assets as of the end of the period, as reported by the company. (Magnitude: sq. ft.)
propertySizeStorageUnits long(-2147483648,2147483647) The number of self-storage units. (Magnitude: actual)
propertySizeTheaterSeats long(-2147483648,2147483647) The number of theater seats. (Magnitude: actual)
propertySizeUnits long(-2147483648,2147483647) The number of apartments or other dwelling units in the property. (Magnitude: units)
propertySizeUnitsManufacturedHousing long(-2147483648,2147483647) The aggregate number of units contained in owned manufactured housing assets as of the end of the period, as reported by the company. (Magnitude: actual)
55 rows of 55 total
API Open API Specification