Data Dictionary - LightBox Fundamentals - Appraisal Documents

Category

Display Name

Array Field Name

Data Type

Format

Definition

Report

String

A unique key provided for context for the user and root entity for Excel Data Type functionality. EX (25-100-300-44) 1234 Charming, Charming City, CA

Report

String

The address of the Subject Property

Report

String

The type of document from which the data was extracted, i.e. Appraisal, Phase 1, Rent Roll, etc.

Report

String

Display-friendly summary combining document type and date (e.g., "Appraisal • 10/07/2022").

Report

Date

mm/dd/yyyy

The date on which the report is transmitted to the client. Generally obtained from the transmittal letter.

Report

Date

mm/dd/yyyy

Calendar date the data was extracted from the source document into LightBox.

Report

DateTime

mm/dd/yyyy–hh:mm:ss AM/PM (UTC)

Exact UTC timestamp when the data extraction from the source document was completed.

Report

Date

mm/dd/yyyy

Calendar date the extracted data for this source document was last extracted and/or date the document and extracted data was reviewed.

Report

String

The Client's unique Job or Project Number, not the Vendor's internal file or invoice number.

Report

String

The intended user's general categorization of a property's type and use.

Report

String

The intended user's more detailed classification of a property's use and type.

Report

String

The client and any other party as identified, by name or type, as users of the appraisal or appraisal review report by the appraiser based on communication with the client at the time of the assignment.

Report

String

The Appraisal Company or Firm Name

Report

String

Primary Appraiser Name on Report

Subject

String

Name of the subject Property, or general description of the project.

Subject

String

Overall general categorization of a property's type and use.

Subject

String

A more detailed classification of a property's use and type.

Subject

String

Street address of subject property

Subject

String

Municipality of subject property

Subject

String

County of subject property

Subject

String

State of subject property

Subject

String

Zip code of subject property

Subject

String

The jurisdiction responsible for assessment of the property.

Subject

String

Assessor's Parcel Number or Tax ID. A numeric or alphanumeric label that uniquely identifies a parcel. Government property assessors use various systems, many with common features including geocoding. The government survey system is often used as a basis for parcel identification.

Subject

Integer

#,###

The number of parcels that are included in the Site Envelope. Usually defined by same ownership.

Subject

Decimal

#,##0.####

The minimum land area required per development which is suitable for OSS. This area includes satisfactory soil conditions, vertical separation and horizontal separation(s).

Subject

Decimal

#,##0

The minimum land area required per development which is suitable for OSS. This area includes satisfactory soil conditions, vertical separation and horizontal separation(s).

Subject

Decimal

#,##0.####

Unusable: Land not beneficial to residential use due to location or character such as drainage ditches, steep slopes, dense woods, sidewalks and utility strips when their presence renders the land unusable for residential use.Excess: Land that is not needed to serve or support the existing use. The highest and best use of the excess land may or may not be the same as the highest and best use of the improved parcel. Excess land has the potential to be sold separately and is valued separately. Surplus: Land that is not currently needed to support the existing use but cannot be separated from the property and sold off for another use. Surplus land does not have an independent highest and best use and may or may not contribute value to the improved parcel.

Subject

Decimal

#,##0

Land that is not currently needed to support the existing use but cannot be separated from the property and sold off for another use. Surplus land does not have an independent highest and best use and may or may not contribute value to the improved parcel.

Subject

Decimal

#,##0.####

Total Land Area of the Site in Acres.

Subject

Decimal

#,##0

Total Land Area of the Site in Square Feet.

Subject

String

Public regulation of the use of private land through application of police power; accomplished by establishing districts or areas with uniform requirements requirements relating to lot coverage, setbacks, type of improvement, permitted activities, signage, structure height, minimum lot area, density, landscaping, and other aspects of land use and development. Zoning regulations are established by enactment of a local (city, town, or county) zoning ordinance.

Subject

String

(FEMA Flood Insurance Rate Map Classification) The flat surfaces along the courses of rivers, streams, and other bodies of water that are subject to flooding.

Subject

Integer

#,###

One who holds or possesses the leasehold interest real estate by any kind of right or title; commonly a person who occupies and uses the property of another under a lease.

Subject

Decimal

0.00%

1. The relationship or ratio between the potential income from the currently rented units in a property and the income that would be received if all the units were occupied (i.e., economic occupancy). 2. The ratio of occupied space to total rentable space in a building (i.e., physical occupancy).

Subject

Decimal

#,###

The number of buildings/structures on the improved site.

Subject

Integer

#,###

Number of above grade stories. If more than one building, state the max number of stories.

Subject

Decimal

#,###

