HRIS S3 connector field reference

To successfully sync your data with the Teamwork Graph for use in Talent, you must format your CSV files according to the specifications in this guide. This reference covers fields available for the positions.csv, workers.csv, and organizations.csv files.

Position fields

The positions.csv file defines the roles within your organization.

Required position fields

S3 connector field	Type	Description
positionId	String	Unique identifier
createdAt	Timestamp	ISO 8601 format (e.g., `2023-06-09T00:54:04.016-07:00`)
isActive	Number	`isActive=1` for active positions `isActive=0` for inactive positions
organizationId	String	Must match an existing `organizationId` from the organizations.csv file with `isActive` set to `1`
workerId	String	Must match an existing `workerId` from the workers.csv report with `isActive` set to `1`

Optional position fields

The positionTitle field is recommended to ensure displayed position names provide relevant context in the Talent app.

S3 connector field	Type	Description
positionTitle	String	Recommended to provide context in Talent
jobTitle	String	Internal job title
status	String	Can be set to `Filled` or `Unfilled` Leaving the field blank will set it to `Unfilled` Entering any value other than `Unfilled` will set the field to `Filled` Entries of `Unfilled` are not case-sensitive, e.g. `unfilled`or `unFilled`are also acceptable
inactiveDate	ISO 8601 date	Example: `2023-06-09` Required only if `isActive` is set to `0` Must be within the past 30 days
employmentType	Enum	Values: `Employee`, `Contingent`, or `Contractor`
timezone	String	Local timezone for the position
jobFamily	String	Internal job family classification
country	String	Country where the position is located
level	String	Job level or grade
externalPositionKey	String	External system identifier
lastUpdatedAt	ISO 8601 timestamp	Example: `2023-06-09T00:54:04.016-07:00` Timestamp of the last update

Worker fields

The workers.csv file contains information about the people in your organization.

Required worker fields

S3 connector field	Type	Description
workerId	String	Unique identifier
createdAt	ISO 8601 timestamp	Example: `2023-06-09T00:54:04.016-07:00`
name	String	The worker's full name
isActive	Number	`isActive=1` for active positions `isActive=0` for inactive positions

Optional worker fields

S3 connector field	Type	Description
emailAddress	String	Highly recommended to unlock Talent features Must be unique
timezone	String	Local timezone for the worker
hireDate	ISO 8601 date	Example: `2023-06-09`
inactiveDate	ISO 8601 date	Example: `2023-06-09` Required only if `isActive` is set to `0`. Must be within the past 30 days.
title	String	The worker's professional title
jobFamily	String	Internal job family
level	String	Job level or grade
country	String	Country of residence
lastUpdatedAt	ISO 8601 timestamp	Example: `2023-06-09T00:54:04.016-07:00` Timestamp of the last update

Organization fields

The organizations.csv file defines your reporting and managerial hierarchy.

Required organization fields

S3 connector field	Type	Description
organizationId	String	Unique identifier
organizationName	String	Name of the department or team
managerPositionId	String	Required when the `organizationId`’s manager assignment is associated with at least one `positionId`from the positions.csv file Not required when the `organizationId`’s manager assignment is not associated with any `positionId`. This is an unmanaged and empty organization.
superiorOrganizationId	String	Required for all except the top-most organization to indicate org hierarchy Must match an existing `organizationId` with `isActive` set to `1`
createdAt	ISO 8601 timestamp	Example: `2023-06-09T00:54:04.016-07:00`
isActive	Number	`isActive=1` for active organizations `isActive=0` for inactive organizations

Optional organization fields

S3 connector field	Type	Description
inactiveDate	ISO 8601 date	Example: `2023-06-09` Required only if `isActive` is set to `0` Must be within the past 30 days
lastUpdatedAt	ISO 8601 timestamp	Example: `2023-06-09T00:54:04.016-07:00` Timestamp of the last update

S3 connector field

Type

Description

inactiveDate

ISO 8601 date

Example: 2023-06-09

Required only if isActive is set to 0
Must be within the past 30 days

lastUpdatedAt

ISO 8601 timestamp

Example: 2023-06-09T00:54:04.016-07:00

Timestamp of the last update

Was this helpful?

It wasn't accurateIt wasn't clearIt wasn't relevant

Still need help?

The Atlassian Community is here for you.

Ask the Community