Skip to main content
Eptura Knowledge Center

Requirements for Building Data

General Information


Description – A list of the buildings to be managed in Serraview. The building data is used to set up the foundation of your Portfolio data.

Building data such as location, leasing information, budget, rating, the annual cost to maintain a building, and other key building information is collected and loaded into Serraview to create a central repository of all real estate information. This information is collated with data for floors, allocations, and occupancy to provide reporting that gives high visibility over the portfolio.

Common Data Sources – The list may come from existing building management or leasing system (such as an IWMS, CAFM, or HR system) or a manually prepared spreadsheet.

Recommended Refresh Frequency - The building data can be updated in sync with when your Corporate Real Estate team publishes updates.

Custom Fields - If you have any custom fields to be included, then inform your SpaceIQ Onboarding Manager as custom fields must be configured in Serraview prior to import.

Custom fields that are not part of the original scope of work for the implementation, will be considered a modification that will incur an additional cost. Any modifications will require a change request to be created.

File Updates – Data files can be used to update and add buildings. All file updates must be full files, no deltas.

Building Import


The Building Import requires the following:

  • Each row must represent a single building.

Identify a Building

The import uses the following columns to identify a building and you must include one of the columns in the import.

  • Building Number
  • Building

Data Dictionary


The table below lists the columns and the required columns and values are shown in blue text.

Column Name

Description

Data Type

Max Length

Column Required

Value Required

Unique in this file

Building Number

Unique identifier for the building. It is usually generated by your leasing system.

Text

20

Yes

Yes

Yes

Building Name

Name of building e.g. 'Headquarters', 'Park Tower', '210 Park Ave'. It is the name that will display on your reports.

Text

150

Yes

Yes

Yes

Short Name

An abbreviation for your building name e.g. 210 Park, which can be used on reports where space is a premium.

A unique name is recommended.

Text

20

No

No

No

Street Address

Street number and the name. e.g. '1000 Main Street'

Text

150

Yes

Yes

No

City

City name.

Text

100

Yes

Yes

No

State

Use the full name or an abbreviation. Use a consistent standard across the data.

Text

100

No

No

No

Postcode

Post code or zip code.

Text

50

No

No

No

Country

Use the full name or an abbreviation. Use a consistent standard across the data.

Text

100

Yes

Yes

No

Region

Geographic region e.g. East Coast.

The lookup values need to correlate to the configured region hierarchy.

Refer to the section on Region Hierarchy Data.

Text
Lookup

200

Yes

Yes

No

Description

Building description such as style, condition, primary use, whatever would be useful.

Text

2000

No

No

No

Comments

Additional building information.

Text

100

No

No

No

Building Type

Type of building and can be anything meaningful to your reporting requirements such as: HQ, Office, Branch.

Text
Lookup

200

No

No

No

Lease Expiry

Date of the next lease expiry in the building

Date

-

No

No

No

Lease land lord

Name of the Landlord

Text

30

No

No

No

Lease Options

Summary of lease renewal options (e.g. 2x5)

Text

30

No

No

No

Lease Type

Freehold, Leasehold

Text
Lookup

200

No

No

No

Lease Term

Current Lease Term in years

Integer

32-Bit

No

No

No

Latitude

GIS Information

Decimal

(20,9)

No

No

No

Longitude

GIS Information

Decimal

(20,9)

No

No

No

 

Any custom fields?