Total floor area of a building, excluding unenclosed areas, measured from the exterior of the walls of the abovegrade area. This includes mezzanines and basements if and when typically included in the market area of the type of property involved.

Subject

Decimal

#,###

For office or retail buildings, the tenant’s pro rata portion of the entire office floor, excluding elements of the building that penetrate through the floor to the areas below. The rentable area of a floor is computed by measuring to the inside finished surface of the dominant portion of the permanent building walls, excluding any major vertical penetrations of the floor. Alternatively, the amount of space on which the rent is based; calculated according to local practice.

Subject

Integer

#,###

Total number of units on the property.

Subject

String

The year the primary improvements were completed; also referred to as year of construction.

Subject

String

The process in which older structures or historic buildings are modernized, remodeled, or restored. Generally, the objective of renovation is to maintain or restore the basic plan and style of a building rather than to modify the original design by accretions or alterations, though new construction often accompanies restoration. Renovation is closely associated with urban renewal and may encompass the development of facilities to serve the community.

Subject

String

Class A, Class B, Class C, Class D, Class S. https://www.corelogic.com/intelligence/a-report-card-for-commercial-building-construction/

Subject

String

For the purposes of comparison, office space is grouped into three classes: Class A, B, and C. These classes represent a subjective quality rating of buildings, which indicates the competitive ability of each building to attract similar types of tenants. Combinations of factors such as rent, building finishes, system standards and efficiency, building amenities, location or accessibility, and market perception are used as relative measures.

Subject

Integer

#,###

The estimated period over which existing improvements are expected to contribute economically to a property; an estimate of the number of years remaining in the economic life of a structure or structural components as of the effective date of the appraisal; used in the economic age-life method of estimating depreciation.

Valuation

Array

All Valuation data available in an array, where the field names are presented in the first column and the premise/scenario data is presented dynamically in the following columns.

Premise

String

Valuation premise qualifier for valuation scenario - Ex: Market Value, Going Concern, etc. Ex: As Stabilized.

Premise

Date

mm/dd/yyyy

Date when concluded valuation is in effect.

Premise

String

Interest appraised for valuation scenario: An enforceable, legal claim to title of or interest in property. Ex: Leased Fee.

Premise

Decimal

$#,##0

A type of value, stated as an opinion, that presumes the transfer of a property (i.e., a right of ownership or a bundle of such rights), as of a certain date, under specific conditions set forth in the value definition that is identified by the appraiser as applicable in an appraisal.

Premise

String

Assumed exposure time (in months). An opinion, based on supporting market data, of the length of time that the property interest being appraised would have been offered on the market prior to the hypothetical consummation of a sale at market value on the effective date of the appraisal.

Premise

String

Assumed marketing time (in months). An opinion of the amount of time to sell a property interest at the concluded market value or at a benchmark price during the period immediately after the effective date of an appraisal. Marketing time differs from exposure time, which precedes the effective date of an appraisal.

Premise

Decimal

$#,##0

The process of deriving a value indication for the subject property by comparing sales of similar properties to the property being appraised, identifying appropriate units of comparison, and making adjustments to the sale prices (or unit prices, as appropriate) of the comparable properties based on relevant, market-derived elements of comparison. The sales comparison approach may be used to value improved properties, vacant land, or land being considered as though vacant when an adequate supply of comparable sales is available.

Premise

Decimal

$#,##0

Concluded valuation via the Income Approach, which may factor in DCF and/or Direct Capitalization Method Values.

Premise

Decimal

$#,##0

A set of procedures through which a value indication is derived for the fee simple estate by estimating the cost new as of the effective date of the appraisal to construct a reproduction of (or replacement for) the existing structure, including an entrepreneurial incentive; deducting depreciation from the total cost; and adding the estimated land value. The contributory value of any site improvements that have not already been considered in the total cost can be added on a depreciated-cost basis. Adjustments may then be made to the indicated value of the fee simple estate in the subject property to reflect the value of the property rights being appraised.

Premise

Decimal

$#,##0

The estimated cost to construct, at current prices as of a specific date, a substitute for a building or other improvements, using modern materials and current standards, design, and layout.

Premise

Decimal

$#,##0

Concluded contributory value of primary land only.

Premise

Decimal

$#,##0

Concluded contributory value of excess land.

Premise

Decimal

$#,##0

Total amount of revenue from leased spaces or units.

Premise

Decimal

$#,##0

All income generated in the operation of the property that is not derived directly from space rental.

Premise

Decimal

$#,##0

The total income attributable to property at full occupancy before vacancy and operating expenses are deducted.

Premise

Decimal

$#,##0

A deduction from potential gross income (PGI) made to reflect income reductions due to vacancies, tenant turnover, and nonpayment of rent.

Premise

Decimal

$#,##0

