Default Custom Fields
After master data is created, Custom Fields must be associated with the data. Custom Fields define different requirements, activities, or transactions that can be associated with the data. Custom Fields are organized into Groups you create. Real Estate Manager provides a default set of Custom Fields that you can select or you can create new Custom Fields. The table below lists the default Custom Fields that may be available.
Custom Field Type |
Custom Field |
Description |
|---|---|---|
Aggregate |
A combination of multiple data points. |
|
Contact |
Assignment/ Sublet Project Manager |
Name of a person or company. |
Contact |
Assignment/ Sublet Primary Contact |
Name of a person or company for assigned or sublet lease. |
Currency |
Tax Base Amount |
Base amount for Tax purposes. |
Currency |
OPEX/CAMS Base Amount |
Operating Expenses (OPEX) or Common Area Maintenance (CAMS) expenses base amount. |
Date |
Date Assignment/Sublet Requested |
Date an assignment or sublet was requested for the asset. |
Date |
Lease Last Update Date |
Date the lease was last updated. |
Date |
Indexed Adjustment Date |
Date any lease adjustment rates based on an index were made. |
Date |
Index Base Date |
Date the index used to calculate adjustments was last updated. |
Date |
Return Date |
Date asset is to be vacated. |
Decimal |
Percentage of area unoccupied by tenant |
Percent of leased area not currently occupied. |
Decimal |
Pro Rata Share %-Bldg |
Proportionate share, the ratio of the tenant’s rentable square footage compared to the entire rentable square footage. |
Decimal |
Pro Rata Share %-Site |
Proportionate share, the ratio of the tenant’s rentable square footage compared to the entire rentable square footage of a piece of property, such as land or an entire site or group of buildings. |
Decimal |
Gross-up % |
Refers to how a landlord calculates a tenant’s pro-rata share of operating expenses when the building is not full. The landlord begins with the actual operating expenses, imputes the operating expenses that would be incurred if the building were fully occupied to determine the “grossed up” expenses, and then multiplies that “grossed up” total by the tenant’s pro-rata share to determine the amount of operating costs that the tenant will pay. |
Decimal |
Current Index |
Currently applied interest rate that is based on a specific benchmark, such as the prime rate, with rate changes based on the movement of the benchmark. |
Decimal |
Previous Index |
Previously used interest rate that was based on a specific benchmark, such as the prime rate, with rate changes based on the movement of the benchmark. |
Decimal |
Base Index |
Interest rate of the benchmark effective at commencement. |
Decimal |
Holdover Rate |
Excess amount (usually expressed as a percentage) of the rental rate to be paid when a tenant remains in possession of the leased asset after the expiration of the lease term. |
Lookup |
Zoning |
Municipal or local laws or regulations that dictate how real property can and cannot be used in certain geographic areas. |
Lookup |
Exposure (N/E/S/W) |
Direction the front of a building faces. |
Lookup |
RE Strategy |
This is the process of aligning an organization's workplaces to support its business goals, while optimizing real estate performance. |
Lookup |
Index Type |
The type of index, such as prime rate, upon which rate changes are based. |
Lookup |
Lease Abstracted By |
Name of person who extracted the lease information. |
Lookup |
Lease Reviewed/Approved By |
Person who reviewed or approved a lease. |
Lookup |
HR Site ID |
Unique identifier for a Human Resources system. |
Lookup |
RE Status |
Status of property from the Corporate Real Estate department. |
Number |
Floors in Building |
Number of floors within the building. |
Number |
Floors Occupied |
Number of floors in use. |
Number |
Year Built |
Year property was constructed. |
Number |
Tax Base Year |
Year upon which the tax assessment is based. |
Number |
OPEX/CAMS Base Year |
Year upon which the Operating Expenses (OPEX) or Common Area Maintenance Service (CAMS) fees are based. |
Number |
Last Year Audited |
Year of most recent audit. |
Number |
FTE Headcount |
Number of full-time employees. |
Number |
FTE Capacity |
Number of full-time employees for which space is available. |
Text |
Primary use |
Describes how the property is primarily employed. |
Text |
Construction Type |
Identifier for the type of materials used or method of construction for property. |
Text |
Assignment/Sublet Lease Reference |
Identifier for the agreement that assigns or sublets a property. |
Text |
Assignment/Sublet Status |
State of an assignment or sublet of a property. |
Text |
RE Comments |
Information about a property. |
Text |
Indexed Adjustment Comments |
Information about changes to costs or fees based on an index rate. |
Text |
Lease Reference |
Identifier for a rental agreement. |
Text |
Property tax comments |
Information about taxes assessed. |
Text |
OPEX/CAMS comments |
Information about Operating Expenses (OPEX) or Common Area Maintenance Service (CAMS) costs. |
Text |
Audit Restriction Comments |
Information about any limitations on an audit. |
Text |
Deadline to dispute/audit/settle |
Date before which a contested issue must be identified to all parties, investigated, or settled. |
Text |
Interest Bearing Comments |
Information about costs or fees that may be subject to interest. |
Text |
Holdover Rate Comments |
Information about the rate used to adjust the rental and potentially other costs when a leased space is not vacated at the end of the lease term. |
Text |
Method of Notice Comments |
Information about notifications that pertain to the method of delivery. |
YesNo |
Marketing for Sublease (Y/N) |
Indicates whether the Asset is being marketed as available for sublease. |
YesNo |
Occupied (Y/N) |
Indicates whether the property is currently occupied. |
YesNo |
Multi-Tenant (Y/N) |
Indicates whether the property is used by more than one lessee. Yes means there are multiple tenants and No indicates that it is a single tenant property. |
YesNo |
Fire Sprinklers (Y/N) |
Indicates whether fire sprinklers are installed. |
YesNo |
Fire Alarm (Y/N) |
Indicates whether fire alarms are installed. |
YesNo |
Security Alarm (Y/N) |
Indicates whether a security alarm is installed. |
YesNo |
Security Guards (Y/N) |
Indicates whether security guards are used. |
YesNo |
Permission Required (Y/N) |
Indicates whether permission is required from Landlord for an unspecified action. |
YesNo |
Request Made (Y/N) |
Indicates whether a request has been made to Landlord for unspecified action. |
YesNo |
Request for Assignment/Sublet Made (Y/N) |
Indicates whether a request for assignment or sublease has been made to the Landlord. |
YesNo |
Lease Fully Abstracted (Y/N) |
Indicates whether the lease agreement has been fully recorded in system. |
YesNo |
Gross-up (Y/N) |
Indicates whether the OPEX/CAMS costs recorded are grossed up. |
YesNo |
Restrictions on who can perform audit? (Y/N) |
Indicates whether there are any limitations on who can perform an audit. |
YesNo |
Interest Bearing? (Y/N) |
Indicates whether the agreement includes interest. |
YesNo |
Permission Required for Assignment/Sublet (Y/N) |
Indicates whether permission to assign or sublet is needed from the Landlord, per the lease agreement. |
Measurement |
Measurement Field Test |
Indicates the method of measurement used to assess the size of the property. |
Measurement |
Area available for Sublease |
Total square area available for sublease. |
Measurement |
Building Area |
Total square area of building. |
Measurement |
Land Area |
Total square area of land. |
Measurement |
Unoccupied Area |
Square area of building not occupied. |
Measurement |
Rentable Area (Gross) |
Total square area available for lease. |
Measurement |
Useable Area (Net) |
Square feet that can be occupied or used. |
Regex |
Advanced version of the text data type where you can specify a regular expression that the text must match. |
|
Measurement Aggregate |
Gives ability to add up all child asset measurement fields to show one value under parent asset For Unit of Measure (UOM) fields. |
Configurations for Custom Fields
Most Data Field Types are configured to define ranges, values, and display options in the Field Configuration section of the Add New Custom Field pop-up. The table below lists and describes the field configuration options available.
Custom Field Data Type |
Field Configuration |
|---|---|
Aggregate |
Aggregates (sums) the values in the fields you select for aggregation. |
Contact |
No field configuration options, which allow for free form text to be recorded. |
Currency |
Minimum and maximum monetary values that can be entered. |
Date |
Restricts dates that can be entered or selected, including allowing dates prior to the current date, dates following the current date, and a date range. |
Decimal |
Defines the format for data that displays as a decimal, including the minimum and maximum values and the number of decimal places. |
Lookup |
Drop-down list. Some may have ability to Add and Select to add to list. |
Number |
Defines the minimum and maximum acceptable values, a prefix such as a currency sign, and a suffix, such as US. |
Text |
Defines the minimum and maximum number of characters allowed and whether or not the text wraps into multiple lines. |
YesNo |
Allows you to change the label that displays for binomial field data types. |
Measurement |
Defines the minimum and maximum values for any measured spaces and allows you to identify whether the measurement is recorded in linear area or square area. |
Regex |
Advanced version of the text data type where you can specify a regular expression that the text must match. |
Measurement Aggregate |
Aggregates (sums) measurements in fields you select for aggregation. |