Reporting reference - fields

allocated_fte

double

The amount of full time equivalent a person is allocated into a team by

Calculated by TeamForm

allocation_allocated_fte

double

Allocation tables: Amount of full time equivalent the person is assigned into a team via Team Builder

Planning tables: Amount of full time equivalent a supply team is providing to a demand team at the start date of the allocation project (aka the baseline)

Calculated by TeamForm

approval_saved_at_timestamp_utc

timestamp

Date and time when a user last inputted a approved FTE amount for a demand.

Calculated by TeamForm

approval_submitted_at_timestamp_utc

timestamp

Date and time when a user last submitted approvals from supply to demands.

Calculated by TeamForm

approval_submitted_fte_actual

double

Total amount of full time equivalent between the supply and the demand that has been submitted to the demand. It is calculated using the formula: allocated_fte + approval_submitted_fte_delta

Calculated by TeamForm

approval_submitted_fte_delta

double

Change in the amount of full time equivalent between the supply and the demand that has been entered by a supply user and submitted to the demand.

User input within TeamForm

approved_fte_actual

double

Total amount of full time equivalent between the supply and the demand that has not not yet been submitted to the demand. It is calculated using the formula: allocated_fte + approved_fte_delta

Calculated by TeamForm

approved_fte_delta

double

Change in the amount of full time equivalent between the supply and the demand that has been entered by a supply user but not yet submitted to the demand.

User input within TeamForm

attribute_id

string

Identifier of the attribute. Only used in some situations. Not unique

Generated by TeamForm

attribute_subtype

string

The secondary category of the attribute. Optional.

Provided by integration

attribute_type

string

The primary category of the attribute.

Provided by integration

attribute_value

string

The value of the attribute.

Provided by integration or user input

current_allocated_fte

double

The amount of full time equivalent a person is allocated into a team by at at the current date and time (only calculated under certain configurations)

Calculated by TeamForm

division_hierarchy_id_1 to division_hierarchy_id_19

string

Identifier of the first to fifteenth division the person is located in

Generated by TeamForm

division_hierarchy_name_1 to division_hierarchy_name_19

string

Name of the first to fifteenth division the person is located in

Provided by HR integration

division_hierarchy_name_string

string

Concatenated hierarchy of the division names separated by a backslash [\]. The first division is division_hierarchy_name_1, followed by division_hierarchy_name_2 and each subsequent division with the last division being the same as the division_name

Provided by HR integration

division_id

string

The identifier of the division the person is located in

Generated by TeamForm

division_name

string

The name of the division the person is located in

Provided by HR integration

division_parent_id

string

Identifier of the parent division

Generated by TeamForm

forecast_fte

double

The estimate full time equivalent set by a demand team user for a particular allocation project between a supply team and a demand team. If no value has been entered it is assumed the forecast is the same as the proceeding quarter’s forecast or if the proceeding quarter is the current active quarter, the request_submitted_fte_actual value

Calculated by TeamForm

manager_firstname

string

Provided by HR integration

manager_preferred_name

string

Provided by HR integration

manager_surname

string

Provided by HR integration

person_address

string

Provided by HR integration

person_allocated_fte

double

Total amount of full time equivalent the person is assigned into teams via Team Builder

Calculated by TeamForm

person_band

string

Employment categorisation of the person

Provided by HR integration

person_city

string

Provided by HR integration

person_company

string

Employing organisation of the person

Provided by HR integration

person_country

string

Provided by HR integration

person_direct_workforce

boolean

Classification of the person’s workforce situation

Provided by HR integration

person_email

string

Provided by HR integration

person_firstname

string

The given name of the person

Provided by HR integration

person_fte

double

Full time equivalent amount the person is employed for

Provided by HR integration

person_fte_span

double

Amount of full time equivalent the person directly manages

Calculated by TeamForm

person_id

string

Unique identifier per person

Provided by HR integration

person_ids

array

Alternative unique identifiers per person

Provided by HR integration

person_isallocated

boolean

Flag indicating if the person has been assigned into any teams via Team Builder

Calculated by TeamForm

person_jobtitle

string

Provided by HR integration

person_layer

int

The layer of the organisation the person is located in

Calculated by TeamForm

person_manager_id

string

Unique identifier of the person’s direct manager

Provided by HR integration

person_preferredname

string

The preferred name of the person to use instead of person_firstname

Provided by HR integration

person_span

int

Number of people who this person directly manages

Calculated by TeamForm

person_surname

string

The family name of the person

Provided by HR integration

project_allocation_timestamp_utc

timestamp

The date and time the project becomes effective

Configured in TeamForm

project_baseline_timestamp_utc

timestamp

This date and time is used as the project baseline for Planner requests and approvals.

