Requirements for Floors Data
- Last updated
- Save as PDF
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:
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? |