Skip to main content
Eptura Knowledge Center

Requirements for Floors Data

General Information


Description – A list of the floors per building to be managed in Serraview. The floor data is used to set up the foundation of Serraview and create the stacking plan in the  Visual Block and Stack (VBS).

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

Recommended Refresh Frequency - The floorplans can be uploaded via an automated or manual process.

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 – Floors are managed manually in Serraview and the floorplan updates can be uploaded via an automated or manual process.

Floor Import


The Floor Import requires the following:

  • Each row must represent a single floor.

Identify a Building

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

  • Building Number
  • Building

Identify a Floor

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

  • Floor Number
  • Floor

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.

Text

20

Yes

Yes

Yes

Building Name

Name of building e.g. 'Headquarters', 'Park Tower', '210 Park Ave'.

Text

150

Yes

Yes

Yes

Floor Number

Unique identifier for the floor e.g. 02.

Text

20

Yes

Yes

Yes

Floor

Name of the floor e.g. Ground Floor, Mezzanine, 2nd Floor, 3rd Floor.

Text

20

Yes

Yes

Yes

Sequence

Order to display floors from the bottom up. For example:

  • Ground Floor would be 0
  • 1st Floor would be 1
  • Mezzanine would be 2
  • 2nd Floor would be 3

This information is important to display the floors in the correct order (bottom to top).

Integer

32-Bit

No

No

No

Leased Area

RSF (Rental Square Feet) or the NLA (Net Nettable Area) associated with the lease.

Decimal

20,2

No

No

No

NLA

Net lettable area (m2)

Decimal

(20,9)

No

No

No

GLA

Gross lettable area (m2)

Decimal

(20,9)

No

No

No

Workpoints Number of workpoints Integer 32-Bit No No No
Show in VBS?

Do you want this floor to display in the Visual Block and Stack?

Yes; No

Boolean N/A No No No

Comments

Notes about the floor such as ceiling height, condition, primary use.

Text

4000

No

No

No

Tags

An existing tag can be applied to a workstation. For example sit to stand, dual monitors, adjustable desk. 

For more information, refer to Tagging.

Text 200 No No No
 

Any custom fields?