Configured in TeamForm

project_forecast

boolean

Flag indicating if the allocation project is configured to appear on the Forecasting page

Generated by TeamForm

project_id

string

Identifier of a project

Generated by TeamForm

project_name

string

The textual name of the project

Configured in TeamForm

project_planning

boolean

Flag indicating if the allocation project is currently open for users to interact with in Team Builder and Planner

Generated by TeamForm

project_start_timestamp_utc

timestamp

The date and time the project opens.

Configured in TeamForm

project_working_days

integer

The number of business days during a project. Used for financial calculations

Configured in TeamForm

proposedAllocatedFteActual

double

Total amount of full time equivalent from the supply to the demand that has been allocated using Team Builder.

Calculated by TeamForm

request_saved_at_timestamp_utc

timestamp

Date and time when a demand user last inputted a request FTE amount from a supply.

Calculated by TeamForm

request_status

approval_status

string

Status text of a Planner request.

• NONE is when no changes have been made and no request or approval is outstanding.

• PRE_APPROVED is when no changes have been made and the allocatedfte amount is the default approved value.

• SAVED is when a request or approved amount has been entered by a user but has not been submitted to the other party.

• SUBMITTED is when a request or approved amount has been entered and has been sent to the other party.

• PENDING is when a request or approved amount has been received but have not been responded to.

Calculated by TeamForm

request_submitted_at_timestamp_utc

timestamp

Date and time when a user last submitted requests from demand to supply.

Calculated by TeamForm

request_submitted_fte_actual

double

Total amount of full time equivalent between the supply and the demand that has been submitted to the supply. It is calculated using the formula: allocated_fte + request_submitted_fte_delta

Calculated by TeamForm

request_submitted_fte_delta

double

Change in the amount of full time equivalent between the supply and the demand that has been entered by a demand user and submitted to the supply.

User input within TeamForm

requested_fte_actual

double

Total amount of full time equivalent between the supply and the demand that has not yet been submitted to the supply. It is calculated using the formula: allocated_fte + requested_fte_delta

Calculated by TeamForm

requested_fte_delta

double

Change in the amount of full time equivalent between the supply and the demand that has been entered by a demand user but not yet submitted to the supply.

User input within TeamForm

supply_hierarchy_id_1 to supply_hierarchy_id_19

string

Identifier of the first to tenth chapter the person is located in

Generated by TeamForm

supply_hierarchy_name_1 to supply_hierarchy_name_19

string

Name of the first to tenth chapter the person is located in

Generated by TeamForm

supply_hierarchy_name_string

string

Concatenated hierarchy of the chapter names separated by a backslash [\]. The first chapter is supply_hierarchy_name_1, followed by supply_hierarchy_name_2 and each subsequent chapter with the last chapter being the same as the supply_name

Generated by TeamForm

supply_hierarchy_type_1 to supply_hierarchy_type_19

string

Type of the first to tenth chapter the person is located in

Generated by TeamForm

supply_id

string

The identifier of the supply team (chapter) the person is located in

Generated by TeamForm

supply_name

string

The name of the supply team (chapter) the person is located in, if the person is located in a chapter

Provided by HR integration

supply_parent_id

string

Identifier of the parent supply team (chapter)

Generated by TeamForm

supply_type

string

The type of chapter the person is located in

Configured in TeamForm

team_daily_rate

double

The numerical cost for one day of one FTE

Provided by HR integration

team_deleted

boolean

Flag indicating if a team has been deleted.

Calculated by TeamForm

team_direct_membership

boolean

Flag indicating if the person has been assigned direct membership into a team or if they are indirectly a member due to membership of a child team

Calculated by TeamForm

team_hidden

boolean

Flag indicating if a team has been hidden.

Calculated by TeamForm

team_hierarchy_id_1 to team_hierarchy_id_19

string

Identifier of the first to tenth team the person is located in

Generated by TeamForm

team_hierarchy_name_1 to team_hierarchy_name_19

string

Name of the first to tenth team the person is located in

Generated by TeamForm

team_hierarchy_name_string

string

Concatenated hierarchy of the team names separated by a backslash [\]. The first team is team_hierarchy_name_1, followed by team_hierarchy_name_2 and each subsequent team with the last team being the same as the team_name

Generated by TeamForm

team_hierarchy_type_1 to team_hierarchy_type_19

string

Type of the first to tenth team the person is located in

Generated by TeamForm

team_id

string

Unique identifier of the team

Generated by TeamForm

team_ids

array

Alternative unique identifiers per team

Provided by integration

team_name

string

Name of the team

User inputed in TeamForm

team_parent_id

string

Identifier of the parent team

Generated by TeamForm

team_type

string

The type of a team

User inputed in TeamForm