Gross Rental Revenue plus other income items, less vacancy and collection loss

Premise

Decimal

$#,##0

The sum of all fixed and variable operating expenses and the replacement allowance cited in the appraiser’s operating expense estimate.

Premise

Decimal

$#,##0

Net operating income: EGI value - OpEx value.

Premise

Decimal

0.00%

Cap rate (OAR, overall rate) applied to NOI projection to arrive at value under Direct Cap Method.

Premise

Decimal

$#,##0

A method used to convert an estimate of a single year’s income expectancy into an indication of value in one direct step, either by dividing the net income estimate by an appropriate capitalization rate or by multiplying the income estimate by an appropriate factor. Direct capitalization employs capitalization rates and multipliers extracted or developed from market data. Only one year’s income is used. Yield and value changes are implied, but not explicitly identified.

Premise

Decimal

0.00%

Discount rate applied to projected cash flows under the DCF Method.

Premise

Decimal

0.00%

Terminal cap rate applied to terminal cash flow projection under the DCF Method.

Premise

Decimal

$#,##0

The procedure in which a discount rate is applied to a set of projected income streams and a reversion. The analyst specifies the quantity, variability, timing, and duration of the income streams and the quantity and timing of the reversion, and discounts each to its present value at a specified yield rate.

LightBox

ID

Persistent, globally unique identifier for the source document in LightBox—use for re-querying, de-duplication, or joining across LightBox.

LightBox

ID

A unique identifier for the Address, derived via LightBox.

LightBox

ID

A unique identifier for the Parcel, derived via LightBox.

LightBox

ID

A unique identifier for the Assessment record, derived via LightBox.

LightBox

String

A nation with its own government, occupying a particular territory. This field is derived via LightBox geocoding.

LightBox

Decimal

##0.0000000

The angular distance of a place north or south of the earth's equator, or of a celestial object north or south of the celestial equator, usually expressed in degrees and minutes. This field is derived via LightBox geocoding.

LightBox

Decimal

##0.0000000

The angular distance of a place east or west of the meridian at Greenwich, England, or west of the standard meridian of a celestial object, usually expressed in degrees and minutes. This field is derived via LightBox geocoding.

Land Sales

integer

#,###

The order in which the comparable is presented in the report.

Land Sales

string

Name of comparable property, if applicable, otherwise full address.

Land Sales

string

Street address of comparable property

Land Sales

string

Municipality of omparable property

Land Sales

string

County of omparable property

Land Sales

string

State of omparable property

Land Sales

string

Zip code of omparable property

Land Sales

string

Assessor's Parcel Number or Tax ID. A numeric or alphanumeric label that uniquely identifies a parcel. Government property assessors use various systems, many with common features including geocoding. The government survey system is often used as a basis for parcel identification.

Land Sales

float

#,###.00

Total Land Area of the Site in Acres.

Land Sales

integer

#,###

Total Land Area of the Site in Square Feet.

Land Sales

string

Public regulation of the use of private land through application of police power; accomplished by establishing districts or areas with uniform requirements requirements relating to lot coverage, setbacks, type of improvement, permitted activities, signage, structure height, minimum lot area, density, landscaping, and other aspects of land use and development. Zoning regulations are established by enactment of a local (city, town, or county) zoning ordinance.

Land Sales

string

(FEMA Flood Insurance Rate Map Classification) The flat surfaces along the courses of rivers, streams, and other bodies of water that are subject to flooding.

Land Sales

string

Overall general categorization of a property's type and use.

Land Sales

string

A more detailed classification of a property's use and type.

Land Sales

date

mm/dd/yyyy

The date parties sign an agreement for the sale or lease of property. (Listing. Contract, Transfer or Sale Date.)

Land Sales

integer

$#,###

The amount asked, offered, or paid for a property. (List, Contract or Sale)

Land Sales

string

Transaction Type (List, Contract, Transfer, Sale, etc.)

Land Sales

string

Buyer or a person to whom property is transferred by deed or to whom property rights are granted by a trust instrument or other document.

Land Sales

string

Seller or a person who transfers property by deed or grants property rights through a trust instrument or other document.

Land Sales

string

Source of comparable information.

Land Sales

Decimal

##0.0000000

The angular distance of a place north or south of the earth's equator, or of a celestial object north or south of the celestial equator, usually expressed in degrees and minutes. This field is derived via LightBox geocoding.

Land Sales

Decimal

##0.0000000

The angular distance of a place east or west of the meridian at Greenwich, England, or west of the standard meridian of a celestial object, usually expressed in degrees and minutes. This field is derived via LightBox geocoding.

Land Sales

GUID

The order in which the comparable is presented in the report.

Land Sales

GUID

