Type PropertyAggregateFinl
Type category Entity
Description The aggregate flow information for real estate property portfolios.
Fields
Name Type Filters Description
key id string(100)* = The unique identifier for property aggregate financial data.
annualization decimal{22,8}* The factor by which flow financial items are multiplied to obtain an annualized figure.
link batch Batch* = The Batch for which this BatchRun is an instance.
link batchRun BatchRun* = The BatchRun in which the entity is sent.
compNRnwlOptLsLIncOvPriorRent decimal{5,1} The straight lined basis as a percent of increase over prior rent for comparable total new, renewal and option leases. (Magnitude: %)
compNewLeasesCount long(-2147483648,2147483647) The number of leases for comparable new leases, as reported by the company. (Magnitude: actual)
compNewLeasesNewRPSF decimal{22,8} The average rent per area for comparable newly signed leases, as reported. (Magnitude: $/sq ft/yr)
compNewLeasesPriorRPSF decimal{22,8} The prior year rent per area for comparable newly signed leases, as reported. (Magnitude: $/sq ft/yr)
compNewLeasesSF decimal{22,8} The area for comparable newly signed leases, as reported by the company. (Magnitude: sq. ft.)
compNewLeasesWALT decimal{5,1} The weighted average lease term (WALT) remaining for comparable newly signed leases, as reported by the company. (Magnitude: years)
compNewLsCBIncOverPriorRent decimal{5,1} Cash basis as a percent of increase over prior rent for comparable newly signed leases. (Magnitude: %)
compNewLsSLIncOverPriorRent decimal{5,1} Straight lined basis as a percent of increase over prior rent for comparable newly signed leases. (Magnitude: %)
compNewRenewalLeasesCount long(-2147483648,2147483647) The number of leases for comparable total new and renewal leases, as reported by the company. (Magnitude: actual)
compNewRenewalLeasesSF decimal{22,8} The area for comparable total new and renewal leases, as reported by the company. (Magnitude: sq. ft.)
compNewRenewalLeasesWALT decimal{5,1} The weighted average lease term (WALT) remaining for comparable total new and renewal leases, as reported by the company. (Magnitude: years)
compNewRenewalOptLeasesCount long(-2147483648,2147483647) The number of leases for comparable total new, renewal and option leases, as reported by the company. (Magnitude: actual)
compNewRenewalOptLeasesWALT decimal{5,1} The weighted average lease term (WALT) remaining for comparable total new, renewal and option leases, as reported by the company. (Magnitude: years)
compNewRenewalOptionLeasesSF decimal{22,8} The area for comparable total new, renewal and option leases, as reported by the company. (Magnitude: sq. ft.)
compNewRnwlLsCBIncOverPriorRent decimal{5,1} Cash basis as a percent of increase over prior rent for comparable total new and renewal leases. (Magnitude: %)
compNewRnwlLsNewRPSF decimal{22,8} The average rent per area for comparable total new and renewal leases, as reported. (Magnitude: $/sq ft/yr)
compNewRnwlLsPriorRPSF decimal{22,8} The prior year rent per area for comparable total new and renewal leases, as reported. (Magnitude: $/sq ft/yr)
compNewRnwlLsSLIncOverPriorRent decimal{5,1} Straight lined basis as a percent of increase over prior rent for comparable total new and renewal leases. (Magnitude: %)
compNewRnwlOptLsCBIncOvPriorRent decimal{5,1} Cash basis as a percent of increase over prior rent for comparable total new, renewal and option leases. (Magnitude: %)
compNewRnwlOptLsNewPSF decimal{22,8} The average rent per area for comparable total new, renewal and option leases, as reported. (Magnitude: $/sq ft/yr)
compNewRnwlOptLsPriorRPSF decimal{22,8} The prior year rent per area for comparable total new, renewal and option leases, as reported. (Magnitude: $/sq ft/yr)
compNonCmpNewLsCBIncOverPriorRent decimal{5,1} Cash basis as a percent of increase over prior rent for total comparable and non-comparable new leases. (Magnitude: %)
compNonCmpNewLsSLIncOverPriorRent decimal{5,1} Straight lined basis as a percent of increase over prior rent for total comparable and non-comparable new leases. (Magnitude: %)
compNonCmpNwRnwLsSLIncOvPriorRent decimal{5,1} Straight lined basis as a percent of increase over prior rent for total comparable and non-comparable, total new and renewal leases. (Magnitude: %)
compNonCmpNwRnwlLsCBIncOvPriorRent decimal{5,1} Cash basis as a percent of increase over prior rent for total comparable and non-comparable, total new and renewal leases. (Magnitude: %)
compNonCmpNwRnwlOpLsCBIncOvPriorRent decimal{5,1} Cash basis as a percent of increase over prior rent for total comparable and non-comparable, total new, renewal and option leases. (Magnitude: %)
compNonCmpNwRnwlOpLsSLIncOvPriorRent decimal{5,1} Straight lined basis as a percent of increase over prior rent for total comparable and non-comparable, total new, renewal and option leases. (Magnitude: %)
compNonCompNewLeasesCount long(-2147483648,2147483647) The number of leases for total comparable and non-comparable new leases, as reported by the company. (Magnitude: actual)
compNonCompNewLeasesSF decimal{22,8} The area for total comparable and non-comparable new leases, as reported by the company. (Magnitude: sq. ft.)
compNonCompNewLeasesWALT decimal{5,1} The weighted average lease term (WALT) remaining for total comparable and non-comparable new leases, as reported by the company. (Magnitude: years)
compNonCompNewLsBaseRent long(-2147483648,2147483647) The base rent for total comparable and non-comparable new leases, as reported. (Magnitude: $000)
compNonCompNewLsNewRPSF decimal{22,8} The average rent per area for total comparable and non-comparable new leases, as reported. (Magnitude: $/sq ft/yr)
compNonCompNewLsPriorRPSF decimal{22,8} The prior year rent per area for total comparable and non-comparable new leases. (Magnitude: $/sq ft/yr)
compNonCompNewRenewalLeasesArea long(-2147483648,2147483647) The area for total comparable and non-comparable total new and renewal leases, as reported by the company. (Magnitude: sq. ft.)
compNonCompNewRenewalLeasesCount long(-2147483648,2147483647) The number of leases for total comparable and non-comparable total new and renewal leases, as reported by the company. (Magnitude: actual)
compNonCompNewRenewalLeasesSF decimal{22,8} The area for total comparable and non-comparable total new and renewal leases, as reported by the company. (Magnitude: sq. ft.)
compNonCompNewRenewalLsWALT decimal{5,1} The weighted average lease term (WALT) remaining for total comparable and non-comparable total new and renewal leases, as reported by the company. (Magnitude: years)
compNonCompNewRenewalOptLsArea long(-2147483648,2147483647) The area for total comparable and non-comparable total new, renewal and option leases, as reported by the company. (Magnitude: sq. ft.)
compNonCompNewRenewalOptLsCount long(-2147483648,2147483647) The number of leases for total comparable and non-comparable total new, renewal and option leases, as reported by the company. (Magnitude: actual)
compNonCompNewRenewalOptLsSF decimal{22,8} The area for total comparable and non-comparable total new, renewal and option leases, as reported by the company. (Magnitude: sq. ft.)
compNonCompNewRenewalOptLsWALT decimal{5,1} The weighted average lease term (WALT) remaining for total comparable and non-comparable total new, renewal and option leases, as reported by the company. (Magnitude: years)
compNonCompNewRnwlLsBaseRent long(-2147483648,2147483647) The base rent for total comparable and non-comparable, total new and renewal leases, as reported. (Magnitude: $000)
compNonCompNewRnwlLsNewRPA decimal{7,2} The average rent per area for total comparable and non-comparable, total new and renewal leases, as reported. (Magnitude: $/sq ft/yr)
compNonCompNewRnwlLsNewRPSF decimal{22,8} The average rent per area for total comparable and non-comparable total new and renewal leases, as reported. (Magnitude: $/sq ft/yr)
compNonCompNewRnwlLsPriorRPA decimal{7,2} The prior year contractual rent per area for total comparable and non-comparable, total new and renewal leases. (Magnitude: $/sq ft/yr)
compNonCompNewRnwlLsPriorRPSF decimal{22,8} The prior year contractual rent per area for total comparable and non-comparable, total new and renewal leases. (Magnitude: $/sq ft/yr)
compNonCompNewRnwlOpLsNwRPSF decimal{22,8} The contractual rent per area for total comparable and non-comparable, total new, renewal and option leases. (Magnitude: $/sq ft/yr)
compNonCompNewRnwlOpLsPriorRPA decimal{7,2} The prior year contractual rent per area for total comparable and non-comparable, total new, renewal and option leases. (Magnitude: $/sq ft/yr)
compNonCompNewRnwlOptLsBaseRent long(-2147483648,2147483647) The base rent for total comparable and non-comparable, total new, renewal and option leases, as reported. (Magnitude: $000)
compNonCompNewRnwlOptLsNewRPA decimal{7,2} The contractual rent per area for total comparable and non-comparable, total new, renewal and option leases. (Magnitude: $/sq ft/yr)
compNonCompNewRnwlOptLsPriorRPSF decimal{22,8} The prior year contractual rent per area for total comparable and non-comparable, total new, renewal and option leases. (Magnitude: $/sq ft/yr)
compNonCompOptLeasesCount long(-2147483648,2147483647) The number of leases for total comparable and non-comparable option leases, as reported by the company. (Magnitude: actual)
compNonCompOptLsBaseRent long(-2147483648,2147483647) The base rent for total comparable and non-comparable option leases, as reported. (Magnitude: $000)
compNonCompOptLsCBIncOvPriorRent decimal{5,1} The cash basis as a percent of increase over prior rent for total comparable and non-comparable option leases. (Magnitude: %)
compNonCompOptLsNewRPSF decimal{22,8} The average rent per area for total comparable and non-comparable option leases, as reported. (Magnitude: $/sq ft/yr)
compNonCompOptLsPriRPSF decimal{22,8} The prior year contractual rent per area for total comparable and non-comparable option leases. (Magnitude: $/sq ft/yr)
compNonCompOptLsSLIncOvPriorRent decimal{5,1} The straight lined basis as a percent of increase over prior rent for total comparable and non-comparable option leases. (Magnitude: %)
compNonCompOptionLeasesSF decimal{22,8} The area for total comparable and non-comparable option leases, as reported by the company. (Magnitude: sq. ft.)
compNonCompOptionLeasesWALT decimal{5,1} The weighted average lease term (WALT) remaining for total comparable and non-comparable option leases, as reported by the company. (Magnitude: years)
compNonCompRenewalLeasesCount long(-2147483648,2147483647) The number of leases for total comparable and non-comparable renewal leases, as reported by the company. (Magnitude: actual)
compNonCompRenewalLeasesSF decimal{22,8} The area for total comparable and non-comparable total new and renewal leases, as reported by the company. (Magnitude: sq. ft.)
compNonCompRenewalLeasesWALT decimal{5,1} The weighted average lease term (WALT) remaining for total comparable and non-comparable total new and renewal leases, as reported by the company. (Magnitude: years)
compNonCompRnwlLsBaseRent long(-2147483648,2147483647) The base rent for total comparable and non-comparable renewal leases, as reported. (Magnitude: $000)
compNonCompRnwlLsCBIncOvPriorRent decimal{5,1} The cash basis as a percent of increase over prior rent for total comparable and non-comparable renewal leases. (Magnitude: %)
compNonCompRnwlLsNewRPSF decimal{22,8} The average rent per area for total comparable and non-comparable renewal leases, as reported. (Magnitude: $/sq ft/yr)
compNonCompRnwlLsPriorRPSF decimal{22,8} The prior year contractual rent per area for total comparable and non-comparable renewal leases. (Magnitude: $/sq ft/yr)
compNonCompRnwlLsSLIncOvPriorRent decimal{5,1} The straight lined basis as a percent of increase over prior rent for total comparable and non-comparable renewal leases. (Magnitude: %)
compOptLeasesNewRPSF decimal{22,8} The average rent per area for comparable option leases, as reported. (Magnitude: $/sq ft/yr)
compOptLeasesPriorRPSF decimal{22,8} The prior year rent per area for comparable option leases, as reported. (Magnitude: $/sq ft/yr)
compOptLsCBIncOverPriorRent decimal{5,1} The cash basis as a percent of increase over prior rent for comparable option leases. (Magnitude: %)
compOptLsSLIncOverPriorRent decimal{5,1} The straight lined basis as a percent of increase over prior rent for comparable option leases. (Magnitude: %)
compOptionLeasesSF decimal{22,8} The area for comparable option leases, as reported by the company. (Magnitude: sq. ft.)
compOptionLeasesWALT decimal{5,1} The weighted average lease term (WALT) remaining for comparable option leases, as reported by the company. (Magnitude: years)
compRenewalLeasesCount long(-2147483648,2147483647) The number of leases for comparable renewal leases, as reported by the company. (Magnitude: actual)
compRenewalLeasesSF decimal{22,8} The area for comparable renewal leases, as reported by the company. (Magnitude: sq. ft.)
compRenewalLeasesWALT decimal{5,1} The weighted average lease term (WALT) remaining for comparable renewal leases, as reported by the company. (Magnitude: years)
compRnwlLeasesNewRPSF decimal{22,8} The average rent per area for comparable total new and renewal leases, as reported. (Magnitude: $/sq ft/yr)
compRnwlLeasesPriorRPSF decimal{22,8} The prior year rent per area for comparable total new and renewal leases. (Magnitude: $/sq ft/yr)
compRnwlLsCBIncOverPriorRent decimal{5,1} The cash basis as a percent of increase over prior rent for comparable total new and renewal leases. (Magnitude: %)
compRnwlLsSLIncOverPriorRent decimal{5,1} The straight lined basis as a percent of increase over prior rent for comparable total new and renewal leases. (Magnitude: %)
comparableOptionLeasesCount long(-2147483648,2147483647) The number of leases for comparable option leases, as reported by the company. (Magnitude: actual)
dataSourcePeriod string(6) A unique identifier for a financial period within the data source, which, along with the Standard & Poor's (S&P) Cap IQ Company ID (KeyInstn) and restatement status, forms a unique key. It is typically a concatenation of the fiscal year and fiscal period values. For derived periods, it may be 'Last Twelve Months (LTM)' or another designation.
dateBegun date* The date on which the fiscal period began.
economicOccupancy decimal{5,2} The economic occupancy rate of the property or properties. If an average occupancy is not available, an end-of-period measurement may be substituted, as reported. (Magnitude: %)
link fiscalPeriodGAAPId FiscalPeriodGAAP A unique key used to identify a financial period on a fiscal basis, which, along with the Standard & Poor's (S&P) Cap IQ Company ID (KeyInstn) and the restatement basis, forms a unique identifier. It is a concatenation of the fiscal year and fiscal quarter values.
fiscalQuarter string(1)* The indicator for a financial period's position within the company's fiscal year. This can include fiscal quarters (e.g., 1 through 4), fiscal years, year-to-date periods, or other specific designations.
fiscalYear string(4) The company's fiscal year for the financial information.
hotelAvgDailyRate decimal{7,2} The average daily room rate. (Magnitude: $)
link measurementStandardId MeasurementStandard* A lookup key for measurement standards. If a lookup is not used, "0" represents United States Standard and "1" represents Metric.
occupancyRate decimal{5,2} The reported occupancy rate of the property or properties. If an average occupancy is not available, an end-of-period measurement may be substituted. (Magnitude: %)
occupancyRateDataCenter decimal{5,2} The average occupancy for the company-owned data center portfolio, as reported. (Magnitude: %)
occupancyRateHotel decimal{5,2} The average reported occupancy for the company-owned hotel portfolio. (Magnitude: %)
occupancyRateIndu decimal{5,2} The average reported occupancy for the company-owned industrial portfolio. (Magnitude: %)
occupancyRateMall decimal{5,2} The average reported occupancy for the company-owned enclosed mall portfolio. (Magnitude: %)
occupancyRateManu decimal{5,2} The average reported occupancy for the company-owned manufactured housing portfolio. (Magnitude: %)
occupancyRateMovie decimal{5,2} The average reported occupancy for the company-owned theater portfolio. (Magnitude: %)
occupancyRateMulti decimal{5,2} The average reported occupancy for the company-owned multifamily portfolio. (Magnitude: %)
occupancyRateOffice decimal{5,2} The average reported occupancy for the company-owned office portfolio. (Magnitude: %)
occupancyRateOther decimal{5,2} The average reported occupancy for the company-owned diversified portfolio. (Magnitude: %)
occupancyRateOutlet decimal{5,2} The average reported occupancy for the company-owned outlet center portfolio. (Magnitude: %)
occupancyRatePower decimal{5,2} The average reported occupancy for the company-owned power center portfolio. (Magnitude: %)
occupancyRateRest decimal{5,2} The average reported occupancy for the company-owned hotel portfolio. (Magnitude: %)
occupancyRateRetail decimal{5,2} The average reported occupancy for the company-owned retail portfolio. (Magnitude: %)
occupancyRateSelf decimal{5,2} The average reported occupancy for the company-owned self-storage portfolio. (Magnitude: %)
occupancyRateShop decimal{5,2} The average reported occupancy for the company-owned shopping center portfolio. (Magnitude: %)
occupancyRateSingle decimal{5,2} The average reported occupancy for the company-owned single-tenant retail portfolio. (Magnitude: %)
propertyAggregateDisposition long(-2147483648,2147483647) The aggregate contractual gross sales price of operating properties sold. (Magnitude: $000)
link propertyAggregateEOPFlatId PropertyAggregateEOPFlat* The identifier for Property Aggregate End Of Period (EOP) Flat.
propertyAggregateEOPId long(-2147483648,2147483647) The identifier for Property Aggregate End Of Period (EOP)
propertyAggregateFinlId long(-2147483648,2147483647)* The unique identifier for property aggregate financial data.
propertyAggregateFinlPriorId long(-2147483648,2147483647) The prior identifier.
propertyAggregatePurchase long(-2147483648,2147483647) The aggregate contractual gross sales price of operating properties purchased. This also includes total consideration paid to the seller of an entity-level transaction that was completed during the period, in which the equity price paid was disclosed. (Magnitude: $000)
propertyInitialYield decimal{5,2} The rents (gross or net) generated by the portfolio as a percent of the portfolio valuation, as reported by the company. (Magnitude: %)
propertyInitialYieldDataCenter decimal{5,2} The annualized rents (gross or net) generated by the data center portfolio expressed as a percent of the data center portfolio valuation, as reported by the company. (Magnitude: %)
propertyInitialYieldHealth decimal{5,2} The annualized rents (gross or net) generated by the healthcare portfolio expressed as a percent of the healthcare portfolio valuation, as reported. (Magnitude: %)
propertyInitialYieldHotel decimal{5,2} The annualized rents (gross or net) generated by the hotel portfolio expressed as a percent of the hotel portfolio valuation, as reported. (Magnitude: %)
propertyInitialYieldIndu decimal{5,2} The annualized rents (gross or net) generated by the industrial portfolio expressed as a percent of the industrial portfolio valuation, as reported. (Magnitude: %)
propertyInitialYieldMall decimal{5,2} The annualized rents (gross or net) generated by the enclosed mall portfolio expressed as a percent of the enclosed mall portfolio valuation, as reported by the company. (Magnitude: %)
propertyInitialYieldManu decimal{5,2} The annualized rents (gross or net) generated by the manufactured homes portfolio expressed as a percent of the manufactured homes portfolio valuation. (Magnitude: %)
propertyInitialYieldMovie decimal{5,2} The annualized rents (gross or net) generated by the theater portfolio expressed as a percent of the theater portfolio valuation, as reported. (Magnitude: %)
propertyInitialYieldMulti decimal{5,2} The annualized rents (gross or net) generated by the multifamily portfolio expressed as a percent of the multifamily portfolio valuation, as reported. (Magnitude: %)
propertyInitialYieldOffice decimal{5,2} The annualized rents (gross or net) generated by the office portfolio expressed as a percent of the office portfolio valuation, as reported. (Magnitude: %)
propertyInitialYieldOther decimal{5,2} The annualized rents (gross or net) generated by the other portfolio expressed as a percent of the other portfolio valuation, as reported. (Magnitude: %)
propertyInitialYieldOutlet decimal{5,2} The annualized rents (gross or net) generated by the outlet center portfolio expressed as a percent of the outlet center portfolio valuation, as reported by the company. (Magnitude: %)
propertyInitialYieldPower decimal{5,2} The annualized rents (gross or net) generated by the power center portfolio expressed as a percent of the power center portfolio valuation, as reported. (Magnitude: %)
propertyInitialYieldRest decimal{5,2} The annualized rents (gross or net) generated by the restaurant portfolio expressed as a percent of the restaurant portfolio valuation, as reported. (Magnitude: %)
propertyInitialYieldRetail decimal{5,2} The annualized rents (gross or net) generated by the retail portfolio expressed as a percent of the retail portfolio valuation, as reported. (Magnitude: %)
propertyInitialYieldSelf decimal{5,2} The annualized rents (gross or net) generated by the self-storage portfolio expressed as a percent of the self-storage portfolio valuation, as reported. (Magnitude: %)
propertyInitialYieldShop decimal{5,2} The annualized rents (gross or net) generated by the shopping center portfolio expressed as a percent of the shopping center portfolio valuation, as reported by the company. (Magnitude: %)
propertyInitialYieldSingle decimal{5,2} The annualized rents (gross or net) generated by the single-tenant portfolio expressed as a percent of the single-tenant portfolio valuation, as reported. (Magnitude: %)
propertyPortfolioNotes string(2500) The notes applying to the property portfolio, as reported by the company.
propertyRentPerSqFtIndu decimal{22,8} The average reported rental rate for the company-owned industrial portfolio. (Magnitude: $/sq ft/yr)
propertyRentPerSqFtMall decimal{22,8} The average reported rental rate for the company-owned enclosed mall portfolio. (Magnitude: $/sq ft/yr)
propertyRentPerSqFtOffice decimal{22,8} The average reported rental rate for the company-owned office portfolio. (Magnitude: $/sq ft/yr)
propertyRentPerSqFtOutlet decimal{22,8} The average reported rental rate for the company-owned outlet center portfolio. (Magnitude: $/sq ft/yr)
propertyRentPerSqFtPower decimal{22,8} The average reported rental rate for the company-owned power center portfolio. (Magnitude: $/sq ft/yr)
propertyRentPerSqFtRetail decimal{22,8} The average reported rental rate for the company-owned retail portfolio. (Magnitude: $/sq ft/yr)
propertyRentPerSqFtShop decimal{22,8} The average reported rental rate for the company-owned shopping center portfolio. (Magnitude: $/sq ft/yr)
propertyRentPerSqFtSingle decimal{22,8} The average reported rental rate for the company-owned single-tenant retail portfolio. (Magnitude: $/sq ft/yr)
propertyRentPerUnitManu decimal{7,2} The average reported rental rate for the company-owned manufactured housing portfolio. (Magnitude: $/unit/mo)
propertyRentPerUnitMulti decimal{7,2} The average reported rental rate for the company-owned multifamily portfolio. (Magnitude: $/unit/mo)
propertyRentPerUnitSelf decimal{7,2} The average reported rental rate for the company-owned self-storage portfolio. (Magnitude: $/unit/mo)
propertySalesPerAreaMall decimal{7,2} The average reported tenant sales for the company-owned enclosed mall portfolio. (Magnitude: $/sq ft/yr)
propertySalesPerAreaOutlet decimal{7,2} The average reported tenant sales for the company-owned outlet center portfolio. (Magnitude: $/sq ft/yr)
propertySalesPerAreaPower decimal{7,2} The average reported tenant sales for the company-owned power center portfolio. (Magnitude: $/sq ft/yr)
propertySalesPerAreaRetail decimal{7,2} The average reported tenant sales for the company-owned retail portfolio. (Magnitude: $/sq ft/yr)
propertySalesPerAreaShop decimal{7,2} The average reported tenant sales for the company-owned shopping center portfolio. (Magnitude: $/sq ft/yr)
propertySalesPerAreaSingle decimal{7,2} The average reported sales rate for the company-owned single-tenant retail portfolio. (Magnitude: $/sq ft/yr)
revenuePerAvailableRoom decimal{7,2} The revenue per available hotel room, which includes only owned and leased properties in which the company has ownership interest. (Magnitude: $)
153 rows of 153 total
API Open API Specification