Lease-Unit-Maping Input
Building
Contact
Unit
Lease
Lease Unit
Active
Indicates whether the record is active. If the record is inactive, the data is ignored in reports and Retrack forms.
Client/Company Reference
A unique reference used in the Data Warehouse to identify the Client/Company of a piece of data.
Asset Reference
The unique alpha-numeric reference number associated with the building in the system of record.
Building Parent Reference
An alpha-numeric identifier associated with a building within the system of record. This field groups more than one physical building for accounting and / or reporting purposes.
Client Asset Reference
The identifier used by your client to identify this asset.
External Asset Reference
The identifier used by an external source (e.g. a benchmark) to identify this asset.
Currency
The ISO standard code for the currency in which all financial amounts associated with this building have been submitted.
Complex Name
The name that is used to identify the group of related buildings to which this building belongs.
Building Name
The name by which the building is generally known, if it is not referred to by its address (e.g. Shard, Empire State Building, Louvre, etc.).
Street Address 1
The number and name of the street where the building is physically located.
Street Address 2
An additional address line. Where Address 1 is a building name, Address 2 should be the building number and street name.
City
Name of the city that corresponds to the street information
State
The state, county or geographic region that corresponds to the City information.
Postal Code
The alpha-numeric code (known in various countries as a postal code or ZIP code) associated with the rest of the Address.
Country
The two-letter code (ISO Alpha-2) that identifies the country that corresponds to the Address.
Latitude
The geographic coordinate, in decimal degrees, that specifies the north-south position of the Building.
Longitude
The geographic coordinate, in decimal degrees, that specifies the east-west position of the Building.
Sector
Classification of the building for market benchmarking purpose (e.g. office, retail, residential, etc.).
Sub Sector
The Sub Sector of the building (e.g. Bank, Department Store, Retirement Home etc).
Alternative Sector
The customer specific classification of the building type for market benchmarking purpose (e.g. office, retail, residential, etc.). This is not aligned with any standard body.
Accounting Classification
Indicates how the investor is treating the building in relation to accounting.
Owner Occupied
Indicates if the asset is occupied by the owner or not.
Location Quality
Indicates if the building is in a well established location.
Catchment Area
Indicates the number of people living within a given radius of the building. For example, within a 30 mile radius there are 1 million people.
Building Use
The primary use of the building. Building Use should reflect the normal permanent use of the majority of the building.
Other Building Use
Other use of the building that is not the primary use of the building.
Building Category
A categorisation of the building. This field will be used to create different models when exporting buildings to ARGUS Taliance.
Investment Purpose
Describes the purpose for which the building is held.
Geographic Area
The high level geographic region in which the building is located. This could be a standard grouping of countries, for example Scandinavia or EMEA.
Benchmark Region
The geographic region, state, city, district or other area for which market benchmark data is available.
Benchmark Sub Region
The more granular sub-state region, city, district or other area for which market benchmark data is available.
Alternative Region
The customer specific geographic region, state, city, district or other area for which market benchmark data is available. This is not aligned with any specific standards body.
Alternative Sub Region
The customer specific more granular sub-state region, city, district or other area for which market benchmark data is available. This is not aligned with any specific standards body.
Sub Market
The Sub Market which corresponds to the City, used for an additional breakdown
Statistical Division
The metropolitan statistical area of the location of the building as defined by the OMB (US), Eurostat (Europe) or applicable government body.
Additional Statistical Division
An additional metropolitan statistical area of the location of the building
Property Form Of Title
The legal form of property title (e.g. freehold, leasehold, mixed, etc.).
Building Ownership Structure
The legal ownership of units within a building, if they are owned by the tenants.
External Ground Lease
Indication of whether or not there is a ground lease associated with the building.
Tenancy Type
Indication of the different types of tenant occupying the asset, for example if it is a single tenant occupying the asset or multi.
Asset Quality
A rating of the quality of the asset (e.g. Grade A, Grade B, etc.)
Building Condition
A rating of the quality of a property's physical condition as evidenced by the most recent property inspection or valuation report.
Alternative Building Condition
A rating of the property, either a more granular representation of the Building Condition, or a classification from an alternative source.
Construction Type
The type of construction of the building e.g.Wood Frame, Concrete, etc.
Year Built
The year when the majority of the subject building was built. This year is based on the actual construction completion date.
Year Of Last Renovation
The year when any major renovation work was done on the subject building (e.g. lobby improvements, façade improvements, mechanical upgrades, etc.).
Available for Refurbishment
Indicates if the building is in use or vacant so it can be refurbished.
Lifecycle
The property's current life cycle stage e.g. development, leasing, renovation
Investor Strategy
As an owner of the asset, this is your buy / hold / sell analysis of the asset.
Date Of Last Property Inspection
Date of last official physical site inspection.
Sustainability Cluster
Indicates if the building is part of a sustainability cluster, for example if improvements such as solar panel roofing has been installed to make the building more energy efficient.
Area Measurement Unit
The unit of measure in which all area amounts associated with this building have been submitted (e.g. sf, sm, etc.).
Gross Building Area
Also known as Gross Floor Area, Gross Building Area is the area of a building measured externally at each floor level. Includes among others, perimeter wall thickness and external projections, areas occupied by internal walls and partitions, etc.
Buildable Area
The sum, in the building's unit of measurement (e.g. sqf or sqm), of all buildable area for which development / redevelopment planning permission has been granted.
Gross Leasable Area
Gross Internal Area is the area of a building measured to the internal face of the perimeter walls at each floor level. Including areas occupied by internal walls and partitions, atria and entrance halls, with clear height above, measured at base level only, etc.
Net Leasable Area
The net internal floor area available for occupation by tenants excluding all common areas, stair wells, etc.
Net Leaseable Area for Other Building Use
The net leasable area for the building's non-primary use, as defined in Other Building Use.
Plot Area
The total area, in the building's unit of measurement, of the plot on which the building is situated.
Number Of Units
The total number of leasable units within the building.
Number of Affordable Units
The total number of affordable leasable units within the building.
Number of Entrances
The total number of entrances for the building.
Number Of Floors
The total number of floors (including basement, ground and upper floors) in the building.
Number of Basements
The total number of basements in the building.
Number of Buildings
The total number of stand-alone buildings designed for occupancy within this asset.
Parking Structure
Indicates whether the property has a parking structure
Number Of Parking Spaces
Total number of parking spaces associated with the subject building. This includes both billable (charged for) and non-billable (free) parking spaces on the premises.
Parking Area
This sum of all parking area including billable (charged for) and non-billable (free) parking spaces, expressed in the unit of measurement associated with the building such as sqf, sqm.
Leased Percentage
The percentage of the building's total leasable area (GLA) that is currently leased to tenants, including area that is leased but not yet occupied. It is calculated by dividing the sum of all the areas of all leased units by the building's GLA.
Market Core Loss Factor Percentage
The ratio of the net internal area of the building which is not leasable area. Net internal area less net leasable area divided by the net internal area of the building expressed as a percentage.
Office Build Out
The area dedicated to office build-out, in the area of measure defined for the asset, for an asset that is primarily industrial.
Industrial Clear Height
Distance from the floor to the lowest hanging ceiling member or hanging objects, beams, joists or truss work descending down into a substantial portion of the industrial work area.
Business Unit Name
The name of the internal corporate division under which the building is reported.
Underwriter
The name of the person who is responsible for underwriting deals relating to the Asset.
Senior Underwriter
The name of the senior person who is responsible for underwriting deals relating to the Asset.
Asset Manager
The name of the person who is responsible for strategy and performance of the building.
Senior Asset Manager
The name of the senior person who is responsible for strategy and performance of the building.
Building Manager
Name of the firm which is responsible for the maintenance of the subject building.
Property Management Company
The name of the service Client/Company that manages the subject building.
Risk Profile
A classification of the risk profile the Asset in relation to the overall portfolio.
Capital Type
The financial capital type that is funding the entity.
Financial Statement Source
Used to indicate where the financial information has come from, such as whether it was derived or provided by a third party.
Insurance Product
Indicates if the building is part of a certain insurance product.
Insurance Coverage Amount
Insured value of the building in local currency.
Insurance Policy Expiry Date
The date at which the insurance policy on the building expires or is renewed.
Insurance Policy Premium
The annual premium, in local currency, payable for the insurance policy on the building.
Custom Classification 1
Customer-defined lookup value number one.
Custom Classification 2
Customer-defined lookup value number two.
Custom Classification 3
Customer-defined lookup value number three.
Custom Classification 4
Customer-defined lookup value number Four.
Custom Classification 5
Customer-defined lookup value number Five.
Custom Classification 6
Customer-defined lookup value number Six.
Custom Classification 7
Customer-defined lookup value number Seven.
Custom Classification 8
Customer-defined lookup value number Eight.
Custom Classification 9
Customer-defined lookup value number Nine.
Custom Classification 10
Customer-defined lookup value number Ten.
Asset Custom Classification 1
Asset Level customer-defined lookup value number one.
Asset Custom Classification 2
Asset Level customer-defined lookup value number two.
Asset Custom Classification 3
Asset Level customer-defined lookup value number three.
Asset Custom Classification 4
Asset Level customer-defined lookup value number four.
Asset Custom Classification 5
Asset Level customer-defined lookup value number five.
Comments
A free text field to hold any additional information about Building.
Submit Building
Active
Indicates whether the record is active. If the record is inactive, the data is ignored in reports and Retrack forms.
Client/Company Reference
A unique reference used in the Data Warehouse to identify the Client/Company of a piece of data.
Object Type
The object type of Asset, Debt Facility, Legal Entity or Modelling Entity the contact details will be saved against.
Object Reference
The Asset Reference, Debt Facility Reference, Investment, Legal Entity or Modelling Entity Reference of the object the contact will be saved against.
Contact Name
The full name of the individual contact.
Company Name
The name of the company the individual contact or contact details relate to.
Contact Type
The contacts role in relation to the Object Reference.
Phone Number
The telephone number for the contact.
Alternative Phone Number
Any alternative contact telephone number, should the contact have one.
Email
The contact's company email address.
Start Date
The date the contact is valid from in relation to the Object Reference.
End Date
The date the contact became invalid in relation to the Object Reference.
Comments
A free text field to hold any additional information about the contact.
Submit Contact
Active
Indicates whether the record is active. If the record is inactive, the data is ignored in reports and Retrack forms.
Client/Company Reference
A unique reference used in the Data Warehouse to identify the Client/Company of a piece of data.
Building Reference
A unique code identifying the building to which the unit is related.
Unit Reference
An unique alpha-numeric code identifying the Unit.
Scenario Name
The Scenario Name that the Unit reflects. e.g Mid Year Valuation, End Year Forecast.
External Unit Reference
The identifier used by an external source (e.g. a benchmark) to identify this Unit.
Unit Number
The number or name of the unit.
Floor Name
Text description of the floor on which the unit resides (e.g. Ground, 2nd, etc.).
Floor Number
The numeric value of the floor which the unit resides. (e.g. 3, -1, 2.1, etc.).
Unit Street Address 1
The number and name of the street where the unit is physically located if different from that of the building.
Unit Postal Code
The alpha-numeric code (known in various countries as a postal code or ZIP code) associated with the address if different from the building postal code.
Unit Market Rent
The amount of annual rent that a tenant is expected to pay for this unit based on prior assigned rental agreements and market comparable rates, expressed in currency per area (e.g. USD 22/sq /pa, EUR 18/sqm/pa).
Target Market Rent
The market rent attainable for the unit based on things like rent control regulations that may pertain to that unit and that is used internally for budgeting and cash flow purposes. Express in currency per area (e.g. EURO 10 per sm).
Unit Market Concession
The total amount of annual concessions that a tenant is expected to receive for this unit based on prior agreed concessions and market comparable rates.
Rent Control Rating
The rating, or figure, applied to the unit which determines any applicable rental control.
Unit Purchase Price
The value allocated to the Unit if the unit was acquired as part of a larger transaction (e.g. an apartment block)
Unit Loan Amount
The loan amount allocated to the Unit if the unit is part of a larger transaction (e.g. an apartment block)
Unit Leasable Area
The amount of floor space of the unit that can be leased to a tenant, in the unit of measurement associated with the building.
Number Of Parking Spaces
Total number of parking spaces associated with the Unit.
Unit Type
Indicates the type of unit (e.g. corner unit, balcony, gold, silver, bronze).
Count
This is a count that can be used for any unit, typically antenna, car park spaces, kiosks, barrows, billboards etc that are sometimes not measured as an Area.
Storage Locker
Flags whether or not a residential unit has an associated storage locker or not.
Number of Bedrooms
For multi-family units, this is the number of bedrooms in the unit
Number of Bathrooms
For multi-family units, this is the number of bathrooms in the unit
Maximum Number of Occupants
For multi-family units, this is is the maximum number of occupants residing in the unit.
Remeasured Date
The most recent date the unit was re-measured.
Year of Last Renovation
The latest year when any major renovation work was done on the unit.
Unit Use
The predominant use classification of the Unit.
Unit Sub Use
Use in conjunction with Unit Use to give a more specific use classification of the Unit
Unit Start Date
The date when the unit becomes effective, active, or is created.
Unit End Date
The date when the unit is no longer effective, active or is demolished.
Unit Status
The current status of the unit as it relates to its ability to be leased e.g. ready to rent, in refurbishment, in fit out
Unit Leasing Status
Indicates the status of the unit within the leasing process.
Unit Reconfiguration Type
If this unit is no longer in use and has been reconfigured, this records the type of reconfiguration.
Reconfigured Unit Reference
If this unit is no longer in use as it has been merged or renumbered to a new unit, this is the reference of the new unit.
Retired Unit Reference
If this unit was formed from the splitting or renumbering of another unit, this is the reference of the retired unit that is no longer in use.
Vacancy Costs
The annual cost incurred by the landlord when a unit is vacant, including, for example, taxes, insurance, utilities, security, etc., expressed as per the vacancy cost basis.
Vacancy Cost Basis
A code indicating how the vacancy cost amount is expressed (e.g. as a total amount or as an amount per unit of area).
Vacancy Costs Index
The index to which the vacancy cost growth is linked.
Custom Classification 1
Customer-defined lookup value number one.
Custom Classification 2
Customer-defined lookup value number two.
Custom Classification 3
Customer-defined lookup value number three.
Custom Classification 4
Customer-defined lookup value number four.
Custom Classification 5
Customer-defined lookup value number five.
Comments
A free text field to hold any additional information about Unit.
Submit Unit
Active
Indicates whether the record is active. If the record is inactive, the data is ignored in reports and Retrack forms.
Client/Company Reference
A unique reference used in the Data Warehouse to identify the Client/Company of a piece of data.
Building Reference
A unique identifier in the system of record for the building to which the lease is related.
Lease Reference
A code uniquely identifying the lease in the system of record.
Scenario Name
The Scenario Name that the Lease reflects. e.g Mid Year Valuation, End Year Forecast.
Master Lease Reference
The unique identifier in the system of record for the master lease under which the lease resides.
Tenant Reference
The Legal Entity Reference of the tenant who is party to the lease.
External Tenant Reference
The identifier used by an external source to identify this tenant.
Tenant DBA Name
Name under which the tenant is operating its business (i.e. the tenant's 'doing business as' name) under the terms of the Lease.
LEI Code
The unique 20 character alphanumeric code based on ISO 17442, which helps identify the legal entities participating in financial transactions.
Lease Use
The use to which the premises are currently put, as described in the Lease Document.
VAT Opted
Does the Tenant Pay VAT on charges on this Lease (Y) Or is the Tenant VAT excluded (N).
Contract Type
Classification of the type of lease contract (e.g. Renewal, Extension, New, etc.).
Statutory Framework
The statutory framework under which the lease falls, if any (e.g. UK Landlord & Tenant Act 1954)
Competition Clause
Indicates if this lease contains a competition clause in relation to the Competition Act 1998.
Competition Clause Details
Contains any details about the competition clause.
Lease Expense Type
Classification of the type of lease billing (e.g. gross, triple net, etc.).
Lease Status
Option 1
Option 2
Option 3
A list of predefined codes that identify the current lease status for billing and reporting purposes (e.g. active, expired, etc.)
Lease Assigned To
If the lease has been assigned this records the reference of the new lease.
Net Effective Rent (Actual)
A numeric field that is used to capture the economic value of a lease to the landlord expressed as an annual rent per local unit of measurement (e.g. sqf, sm). It is calculated by amortizing over the term of the lease the present value of all cash inflows and outflows generated by the lease.
Leasing Commissions (Inside)
Total commission paid to the internal leasing agent related to this lease.
Leasing Commissions (Outside)
Total commission paid to any external agents related to this lease.
Leasing Commissions in Months (Inside)
The total commission paid to the internal leasing agent related to this lease, expressed as a number of months of rent.
Leasing Commissions in Months (Outside)
The total commission paid to any external agents related to this lease, expressed as a number of months of rent.
Marketing Source
Define the marketing tools that were used to let the available spaces of an asset.
Execution Date
The date when the lease agreement was executed.
Commencement Date
The date when the lease term begins as per the lease contract.
Expiration Date
The date when the lease term ends as per the lease contract.
Termination Date
The date that the lease was terminated if different from the lease expiration date.
Move Out Reason
Define the reason why the tenant moved out when they terminate their lease.
Renewal Date
The date when the lease renewal term begins.
Leased Area
Area or size of the unit, expressed in the local unit of measurement, to which the tenant has obtained possession as defined in the lease agreement. Leased Area is normally used as the basis for all rents/participation charge calculations.
Leased Area Occupied
Area or size of the unit, expressed in the local unit of measurement, which the tenant is actually occupying.This can be used alongside Leased Area if the area occupied is less than the area leased.
Annual Gross Rent
The total amount of annual income for the lease, including headline rent and all pertinent recoverable expenses, that are stated on the Lease.
Annual Net Rent
The total amount of annual headline rent for the lease including any prior escalations but before pass-through, percentage rent or common area charges. This is excluding any adjustments for open credit.
Green Lease
If the lease has a Green clause or not.
Ethical Lease
If the lease has an Ethical clause or not.
kW Sold
In Data Centres, the total number of Kilowatts sold under the terms of the Master Service Agreement.
kW Contracted
In Data Centres, the actual number of Kilowatts being charged.
Rate per kW
In Data Centres, the rate per Kilowatt charged.
Parking Space Count
Number of parking spaces associated with the lease.
Security Deposit Amount Contracted
The amount of the security deposit as specified in the lease agreement.
Security Deposit Amount Current
The latest amount of the security deposit held.
Security Deposit Type
The type of security deposit collected from the tenant upon execution of the lease as a reserve to compensate the landlord for loss, cost, damage, or expense sustained due to the tenant's default.
Guarantor Name
Name of the company or individual(s) as stated in the legal document, who agrees to perform the contractual lease obligations of the tenant if the tenant shall fail to perform.
Tenant Legal Name
The full legal name of the tenant.
Tenant Tax ID
An identification number used by government agencies (e.g. Internal Revenue Service (IRS) in the USA for tax purposes or Companies House registration in the UK).
Tenant Legal Structure
The legal structure of the entity, (e.g. Limited, Inc., PLC, LLP, etc.).
Company Number
The government registered company number, (e.g. in the UK this is known as the Companies House Number).
Tenant Company Description
A description of the company. This field can be used to record a description of the company's activities, for example.
Tenant Industry
A code, based on standard industry classifications, identifying the company's industry sector (e.g. banking, retail, telecommunications, etc.).
Tenant DUNS Number
The nine-digit number, issued by D&B (Dun & Bradstreet - www.dnb.com), that applies to this Tenant.
Tenant Credit Rating
The company's credit rating as provided by the rating agency or other source (e.g. an internal model) indicated in the "Company Credit Rating Source" field.
Tenant Credit Rating Source
The name of the rating agency or other source (e.g. an internal model) from which the company's credit rating was obtained.
Internal Tenant Rating
A classification of the Tenant Risk of default
Tenant Activity
A user-defined classification of the main business activity of the Tenant.
Tenant Operating Status
An indication of whether the Tenant's Business is currently Active or Out of Business
Tenant Telephone Number
This is the business contact number
Tenant Business Start Date
The date the tenant's business started
Tenant Name of Most Senior Principal
Name of the most senior principal within the business
Tenant Number of Employees
This is the number of employees employed by the tenant within their business
Tenant Street Address
The Street Address details used for postal correspondence with the Tenant.
Tenant City
Name of the city that corresponds to the street information
Tenant State
The state, county or geographic region that corresponds to the City information.
Tenant Postal Code
The alpha-numeric code (known in various countries as a postal code or ZIP code) associated with the rest of the Address.
Tenant Country
The two-letter code (ISO Alpha-2) that identifies the country that corresponds to the Address.
Tenant Billing Address
The street number and name associated with the Tenant's invoices and payments.
Tenant Billing City
Name of the city that corresponds to the street information
Tenant Billing State
The state, county or geographic region that corresponds to the City information.
Tenant Billing Postal Code
The alpha-numeric code (known in various countries as a postal code or ZIP code) associated with the rest of the Address.
Tenant Billing Country
The two-letter code (ISO Alpha-2) that identifies the country that corresponds to the Address.
Custom Classification 1
Customer-defined lookup value number one.
Custom Classification 2
Customer-defined lookup value number two.
Custom Classification 3
Customer-defined lookup value number three.
Custom Classification 4
Customer-defined lookup value number four.
Custom Classification 5
Customer-defined lookup value number five.
Comments
A free text field to hold any additional information about Lease.
Submit Lease
Active
Indicates whether the record is active. If the record is inactive, the data is ignored in reports and Retrack forms.
Client/Company Reference
A unique reference used in the Data Warehouse to identify the Client/Company of a piece of data.
Asset Reference
The unique alpha-numeric reference number associated with the building in the system of record.
Lease Reference
A unique code identifying the lease to which the Lease - Unit record is associated.
Unit Reference
A unique code identifying the building unit to which the Lease - Unit record is associated.
Lease-Unit Reference
A unique alpha-numeric code identifying the Lease Unit in the system of record.
Scenario Name
The Scenario Name that the Lease Unit reflects. e.g Mid Year Valuation, End Year Forecast.
Description
Additional text description associated with the Lease - Unit.
Leased Area
Area or size of the subject space expressed in the local unit of measurement (e.g. sqf, sqm).
Annual Gross Rent
The total amount of annual income for the unit, including headline rent and all pertinent recoverable expenses, that are stated on the Lease.
Annual Net Rent
The total amount of annual headline rent for the unit including any prior escalations but before pass-through, percentage rent or common area charges. This is excluding any adjustments for open credit.
Contract Start Date
The date from which the particular unit comes into tenant possession, if different from the Lease Commencement Date.
Move In Date
The date when the tenant moved into the unit.
Rent Start Date
The date from which the tenant must begin to pay rent.
Contract End Date
The date when the particular unit is released from possession if different from the lease end date.
Move Out Date
The date when the tenant moved out of the unit.
Sublease To
Lease reference for the sub-lease associated with the Lease-Unit.
Leasing Agent
Name of the agent firm which is involved in the lease negotiation.
Submit Lease Unit