Type PropertyAggregateTenant
Type category Entity
Description Contains aggregate property data, categorized by tenant. The tenant is identified by its S&P Capital IQ Company ID.
Fields
Name Type Filters Description
key id string(100)* = The unique identifier for the aggregated property tenant data.
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.
formOrder long(-2147483648,2147483647) A value used for relative ordering of output rows in ascending order. It does not represent an absolute quantity.
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.
link propertyAggregateDateId PropertyAggregateDate* The unique identifier for the date on which property data was aggregated.
propertyAggregatePriorId long(-2147483648,2147483647) The identifier for the prior property aggregate row.
propertyAggregateTenantId long(-2147483648,2147483647)* The unique identifier for the aggregated property tenant data.
tenantLeaseArea long(-2147483648,2147483647) The area leased by the tenant under agreements that were current as of the date indicated. (Magnitude: sq. ft.)
tenantLeaseRent long(-2147483648,2147483647) The aggregate rents to be paid to the company by the tenant. (Magnitude: $000)
tenantLeaseRentPercent decimal{5,2} The aggregate rents to be paid to the company by the tenant as a percent of the total rents. (Magnitude: %)
tenantLeaseRooms long(-2147483648,2147483647) The number of hotel rooms leased by the tenant under agreements that were current as of the date indicated.
tenantLeaseRoomsPercent decimal{5,2} The number of hotel rooms leased by the tenant as a percent of the company's total leasable hotel rooms. (Magnitude: %)
tenantLeaseSquareFoot decimal{22,8} The area leased by the tenant under agreements which were current as of the date indicated. (Magnitude: sq. ft.)
tenantLeaseSquareFootPercent decimal{5,2} The aggregate square footage leased by the tenant as a percent of the company's total leasable area. (Magnitude: %)
tenantLeaseTermRemaining decimal{5,1} The weighted average unexpired term remaining under leases between the company and its tenants. This may be reported as weighted average unexpired lease term (WAULT). If available, the weighting is by square footage, otherwise, by rents. (Magnitude: years)
tenantLeases long(-32768,32767) The number of property locations leased by the tenant under agreements that were current as of the date indicated.
link tenantRank TenantRank The hierarchical classification or standing of a tenant based on lease metrics reported by the company. Ranking criteria include lease area (square footage), rental income, remaining lease term, and room counts, expressed as either absolute values or percentages of the total property.
tenantRankId long(0,255) The unique identifier for the tenant rank.
22 rows of 22 total
API Open API Specification