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 the 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. Mezzanine, 2nd Floor, 3rd Floor. |
Text |
20 |
Yes |
Yes |
Yes |
|
Sequence |
The Floor Sequence values entered must be a unique, positive integer/whole number; it cannot be a negative value, or be zero as this is reserved for the Scratch Pad. |
Integer |
32-Bit |
No |
No |
No |
|
NLA |
Net 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? Accepted values: Yes/No, True/False, One (1)/ Zero (0) or Blank (false) |
Boolean | N/A | No | No | No |
| Location Integration |
Accepted values: Yes/No, True/False, One (1)/ Zero (0) or Blank (false) |
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. Learn more about Tagging. |
Text | 200 | No | No | No |
|
Any custom fields? |