Properties Table: Field Reference
Property is a registry for your real property inventory that enables you to track buildings, structures, and land. Property is classified as either land or structure, and can have buildings, costs, parcels, taxes, and assets assigned to it.
A few of these fields are used by the Archibus Client / Server applications and are not used in the Web Central applications. When a field is not currently used, this is noted in the Purpose column.
This topic documents all the Properties table fields. The table is sorted alphabetically by Field Heading.
Field Heading | Field Name | Purpose | Archibus Type |
---|---|---|---|
# of Parking Spaces | qty_no_spaces | This field stores your entry for the number of parking spaces that this property offers. The value is shown in the Amenities by Property report. | None |
# of Parking Spaces - Calculated | qty_no_spaces_calc | This was used by Archibus Client / Server to record parking spaces developed in CAD. It is not currently used. | Calculated |
Account Code | ac_id | Use this field to store the account to which expenses related to this property are billed by choosing a value from the validating Accounts (ac) table. | None |
Address 1 | address1 | This field stores the complete street address, for example: 18 Tremont Street. The Address 1 field is used (along with the State Code and City Code) to place the property on the map when you run the geocode action (Calculate location for new item.). | None |
Address 2 | address2 | This field stores any additional address information. Address 2 is used to place the item on the map only if Address 1 is left blank. | None |
Airport Distance | air_dist | Use this field to record the distance from the property to the nearest airport. This information is important to brokers trying to sell or lease a property. | None |
Airport Name | air_name | Use this field to store the name of the airport nearest to the property. This information is important to brokers trying to sell or lease a property. | None |
Area - Bldg. Est. Rentable | area_bl_est_rentable | Use this field to store an estimate of the rentable areas in all buildings located on this property. | None |
Area - Bldg. Int. Gross | area_bl_gross_int |
The field is the sum of the Internal Gross Area values for all buildings assigned to this property. Use this field to assess a building's total floor area. This field is calculated when you generate the Property Abstract report. |
Calculated |
Area - Bldg. Rentable | area_bl_rentable |
Rentable area indicates the total income-producing area of a building, and is useful for analyzing the economic potential of a building. This area appears in the Property Abstract, Building Abstract, and Property & Building Benchmarks reports. Archibus calculates this area when you generate the report. However, a building's rentable area is summed from its floors' rentable areas. Archibus calculates a floor's rentable area by subtracting its vertical penetration areas from the internal gross area when you run the Update Area Totals action. |
Calculated |
Area - Bldg. Usable | area_bl_usable |
This area is the sum of the Area Usable for all buildings assigned to the property. Use this area to review the actual occupiable area for all buildings on the property. This value appears in the Property and Building Benchmark reports. Archibus calculates this area when you generate the report. However, a building's usable area is summed from its floors' usable areas. Archibus calculates a floor's usable area by subtracting the floor's service areas and vertical penetration areas from its internal gross area when you run the Update Area Totals action. |
Calculated |
Area - CAD | area_cad | If you represent the property area with an asset symbol, the system completes this drawing-driven field with the area represented by the asset symbol. | CAD |
Area - Lease Measured | area_lease_meas | Use this field to review the total leased area on a property that can be charged for. The Area - Lease Measured is summed from suites, groups, or rooms, depending on the lease area method you have selected. The Area - Lease Measured is the sum of the Area Meas. Rentable for all leases on the property. To be included in the calculation, these measured areas must be associated with a lease for one of the buildings on the property. Archibus calculates the Area - Lease Measured when you generate the Property Abstract or Property and Building Benchmarks reports. | Calculated |
Area - Lease Negotiated | area_lease_neg |
Sum of the Area - Neg. Rentable entered for each lease for the buildings belonging to the property. The Area - Neg. Rentable is the area to which the landlord and tenant agree and which is specified in the lease agreement document. Discrepancies found when comparing measured and negotiated area values can indicate leases that need to be renegotiated. This measurement appears in the Property Abstract and Building Abstract reports; the value is calculated when you generate the report. |
Calculated |
Area - Manual | area_manual | This field stores the number of acres this property occupies. For land, you can view the estimated area by geographical location in key performance indicator charts. | None |
Area - Non- Permeable | area_non_permeable | If you have developed runoff asset symbols in your drawing, the system calculates the non-permeable area using your runoff areas. | Calculated |
Area - Parcel | area_parcel | If you have developed parcel asset symbols in your drawing, the system sums the parcels assigned to this property and records the value in this field. | Calculated |
Area - Parking | area_parking_total | If you have developed parking spaces in your drawing, the system sums the areas of these asset symbols to this field. | Calculated |
Area - Permeable | area_total_permeable | If you have developed runoff areas in your drawing, the system calculates the property’s permeable area by summing the runoff areas assigned to the property. | Calculated |
City Code | city_id | This field stores the city for the property. The City Code is validated by the Cities (city) table. When you run the geocode action (calculate location for new item), the application uses the City Code field (along with the State Code and Address 1) to calculate the longitude and latitude for a building, so that you can see it on map views. | None |
Comments |
Use this field to store additional information, such as a brief description of the property location, condition, amenities, or dates of any renovations or modifications. |
None | |
Corporate Unit | unit | Currently not used. | None |
Country Code |
ctry_id | This field stores the country for the property. The Country Code is validated by the Countries (ctry) table. You can use this field to filter reports by country, such as Portfolio Items by Location. | None |
County Code | county_id | This field stores the county for the property. You can use county data to record taxes that the county assesses. County data is not part of the geographic hierarchy required to view KPI charts. The County Code is validated by the Counties (county) table. | None |
Date - Book Value Assessed | date_book_val | This field stores the date the book value was determined. Having this date helps you evaluate if the book value needs updating. | None |
Date Costs Calculated | date_costs_last_calcd | When you generate the Property Abstract, Property and Building Benchmark, and Undeveloped Properties reports, the costs shown in the report are calculated. The date the costs are calculated is stored in this field. | None |
Date Costs End | date_costs_end | When you generate the Property Abstract, Property and Building Benchmark, and Undeveloped Properties reports, the Summarize Property Costs action runs. Costs are calculated using the Date Start and Date End you select. The Date End value for the last time the report was generated is stored in this field. | None |
Date Costs Start | date_costs_start |
When you generate the Property Abstract, Property and Building Benchmark, and Undeveloped Properties reports, the Summarize Property Costs action runs. Costs are calculated using the Date Start and Date End you select. The Date End value for the last time the report was generated is stored in this field. |
None |
Date Disposed | date_disposal | The date the property was disposed of. This date is entered in the Asset Disposal Console. | None |
Date Market Value Assessed | date_market_val | The date you assessed the property's market value. This date helps you evaluate if the market value needs updating. | None |
Date Sold | date_sold | The date the property sold. Tracking the date sold along with the price the property sold for is important for spotting real estate trends. | None |
Date Purchased | date_purchase | The date the property was purchased. | None |
Description | description | Enter a brief description of the property. | Desc |
Detail Drawing | detail_dwg | Not currently used in Web Central. It was previously used in Archibus Client / Server. | None |
Disposal Comments | comment_disposal | When a property is disposed of using the Asset Disposal Console, use this field to store any comments about the disposal. | None |
Disposal Type | disposal_type | This field describes how the asset was disposed of, for example, by selling, donating, or discarding. | None |
Drawing Name | dwgname | Not currently used in Web Central. | Dwgname |
Entity Handle / Unique ID | ehandle | If you represented the property with an asset symbol in a drawing, the system automatically completes this field with the asset symbol’s entity handle. When querying the drawing, the Archibus Smart Client Extension for AutoCAD uses the values in the Entity Handle field to quickly find the asset symbol. | Ehandle |
Expense - Oper. Total | cost_operating_ total |
This amount summarizes a property's operating costs as net income; the operating expenses are subtracted from any incidental income for the OPERATING EXP cost type. Calculated as : This field is calculated when you generate the Property Abstract, Property and Building Benchmark, and Undeveloped Properties reports. |
Calculated |
Expense - Other Total | expense_other_total |
Use this field to review summarized expenses for cost types other than the major categories of TAX, UTILITY, or OPERATING EXP. If these "other" costs also have income amounts, this income is summarized in the Income Total amount. Calculated as: This value is calculated when you generate the Property Abstract, Property and Building Abstract, and Undeveloped Properties reports. |
Calculated |
Expense - Tax Total | cost_tax_total |
This amount summarizes a property's tax costs as net income; the tax expenses are subtracted from any incidental income for the TAX cost type. Calculated as: This amount is calculated when you generate the Property Abstract, Property and Building Benchmark, and Undeveloped Properties reports. |
Calculated |
Expense - Utility Total | cost_utility_total |
This amount summarizes a property's utility costs as net income; the utility expenses are subtracted from any incidental income for the UTILITY cost type. Calculated as: This amount is calculated when you generate the Property Abstract, Property and Building Benchmark, and Undeveloped Properties reports. |
Calculated |
GIS Object ID | gis_objectid | When using advanced map features, if you are maintaining asset geometry outside the Archibus environment (rather than with the Smart Client Extensions), you export this field from ArcGIS Map Services, so that it can be imported into Archibus. | None |
Graphic - Map | image_map | Use this graphic field to enter the file name, with extension, of a map of the property. This graphic file can be displayed in the Property Abstract report. | Graphic |
Graphic - Property | image_file | Use this graphic field to enter the file names, with extensions, of an image of the property. This graphic file can be displayed in the Property Abstract report. | Graphic |
Highway Distance | int_dist | Use this field to record the distance from the property to the nearest highway. This information is important to brokers trying to sell or lease a property. | None |
Highway Name | int_name |
Use this field to record the name of the highway nearest to the property. This information is important to brokers trying to sell or lease a property. |
None |
Income - Total | income_total |
This field is calculated to store income-producing costs for a property, for example, fees or rent you receive from a tenant. This amount summarizes income for a property for any cost types that are not TAX, UTILITY, or OPERATING EXP. Calculated as: This value is calculated when you generate the Property Abstract, Property and Building Benchmark reports. |
Calculated |
Internal Rate of Return | cost_irr | Complete this field with appropriate values if you wish to include this information in your property financial and abstract reports. The system does not calculate these values; you must determine these amounts and then complete the field. | None |
Land / Structure | property_type |
Record whether this property is a structure or land. This field enables you to track both types of property. For example, by defining property as structure or land, you can review information for these portfolio items in the Buildings /Structure / Land by…Country / Region / State / City / Site / Property report. |
None |
Land Acres | area_land_acres | Enter the number of acres this property occupies. | None |
Land Is | land_is |
Use this field to indicate the ownership status of the property’s land. For example, if you own all the land, complete this field with "Owned." |
None |
Latitude | lat | The property's latitude that is calculated from the property's street address (Address 1 field), City and State Codes when you run the Geocode action for the property. Used to place the property on a map view. These values are calculated for a property when you run the geocode action (globe button with tool tip Calculate location or new items) from the Manage Structures by Location or Manage Land by Location tasks. | Calculated |
Longitude | lon | The property's longitude that is calculated from the property's street address (Address 1 field), City and State Codes when you run the Geocode action for the property. Used to place the property on a map view. These values are calculated for a property when you run the geocode action (globe button with tool tip Calculate location or new items) from the Manage Structures by Location or Manage Land by Location tasks. | Calculated |
Number of Buildings | qty_no_bldgs | This fields stores your entry for the number of buildings located on the property. | None |
Number of Buildings - Calculated | qty_no_bldgs_calc | The system calculates this field by summing the number of buildings associated with this property. The value is shown in the Amenities by Property report. | Calculated |
Option 1 | option1 | This field is available to use when customizing the application. | None |
Option 2 | option2 | This field is available to use when customizing the application. | None |
Other Name | other_name | Use this field to document other names under which the property may be known, such as Corporate Headquarters. | None |
Parking Acres | area_prkg_acres | Use this field to store the number of acres devoted to parking spaces. | None |
Pending Action | pending_action | This field stores the description of where the property is in the disposal process. These values come from the enumerated list: N/A (for not being considered for disposal); Mark for Disposal; Mark for Donation; Mark for Evaluation; Mark for Refurbish; Mark for Repurpose. | None |
Percent Owned | pct_own | Enter the percentage of the property owned by your organization. | None |
Postal Code | zip | Use this field to store the postal code. The postal code appears in some reports, such as the View Buildings by Building Status report. You can sort this report by Postal Code. | None |
Property Condition | condition |
Property assessments should update the value of this field to reflect the current condition of the asset as .New; Excellent; Good; Fair; Poor; or Bad . These values are stored in an enumerated list. The condition of an asset is a key factor in optimization analysis. |
None |
Primary Contact | contact1 | Enter the name of the primary contact for this property. Note that this field is not validated. | None |
Property Code | property_id | The unique identifier for the property. | None |
Property Fronts On | fronts | Use this field to document the area that the property faces, such as Ocean, River, or Road. | None |
Property Headcount | qty_headcount |
This is the sum of the Building Occupancy value entered for each building assigned to the property. You enter the Building Occupancy using the Portfolio Edit Wizard. This value is calculated when you generate the Property Abstract report. |
Calculated |
Property Is | prop_is |
Use this field to indicate the ownership status of the entire property. For example, if you own the entire property, complete this field with "Owned." |
None |
Property Name | name | Enter a descriptive name for the property. | Desc |
Property Occupancy | qty_occupancy | Enter the number of people who work in the buildings on this property. The Property Occupancy value is used in the Property Summary and Property and Building Benchmark reports to calculate benchmarks, such as the Yearly Income per Occupant. | None |
Property Photo | prop_photo | Select an image to include it in reports, such as the Leases and Suites by Buildings or Leases by Structures / Land reports (Portfolio application), or the Building / Structure / Land / Lease Details reports (Leases application). | Document |
Property Status | status |
This field stores the ownership status of the property. The system can generate the status based on information you enter for the property. For example, when you select Owned or Leased on the Portfolio Edit Wizard using the Real Property application, the system sets the property's status as Owned or Leased according to your selection. As you enter information for the property throughout its lifecycle, the system can update the status. For example, when you set the Disposal Type for a property to Donate, Discard, or Sell, the Property Status is set to Donated, Disposed, or Sold according to your selection. At other times, you set the status manually. The Status field is used to help identify assets to be evaluated for disposal, refurbishment, or repurposing. See Status Definitions for Assets for a description of all statuses. The Property Status is shown in the asset registry.You can also review property status in the Properties or Buildings by Property Status, All Properties Yearly Financial Summary by Country, Property Financial Summary, and Undeveloped Properties reports. |
None |
Property Use | use1 | Select the description of how this property is used (office space, mixed use, hotel). Property Use is shown in property financial reports to help you evaluate property financial data by the property's use. | None |
Property Value - Book | |||
Property Value – Market | |||
Property Value - Land | property.value_land | ||
Property Value - Building | property.value_bldg | ||
Property Value - Extras | property.value_extras | ||
Purchase Price | cost_purchase |
This field stores the price you paid for the property. Note: The metrics shown on the Optimization tab of the Asset Lifecycle Console use the Purchase Price from the Ownership Transaction table, not the Purchase price stored for the property. |
None |
Purchased From | purchased_from | This field documents the person or entity you purchased the property from. | None |
Real Property Unique Identifier | grp_uid |
Archibus provides the non-validating Real Property Unique Identifier (grp_uid) field in the Property (property), Building (bl) and Equipment (eq) tables for deployments looking to link US Federal Registry assets to Archibus asset inventory tables. |
None |
Region Code | regn_id | Use this field if you report on properties in terms of regions. This field is validated by the Regions (regn) table. | None |
Return On Investment | cost_roi | Complete this field with the appropriate values if you wish to include this information in your property financial and abstract reports. The system does not calculate this value; you must determine this amount and then complete the field. | None |
Secondary Contact | contact2 | Enter the name of the secondary contact for this property. Note that this field is not validated. | None |
Selling Broker | selling_broker | Use this field to record the broker who sold the property. | None |
Selling Commission | selling_commission | When you sell the property, use this field to record the selling commission. This can be helpful for spotting real estate trends | None |
Selling Price | cost_selling | The price the property sold for. Tracking the price is important for spotting real estate trends. | None |
Services Used | services | Use this field to record the municipal services that the property requires, such as Sewer, Water, Electric, and Gas. These services are shown in the Property Abstract, Land or Structure Details, and the Amenities by Properties reports. | None |
Site Code | site_id | You can use the Site Code field to represent the campus on which a property is located. This field is validated by the Sites (site) table. | None |
Sold To | Sold To | The party that purchased the property. Tracking the party who purchased a property is important for long-term reporting requirements, such as hazardous waste liability which is not limited by the sales transaction. | None |
State Code | state_id | This field stores the state where the property is located. Validated by the States (states) table. | None |
Street | street | The street address of the property that you enter when adding the record for the property. | None |
Suite Occupancy | qty_su_occupancy |
The applications sums the Suite Occupancy values assigned to all suites for all leases for the buildings on the property. This value is calculated when you generate the Lease Abstract Report. |
Calculated |
Tax Rate - Property | tax_rate_prop |
This field is calculated when you run the Update Property Tax Rate action from the Property Abstract report. It is based on costs entered using the property tax type (Cost Category - Tax Rate - Property). These calculations are aggregated from the parcel to the property level. The calculations take into account the most recently paid tax cost, so only actual cost records are used. |
Calculated |
Tax Rate - School | tax_rate_school | This field is updated using the “Update Property Tax Rates” action in the Property Abstract report. For each property, the Tax Rate - School is determined by summing the tax rates for the school tax type. These calculations use the most recent property tax rates, and use the latest paid actual costs. | Calculated |
Value - Assessed Prop. Tax | value_assessed_prop_tax | This field is updated using the “Update Property Tax Rates” action in the Property Abstract report. For each property, the assessed value for the property tax is determined by summing the assessed values from all parcels assigned to the property. These calculations use the most recent property tax rates, and use the latest paid actual costs. | Calculated |
Value - Assessed School Tax | value_assessed_school_tax | This field is updated using the “Update Property Tax Rates” action in the Property Abstract report. For each property, the assessed value for the school tax is determined by summing the school tax rate and assessed values from all parcels assigned to the property. These calculations use the most recent property tax rates, and use the latest paid actual costs. | Calculated |
Value - Book | The book value you enter for the property is summed for geographic locations, and is shown in dashboard key performance indicator charts that help you look for profit opportunities in your current portfolio. The Property and Building Benchmark report provides the minimum, maximum, and average for this value for the properties included in the report. | None | |
Value - Market | The market value you enter is summed for geographic locations, and is shown in dashboard key performance indicator charts that help you look for profit opportunities in your current portfolio. The Property and Building Benchmark report provides the minimum, maximum, and average for this value for the properties included in the report. | None | |
Vicinity Type | vicinity |
This field records the area in which the property is located, such as Suburban Office Park, Industrial, Wharf, or Downtown Office. You can review this information in the Property Abstract, land or Structure Details, or Amenities by Property reports. |
None |
Zoning Type | zoning | You record the zoning type by selecting a value for this field from enumerated list. You can then review the zoning type in reports, such as the Properties Details, Property Abstract, and Amenities by Property reports. | None |