Requirements for Team Data
- Last updated
- Save as PDF
General Information
- The import file can have multiple teams, with different names, but the same cost center.
Team Import
- Each row must represent a single team.
Identify a Building
The import uses the following columns to identify a building and you must include both or one of the columns in the import.
- Building Number
- Building
Identify a Floor
The import uses the following columns to identify a floor and you must include both or one of the columns in the import.
- Floor Number
- Floor
Identify an OrgUnit Mapping
The import uses the following columns to identify an org unit mapping and you must include either all columns or one of the columns in the import:
- OrgUnit (name)
- Cost Centre (code)
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 |
|---|---|---|---|---|---|---|
|
Team Id |
Unique identifier of the team. |
No |
No |
Yes |
||
|
Team |
The name of the team |
Text |
50 |
No |
No |
No |
|
Building Number |
Unique identifier for the building. |
Text |
20 |
Yes |
Yes |
No |
|
Building |
Name of building e.g. 'Headquarters', 'Park Tower', '210 Park Ave'. |
Text |
150 |
Yes |
Yes |
No |
|
Floor Number |
Unique identifier for the floor e.g. 02. |
Text |
20 |
Yes |
Yes |
No |
|
Floor |
Name of the floor e.g. Ground Floor, Mezzanine, 2nd Floor, 3rd Floor. |
Text |
20 |
Yes |
Yes |
No |
|
Zone |
No |
No |
No |
|||
|
Cost Centre |
The cost center of the org unit allocated to this space. |
Text |
20 |
Yes |
Yes |
No |
|
OrgUnit |
The org unit or cost center description e.g. Commercial Banking. |
Text |
100 |
Yes |
Yes |
No |
|
Hood |
Allocate the workpoint(or space) to a hood. |
Text |
50 |
No |
No |
No |
|
New Team Name |
Name of the new team. |
- |
No |
No |
No |
|
|
Workpoints |
Number of workpoints. |
Integer |
32-Bit |
No |
No |
Yes |
|
Is Flexi? |
Identifies the space's working style. You can use the following values: Yes; No The Yes value means the space is flexi and No values means the space is fixed. |
Boolean |
No |
No |
No |
|
|
Target Ratio |
If the team is a Flexi team, then you can set the target ratio for the team. For example 1.2 |
No |
No |
No |
||
|
Administrator Comments |
Any comments from the Administrator. The comments will display in the Team form's Overview tab, refer to Team Details Form. |
Text |
100 |
No |
No |
No |
|
Wayfinding Comments |
Comments for a room or workpoint that will show in the Wayfinding interface. |
Text |
100 |
No |
No |
No |
|
Workplace Administrators |
Name of the Workplace Administrator(s). |
No |
No |
No |
||
|
Tags |
An existing tag can be applied to a team. For more information, refer to Tagging. |
Text |
200 |
No |
No |
No |
| Any custom fields? |