Skip to main content
Eptura Knowledge Center

Requirements for Team Data

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?