Schema for Talent

Talent helps leaders shape their workforce to ensure the right people are working on their most important strategies. Talent is the hub for designing the workforce you need and will help you make key decisions with confidence about you allocate your talent to your strategy. Read more about Talent.

If you add Talent data to an Atlassian Data Lake connection, you can query that data from the following tables:

Table for custom field data

Custom field

The talent_custom_field table contains the latest information for the custom fields of your positions and workers.

Name

The name of the custom field.

SQL name	`name`
Data type	String
Example values	Address, Travel required

Position ID

The unique identifier of the position.

SQL name	`position_id`
Data type	String
Foreign key	Links to a record in the `talent_position` table.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

String value

The string value of the custom field.

SQL name	`string_value`
Data type	String
Example values	112 ABC Lane

Worker ID

The unique identifier of the worker.

SQL name	`worker_id`
Data type	String
Foreign key	Links to a record in the `talent_worker` table.

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Table for position data

Position

The talent_position table contains the latest information for your positions.

Country

The country the position is based in.

SQL name	`country`
Data type	String

Created at

The date and time (UTC time zone) when the position was created.

SQL name	`created_at`
Data type	Datetime

Employment type

The classification of employment based on the nature of the employment relationship with the company.

SQL name	`employment_type`
Data type	String
Example values	employee contingent contractor

External reference

The unique identifier of the position in the HRIS data source.

SQL name	`external_ref`
Data type	String

Job family

The business function of the position.

SQL name	`job_family`
Data type	String
Example value	Product Management

Job title

The display name for the job of the position.

SQL name	`job_title`
Data type	String
Example value	Senior Product Manager

Level

The job level of the position that defines the typical scope, organizational reach, and degree of impact.

SQL name	`level`
Data type	String
Example values	L1, L2, L3, P40, P50, M80

Manager position ID

The unique identifier of the position defined as the manager.

SQL name	`manager_position_id`
Data type	String
Foreign key	Links to another record in the `talent_position` table.

Position ID

The unique identifier of the position. Use this as the primary key for position data.

SQL name	`position_id`
Data type	String

Position title

The display name describing the specific position.

SQL name	`position_title`
Data type	String
Example value	Senior Product Manager - Confluence

Role

The organizational role of the position (either manager or individual contributor).

SQL name	`role`
Data type	String
Example values	Manager Individual contributor

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Status

The status of the position based on whether or not the position is filled by a worker.

SQL name	`status`
Data type	String
Example values	filled unfilled = “Not filled” in Talent

Timezone

The timezone the position is based in.

SQL name	`timezone`
Data type	String
Example values	Europe/London, America/New_York

Updated at

The date and time (UTC time zone) when the position was last updated.

SQL name	`updated_at`
Data type	Datetime

Worker ID

The unique identifier of the work filling the position.

SQL name	`worker_id`
Data type	String
Foreign key	Links to a record in the `talent_worker` table.

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Table for worker data

Worker

The talent_worker table contains the latest information for workers.

Account ID

The unique identifier of the Atlassian account associated with the worker.

SQL name	`account_id`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Country

The country the worker is based in.

SQL name	`country`
Data type	String

Created at

The date and time (UTC time zone) when the worker was created.

SQL name	`created_at`
Data type	Datetime

Email

The email address of the worker.

SQL name	`email`
Data type	String

External reference

The unique identifier of the worker in the HRIS data source.

SQL name	`external_ref`
Data type	String

Job family

The business function of the worker.

SQL name	`job_family`
Data type	String
Example value	Product Management

Job title

The display name of the job of the worker.

SQL name	`job_title`
Data type	String
Example value	Senior Product Manager

Level

The job level of the worker that defines the typical scope, organizational reach, and degree of impact.

SQL name	`level`
Data type	String
Example values	L1, L2, L3, P40, P50, M80

Most recent hire date

The date and time that the worker started working at the company.

SQL name	`most_recent_hire_date`
Data type	Datetime

Preferred name

The preferred name of the worker.

SQL name	`preferred_name`
Data type	String

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Timezone

The timezone the worker is based in.

SQL name	`timezone`
Data type	String

Updated at

The date and time (UTC time zone) when the worker was last updated.

SQL name	`uupdated_at`
Data type	Datetime

Worker ID

The unique identifier of the worker. Use this as the primary key for worker data.

SQL name	`worker_id`
Data type	String

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

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