A unique identifier for the Address, derived via LightBox.

Land Sales

GUID

A unique identifier for the Parcel, derived via LightBox.

Land Sales

GUID

A unique identifier for the Assessment record, derived via LightBox.

integer

The order in which the comparable is presented in the report.

string

Name of comparable property, if applicable, otherwise full address.

string

Street address of comparable property

string

Municipality of omparable property

string

County of omparable property

string

State of omparable property

string

Zip code of omparable property

string

Assessor's Parcel Number or Tax ID. A numeric or alphanumeric label that uniquely identifies a parcel. Government property assessors use various systems, many with common features including geocoding. The government survey system is often used as a basis for parcel identification.

float

Total Land Area of the Site in Acres.

integer

Total Land Area of the Site in Square Feet.

string

Public regulation of the use of private land through application of police power; accomplished by establishing districts or areas with uniform requirements requirements relating to lot coverage, setbacks, type of improvement, permitted activities, signage, structure height, minimum lot area, density, landscaping, and other aspects of land use and development. Zoning regulations are established by enactment of a local (city, town, or county) zoning ordinance.

string

(FEMA Flood Insurance Rate Map Classification) The flat surfaces along the courses of rivers, streams, and other bodies of water that are subject to flooding.

string

Overall general categorization of a property's type and use.

string

A more detailed classification of a property's use and type.

date

mm/dd/yyyy

The date parties sign an agreement for the sale or lease of property. (Listing. Contract, Transfer or Sale Date.)

integer

$#,###

The amount asked, offered, or paid for a property. (List, Contract or Sale)

string

Transaction Type (List, Contract, Transfer, Sale, etc.)

string

Buyer or a person to whom property is transferred by deed or to whom property rights are granted by a trust instrument or other document.

string

Seller or a person who transfers property by deed or grants property rights through a trust instrument or other document.

string

Source of comparable information.

Decimal

##0.0000000

The angular distance of a place north or south of the earth's equator, or of a celestial object north or south of the celestial equator, usually expressed in degrees and minutes. This field is derived via LightBox geocoding.

Decimal

##0.0000000

The angular distance of a place east or west of the meridian at Greenwich, England, or west of the standard meridian of a celestial object, usually expressed in degrees and minutes. This field is derived via LightBox geocoding.

string

The type of Parking for a property: Surface, Garage, etc.

float

#.00

A ratio of parking area or parking spaces to an economic or physical unit of comparison. Minimum required parking ratios for various land uses are often stated in zoning ordinances.

integer

#,###

The number of parking spaces on the comparable property.

string

For the purposes of comparison, office space is grouped into three classes: Class A, B, and C. These classes represent a subjective quality rating of buildings, which indicates the competitive ability of each building to attract similar types of tenants. Combinations of factors such as rent, building finishes, system standards and efficiency, building amenities, location or accessibility, and market perception are used as relative measures.

integer

#,###

Total floor area of a building, excluding unenclosed areas, measured from the exterior of the walls of the abovegrade area. This includes mezzanines and basements if and when typically included in the market area of the type of property involved.

integer

#,###

For office or retail buildings, the tenant’s pro rata portion of the entire office floor, excluding elements of the building that penetrate through the floor to the areas below. The rentable area of a floor is computed by measuring to the inside finished surface of the dominant portion of the permanent building walls, excluding any major vertical penetrations of the floor. Alternatively, the amount of space on which the rent is based; calculated according to local practice.

string

The year the primary improvements were completed; also referred to as year of construction.

string

The process in which older structures or historic buildings are modernized, remodeled, or restored. Generally, the objective of renovation is to maintain or restore the basic plan and style of a building rather than to modify the original design by accretions or alterations, though new construction often accompanies restoration. Renovation is closely associated with urban renewal and may encompass the development of facilities to serve the community.

integer

#,###

Total number of rentable units on the property.

float

#.00%

1. The relationship or ratio between the potential income from the currently rented units in a property and the income that would be received if all the units were occupied (i.e., economic occupancy). 2. The ratio of occupied space to total rentable space in a building (i.e., physical occupancy).

integer

$#,###

Gross Rental Revenue plus other income items, less vacancy and collection loss

integer

$#,###

The sum of all fixed and variable operating expenses and the replacement allowance cited in the appraiser’s operating expense estimate.

integer

$#,###

Net operating income: EGI value - OpEx value.

float

#.00%

Cap rate (OAR, overall rate) applied to NOI projection to arrive at value under Direct Cap Method.

GUID

The order in which the comparable is presented in the report.

GUID

A unique identifier for the Address, derived via LightBox.

GUID

A unique identifier for the Parcel, derived via LightBox.

GUID

A unique identifier for the Assessment record, derived via LightBox.