| 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. |