| key |
id |
string(100)* |
= |
The unique identifier for property 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. |
|
capRateProperty |
decimal{5,1} |
|
The capitalization rate (yield) of property at period end as reported by the company. (Magnitude: %) |
|
currencyBOPDate |
date |
|
The beginning of period date used for currency flow conversion. |
| link |
currencyId |
Currency* |
|
The alphabetic code used to identify currencies, pursuant to the International Organization for Standardization (ISO) 4217 standard. |
|
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. |
|
ebitdaRealEstate |
decimal{19,0} |
|
Earnings before interest, taxes, depreciation, and amortization. (Magnitude: $000) |
|
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. |
|
gamingSlotCount |
long(-2147483648,2147483647) |
|
The aggregate count of slot machines at casinos that are owned or operated. (Magnitude: actual) |
|
gamingTableCount |
long(-2147483648,2147483647) |
|
The aggregate count of gaming tables at casinos that are owned or operated. (Magnitude: actual) |
|
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. |
|
mostRecentPeriod |
boolean |
|
Indicates that the record is the most recent one for a given period type |
|
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. |
|
mostRecentSequenceFiscalYears |
long(0,255) |
|
The identifier for the row that represents the most recent year-end. |
|
mostRecentSequenceQuarter |
long(0,255) |
|
The identifier for the row that represents the most recent quarter. |
|
multipleProperties |
boolean* |
|
Indicates that the property record contains information on more than one physical property due to limited disclosure by the company. |
|
multiplePropertyCount |
long(-2147483648,2147483647) |
|
The number of physical properties a record comprises when it represents more than one property. (Magnitude: actual) |
|
numberOfBuildings |
long(-2147483648,2147483647) |
|
The number of building structures the property comprises. (Magnitude: actual) |
|
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: %) |
|
occupancyRateHotel |
decimal{5,2} |
|
The average reported occupancy for the company's owned hotel portfolio. (Magnitude: %) |
|
priorPropertyFinl |
long(-2147483648,2147483647) |
|
The identifier for a prior property financial record. |
|
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) |
|
propertyAcquisitionPriceLand |
long(-2147483648,2147483647) |
|
The price paid for the land on which the property sits. (Magnitude: $000) |
|
propertyAppraisalDate |
date |
|
The date at which the property was last appraised or revalued. |
|
propertyAppraisalValue |
long(-2147483648,2147483647) |
|
The appraised value of the property. (Magnitude: $000) |
|
propertyBaseRents |
long(-2147483648,2147483647) |
|
The annual base rents, where annualized figures may be substituted for actuals in some cases. (Magnitude: $000) |
|
propertyCapRateTypeReported |
string(30) |
|
The type of capitalization rate (yield) as reported by the company. |
|
propertyCarryValue |
long(-2147483648,2147483647) |
|
The initial cost of the property plus capitalized expenditures and land improvements, net of writedowns. (Magnitude: $000) |
|
propertyCarryValueBldg |
long(-2147483648,2147483647) |
|
The book value of the property's improvements, representing the historical cost, before depreciation. (Magnitude: $000) |
|
propertyCarryValueCapEx |
long(-2147483648,2147483647) |
|
The capitalized expenditures accounted for subsequent to the acquisition or construction of the property. (Magnitude: $000) |
|
propertyCarryValueCapExLand |
long(-2147483648,2147483647) |
|
The capitalized improvements to land, additional land added to the property subsequent to purchase, or other change in land value. (Magnitude: $000) |
|
propertyCarryValueLand |
long(-2147483648,2147483647) |
|
The book value of the land underlying the property, representing the historical cost before depreciation. (Magnitude: $000) |
|
propertyCarryValueNet |
long(-2147483648,2147483647) |
|
The carrying value of the property, reflecting the historical cost of the property and improvements, net of accumulated depreciation. This represents the reported book value, fair value, market value, or tax assessment value for companies that do not depreciate their assets. (Magnitude: $000) |
|
propertyCarryValueWritedown |
long(-2147483648,2147483647) |
|
The reductions to the carrying value of the property as a result of permanent impairments or changes to fair-market value. (Magnitude: $000) |
|
propertyDepreciation |
long(-2147483648,2147483647) |
|
The accumulated depreciation of the property since acquisition or construction. (Magnitude: $000) |
|
propertyFinlAsOf |
date* |
|
The date for which the property financial information is reported. |
|
propertyFinlId |
long(-2147483648,2147483647)* |
|
The unique identifier for property financial data. |
|
propertyNOI |
long(-2147483648,2147483647) |
|
The net operating income of the property, on an annualized basis. (Magnitude: $000) |
| link |
propertyOwnershipId |
PropertyOwnership* |
|
The unique identifier for property ownership data. |
|
propertyRentPerArea |
decimal{10,2} |
|
The rental rate, which may be either the actual historic amount earned or the current offer rate, depending on the company's reporting practices. (Magnitude: $/sq ft/yr) |
|
propertyRentPerSqFt |
decimal{22,8} |
|
The rental rate, which may be either the actual historic amount earned or the current offer rate, depending on the company's reporting practices. (Magnitude: $/sq ft/yr) |
|
propertyRentPerSqFtMonthly |
decimal{22,8} |
|
The rental rate, which may be either the actual historic amount earned or the current offer rate, depending on the company's reporting practices. (Magnitude: $/sq ft/mo) |
|
propertyRentPerUnit |
decimal{9,2} |
|
The average monthly property rent per dwelling unit. (Magnitude: $/unit/mo) |
|
propertySalesPerArea |
decimal{10,2} |
|
The sales for the property, which may be either the actual historic sales or the current sales, depending on the company's reporting practices. |
|
propertySalesPerSqFt |
decimal{22,8} |
|
The sales for the property, which may be either the actual historic sales or the current sales, depending on the company's reporting practices. (Magnitude: $/sq ft/yr) |
|
propertySalesPerSqFtMonthly |
decimal{22,8} |
|
The sales for the property, which may be either the actual historic sales or the current sales, depending on the company's reporting practices.(Magnitude: $/sq ft/mo) |
|
propertySizeArea |
long(-2147483648,2147483647) |
|
The total interior area of the building or buildings. (Magnitude: sq. ft.) |
|
propertySizeBeds |
long(-2147483648,2147483647) |
|
The number of beds in a health-care or student housing facility. (Magnitude: actual) |
|
propertySizeCasino |
decimal{22,8} |
|
The area of the casino portion of a property. (Magnitude: sq. ft.) |
|
propertySizeCasinoArea |
long(-2147483648,2147483647) |
|
The area of the casino portion of a property. (Magnitude: sq. ft.) |
|
propertySizeColdStorage |
decimal{22,8} |
|
The volume within the property or properties available for use as cold storage. (Magnitude: cubic ft) |
|
propertySizeColdStorageVol |
long(-2147483648,2147483647) |
|
The volume within the property or properties available for use as cold storage. (Magnitude: cubic ft) |
|
propertySizeConference |
decimal{22,8} |
|
The space available for conference-hosting. (Magnitude: sq. ft.) |
|
propertySizeConferenceArea |
long(-2147483648,2147483647) |
|
The space available for conference-hosting. (Magnitude: sq. ft.) |
|
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, the owned gross leasable area is presented if applicable. (Magnitude: sq. ft.) |
|
propertySizeGolfHoles |
long(-2147483648,2147483647) |
|
The number of holes. (Magnitude: actual) |
|
propertySizeGolfYards |
long(-2147483648,2147483647) |
|
The total yardage of golf courses. (Magnitude: yards) |
|
propertySizeHotelSuites |
long(-2147483648,2147483647) |
|
The number of hotel suites, comprising more than one room. (Magnitude: actual) |
|
propertySizeHotelUnclassified |
long(-2147483648,2147483647) |
|
The number of hotel rooms not classified as suites. (Magnitude: actual) |
|
propertySizeLand |
decimal{22,8} |
|
The land area underlying the property. (Magnitude: acres) |
|
propertySizeLandArea |
decimal{10,2} |
|
The land area underlying the property. (Magnitude: acres) |
|
propertySizeMovieScreens |
long(-2147483648,2147483647) |
|
The number of movie screens. (Magnitude: actual) |
|
propertySizeParking |
long(-2147483648,2147483647) |
|
The number of parking spaces. (Magnitude: actual) |
|
propertySizePassengers |
long(-2147483648,2147483647) |
|
The maximum number of passengers allowed on a mode of transportation. (Magnitude: actual) |
|
propertySizeRooms |
long(-2147483648,2147483647) |
|
The size of a hotel or hotels measured in number of rooms and suites. (Magnitude: rooms) |
|
propertySizeSqFt |
decimal{22,8} |
|
The total interior area of the building or buildings. (Magnitude: sq. ft.) |
|
propertySizeStorage |
decimal{22,8} |
|
The area of self-storage space as directly reported from the original data source. This value reflects the square footage provided by external parties or documents, without adjustment. (Magnitude: sq. ft.) |
|
propertySizeStorageArea |
long(-2147483648,2147483647) |
|
The area of self-storage space calculated or derived through internal processes to ensure consistency and accuracy. This value may be based on standardized measurement methods, reconciled data, or internal calculations, and is expressed in square feet. (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) |
|
propertySizeTimber |
decimal{22,8} |
|
The area of timbered land comprising the property, as directly reported from the original data source. This value reflects the timber acreage as provided by external parties or documents, without adjustment. (Magnitude: acres) |
|
propertySizeTimberArea |
long(-2147483648,2147483647) |
|
The area of timbered land comprising the property, calculated or derived through internal processes to ensure consistency and accuracy. (Magnitude: acres) |
|
propertySizeUnits |
long(-2147483648,2147483647) |
|
The number of apartments or other dwelling units in the property. (Magnitude: units) |
|
revenueGamingGames |
long(-2147483648,2147483647) |
|
The revenues earned from customer losses, net of house losses, at games of chance and from wager-book activities. (Magnitude: $000) |
|
revenuePerAvailableRoom |
decimal{7,2} |
|
The revenue per available hotel room (includes only owned and leased properties in which the company has ownership interest). (Magnitude: $) |
|
snpFiscalQuarter |
long(-2147483648,2147483647) |
|
The fiscal quarter within the company's fiscal year. |
|
snpFiscalYear |
string(4) |
|
The company's fiscal year. |