| key |
id |
string(100)* |
= |
The unique identifier for property ownership data. |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the entity is sent. |
|
capRateDisposition |
decimal{5,1} |
|
The expected rate of return on property at disposition, as reported by the company. (Magnitude: %) |
|
capRateReported |
decimal{5,1} |
|
The expected rate of return on property at acquisition, as reported by the company. (Magnitude: %) |
|
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 |
constructionCostShareTypeId |
ConstructionCostShareType |
|
The unique identifier for a construction cost share type. |
| link |
currencyId |
Currency* |
|
The alphabetic code used to identify currencies, pursuant to the International Organization for Standardization (ISO) 4217 standard. |
| link |
groundLeaseId |
GroundLease |
|
The unique identifier for a ground lease effect type. |
|
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. |
|
leaseExpirationYear |
string(4) |
|
The year in which the lease expires. |
|
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. |
|
ownershipEventDate |
date |
|
The date of the event, such as a deal announcement or closing, charter change, or other change in the relevant information that caused the record to be updated. |
|
propertyAcquisitionGroup |
long(0,255) |
|
The type of transaction through which the property was acquired or disposed. |
|
propertyAcquisitionGroupName |
string(15) |
|
The type of acquisition for the property, such as a merger, portfolio acquisition, or a stand-alone deal. |
|
propertyAcquisitionMerger |
boolean |
|
Indicates that the property was acquired through a merger. |
|
propertyAcquisitionPortfolio |
boolean |
|
Indicates that the property was purchased as part of a portfolio. |
|
propertyAcquisitionPrice |
long(-2147483648,2147483647) |
|
The historical cost basis assigned to the property by the acquirer. In the financial context, the value is currently on the financial statements, which may differ from the cost reported at the time of purchase. (Magnitude: $000) |
|
propertyAcquisitionPriceBuild |
long(-2147483648,2147483647) |
|
The portion of the initial purchase price that is attributable to buildings and equipment or furnishings. (Magnitude: $000) |
|
propertyAcquisitionPriceDeal |
long(-2147483648,2147483647) |
|
If the record represents the partial sale of a property and the partial amount is not known, the value of the transaction for the entire property, rather than just this portion. (Magnitude: $000) |
|
propertyAcquisitionPriceLand |
long(-2147483648,2147483647) |
|
The price paid for the land on which the property sits. (Magnitude: $000) |
|
propertyConstrCostIncurAsOf |
date |
|
The date as of which the construction costs have been incurred. |
|
propertyConstrCostIncurred |
long(-2147483648,2147483647) |
|
The costs incurred to complete the development, as a portion of the total amount to complete the real estate project. (Magnitude: $000) |
|
propertyConstrCostUnfunded |
long(-2147483648,2147483647) |
|
The outstanding amount of the publicly stated projection of costs to be incurred in the construction of the real estate project. (Magnitude: $000) |
|
propertyConstructionCost |
long(-2147483648,2147483647) |
|
The original cost of constructing the property's improvements. (Magnitude: $000) |
|
propertyGainOnSale |
long(-2147483648,2147483647) |
|
The gain on sale of the property realized by the seller. (Magnitude: $000) |
|
propertyHeldForSale |
boolean |
|
Indicates that the owner has contracted to sell the property. |
| link |
propertyId |
Property* |
|
The unique identifier for real estate properties. |
|
propertyOwnerCurrent |
boolean* |
|
Indicates that the owner still has ownership of the property. |
|
propertyOwnerDevPipeline |
boolean |
|
Indicates that the property is part of the owned development pipeline. The owned development pipeline excludes planned acquisitions and sold properties. |
|
propertyOwnerOperating |
boolean* |
|
Indicates that the property is part of the owned equity portfolio. The owned equity portfolio excludes planned acquisitions, planned constructions, and sold properties. |
|
propertyOwnershipEnded |
date |
|
The date as of which the owner transferred the ownership rights of the property to another owner. |
|
propertyOwnershipId |
long(-2147483648,2147483647)* |
|
The unique identifier for property ownership data. |
|
propertyOwnershipPublishId |
long(-2147483648,2147483647) |
|
The unique identifier for a property ownership record. |
|
propertyPartialGroundLease |
boolean |
|
Indicates that a portion of the land underlying the property is leased by the company. |
|
propertyPercentOwned |
decimal{5,2} |
|
The percent of the property's equity owned by the owner. (Magnitude: %) |
|
propertySalePrice |
long(-2147483648,2147483647) |
|
The price assigned to the property by the seller to calculate gain on sale of the property. (Magnitude: $000) |
| link |
propertyTenureTypeId |
PropertyTenureType |
|
The unique identifier for a property tenure type. |