Workday HCM connector reference

Beta

This feature is in Beta. Workspace admins can control access to this feature from the Previews page. See Manage Databricks previews.

This page contains reference documentation for the managed Workday HCM connector in Lakeflow Connect.

Supported data

The connector supports 137 selectable destination tables from 20 Workday Objects. The following table groups the destination tables by their source API and identifies their ingestion mode. All destination tables generated from the same API share the ingestion mode shown for that API.

Workday Object	Ingestion mode	Destination tables
Workers	Incremental	`worker_collective_agreement`, `worker_leave_status`, `worker_position_compensation`, `worker_position_end_employment_reason`, `worker_position_job_classification`, `worker_position_manager`, `worker_position_organization`, `worker_position_payroll_reporting_code`, `worker_positions`, `worker_probation_period`, `worker_secondary_termination_reason`, `workers`
Ethnicities	Full refresh	`ethnicity`
Gender identities	Full refresh	`gender_identity`
LGBT identifications	Full refresh	`lgbt_identification`
Pronouns	Full refresh	`pronoun`
Sexual orientations	Full refresh	`sexual_orientation`
Organizations	Full refresh	`organization`, `organization_assignment`, `organization_leader`, `organization_role`, `organization_role_worker`
Job profiles	Incremental	`job_family_job_profile`, `job_profile`, `job_profile_certification`, `job_profile_classification`, `job_profile_company_insider`, `job_profile_competency`, `job_profile_education`, `job_profile_exempt`, `job_profile_language`, `job_profile_language_ability`, `job_profile_pay_rate`, `job_profile_responsibility`, `job_profile_restrict_to_country`, `job_profile_skill`, `job_profile_training`, `job_profile_work_experience`, `job_profile_worker_compensation`
Positions	Incremental	`position`, `position_bonus_plan`, `position_certification`, `position_competency`, `position_education`, `position_job_family`, `position_job_profile`, `position_language`, `position_location`, `position_merit_plan`, `position_organization`, `position_pay_plan`, `position_responsibility`, `position_skill`, `position_stock_plan`, `position_training`, `position_work_experience`, `position_worker_type_restriction`
Candidates	Full refresh	`candidate`, `candidate_certification`, `candidate_education`, `candidate_experience`, `candidate_language`, `candidate_name`, `candidate_pool_membership`, `candidate_skill`, `candidate_tag`, `candidate_website`
Questionnaires	Full refresh	`questionnaire`, `questionnaire_setup`
Interviews	Full refresh	`interview`, `interview_competency`, `interview_questionnaire`, `interview_session`, `interview_session_detail`, `interviewer`
External reference	Full refresh	`external_reference_line`, `external_reference_participant`, `questionnaire_answer`
Job requisitions	Incremental	`job_requisition`, `job_requisition_additional_job_posting_location`, `job_requisition_additional_job_profile`, `job_requisition_additional_location`, `job_requisition_allowance_plan`, `job_requisition_bonus_plan`, `job_requisition_calculated_plan`, `job_requisition_certification`, `job_requisition_commission_plan`, `job_requisition_compensation`, `job_requisition_competency`, `job_requisition_custom_organization`, `job_requisition_default_assessment_test`, `job_requisition_education`, `job_requisition_language`, `job_requisition_language_ability`, `job_requisition_merit_plan`, `job_requisition_organization`, `job_requisition_pay_plan`, `job_requisition_period_salary_plan`, `job_requisition_position`, `job_requisition_responsibility`, `job_requisition_skill`, `job_requisition_stock_plan`, `job_requisition_training`, `job_requisition_unit_allowance_plan`, `job_requisition_unit_salary_plan`, `job_requisition_work_experience`
Payroll results	Incremental	`payroll_line`, `payroll_line_pay_component`, `payroll_line_related_calculation`, `payroll_line_withholding`, `payroll_local_city_authority_tax_worktag`, `payroll_local_county_authority_tax_worktag`, `payroll_national_id`, `payroll_result`, `payroll_state_authority_tax_worktag`
Compensation plans	Full refresh	`compensation_allowance_plan_amount_profile`, `compensation_allowance_plan_percent_profile`, `compensation_bonus_plan_coverage_date_eligibility_rule`, `compensation_bonus_plan_performance_factor_scorecard`, `compensation_bonus_plan_replacement_percent`, `compensation_bonus_tranche`, `compensation_commission_plan_profile`, `compensation_future_payment_bonus_plan`, `compensation_merit_plan_replacement_percent`, `compensation_plan`, `compensation_stock_plan_amount_profile`, `compensation_stock_plan_grant`, `compensation_stock_plan_unit_profile`, `compensation_stock_profile_grant_split`, `deferred_compensation_eligibility_rule`
Compensation grades	Full refresh	`compensation_grade`, `compensation_grade_profile`, `compensation_step`
Absence inputs	Full refresh	`absence_input`
Override balances	Full refresh	`override_balance`
Time off plan balances	Full refresh	`time_off_plan_balance`, `time_off_plan_balance_position`

Workday Object	Ingestion mode	Destination tables
Workers	Incremental	`worker_collective_agreement`, `worker_leave_status`, `worker_position_compensation`, `worker_position_end_employment_reason`, `worker_position_job_classification`, `worker_position_manager`, `worker_position_organization`, `worker_position_payroll_reporting_code`, `worker_positions`, `worker_probation_period`, `worker_secondary_termination_reason`, `workers`
Ethnicities	Full refresh	`ethnicity`
Gender identities	Full refresh	`gender_identity`
LGBT identifications	Full refresh	`lgbt_identification`
Pronouns	Full refresh	`pronoun`
Sexual orientations	Full refresh	`sexual_orientation`
Organizations	Full refresh	`organization`, `organization_assignment`, `organization_leader`, `organization_role`, `organization_role_worker`
Job profiles	Incremental	`job_family_job_profile`, `job_profile`, `job_profile_certification`, `job_profile_classification`, `job_profile_company_insider`, `job_profile_competency`, `job_profile_education`, `job_profile_exempt`, `job_profile_language`, `job_profile_language_ability`, `job_profile_pay_rate`, `job_profile_responsibility`, `job_profile_restrict_to_country`, `job_profile_skill`, `job_profile_training`, `job_profile_work_experience`, `job_profile_worker_compensation`
Positions	Incremental	`position`, `position_bonus_plan`, `position_certification`, `position_competency`, `position_education`, `position_job_family`, `position_job_profile`, `position_language`, `position_location`, `position_merit_plan`, `position_organization`, `position_pay_plan`, `position_responsibility`, `position_skill`, `position_stock_plan`, `position_training`, `position_work_experience`, `position_worker_type_restriction`
Candidates	Full refresh	`candidate`, `candidate_certification`, `candidate_education`, `candidate_experience`, `candidate_language`, `candidate_name`, `candidate_pool_membership`, `candidate_skill`, `candidate_tag`, `candidate_website`
Questionnaires	Full refresh	`questionnaire`, `questionnaire_setup`
Interviews	Full refresh	`interview`, `interview_competency`, `interview_questionnaire`, `interview_session`, `interview_session_detail`, `interviewer`
External reference	Full refresh	`external_reference_line`, `external_reference_participant`, `questionnaire_answer`
Job requisitions	Incremental	`job_requisition`, `job_requisition_additional_job_posting_location`, `job_requisition_additional_job_profile`, `job_requisition_additional_location`, `job_requisition_allowance_plan`, `job_requisition_bonus_plan`, `job_requisition_calculated_plan`, `job_requisition_certification`, `job_requisition_commission_plan`, `job_requisition_compensation`, `job_requisition_competency`, `job_requisition_custom_organization`, `job_requisition_default_assessment_test`, `job_requisition_education`, `job_requisition_language`, `job_requisition_language_ability`, `job_requisition_merit_plan`, `job_requisition_organization`, `job_requisition_pay_plan`, `job_requisition_period_salary_plan`, `job_requisition_position`, `job_requisition_responsibility`, `job_requisition_skill`, `job_requisition_stock_plan`, `job_requisition_training`, `job_requisition_unit_allowance_plan`, `job_requisition_unit_salary_plan`, `job_requisition_work_experience`
Payroll results	Incremental	`payroll_line`, `payroll_line_pay_component`, `payroll_line_related_calculation`, `payroll_line_withholding`, `payroll_local_city_authority_tax_worktag`, `payroll_local_county_authority_tax_worktag`, `payroll_national_id`, `payroll_result`, `payroll_state_authority_tax_worktag`
Compensation plans	Full refresh	`compensation_allowance_plan_amount_profile`, `compensation_allowance_plan_percent_profile`, `compensation_bonus_plan_coverage_date_eligibility_rule`, `compensation_bonus_plan_performance_factor_scorecard`, `compensation_bonus_plan_replacement_percent`, `compensation_bonus_tranche`, `compensation_commission_plan_profile`, `compensation_future_payment_bonus_plan`, `compensation_merit_plan_replacement_percent`, `compensation_plan`, `compensation_stock_plan_amount_profile`, `compensation_stock_plan_grant`, `compensation_stock_plan_unit_profile`, `compensation_stock_profile_grant_split`, `deferred_compensation_eligibility_rule`
Compensation grades	Full refresh	`compensation_grade`, `compensation_grade_profile`, `compensation_step`
Absence inputs	Full refresh	`absence_input`
Override balances	Full refresh	`override_balance`
Time off plan balances	Full refresh	`time_off_plan_balance`, `time_off_plan_balance_position`

Automated transformations

Workday Object APIs return deeply nested responses. Databricks ingests each response into an internal raw staging table and automatically transforms it into one or more flattened destination tables. You select the flattened destination tables listed on this page. The connector does not expose the internal raw staging tables as selectable source tables.

Destination table schemas

The following sections list the columns in each selectable destination table. Data types use Databricks SQL notation. Composite types use forms such as array<string> and struct<field: string>.

Workers

Ingestion mode: Incremental

Destination tables: 12

`worker_collective_agreement`

Column	Data type
`worker_id`	`string`
`position_id`	`string`
`collective_agreement_id`	`string`
`employee_collective_agreement_event_code`	`string`
`employee_collective_agreement_event_id`	`string`
`effective_date`	`date`
`end_assignment_date`	`date`

Column	Data type
`worker_id`	`string`
`position_id`	`string`
`collective_agreement_id`	`string`
`employee_collective_agreement_event_code`	`string`
`employee_collective_agreement_event_id`	`string`
`effective_date`	`date`
`end_assignment_date`	`date`

`worker_leave_status`

Column	Data type
`worker_id`	`string`
`leave_request_event_id`	`string`
`leave_status_code`	`string`
`description`	`string`
`leave_return_event`	`string`
`on_leave`	`boolean`
`leave_start_date`	`date`
`estimated_leave_end_date`	`date`
`leave_end_date`	`date`
`first_day_of_work`	`date`
`leave_last_day_of_work`	`date`
`leave_of_absence_type`	`string`
`leave_type_reason`	`string`
`benefits_effect`	`boolean`
`payroll_effect`	`boolean`
`paid_time_off_accrual_effect`	`boolean`
`continuous_service_accrual_effect`	`boolean`
`stock_vesting_effect`	`boolean`
`leave_request_additional_last_date_for_which_paid`	`date`
`leave_request_additional_expected_due_date`	`date`
`leave_request_additional_child_birth_date`	`date`
`leave_request_additional_stillbirth_baby_deceased`	`boolean`
`leave_request_additional_date_baby_arrived_home`	`date`
`leave_request_additional_adoption_placement_date`	`date`
`leave_request_additional_adoption_notification_date`	`date`
`leave_request_additional_date_child_entered_country`	`date`
`leave_request_additional_multiple_child_indicator`	`boolean`
`leave_request_additional_number_of_babies_adopted_children`	`decimal(2,0)`
`leave_request_additional_number_of_previous_births`	`decimal(2,0)`
`leave_request_additional_number_of_previous_maternity_leaves`	`decimal(2,0)`
`leave_request_additional_number_of_child_dependents`	`decimal(2,0)`
`leave_request_additional_single_parent_indicator`	`boolean`
`leave_request_additional_age_of_dependent`	`decimal(3,0)`
`leave_request_additional_child_disability_indicator`	`boolean`
`leave_request_additional_child_date_of_death`	`date`
`leave_request_additional_work_related`	`boolean`
`leave_request_additional_social_security_disability_code`	`string`
`leave_request_additional_caesarean_section_birth`	`boolean`
`leave_request_additional_week_of_confinement`	`date`
`leave_request_additional_neonatal_care_start_date`	`date`
`leave_request_additional_neonatal_care_discharge_date`	`date`
`leave_request_additional_location_during_leave`	`string`
`leave_request_additional_leave_percentage`	`decimal(5,2)`
`leave_request_additional_leave_entitlement_override`	`decimal(5,0)`
`leave_request_additional_stop_payment_date`	`date`
`leave_request_additional_date_of_recall`	`date`

Column	Data type
`worker_id`	`string`
`leave_request_event_id`	`string`
`leave_status_code`	`string`
`description`	`string`
`leave_return_event`	`string`
`on_leave`	`boolean`
`leave_start_date`	`date`
`estimated_leave_end_date`	`date`
`leave_end_date`	`date`
`first_day_of_work`	`date`
`leave_last_day_of_work`	`date`
`leave_of_absence_type`	`string`
`leave_type_reason`	`string`
`benefits_effect`	`boolean`
`payroll_effect`	`boolean`
`paid_time_off_accrual_effect`	`boolean`
`continuous_service_accrual_effect`	`boolean`
`stock_vesting_effect`	`boolean`
`leave_request_additional_last_date_for_which_paid`	`date`
`leave_request_additional_expected_due_date`	`date`
`leave_request_additional_child_birth_date`	`date`
`leave_request_additional_stillbirth_baby_deceased`	`boolean`
`leave_request_additional_date_baby_arrived_home`	`date`
`leave_request_additional_adoption_placement_date`	`date`
`leave_request_additional_adoption_notification_date`	`date`
`leave_request_additional_date_child_entered_country`	`date`
`leave_request_additional_multiple_child_indicator`	`boolean`
`leave_request_additional_number_of_babies_adopted_children`	`decimal(2,0)`
`leave_request_additional_number_of_previous_births`	`decimal(2,0)`
`leave_request_additional_number_of_previous_maternity_leaves`	`decimal(2,0)`
`leave_request_additional_number_of_child_dependents`	`decimal(2,0)`
`leave_request_additional_single_parent_indicator`	`boolean`
`leave_request_additional_age_of_dependent`	`decimal(3,0)`
`leave_request_additional_child_disability_indicator`	`boolean`
`leave_request_additional_child_date_of_death`	`date`
`leave_request_additional_work_related`	`boolean`
`leave_request_additional_social_security_disability_code`	`string`
`leave_request_additional_caesarean_section_birth`	`boolean`
`leave_request_additional_week_of_confinement`	`date`
`leave_request_additional_neonatal_care_start_date`	`date`
`leave_request_additional_neonatal_care_discharge_date`	`date`
`leave_request_additional_location_during_leave`	`string`
`leave_request_additional_leave_percentage`	`decimal(5,2)`
`leave_request_additional_leave_entitlement_override`	`decimal(5,0)`
`leave_request_additional_stop_payment_date`	`date`
`leave_request_additional_date_of_recall`	`date`

`worker_position_compensation`

Column	Data type
`worker_id`	`string`
`position_id`	`string`
`workers_compensation_code`	`string`

`worker_position_end_employment_reason`

Column	Data type
`worker_id`	`string`
`position_id`	`string`
`end_employment_reason`	`string`
`end_employment_date`	`date`

`worker_position_job_classification`

Column	Data type
`worker_id`	`string`
`position_id`	`string`
`job_classification_id`	`string`
`job_group_code`	`string`

`worker_position_manager`

Column	Data type
`worker_id`	`string`
`position_id`	`string`
`manager_id`	`array<string>`

`worker_position_organization`

Column	Data type
`worker_id`	`string`
`position_id`	`string`
`organization_id`	`string`
`organization_type_id`	`string`
`organization_type_code`	`string`
`organization_name`	`string`
`date_of_pay_group_assignment`	`date`
`primary_business_site`	`string`
`used_in_change_organization_assignments`	`boolean`
`index`	`int`

Column	Data type
`worker_id`	`string`
`position_id`	`string`
`organization_id`	`string`
`organization_type_id`	`string`
`organization_type_code`	`string`
`organization_name`	`string`
`date_of_pay_group_assignment`	`date`
`primary_business_site`	`string`
`used_in_change_organization_assignments`	`boolean`
`index`	`int`

`worker_position_payroll_reporting_code`

Column	Data type
`worker_id`	`string`
`position_id`	`string`
`payroll_reporting_id`	`string`
`payroll_reporting_code`	`string`
`formatted_code`	`string`
`payroll_reporting_type`	`string`

`worker_positions`

Column	Data type
`worker_id`	`string`
`position_id`	`string`
`position_title`	`string`
`business_title`	`string`
`start_date`	`date`
`end_date`	`date`
`end_employment_date`	`date`
`pay_through_date`	`date`
`position_effective_date`	`date`
`is_primary_job`	`boolean`
`worker_type`	`string`
`worker_type_descriptor`	`string`
`position_time_type`	`string`
`job_exempt`	`boolean`
`exclude_from_headcount`	`boolean`
`headcount_id`	`string`
`job_profile_id`	`string`
`job_profile_name`	`string`
`job_family_id`	`array<string>`
`management_level_id`	`string`
`management_level_descriptor`	`string`
`job_category_id`	`string`
`work_shift_required`	`boolean`
`critical_job`	`boolean`
`difficulty_to_fill`	`string`
`scheduled_weekly_hours`	`decimal(5,2)`
`default_weekly_hours`	`decimal(5,2)`
`full_time_equivalent_percentage`	`decimal(12,2)`
`paid_fte`	`decimal(22,12)`
`working_fte`	`decimal(22,12)`
`specify_paid_fte`	`boolean`
`specify_working_fte`	`boolean`
`working_time_value`	`decimal(6,2)`
`working_time_frequency`	`string`
`working_time_unit`	`string`
`work_shift`	`string`
`work_hours_profile`	`string`
`worker_hours_profile_classification`	`string`
`regular_paid_equivalent_hours`	`decimal(5,2)`
`work_space`	`string`
`payroll_effective_date`	`date`
`pay_rate_type`	`string`
`pay_group`	`string`
`payroll_entity`	`string`
`employee_type`	`string`
`payroll_file_number`	`string`
`pay_frequency`	`string`
`federal_withholding_fein`	`string`
`business_site_name`	`string`
`location_id`	`string`
`time_profile`	`string`
`international_assignment_type`	`string`
`position_home_country`	`string`
`host_country`	`string`
`expected_assignment_end_date`	`date`
`start_international_assignment_reason`	`string`

Column	Data type
`worker_id`	`string`
`position_id`	`string`
`position_title`	`string`
`business_title`	`string`
`start_date`	`date`
`end_date`	`date`
`end_employment_date`	`date`
`pay_through_date`	`date`
`position_effective_date`	`date`
`is_primary_job`	`boolean`
`worker_type`	`string`
`worker_type_descriptor`	`string`
`position_time_type`	`string`
`job_exempt`	`boolean`
`exclude_from_headcount`	`boolean`
`headcount_id`	`string`
`job_profile_id`	`string`
`job_profile_name`	`string`
`job_family_id`	`array<string>`
`management_level_id`	`string`
`management_level_descriptor`	`string`
`job_category_id`	`string`
`work_shift_required`	`boolean`
`critical_job`	`boolean`
`difficulty_to_fill`	`string`
`scheduled_weekly_hours`	`decimal(5,2)`
`default_weekly_hours`	`decimal(5,2)`
`full_time_equivalent_percentage`	`decimal(12,2)`
`paid_fte`	`decimal(22,12)`
`working_fte`	`decimal(22,12)`
`specify_paid_fte`	`boolean`
`specify_working_fte`	`boolean`
`working_time_value`	`decimal(6,2)`
`working_time_frequency`	`string`
`working_time_unit`	`string`
`work_shift`	`string`
`work_hours_profile`	`string`
`worker_hours_profile_classification`	`string`
`regular_paid_equivalent_hours`	`decimal(5,2)`
`work_space`	`string`
`payroll_effective_date`	`date`
`pay_rate_type`	`string`
`pay_group`	`string`
`payroll_entity`	`string`
`employee_type`	`string`
`payroll_file_number`	`string`
`pay_frequency`	`string`
`federal_withholding_fein`	`string`
`business_site_name`	`string`
`location_id`	`string`
`time_profile`	`string`
`international_assignment_type`	`string`
`position_home_country`	`string`
`host_country`	`string`
`expected_assignment_end_date`	`date`
`start_international_assignment_reason`	`string`

`worker_probation_period`

Column	Data type
`worker_id`	`string`
`position_id`	`string`
`probation_period_id`	`string`
`employee_probation_period_code`	`string`
`effective_date`	`date`
`start_date`	`date`
`end_date`	`date`
`extended_end_date`	`date`
`probation_reason`	`string`
`probation_type`	`string`
`note`	`string`

Column	Data type
`worker_id`	`string`
`position_id`	`string`
`probation_period_id`	`string`
`employee_probation_period_code`	`string`
`effective_date`	`date`
`start_date`	`date`
`end_date`	`date`
`extended_end_date`	`date`
`probation_reason`	`string`
`probation_type`	`string`
`note`	`string`

`worker_secondary_termination_reason`

Column	Data type
`worker_id`	`string`
`secondary_reason`	`string`
`reason_category`	`string`
`index`	`int`

`workers`

Column	Data type
`academic_tenure_date`	`date`
`active`	`boolean`
`active_status_date`	`date`
`benefits_service_date`	`date`
`company_service_date`	`date`
`continuous_service_date`	`date`
`date_entered_workforce`	`date`
`days_unemployed`	`decimal(12,0)`
`eligible_for_hire`	`string`
`eligible_for_rehire_on_latest_termination`	`string`
`expected_date_of_return`	`date`
`expected_retirement_date`	`date`
`first_day_of_work`	`date`
`has_international_assignment`	`boolean`
`hire_date`	`date`
`hire_reason`	`string`
`hire_rescinded`	`boolean`
`home_country`	`string`
`months_continuous_prior_employment`	`decimal(14,2)`
`not_returning`	`boolean`
`original_hire_date`	`date`
`pay_through_date`	`date`
`probation_end_date`	`date`
`probation_start_date`	`date`
`rehire`	`boolean`
`resignation_date`	`date`
`retired`	`boolean`
`retirement_date`	`date`
`return_unknown`	`boolean`
`seniority_date`	`date`
`severance_date`	`date`
`time_off_service_date`	`date`
`vesting_date`	`date`
`compensation_grade_ids`	`array<string>`
`compensation_grade_profile_ids`	`array<string>`
`display_language_code`	`string`
`hour_clock_code`	`string`
`locale_code`	`string`
`preferred_language_code`	`string`
`time_zone_code`	`string`
`user_language_code`	`string`
`user_name`	`string`
`local_termination_reason`	`string`
`primary_termination_category`	`string`
`primary_termination_reason`	`string`
`regrettable_termination`	`boolean`
`terminated`	`boolean`
`termination_date`	`date`
`termination_involuntary`	`boolean`
`termination_last_day_of_work`	`date`
`id`	`string`
`universal_id`	`string`
`user_id`	`string`

Column	Data type
`academic_tenure_date`	`date`
`active`	`boolean`
`active_status_date`	`date`
`benefits_service_date`	`date`
`company_service_date`	`date`
`continuous_service_date`	`date`
`date_entered_workforce`	`date`
`days_unemployed`	`decimal(12,0)`
`eligible_for_hire`	`string`
`eligible_for_rehire_on_latest_termination`	`string`
`expected_date_of_return`	`date`
`expected_retirement_date`	`date`
`first_day_of_work`	`date`
`has_international_assignment`	`boolean`
`hire_date`	`date`
`hire_reason`	`string`
`hire_rescinded`	`boolean`
`home_country`	`string`
`months_continuous_prior_employment`	`decimal(14,2)`
`not_returning`	`boolean`
`original_hire_date`	`date`
`pay_through_date`	`date`
`probation_end_date`	`date`
`probation_start_date`	`date`
`rehire`	`boolean`
`resignation_date`	`date`
`retired`	`boolean`
`retirement_date`	`date`
`return_unknown`	`boolean`
`seniority_date`	`date`
`severance_date`	`date`
`time_off_service_date`	`date`
`vesting_date`	`date`
`compensation_grade_ids`	`array<string>`
`compensation_grade_profile_ids`	`array<string>`
`display_language_code`	`string`
`hour_clock_code`	`string`
`locale_code`	`string`
`preferred_language_code`	`string`
`time_zone_code`	`string`
`user_language_code`	`string`
`user_name`	`string`
`local_termination_reason`	`string`
`primary_termination_category`	`string`
`primary_termination_reason`	`string`
`regrettable_termination`	`boolean`
`terminated`	`boolean`
`termination_date`	`date`
`termination_involuntary`	`boolean`
`termination_last_day_of_work`	`date`
`id`	`string`
`universal_id`	`string`
`user_id`	`string`

Ethnicities

Ingestion mode: Full refresh

Destination tables: 1

`ethnicity`

Column	Data type
`id`	`string`
`ethnicity_id`	`string`
`name`	`string`
`code`	`string`
`description`	`string`
`inactive`	`boolean`
`location_id`	`string`
`ethnicity_mapping_id`	`string`

Gender identities

Ingestion mode: Full refresh

Destination tables: 1

`gender_identity`

Column	Data type
`id`	`string`
`gender_identity_id`	`string`
`order`	`string`
`name`	`string`
`code`	`string`
`description`	`string`
`inactive`	`boolean`

LGBT identifications

Ingestion mode: Full refresh

Destination tables: 1

`lgbt_identification`

Column	Data type
`id`	`string`
`lgbt_identification_id`	`string`
`name`	`string`
`description`	`string`
`inactive`	`boolean`
`location_id`	`string`

Pronouns

Ingestion mode: Full refresh

Destination tables: 1

`pronoun`

Column	Data type
`id`	`string`
`pronoun_id`	`string`
`order`	`string`
`name`	`string`
`code`	`string`
`description`	`string`
`inactive`	`boolean`

Sexual orientations

Ingestion mode: Full refresh

Destination tables: 1

`sexual_orientation`

Column	Data type
`id`	`string`
`sexual_orientation_id`	`string`
`name`	`string`
`code`	`string`
`description`	`string`
`inactive`	`boolean`

Organizations

Ingestion mode: Full refresh

Destination tables: 5

`organization`

Column	Data type
`id`	`string`
`organization_code`	`string`
`name`	`string`
`description`	`string`
`include_manager_in_name`	`boolean`
`include_organization_code_in_name`	`boolean`
`type`	`string`
`sub_type`	`string`
`availability_date`	`timestamp`
`last_updated_date_time`	`timestamp`
`inactive`	`boolean`
`inactive_date`	`date`
`manager_id`	`string`
`organization_owner_id`	`string`
`visibility`	`string`
`external_url`	`string`
`top_level_organization_id`	`string`
`superior_organization_id`	`string`
`staffing_model`	`string`
`location`	`string`
`available_for_hire`	`boolean`
`hiring_freeze`	`boolean`
`supervisory_position_availability_date`	`date`
`supervisory_position_earliest_hire_date`	`date`
`supervisory_position_worker_type`	`string`
`supervisory_position_time_type`	`string`
`code`	`string`

Column	Data type
`id`	`string`
`organization_code`	`string`
`name`	`string`
`description`	`string`
`include_manager_in_name`	`boolean`
`include_organization_code_in_name`	`boolean`
`type`	`string`
`sub_type`	`string`
`availability_date`	`timestamp`
`last_updated_date_time`	`timestamp`
`inactive`	`boolean`
`inactive_date`	`date`
`manager_id`	`string`
`organization_owner_id`	`string`
`visibility`	`string`
`external_url`	`string`
`top_level_organization_id`	`string`
`superior_organization_id`	`string`
`staffing_model`	`string`
`location`	`string`
`available_for_hire`	`boolean`
`hiring_freeze`	`boolean`
`supervisory_position_availability_date`	`date`
`supervisory_position_earliest_hire_date`	`date`
`supervisory_position_worker_type`	`string`
`supervisory_position_time_type`	`string`
`code`	`string`

`organization_assignment`

Column	Data type
`organization_id`	`string`
`reference_organization_id`	`string`
`reference_organization_type`	`string`

`organization_leader`

Column	Data type
`organization_id`	`string`
`organization_manager_id`	`string`

`organization_role`

Column	Data type
`organization_id`	`string`
`role_id`	`string`
`organization_role_code`	`string`

`organization_role_worker`

Column	Data type
`organization_id`	`string`
`role_id`	`string`
`associated_worker_id`	`string`

Job profiles

Ingestion mode: Incremental

Destination tables: 17

`job_family_job_profile`

Column	Data type
`job_profile_id`	`string`
`job_family_id`	`string`

`job_profile`

Column	Data type
`id`	`string`
`job_profile_code`	`string`
`effective_date`	`date`
`union_code`	`string`
`union_membership_requirement`	`string`
`work_study_award_source_code`	`string`
`work_study_requirement_option_code`	`string`
`compensation_grade_id`	`string`
`title`	`string`
`private_title`	`string`
`summary`	`string`
`description`	`string`
`additional_job_description`	`string`
`inactive`	`boolean`
`include_job_code_in_name`	`boolean`
`work_shift_required`	`boolean`
`public_job`	`boolean`
`critical_job`	`boolean`
`difficulty_to_fill`	`string`
`management_level`	`string`
`job_category_id`	`string`
`level`	`string`
`referral_payment_plan`	`string`

Column	Data type
`id`	`string`
`job_profile_code`	`string`
`effective_date`	`date`
`union_code`	`string`
`union_membership_requirement`	`string`
`work_study_award_source_code`	`string`
`work_study_requirement_option_code`	`string`
`compensation_grade_id`	`string`
`title`	`string`
`private_title`	`string`
`summary`	`string`
`description`	`string`
`additional_job_description`	`string`
`inactive`	`boolean`
`include_job_code_in_name`	`boolean`
`work_shift_required`	`boolean`
`public_job`	`boolean`
`critical_job`	`boolean`
`difficulty_to_fill`	`string`
`management_level`	`string`
`job_category_id`	`string`
`level`	`string`
`referral_payment_plan`	`string`

`job_profile_certification`

Column	Data type
`job_profile_id`	`string`
`certification_code`	`string`
`name`	`string`
`issuer`	`string`
`required`	`boolean`
`country_code`	`string`
`index`	`int`

`job_profile_classification`

Column	Data type
`job_profile_id`	`string`
`job_classification_id`	`string`

`job_profile_company_insider`

Column	Data type
`job_profile_id`	`string`
`company_insider_type`	`string`
`index`	`int`

`job_profile_competency`

Column	Data type
`job_profile_id`	`string`
`competency_id`	`string`
`competency_code`	`string`
`required`	`boolean`
`proficiency_rating`	`string`

`job_profile_education`

Column	Data type
`job_profile_id`	`string`
`required`	`boolean`
`degree_code`	`string`
`field_of_study`	`string`
`index`	`int`

`job_profile_exempt`

Column	Data type
`job_profile_id`	`string`
`is_job_exempt`	`boolean`
`location_context`	`string`
`index`	`int`

`job_profile_language`

Column	Data type
`job_profile_id`	`string`
`language_id`	`string`
`language_code`	`string`
`required`	`boolean`

`job_profile_language_ability`

Column	Data type
`job_profile_id`	`string`
`language_id`	`string`
`language_ability_type_code`	`string`
`language_proficiency_code`	`string`
`index`	`int`

`job_profile_pay_rate`

Column	Data type
`job_profile_id`	`string`
`country_code`	`string`
`pay_rate_code`	`string`
`index`	`int`

`job_profile_responsibility`

Column	Data type
`job_profile_id`	`string`
`description`	`string`
`required`	`boolean`
`index`	`int`

`job_profile_restrict_to_country`

Column	Data type
`job_profile_id`	`string`
`country_id`	`string`
`country_code`	`string`

`job_profile_skill`

Column	Data type
`job_profile_id`	`string`
`skill_code`	`string`
`name`	`string`
`required`	`boolean`
`index`	`int`

`job_profile_training`

Column	Data type
`job_profile_id`	`string`
`name`	`string`
`description`	`string`
`required`	`boolean`
`training_type`	`string`
`index`	`int`

`job_profile_work_experience`

Column	Data type
`job_profile_id`	`string`
`work_experience_id`	`string`
`work_experience_code`	`string`
`required`	`boolean`
`work_experience_rating_id`	`string`
`work_experience_rating_code`	`string`

`job_profile_worker_compensation`

Column	Data type
`job_profile_id`	`string`
`worker_compensation_code`	`string`
`index`	`int`

Positions

Ingestion mode: Incremental

Destination tables: 18

`position`

Column	Data type
`id`	`string`
`supervisory_organization_id`	`string`
`effective_date`	`date`
`position_code`	`string`
`job_posting_title`	`string`
`academic_tenure_eligible`	`boolean`
`job_description_summary`	`string`
`job_description`	`string`
`available_for_hire`	`boolean`
`available_for_recruiting`	`boolean`
`hiring_freeze`	`boolean`
`work_shift_required`	`boolean`
`available_for_overlap`	`boolean`
`earliest_overlap_date`	`date`
`critical_job`	`boolean`
`difficulty_to_fill_code`	`string`
`availability_date`	`date`
`earliest_hire_date`	`date`
`worker_type_code`	`string`
`position_time_type_code`	`string`
`primary_compensation_basis`	`decimal(26,6)`
`primary_compensation_basis_amount_change`	`decimal(26,6)`
`primary_compensation_basis_percent_change`	`decimal(21,6)`
`compensation_package_code`	`string`
`compensation_grade_code`	`string`
`compensation_grade_profile_code`	`string`
`compensation_step_code`	`string`
`worker_for_filled_position_id`	`string`
`worker_position_id`	`string`
`closed`	`boolean`

Column	Data type
`id`	`string`
`supervisory_organization_id`	`string`
`effective_date`	`date`
`position_code`	`string`
`job_posting_title`	`string`
`academic_tenure_eligible`	`boolean`
`job_description_summary`	`string`
`job_description`	`string`
`available_for_hire`	`boolean`
`available_for_recruiting`	`boolean`
`hiring_freeze`	`boolean`
`work_shift_required`	`boolean`
`available_for_overlap`	`boolean`
`earliest_overlap_date`	`date`
`critical_job`	`boolean`
`difficulty_to_fill_code`	`string`
`availability_date`	`date`
`earliest_hire_date`	`date`
`worker_type_code`	`string`
`position_time_type_code`	`string`
`primary_compensation_basis`	`decimal(26,6)`
`primary_compensation_basis_amount_change`	`decimal(26,6)`
`primary_compensation_basis_percent_change`	`decimal(21,6)`
`compensation_package_code`	`string`
`compensation_grade_code`	`string`
`compensation_grade_profile_code`	`string`
`compensation_step_code`	`string`
`worker_for_filled_position_id`	`string`
`worker_position_id`	`string`
`closed`	`boolean`

`position_bonus_plan`

Column	Data type
`position_id`	`string`
`bonus_plan_id`	`string`
`individual_target_amount`	`decimal(26,6)`
`individual_target_percent`	`decimal(16,6)`
`guaranteed_minimum`	`boolean`
`percent_assigned`	`decimal(16,6)`
`bonus_plan_code`	`string`
`compensation_basis_override_amount`	`decimal(26,6)`
`inactive_date`	`date`
`fixed_for_manage_by_basis_total`	`boolean`

Column	Data type
`position_id`	`string`
`bonus_plan_id`	`string`
`individual_target_amount`	`decimal(26,6)`
`individual_target_percent`	`decimal(16,6)`
`guaranteed_minimum`	`boolean`
`percent_assigned`	`decimal(16,6)`
`bonus_plan_code`	`string`
`compensation_basis_override_amount`	`decimal(26,6)`
`inactive_date`	`date`
`fixed_for_manage_by_basis_total`	`boolean`

`position_certification`

Column	Data type
`position_id`	`string`
`id`	`string`
`certification_code`	`string`
`country`	`string`
`name`	`string`
`issuer`	`string`
`required`	`boolean`
`qualification_source`	`string`

`position_competency`

Column	Data type
`position_id`	`string`
`id`	`string`
`required`	`boolean`
`competency_code`	`string`
`proficiency_rating`	`string`
`qualification_source`	`string`

`position_education`

Column	Data type
`position_id`	`string`
`id`	`string`
`required`	`boolean`
`degree`	`string`
`field_of_study`	`string`
`qualification_source`	`string`

`position_job_family`

Column	Data type
`position_id`	`string`
`job_family_id`	`string`

`position_job_profile`

Column	Data type
`position_id`	`string`
`job_profile_id`	`string`
`name`	`string`
`management_level_code`	`string`
`management_level_descriptor`	`string`
`job_category_code`	`string`
`work_shift_required`	`boolean`
`is_critical_job`	`boolean`
`difficulty_to_fill_code`	`string`

Column	Data type
`position_id`	`string`
`job_profile_id`	`string`
`name`	`string`
`management_level_code`	`string`
`management_level_descriptor`	`string`
`job_category_code`	`string`
`work_shift_required`	`boolean`
`is_critical_job`	`boolean`
`difficulty_to_fill_code`	`string`

`position_language`

Column	Data type
`position_id`	`string`
`id`	`string`
`language_code`	`string`
`required`	`boolean`
`qualification_source`	`string`

`position_location`

Column	Data type
`position_id`	`string`
`location_id`	`string`
`location_code`	`string`

`position_merit_plan`

Column	Data type
`position_id`	`string`
`merit_plan_id`	`string`
`individual_target_percent`	`decimal(16,6)`
`guaranteed_minimum`	`boolean`
`merit_plan_code`	`string`
`individual_target_amount`	`decimal(26,6)`
`actual_end_date`	`date`

`position_organization`

Column	Data type
`position_id`	`string`
`organization_id`	`string`
`type`	`string`

`position_pay_plan`

Column	Data type
`position_id`	`string`
`pay_plan_id`	`string`
`pay_plan_code`	`string`
`amount`	`decimal(26,6)`
`percent_change`	`decimal(21,6)`
`amount_change`	`decimal(26,6)`
`currency_code`	`string`
`frequency_code`	`string`
`expected_end_date`	`date`
`actual_end_date`	`date`

Column	Data type
`position_id`	`string`
`pay_plan_id`	`string`
`pay_plan_code`	`string`
`amount`	`decimal(26,6)`
`percent_change`	`decimal(21,6)`
`amount_change`	`decimal(26,6)`
`currency_code`	`string`
`frequency_code`	`string`
`expected_end_date`	`date`
`actual_end_date`	`date`

`position_responsibility`

Column	Data type
`position_id`	`string`
`id`	`string`
`responsibility`	`string`
`required`	`boolean`
`qualification_source`	`string`

`position_skill`

Column	Data type
`position_id`	`string`
`id`	`string`
`skill_code`	`string`
`name`	`string`
`required`	`boolean`
`qualification_source`	`string`

`position_stock_plan`

Column	Data type
`position_id`	`string`
`stock_plan_id`	`string`
`stock_plan_code`	`string`
`individual_target_shares`	`decimal(21,6)`
`individual_target_percent`	`decimal(18,6)`
`individual_target_amount`	`decimal(26,6)`
`currency_code`	`string`
`compensation_basis_override_amount`	`decimal(26,6)`
`actual_end_date`	`date`
`fixed_for_manage_by_basis_total`	`boolean`

Column	Data type
`position_id`	`string`
`stock_plan_id`	`string`
`stock_plan_code`	`string`
`individual_target_shares`	`decimal(21,6)`
`individual_target_percent`	`decimal(18,6)`
`individual_target_amount`	`decimal(26,6)`
`currency_code`	`string`
`compensation_basis_override_amount`	`decimal(26,6)`
`actual_end_date`	`date`
`fixed_for_manage_by_basis_total`	`boolean`

`position_training`

Column	Data type
`position_id`	`string`
`id`	`string`
`name`	`string`
`description`	`string`
`required`	`boolean`
`training_type`	`string`
`qualification_source`	`string`

`position_work_experience`

Column	Data type
`position_id`	`string`
`id`	`string`
`work_experience_code`	`string`
`required`	`boolean`
`work_experience_rating`	`string`
`qualification_source`	`string`

`position_worker_type_restriction`

Column	Data type
`position_id`	`string`
`worker_type_id`	`string`
`worker_type_code`	`string`

Candidates

Ingestion mode: Full refresh

Destination tables: 10

`candidate`

Column	Data type
`id`	`string`
`candidate_code`	`string`
`pre_hire_id`	`string`
`worker_id`	`string`
`phone_device_type_code`	`string`
`phone_country_code`	`string`
`phone_number`	`string`
`phone_extension`	`string`
`email_address`	`string`
`country_code`	`string`
`address_line_1`	`string`
`address_line_2`	`string`
`address_line_3`	`string`
`address_line_4`	`string`
`address_line_5`	`string`
`address_line_6`	`string`
`address_line_7`	`string`
`address_line_8`	`string`
`address_line_9`	`string`
`address_line_1_local`	`string`
`address_line_2_local`	`string`
`address_line_3_local`	`string`
`address_line_4_local`	`string`
`address_line_5_local`	`string`
`address_line_6_local`	`string`
`city_code`	`string`
`country_region_code`	`string`
`region_subdivision_1`	`string`
`region_subdivision_2`	`string`
`region_subdivision_1_local`	`string`
`postal_code`	`string`
`do_not_hire`	`boolean`
`withdrawn`	`boolean`
`prospect`	`boolean`
`confidential`	`boolean`
`referral_consent_given`	`boolean`
`management_level_code`	`string`
`prospect_status_code`	`string`
`prospect_type_code`	`string`
`applicant_source`	`string`
`referred_by_worker_id`	`string`
`added_by_worker_id`	`string`
`candidate_owner_worker_id`	`string`
`ownership_start_date`	`timestamp`
`ownership_end_date`	`timestamp`
`user_language_code`	`string`

Column	Data type
`id`	`string`
`candidate_code`	`string`
`pre_hire_id`	`string`
`worker_id`	`string`
`phone_device_type_code`	`string`
`phone_country_code`	`string`
`phone_number`	`string`
`phone_extension`	`string`
`email_address`	`string`
`country_code`	`string`
`address_line_1`	`string`
`address_line_2`	`string`
`address_line_3`	`string`
`address_line_4`	`string`
`address_line_5`	`string`
`address_line_6`	`string`
`address_line_7`	`string`
`address_line_8`	`string`
`address_line_9`	`string`
`address_line_1_local`	`string`
`address_line_2_local`	`string`
`address_line_3_local`	`string`
`address_line_4_local`	`string`
`address_line_5_local`	`string`
`address_line_6_local`	`string`
`city_code`	`string`
`country_region_code`	`string`
`region_subdivision_1`	`string`
`region_subdivision_2`	`string`
`region_subdivision_1_local`	`string`
`postal_code`	`string`
`do_not_hire`	`boolean`
`withdrawn`	`boolean`
`prospect`	`boolean`
`confidential`	`boolean`
`referral_consent_given`	`boolean`
`management_level_code`	`string`
`prospect_status_code`	`string`
`prospect_type_code`	`string`
`applicant_source`	`string`
`referred_by_worker_id`	`string`
`added_by_worker_id`	`string`
`candidate_owner_worker_id`	`string`
`ownership_start_date`	`timestamp`
`ownership_end_date`	`timestamp`
`user_language_code`	`string`

`candidate_certification`

Column	Data type
`job_application_id`	`string`
`certification_code`	`string`
`removed`	`boolean`
`country`	`string`
`certification_number`	`string`
`exam_date`	`date`
`exam_score`	`string`
`issued_date`	`date`
`expiration_date`	`date`
`index`	`int`

`candidate_education`

Column	Data type
`job_application_id`	`string`
`school_code`	`string`
`school_name`	`string`
`first_year_attended`	`decimal(4,0)`
`last_year_attended`	`decimal(4,0)`
`degree_code`	`string`
`field_of_study_code`	`string`
`grade_average`	`string`
`index`	`int`

Column	Data type
`job_application_id`	`string`
`school_code`	`string`
`school_name`	`string`
`first_year_attended`	`decimal(4,0)`
`last_year_attended`	`decimal(4,0)`
`degree_code`	`string`
`field_of_study_code`	`string`
`grade_average`	`string`
`index`	`int`

`candidate_experience`

Column	Data type
`job_application_id`	`string`
`company_code`	`string`
`company_name`	`string`
`title`	`string`
`location`	`string`
`start_month`	`decimal(2,0)`
`start_year`	`decimal(4,0)`
`end_month`	`decimal(2,0)`
`end_year`	`decimal(4,0)`
`currently_work_here`	`boolean`
`description`	`string`
`index`	`int`

Column	Data type
`job_application_id`	`string`
`company_code`	`string`
`company_name`	`string`
`title`	`string`
`location`	`string`
`start_month`	`decimal(2,0)`
`start_year`	`decimal(4,0)`
`end_month`	`decimal(2,0)`
`end_year`	`decimal(4,0)`
`currently_work_here`	`boolean`
`description`	`string`
`index`	`int`

`candidate_language`

Column	Data type
`job_application_id`	`string`
`language_code`	`string`
`index`	`int`

`candidate_name`

Column	Data type
`candidate_id`	`string`
`title`	`string`
`salutation_suffix`	`string`
`first_name`	`string`
`middle_name`	`string`
`hereditary_suffix`	`string`
`last_name`	`string`
`secondary_last_name`	`string`
`tertiary_last_name`	`string`
`social_suffix`	`string`
`local_first_name`	`string`
`local_middle_name`	`string`
`local_last_name`	`string`
`local_secondary_last_name`	`string`
`type`	`string`

Column	Data type
`candidate_id`	`string`
`title`	`string`
`salutation_suffix`	`string`
`first_name`	`string`
`middle_name`	`string`
`hereditary_suffix`	`string`
`last_name`	`string`
`secondary_last_name`	`string`
`tertiary_last_name`	`string`
`social_suffix`	`string`
`local_first_name`	`string`
`local_middle_name`	`string`
`local_last_name`	`string`
`local_secondary_last_name`	`string`
`type`	`string`

`candidate_pool_membership`

Column	Data type
`candidate_id`	`string`
`candidate_pool_id`	`string`
`candidate_pool_code`	`string`
`readiness_status_id`	`string`
`readiness_status_code`	`string`

`candidate_skill`

Column	Data type
`job_application_id`	`string`
`skill_code`	`string`
`skill_name`	`string`
`index`	`int`

`candidate_tag`

Column	Data type
`candidate_id`	`string`
`tag_code`	`string`
`index`	`int`

`candidate_website`

Column	Data type
`candidate_id`	`string`
`url`	`string`
`index`	`int`

Questionnaires

Ingestion mode: Full refresh

Destination tables: 2

`questionnaire`

Column	Data type
`id`	`string`
`questionnaire_code`	`string`
`name`	`string`
`display_name`	`string`
`instructions`	`string`
`inactive`	`boolean`

`questionnaire_setup`

Column	Data type
`questionnaire_id`	`string`
`questionnaire_setup_id`	`string`
`question_description`	`string`
`order`	`string`
`required`	`boolean`

Interviews

Ingestion mode: Full refresh

Destination tables: 6

`interview`

Column	Data type
`id`	`string`
`overall_comment`	`string`
`time_zone_code`	`string`

`interview_competency`

Column	Data type
`interview_session_detail_id`	`int`
`interview_session_id`	`string`
`competency_id`	`string`
`competency_code`	`string`

`interview_questionnaire`

Column	Data type
`interview_session_detail_id`	`int`
`interview_session_id`	`string`
`questionnaire_id`	`string`

`interview_session`

Column	Data type
`interview_id`	`string`
`interview_session_id`	`string`
`interview_session_code`	`string`

`interview_session_detail`

Column	Data type
`interview_session_id`	`string`
`interview_start_time`	`timestamp`
`interview_end_time`	`timestamp`
`location_code`	`string`
`interview_type_code`	`string`
`comment`	`string`
`index`	`int`

`interviewer`

Column	Data type
`interview_session_detail_id`	`int`
`interview_session_id`	`string`
`interviewer_id`	`string`

External reference

Ingestion mode: Full refresh

Destination tables: 3

`external_reference_line`

Column	Data type
`id`	`string`
`job_application_id`	`string`
`candidate_id`	`string`
`job_requisition_id`	`string`

`external_reference_participant`

Column	Data type
`external_reference_id`	`string`
`referee_id`	`string`
`referee_code`	`string`
`questionnaire_id`	`string`

`questionnaire_answer`

Column	Data type
`reference_id`	`string`
`question_order`	`string`
`date`	`date`
`answer_numeric`	`decimal(12,0)`
`answer_text`	`string`
`index`	`int`

Job requisitions

Ingestion mode: Incremental

Destination tables: 28

`job_requisition`

Column	Data type
`id`	`string`
`status_code`	`string`
`job_posting_title`	`string`
`positions_allocated`	`decimal(7,0)`
`positions_available`	`decimal(7,0)`
`academic_tenure_eligible`	`boolean`
`job_description_summary`	`string`
`job_description`	`string`
`additional_job_description`	`string`
`justification`	`string`
`recruiting_instruction_code`	`string`
`do_not_send_to_recruiting_system`	`boolean`
`available_for_recruiting`	`boolean`
`replacement_for_worker_id`	`string`
`confidential_job_requisition`	`boolean`
`job_application_template_code`	`string`
`recruiting_start_date`	`date`
`target_hire_date`	`date`
`target_end_date`	`date`
`job_profile_id`	`string`
`worker_type_code`	`string`
`position_worker_type_code`	`string`
`remote_type_code`	`string`
`primary_location_code`	`string`
`primary_job_posting_location_code`	`string`
`position_time_type_code`	`string`
`employee_contract_type_code`	`string`
`scheduled_weekly_hours`	`decimal(14,2)`
`work_shift_code`	`string`
`spotlight_job`	`boolean`
`referral_payment_plan_code`	`string`
`internal_career_site_questionnaire_id`	`string`
`internal_career_site_secondary_questionnaire_id`	`string`
`external_career_sites_questionnaire_id`	`string`
`external_career_site_secondary_questionnaire_id`	`string`
`inline_assessment_test_code`	`string`
`supervisory_organization_id`	`string`
`job_requisition_code`	`string`
`is_evergreen_job_requisition`	`boolean`

Column	Data type
`id`	`string`
`status_code`	`string`
`job_posting_title`	`string`
`positions_allocated`	`decimal(7,0)`
`positions_available`	`decimal(7,0)`
`academic_tenure_eligible`	`boolean`
`job_description_summary`	`string`
`job_description`	`string`
`additional_job_description`	`string`
`justification`	`string`
`recruiting_instruction_code`	`string`
`do_not_send_to_recruiting_system`	`boolean`
`available_for_recruiting`	`boolean`
`replacement_for_worker_id`	`string`
`confidential_job_requisition`	`boolean`
`job_application_template_code`	`string`
`recruiting_start_date`	`date`
`target_hire_date`	`date`
`target_end_date`	`date`
`job_profile_id`	`string`
`worker_type_code`	`string`
`position_worker_type_code`	`string`
`remote_type_code`	`string`
`primary_location_code`	`string`
`primary_job_posting_location_code`	`string`
`position_time_type_code`	`string`
`employee_contract_type_code`	`string`
`scheduled_weekly_hours`	`decimal(14,2)`
`work_shift_code`	`string`
`spotlight_job`	`boolean`
`referral_payment_plan_code`	`string`
`internal_career_site_questionnaire_id`	`string`
`internal_career_site_secondary_questionnaire_id`	`string`
`external_career_sites_questionnaire_id`	`string`
`external_career_site_secondary_questionnaire_id`	`string`
`inline_assessment_test_code`	`string`
`supervisory_organization_id`	`string`
`job_requisition_code`	`string`
`is_evergreen_job_requisition`	`boolean`

`job_requisition_additional_job_posting_location`

Column	Data type
`job_requisition_id`	`string`
`location_id`	`string`
`location_code`	`string`

`job_requisition_additional_job_profile`

Column	Data type
`job_requisition_id`	`string`
`job_profile_id`	`string`

`job_requisition_additional_location`

Column	Data type
`job_requisition_id`	`string`
`location_id`	`string`
`location_code`	`string`

`job_requisition_allowance_plan`

Column	Data type
`job_requisition_compensation_id`	`int`
`job_requisition_id`	`string`
`allowance_plan_id`	`string`
`allowance_plan_code`	`string`
`percent`	`decimal(20,10)`
`amount`	`decimal(26,6)`
`compensation_basis_override_amount`	`decimal(26,6)`
`currency_code`	`string`
`frequency_code`	`string`
`actual_end_date`	`date`
`reimbursement_start_date`	`date`
`fixed_for_manage_by_basis_total`	`boolean`

Column	Data type
`job_requisition_compensation_id`	`int`
`job_requisition_id`	`string`
`allowance_plan_id`	`string`
`allowance_plan_code`	`string`
`percent`	`decimal(20,10)`
`amount`	`decimal(26,6)`
`compensation_basis_override_amount`	`decimal(26,6)`
`currency_code`	`string`
`frequency_code`	`string`
`actual_end_date`	`date`
`reimbursement_start_date`	`date`
`fixed_for_manage_by_basis_total`	`boolean`

`job_requisition_bonus_plan`

Column	Data type
`job_requisition_compensation_id`	`int`
`job_requisition_id`	`string`
`bonus_plan_id`	`string`
`bonus_plan_code`	`string`
`individual_target_amount`	`decimal(26,6)`
`individual_target_percent`	`decimal(16,6)`
`compensation_basis_override_amount`	`decimal(26,6)`
`guaranteed_minimum`	`boolean`
`percent_assigned`	`decimal(16,6)`
`inactive_date`	`date`
`fixed_for_manage_by_basis_total`	`boolean`

Column	Data type
`job_requisition_compensation_id`	`int`
`job_requisition_id`	`string`
`bonus_plan_id`	`string`
`bonus_plan_code`	`string`
`individual_target_amount`	`decimal(26,6)`
`individual_target_percent`	`decimal(16,6)`
`compensation_basis_override_amount`	`decimal(26,6)`
`guaranteed_minimum`	`boolean`
`percent_assigned`	`decimal(16,6)`
`inactive_date`	`date`
`fixed_for_manage_by_basis_total`	`boolean`

`job_requisition_calculated_plan`

Column	Data type
`job_requisition_compensation_id`	`int`
`job_requisition_id`	`string`
`calculated_plan_id`	`string`
`calculated_plan_code`	`string`
`amount_override`	`decimal(26,6)`
`currency_code`	`string`
`frequency_code`	`string`
`actual_end_date`	`date`

Column	Data type
`job_requisition_compensation_id`	`int`
`job_requisition_id`	`string`
`calculated_plan_id`	`string`
`calculated_plan_code`	`string`
`amount_override`	`decimal(26,6)`
`currency_code`	`string`
`frequency_code`	`string`
`actual_end_date`	`date`

`job_requisition_certification`

Column	Data type
`job_requisition_id`	`string`
`id`	`string`
`certification_code`	`string`
`country`	`string`
`name`	`string`
`issuer`	`string`
`required`	`boolean`
`qualification_source`	`string`

`job_requisition_commission_plan`

Column	Data type
`job_requisition_compensation_id`	`int`
`job_requisition_id`	`string`
`commission_plan_id`	`string`
`commission_plan_code`	`string`
`target_amount`	`decimal(26,6)`
`currency_code`	`string`
`frequency_code`	`string`
`draw_amount`	`decimal(21,6)`
`draw_frequency_code`	`string`
`draw_duration`	`string`
`recoverable`	`boolean`
`actual_end_date`	`date`
`fixed_for_manage_by_basis_total`	`boolean`

Column	Data type
`job_requisition_compensation_id`	`int`
`job_requisition_id`	`string`
`commission_plan_id`	`string`
`commission_plan_code`	`string`
`target_amount`	`decimal(26,6)`
`currency_code`	`string`
`frequency_code`	`string`
`draw_amount`	`decimal(21,6)`
`draw_frequency_code`	`string`
`draw_duration`	`string`
`recoverable`	`boolean`
`actual_end_date`	`date`
`fixed_for_manage_by_basis_total`	`boolean`

`job_requisition_compensation`

Column	Data type
`job_requisition_id`	`string`
`primary_compensation_basis`	`decimal(26,6)`
`primary_compensation_basis_amount_change`	`decimal(26,6)`
`primary_compensation_basis_percent_change`	`decimal(21,6)`
`compensation_package_code`	`string`
`compensation_grade_id`	`string`
`compensation_grade_profile_id`	`string`
`compensation_step_code`	`string`
`index`	`int`

Column	Data type
`job_requisition_id`	`string`
`primary_compensation_basis`	`decimal(26,6)`
`primary_compensation_basis_amount_change`	`decimal(26,6)`
`primary_compensation_basis_percent_change`	`decimal(21,6)`
`compensation_package_code`	`string`
`compensation_grade_id`	`string`
`compensation_grade_profile_id`	`string`
`compensation_step_code`	`string`
`index`	`int`

`job_requisition_competency`

Column	Data type
`job_requisition_id`	`string`
`id`	`string`
`required`	`boolean`
`competency_code`	`string`
`proficiency_rating`	`string`
`qualification_source`	`string`

`job_requisition_custom_organization`

Column	Data type
`job_requisition_id`	`string`
`custom_organization_id`	`string`

`job_requisition_default_assessment_test`

Column	Data type
`job_requisition_id`	`string`
`id`	`string`
`default_assessment_test_code`	`string`

`job_requisition_education`

Column	Data type
`job_requisition_id`	`string`
`id`	`string`
`required`	`boolean`
`degree`	`string`
`field_of_study`	`string`
`qualification_source`	`string`

`job_requisition_language`

Column	Data type
`job_requisition_id`	`string`
`id`	`string`
`language_code`	`string`
`required`	`boolean`
`qualification_source`	`string`

`job_requisition_language_ability`

Column	Data type
`job_requisition_language_id`	`string`
`language_ability_type`	`string`
`language_proficiency`	`string`
`index`	`int`

`job_requisition_merit_plan`

Column	Data type
`job_requisition_compensation_id`	`int`
`job_requisition_id`	`string`
`merit_plan_id`	`string`
`merit_plan_code`	`string`
`individual_target_amount`	`decimal(26,6)`
`individual_target_percent`	`decimal(16,6)`
`guaranteed_minimum`	`boolean`
`actual_end_date`	`date`

Column	Data type
`job_requisition_compensation_id`	`int`
`job_requisition_id`	`string`
`merit_plan_id`	`string`
`merit_plan_code`	`string`
`individual_target_amount`	`decimal(26,6)`
`individual_target_percent`	`decimal(16,6)`
`guaranteed_minimum`	`boolean`
`actual_end_date`	`date`

`job_requisition_organization`

Column	Data type
`job_requisition_id`	`string`
`company_id`	`string`
`cost_center_id`	`string`
`region_id`	`string`
`business_unit_code`	`string`
`grant_code`	`string`
`program_code`	`string`
`fund_code`	`string`
`gift_code`	`string`
`index`	`int`

`job_requisition_pay_plan`

Column	Data type
`job_requisition_compensation_id`	`int`
`job_requisition_id`	`string`
`pay_plan_id`	`string`
`pay_plan_code`	`string`
`amount`	`decimal(26,6)`
`percent_change`	`decimal(21,6)`
`amount_change`	`decimal(26,6)`
`currency_code`	`string`
`frequency_code`	`string`
`expected_end_date`	`date`
`actual_end_date`	`date`

Column	Data type
`job_requisition_compensation_id`	`int`
`job_requisition_id`	`string`
`pay_plan_id`	`string`
`pay_plan_code`	`string`
`amount`	`decimal(26,6)`
`percent_change`	`decimal(21,6)`
`amount_change`	`decimal(26,6)`
`currency_code`	`string`
`frequency_code`	`string`
`expected_end_date`	`date`
`actual_end_date`	`date`

`job_requisition_period_salary_plan`

Column	Data type
`job_requisition_compensation_id`	`int`
`job_requisition_id`	`string`
`period_salary_plan_id`	`string`
`period_salary_plan_code`	`string`
`compensation_period_code`	`string`
`compensation_basis_override_amount`	`decimal(26,6)`
`currency_code`	`string`
`compensation_period_multiplier`	`decimal(18,6)`
`frequency_code`	`string`
`actual_end_date`	`date`

Column	Data type
`job_requisition_compensation_id`	`int`
`job_requisition_id`	`string`
`period_salary_plan_id`	`string`
`period_salary_plan_code`	`string`
`compensation_period_code`	`string`
`compensation_basis_override_amount`	`decimal(26,6)`
`currency_code`	`string`
`compensation_period_multiplier`	`decimal(18,6)`
`frequency_code`	`string`
`actual_end_date`	`date`

`job_requisition_position`

Column	Data type
`job_requisition_id`	`string`
`position_id`	`string`

`job_requisition_responsibility`

Column	Data type
`job_requisition_id`	`string`
`id`	`string`
`responsibility`	`string`
`required`	`boolean`
`qualification_source`	`string`

`job_requisition_skill`

Column	Data type
`job_requisition_id`	`string`
`id`	`string`
`skill_code`	`string`
`name`	`string`
`required`	`boolean`
`qualification_source`	`string`

`job_requisition_stock_plan`

Column	Data type
`job_requisition_compensation_id`	`int`
`job_requisition_id`	`string`
`stock_plan_id`	`string`
`stock_plan_code`	`string`
`individual_target_shares`	`decimal(21,6)`
`individual_target_percent`	`decimal(18,6)`
`individual_target_amount`	`decimal(26,6)`
`compensation_basis_override_amount`	`decimal(26,6)`
`currency_code`	`string`
`actual_end_date`	`date`
`fixed_for_manage_by_basis_total`	`boolean`

Column	Data type
`job_requisition_compensation_id`	`int`
`job_requisition_id`	`string`
`stock_plan_id`	`string`
`stock_plan_code`	`string`
`individual_target_shares`	`decimal(21,6)`
`individual_target_percent`	`decimal(18,6)`
`individual_target_amount`	`decimal(26,6)`
`compensation_basis_override_amount`	`decimal(26,6)`
`currency_code`	`string`
`actual_end_date`	`date`
`fixed_for_manage_by_basis_total`	`boolean`

`job_requisition_training`

Column	Data type
`job_requisition_id`	`string`
`id`	`string`
`name`	`string`
`description`	`string`
`required`	`boolean`
`training_type`	`string`
`qualification_source`	`string`

`job_requisition_unit_allowance_plan`

Column	Data type
`job_requisition_compensation_id`	`int`
`job_requisition_id`	`string`
`unit_allowance_plan_id`	`string`
`unit_allowance_plan_code`	`string`
`number_of_units`	`decimal(21,6)`
`per_unit_amount`	`decimal(26,6)`
`currency_code`	`string`
`frequency_code`	`string`
`actual_end_date`	`date`
`reimbursement_start_date`	`date`
`fixed_for_manage_by_basis_total`	`boolean`

Column	Data type
`job_requisition_compensation_id`	`int`
`job_requisition_id`	`string`
`unit_allowance_plan_id`	`string`
`unit_allowance_plan_code`	`string`
`number_of_units`	`decimal(21,6)`
`per_unit_amount`	`decimal(26,6)`
`currency_code`	`string`
`frequency_code`	`string`
`actual_end_date`	`date`
`reimbursement_start_date`	`date`
`fixed_for_manage_by_basis_total`	`boolean`

`job_requisition_unit_salary_plan`

Column	Data type
`job_requisition_compensation_id`	`int`
`job_requisition_id`	`string`
`unit_salary_plan_id`	`string`
`unit_salary_plan_code`	`string`
`per_unit_amount`	`decimal(26,6)`
`currency_code`	`string`
`default_units`	`decimal(21,6)`
`frequency_code`	`string`
`actual_end_date`	`date`

Column	Data type
`job_requisition_compensation_id`	`int`
`job_requisition_id`	`string`
`unit_salary_plan_id`	`string`
`unit_salary_plan_code`	`string`
`per_unit_amount`	`decimal(26,6)`
`currency_code`	`string`
`default_units`	`decimal(21,6)`
`frequency_code`	`string`
`actual_end_date`	`date`

`job_requisition_work_experience`

Column	Data type
`job_requisition_id`	`string`
`id`	`string`
`work_experience_code`	`string`
`required`	`boolean`
`work_experience_rating`	`string`
`qualification_source`	`string`

Payroll results

Ingestion mode: Incremental

Destination tables: 9

`payroll_line`

Column	Data type
`payroll_id`	`string`
`employee_id`	`string`
`company_id`	`string`
`costing_company_id`	`string`
`arrco_agirc_category_code`	`string`
`arrear_amount`	`decimal(18,6)`
`business_unit_worktag_code`	`string`
`amount`	`decimal(26,6)`
`custom_worktag_06_code`	`string`
`custom_worktag_07_code`	`string`
`custom_worktag_08_code`	`string`
`custom_worktag_09_code`	`string`
`custom_worktag_10_code`	`string`
`custom_worktag_11_code`	`string`
`custom_worktag_12_code`	`string`
`custom_worktag_13_code`	`string`
`custom_worktag_14_code`	`string`
`custom_worktag_15_code`	`string`
`exemption_code`	`string`
`fund_worktag_code`	`string`
`gift_worktag_code`	`string`
`grant_worktag_code`	`string`
`income_code`	`string`
`input_comment`	`string`
`ni_category_code`	`string`
`object_class_worktag_code`	`string`
`pay_frequency`	`decimal(18,6)`
`period_remaining`	`decimal(12,0)`
`program_worktag_code`	`string`
`project_phase_worktag_code`	`string`
`project_task_worktag_code`	`string`
`subperiod_end`	`date`
`subperiod_start`	`date`
`tax_residency_country_code`	`string`
`workers_compensation_code`	`string`
`index`	`int`

Column	Data type
`payroll_id`	`string`
`employee_id`	`string`
`company_id`	`string`
`costing_company_id`	`string`
`arrco_agirc_category_code`	`string`
`arrear_amount`	`decimal(18,6)`
`business_unit_worktag_code`	`string`
`amount`	`decimal(26,6)`
`custom_worktag_06_code`	`string`
`custom_worktag_07_code`	`string`
`custom_worktag_08_code`	`string`
`custom_worktag_09_code`	`string`
`custom_worktag_10_code`	`string`
`custom_worktag_11_code`	`string`
`custom_worktag_12_code`	`string`
`custom_worktag_13_code`	`string`
`custom_worktag_14_code`	`string`
`custom_worktag_15_code`	`string`
`exemption_code`	`string`
`fund_worktag_code`	`string`
`gift_worktag_code`	`string`
`grant_worktag_code`	`string`
`income_code`	`string`
`input_comment`	`string`
`ni_category_code`	`string`
`object_class_worktag_code`	`string`
`pay_frequency`	`decimal(18,6)`
`period_remaining`	`decimal(12,0)`
`program_worktag_code`	`string`
`project_phase_worktag_code`	`string`
`project_task_worktag_code`	`string`
`subperiod_end`	`date`
`subperiod_start`	`date`
`tax_residency_country_code`	`string`
`workers_compensation_code`	`string`
`index`	`int`

`payroll_line_pay_component`

Column	Data type
`payroll_id`	`string`
`payroll_line_index`	`int`
`earning`	`string`
`deduction`	`string`
`index`	`int`

`payroll_line_related_calculation`

Column	Data type
`payroll_id`	`string`
`payroll_line_index`	`int`
`amount`	`decimal(26,6)`
`calculation_code`	`string`
`workday_calculation_code`	`string`
`index`	`int`

`payroll_line_withholding`

Column	Data type
`payroll_id`	`string`
`begin_date`	`date`
`case_number`	`string`
`deduction_recepient`	`string`
`deduction_recepient_bank_account`	`string`
`end_date`	`date`
`memo`	`string`
`order_date`	`date`
`order_priority`	`decimal(6,0)`
`order_status`	`string`
`order_type`	`string`
`originating_entity`	`string`
`pay_frequency`	`string`
`pay_period_amount`	`decimal(26,6)`
`pay_period_amount_type`	`string`
`pay_period_percent`	`decimal(9,6)`
`received_date`	`timestamp`
`tax_authority`	`string`
`total_debt`	`decimal(26,6)`
`payroll_line_index`	`int`

Column	Data type
`payroll_id`	`string`
`begin_date`	`date`
`case_number`	`string`
`deduction_recepient`	`string`
`deduction_recepient_bank_account`	`string`
`end_date`	`date`
`memo`	`string`
`order_date`	`date`
`order_priority`	`decimal(6,0)`
`order_status`	`string`
`order_type`	`string`
`originating_entity`	`string`
`pay_frequency`	`string`
`pay_period_amount`	`decimal(26,6)`
`pay_period_amount_type`	`string`
`pay_period_percent`	`decimal(9,6)`
`received_date`	`timestamp`
`tax_authority`	`string`
`total_debt`	`decimal(26,6)`
`payroll_line_index`	`int`

`payroll_local_city_authority_tax_worktag`

Column	Data type
`payroll_id`	`string`
`payroll_line_id`	`int`
`id`	`string`
`payroll_local_city_authority_tax_code`	`string`

`payroll_local_county_authority_tax_worktag`

Column	Data type
`payroll_id`	`string`
`payroll_line_id`	`int`
`id`	`string`
`payroll_local_county_authority_tax_code`	`string`

`payroll_national_id`

Column	Data type
`payroll_id`	`string`
`id`	`string`
`type`	`string`
`country`	`string`
`issued_date`	`date`
`expiration_date`	`date`
`verification_date`	`date`
`series`	`string`
`issuing_agency`	`string`
`verified_by`	`string`

`payroll_result`

Column	Data type
`id`	`string`
`employee_id`	`string`
`company_id`	`string`
`payroll_code`	`string`
`account_number`	`string`
`establishment`	`string`
`pay_group`	`string`
`run_category`	`string`
`pay_period_frequency`	`decimal(18,6)`
`off_cycle_type`	`string`
`for_additional_pay`	`boolean`
`result_completed_date`	`timestamp`
`period`	`string`
`period_start`	`date`
`period_end`	`date`
`subperiod_start`	`date`
`subperiod_end`	`date`
`payment_date`	`date`
`currency`	`string`
`original_payment_date`	`date`
`gross_amount`	`decimal(18,6)`
`net_amount`	`decimal(26,6)`

Column	Data type
`id`	`string`
`employee_id`	`string`
`company_id`	`string`
`payroll_code`	`string`
`account_number`	`string`
`establishment`	`string`
`pay_group`	`string`
`run_category`	`string`
`pay_period_frequency`	`decimal(18,6)`
`off_cycle_type`	`string`
`for_additional_pay`	`boolean`
`result_completed_date`	`timestamp`
`period`	`string`
`period_start`	`date`
`period_end`	`date`
`subperiod_start`	`date`
`subperiod_end`	`date`
`payment_date`	`date`
`currency`	`string`
`original_payment_date`	`date`
`gross_amount`	`decimal(18,6)`
`net_amount`	`decimal(26,6)`

`payroll_state_authority_tax_worktag`

Column	Data type
`payroll_id`	`string`
`payroll_line_id`	`int`
`id`	`string`
`payroll_state_authority_tax_code`	`string`

Compensation plans

Ingestion mode: Full refresh

Destination tables: 15

`compensation_allowance_plan_amount_profile`

Column	Data type
`compensation_plan_id`	`string`
`amount`	`decimal(26,6)`
`currency`	`string`
`compensation_eligibility_rule_id`	`string`
`index`	`int`

`compensation_allowance_plan_percent_profile`

Column	Data type
`compensation_plan_id`	`string`
`percent`	`decimal(18,6)`
`ceiling_amount`	`decimal(26,6)`
`ceiling_currency`	`string`
`compensation_eligibility_rule_id`	`string`
`compensation_basis`	`string`
`calculation_compensation`	`string`
`index`	`int`

Column	Data type
`compensation_plan_id`	`string`
`percent`	`decimal(18,6)`
`ceiling_amount`	`decimal(26,6)`
`ceiling_currency`	`string`
`compensation_eligibility_rule_id`	`string`
`compensation_basis`	`string`
`calculation_compensation`	`string`
`index`	`int`

`compensation_bonus_plan_coverage_date_eligibility_rule`

Column	Data type
`compensation_plan_id`	`string`
`compensation_eligibility_rule_id`	`string`

`compensation_bonus_plan_performance_factor_scorecard`

Column	Data type
`compensation_plan_id`	`string`
`id`	`string`
`performance_scorecard_code`	`string`
`weight`	`decimal(10,4)`
`bonus_modifier`	`string`

`compensation_bonus_plan_replacement_percent`

Column	Data type
`compensation_plan_id`	`string`
`percentage`	`decimal(16,4)`
`compensation_eligibility_rule_id`	`string`
`compensation_basis`	`string`
`calculation_compensation`	`string`
`index`	`int`

`compensation_bonus_tranche`

Column	Data type
`compensation_plan_id`	`string`
`name`	`decimal(12,0)`
`percentage`	`decimal(18,6)`

`compensation_commission_plan_profile`

Column	Data type
`compensation_plan_id`	`string`
`currency`	`string`
`amount`	`decimal(26,6)`
`draw_amount`	`decimal(21,6)`
`compensation_eligibility_rule_id`	`string`
`index`	`int`

`compensation_future_payment_bonus_plan`

Column	Data type
`compensation_plan_id`	`string`
`bonus_plan_id`	`string`

`compensation_merit_plan_replacement_percent`

Column	Data type
`compensation_plan_id`	`string`
`percentage`	`decimal(18,6)`
`compensation_eligibility_rule_id`	`string`
`compensation_basis`	`string`
`calculation_compensation`	`string`
`index`	`int`

`compensation_plan`

Column	Data type
`id`	`string`
`compensation_plan_code`	`string`
`allowance_plan_element`	`string`
`allowance_plan_currency`	`string`
`allowance_plan_frequency`	`string`
`allowance_plan_no_individual_override`	`boolean`
`allowance_plan_exclude_from_merit`	`boolean`
`allowance_plan_apply_full_time_equivalent`	`boolean`
`allowance_plan_amount`	`decimal(26,6)`
`allowance_plan_percentage`	`decimal(16,6)`
`allowance_plan_compensation_basis`	`string`
`allowance_plan_calculation_compensation`	`string`
`allowance_plan_percent_ceiling_amount`	`decimal(26,6)`
`allowance_plan_percent_ceiling_currency`	`string`
`allowance_plan_default_units`	`decimal(21,6)`
`allowance_plan_per_unit_amount`	`decimal(26,6)`
`allowance_plan_unit_of_measure`	`string`
`allowance_plan_reimbursement_expense_item`	`string`
`allowance_plan_reimbursement_expense_accumulator`	`string`
`base_plan_exclude_from_merit`	`boolean`
`base_plan_currency`	`string`
`base_plan_frequency`	`string`
`base_plan_element`	`string`
`base_plan_salary_apply_full_time_equivalent`	`boolean`
`base_plan_hourly_amount`	`decimal(26,6)`
`base_plan_hourly_minimum_wage`	`boolean`
`base_plan_unit_salary_per_unit_amount`	`decimal(26,6)`
`base_plan_unit_salary_default_units`	`decimal(21,6)`
`base_plan_unit_salary_no_individual_override`	`boolean`
`base_plan_unit_salary_unit_of_measure`	`string`
`bonus_plan_currency`	`string`
`bonus_plan_frequency`	`string`
`bonus_plan_element`	`string`
`bonus_plan_allow_individual_targets`	`boolean`
`bonus_plan_apply_full_time_equivalent`	`boolean`
`bonus_plan_waiting_period`	`string`
`bonus_plan_time_proration`	`string`
`bonus_plan_include_active_employees_in_waiting_period`	`boolean`
`bonus_plan_rounding_rule`	`string`
`bonus_plan_performance_scorecard`	`string`
`bonus_plan_include_active_employees_assigned`	`boolean`
`bonus_plan_performance_matrix_compensation_matrix_id`	`string`
`bonus_plan_performance_matrix_use_matrix_as_reference_only`	`boolean`
`bonus_plan_performance_matrix_apply_net_attainment`	`boolean`
`bonus_plan_performance_matrix_bonus_modifier`	`string`
`bonus_plan_performance_factor_apply_net_attainment`	`boolean`
`bonus_plan_performance_factor_weight`	`decimal(10,4)`
`bonus_plan_performance_factor_compensation_matrix_id`	`string`
`bonus_plan_performance_factor_bonus_modifier`	`string`
`bonus_plan_amount`	`decimal(26,6)`
`bonus_plan_percentage`	`decimal(14,4)`
`bonus_plan_compensation_basis`	`string`
`bonus_plan_calculation_compensation`	`string`
`bonus_plan_deferred_compensation_calculation`	`string`
`bonus_plan_deferred_compensation_stock_plan`	`string`
`calculated_plan_element`	`string`
`calculated_plan_currency`	`string`
`calculated_plan_frequency`	`string`
`calculated_plan_calculation`	`string`
`calculated_plan_exclude_from_total_salary_and_allowance_compensation`	`boolean`
`calculated_plan_is_dynamic_calculated_plan`	`boolean`
`calculated_plan_is_event_driven_calculated_plan`	`boolean`
`commission_plan_element`	`string`
`commission_plan_currency`	`string`
`commission_plan_frequency`	`string`
`commission_plan_target_amount`	`decimal(26,6)`
`commission_plan_draw_amount`	`decimal(21,6)`
`commission_plan_draw_frequency`	`string`
`commission_plan_draw_duration`	`string`
`commission_plan_recoverable`	`boolean`
`description`	`string`
`effective_date`	`date`
`future_payment_plan_element`	`string`
`future_payment_plan_currency`	`string`
`future_payment_plan_frequency`	`string`
`future_payment_plan_allow_individual_targets`	`boolean`
`future_payment_plan_include_all_bonus_compensation_plan`	`boolean`
`future_payment_plan_include_one_time_payment_compensation_plan`	`boolean`
`future_payment_plan_amount`	`decimal(26,6)`
`inactive`	`boolean`
`merit_plan_currency`	`string`
`merit_plan_frequency`	`string`
`merit_plan_subject_to_statutory_minimum`	`boolean`
`merit_plan_allow_individual_targets`	`boolean`
`merit_plan_compensation_matrix_id`	`string`
`merit_plan_use_matrix_as_reference_only`	`boolean`
`merit_plan_waiting_period`	`string`
`merit_plan_include_active_employees_in_waiting_period`	`boolean`
`merit_plan_time_proration`	`string`
`merit_plan_rounding_rule`	`string`
`merit_plan_include_active_employess_assigned`	`boolean`
`merit_plan_target_percentage`	`decimal(16,6)`
`merit_plan_percentage_manage_by_compensation_basis`	`boolean`
`merit_plan_percentage_calculation_compensation`	`string`
`merit_plan_percentage_compensation_basis`	`string`
`merit_plan_required_amount`	`decimal(26,6)`
`merit_plan_amount_calculation_compensation`	`string`
`merit_plan_amount_compensation_basis`	`string`
`merit_plan_amount_manage_by_compensation_basis`	`boolean`
`name`	`string`
`period_plan_calculation_compensation`	`string`
`period_plan_compensation_basis`	`string`
`period_plan_element`	`string`
`period_plan_default_compensation_multiplier`	`decimal(18,6)`
`period_plan_unit_of_duration`	`string`
`stock_plan_allow_target_override`	`boolean`
`stock_plan_compensation_matrix_id`	`string`
`stock_plan_use_as_reference_only`	`boolean`
`stock_plan_unit_data_target_shares`	`decimal(15,0)`
`stock_plan_percent_data_calculation_compensation`	`string`
`stock_plan_percent_data_compensation_basis`	`string`
`stock_plan_percent_data_rounding_rule`	`string`
`stock_plan_percent_data_target_percent`	`decimal(19,4)`
`stock_plan_amount_data_rounding_rule`	`string`
`stock_plan_amount_data_use_target_currency`	`boolean`
`stock_plan_amount_data_target_amount`	`decimal(21,6)`
`stock_plan_amount_data_currency`	`string`

Column	Data type
`id`	`string`
`compensation_plan_code`	`string`
`allowance_plan_element`	`string`
`allowance_plan_currency`	`string`
`allowance_plan_frequency`	`string`
`allowance_plan_no_individual_override`	`boolean`
`allowance_plan_exclude_from_merit`	`boolean`
`allowance_plan_apply_full_time_equivalent`	`boolean`
`allowance_plan_amount`	`decimal(26,6)`
`allowance_plan_percentage`	`decimal(16,6)`
`allowance_plan_compensation_basis`	`string`
`allowance_plan_calculation_compensation`	`string`
`allowance_plan_percent_ceiling_amount`	`decimal(26,6)`
`allowance_plan_percent_ceiling_currency`	`string`
`allowance_plan_default_units`	`decimal(21,6)`
`allowance_plan_per_unit_amount`	`decimal(26,6)`
`allowance_plan_unit_of_measure`	`string`
`allowance_plan_reimbursement_expense_item`	`string`
`allowance_plan_reimbursement_expense_accumulator`	`string`
`base_plan_exclude_from_merit`	`boolean`
`base_plan_currency`	`string`
`base_plan_frequency`	`string`
`base_plan_element`	`string`
`base_plan_salary_apply_full_time_equivalent`	`boolean`
`base_plan_hourly_amount`	`decimal(26,6)`
`base_plan_hourly_minimum_wage`	`boolean`
`base_plan_unit_salary_per_unit_amount`	`decimal(26,6)`
`base_plan_unit_salary_default_units`	`decimal(21,6)`
`base_plan_unit_salary_no_individual_override`	`boolean`
`base_plan_unit_salary_unit_of_measure`	`string`
`bonus_plan_currency`	`string`
`bonus_plan_frequency`	`string`
`bonus_plan_element`	`string`
`bonus_plan_allow_individual_targets`	`boolean`
`bonus_plan_apply_full_time_equivalent`	`boolean`
`bonus_plan_waiting_period`	`string`
`bonus_plan_time_proration`	`string`
`bonus_plan_include_active_employees_in_waiting_period`	`boolean`
`bonus_plan_rounding_rule`	`string`
`bonus_plan_performance_scorecard`	`string`
`bonus_plan_include_active_employees_assigned`	`boolean`
`bonus_plan_performance_matrix_compensation_matrix_id`	`string`
`bonus_plan_performance_matrix_use_matrix_as_reference_only`	`boolean`
`bonus_plan_performance_matrix_apply_net_attainment`	`boolean`
`bonus_plan_performance_matrix_bonus_modifier`	`string`
`bonus_plan_performance_factor_apply_net_attainment`	`boolean`
`bonus_plan_performance_factor_weight`	`decimal(10,4)`
`bonus_plan_performance_factor_compensation_matrix_id`	`string`
`bonus_plan_performance_factor_bonus_modifier`	`string`
`bonus_plan_amount`	`decimal(26,6)`
`bonus_plan_percentage`	`decimal(14,4)`
`bonus_plan_compensation_basis`	`string`
`bonus_plan_calculation_compensation`	`string`
`bonus_plan_deferred_compensation_calculation`	`string`
`bonus_plan_deferred_compensation_stock_plan`	`string`
`calculated_plan_element`	`string`
`calculated_plan_currency`	`string`
`calculated_plan_frequency`	`string`
`calculated_plan_calculation`	`string`
`calculated_plan_exclude_from_total_salary_and_allowance_compensation`	`boolean`
`calculated_plan_is_dynamic_calculated_plan`	`boolean`
`calculated_plan_is_event_driven_calculated_plan`	`boolean`
`commission_plan_element`	`string`
`commission_plan_currency`	`string`
`commission_plan_frequency`	`string`
`commission_plan_target_amount`	`decimal(26,6)`
`commission_plan_draw_amount`	`decimal(21,6)`
`commission_plan_draw_frequency`	`string`
`commission_plan_draw_duration`	`string`
`commission_plan_recoverable`	`boolean`
`description`	`string`
`effective_date`	`date`
`future_payment_plan_element`	`string`
`future_payment_plan_currency`	`string`
`future_payment_plan_frequency`	`string`
`future_payment_plan_allow_individual_targets`	`boolean`
`future_payment_plan_include_all_bonus_compensation_plan`	`boolean`
`future_payment_plan_include_one_time_payment_compensation_plan`	`boolean`
`future_payment_plan_amount`	`decimal(26,6)`
`inactive`	`boolean`
`merit_plan_currency`	`string`
`merit_plan_frequency`	`string`
`merit_plan_subject_to_statutory_minimum`	`boolean`
`merit_plan_allow_individual_targets`	`boolean`
`merit_plan_compensation_matrix_id`	`string`
`merit_plan_use_matrix_as_reference_only`	`boolean`
`merit_plan_waiting_period`	`string`
`merit_plan_include_active_employees_in_waiting_period`	`boolean`
`merit_plan_time_proration`	`string`
`merit_plan_rounding_rule`	`string`
`merit_plan_include_active_employess_assigned`	`boolean`
`merit_plan_target_percentage`	`decimal(16,6)`
`merit_plan_percentage_manage_by_compensation_basis`	`boolean`
`merit_plan_percentage_calculation_compensation`	`string`
`merit_plan_percentage_compensation_basis`	`string`
`merit_plan_required_amount`	`decimal(26,6)`
`merit_plan_amount_calculation_compensation`	`string`
`merit_plan_amount_compensation_basis`	`string`
`merit_plan_amount_manage_by_compensation_basis`	`boolean`
`name`	`string`
`period_plan_calculation_compensation`	`string`
`period_plan_compensation_basis`	`string`
`period_plan_element`	`string`
`period_plan_default_compensation_multiplier`	`decimal(18,6)`
`period_plan_unit_of_duration`	`string`
`stock_plan_allow_target_override`	`boolean`
`stock_plan_compensation_matrix_id`	`string`
`stock_plan_use_as_reference_only`	`boolean`
`stock_plan_unit_data_target_shares`	`decimal(15,0)`
`stock_plan_percent_data_calculation_compensation`	`string`
`stock_plan_percent_data_compensation_basis`	`string`
`stock_plan_percent_data_rounding_rule`	`string`
`stock_plan_percent_data_target_percent`	`decimal(19,4)`
`stock_plan_amount_data_rounding_rule`	`string`
`stock_plan_amount_data_use_target_currency`	`boolean`
`stock_plan_amount_data_target_amount`	`decimal(21,6)`
`stock_plan_amount_data_currency`	`string`

`compensation_stock_plan_amount_profile`

Column	Data type
`compensation_plan_id`	`string`
`index`	`int`
`target_amount`	`decimal(26,6)`
`compensation_eligibility_rule_id`	`string`
`currency`	`string`

`compensation_stock_plan_grant`

Column	Data type
`compensation_plan_id`	`string`
`index`	`int`
`grant_split_percent`	`decimal(10,4)`
`grant_type`	`string`
`stock_vesting_schedule`	`string`
`stock_date_rule`	`string`
`type`	`string`

`compensation_stock_plan_unit_profile`

Column	Data type
`compensation_plan_id`	`string`
`index`	`int`
`target_shares`	`decimal(21,6)`
`compensation_eligibility_rule_id`	`string`

`compensation_stock_profile_grant_split`

Column	Data type
`compensation_plan_id`	`string`
`unit_profile_replacement_index`	`int`
`index`	`int`
`grant_split_percent`	`decimal(10,4)`
`grant_type`	`string`
`stock_vesting_schedule`	`string`
`stock_date_rule`	`string`
`type`	`string`

`deferred_compensation_eligibility_rule`

Column	Data type
`compensation_plan_id`	`string`
`compensation_eligibility_rule_id`	`string`

Compensation grades

Ingestion mode: Full refresh

Destination tables: 3

`compensation_grade`

Column	Data type
`id`	`string`
`compensation_grade_code`	`string`
`effective_date`	`date`
`name`	`string`
`description`	`string`
`number_of_segments`	`decimal(12,0)`
`minimum`	`decimal(21,6)`
`midpoint`	`decimal(21,6)`
`maximum`	`decimal(32,6)`
`spread`	`decimal(32,6)`
`segment_1_top`	`decimal(21,6)`
`segment_2_top`	`decimal(21,6)`
`segment_3_top`	`decimal(21,6)`
`segment_4_top`	`decimal(21,6)`
`segment_5_top`	`decimal(21,6)`
`currency_code`	`string`
`frequency_code`	`string`
`compensation_plan_id`	`string`
`is_override_allowed`	`boolean`
`is_first_step_during_compensation_proposal_assigned`	`boolean`
`pay_level`	`string`
`inactive`	`boolean`

Column	Data type
`id`	`string`
`compensation_grade_code`	`string`
`effective_date`	`date`
`name`	`string`
`description`	`string`
`number_of_segments`	`decimal(12,0)`
`minimum`	`decimal(21,6)`
`midpoint`	`decimal(21,6)`
`maximum`	`decimal(32,6)`
`spread`	`decimal(32,6)`
`segment_1_top`	`decimal(21,6)`
`segment_2_top`	`decimal(21,6)`
`segment_3_top`	`decimal(21,6)`
`segment_4_top`	`decimal(21,6)`
`segment_5_top`	`decimal(21,6)`
`currency_code`	`string`
`frequency_code`	`string`
`compensation_plan_id`	`string`
`is_override_allowed`	`boolean`
`is_first_step_during_compensation_proposal_assigned`	`boolean`
`pay_level`	`string`
`inactive`	`boolean`

`compensation_grade_profile`

Column	Data type
`compensation_grade_id`	`string`
`id`	`string`
`compensation_grade_profile_code`	`string`
`effective_date`	`date`
`name`	`string`
`description`	`string`
`inactive`	`boolean`
`number_of_segments`	`decimal(12,0)`
`minimum`	`decimal(21,6)`
`midpoint`	`decimal(21,6)`
`maximum`	`decimal(32,6)`
`spread`	`decimal(32,6)`
`segment_1_top`	`decimal(21,6)`
`segment_2_top`	`decimal(21,6)`
`segment_3_top`	`decimal(21,6)`
`segment_4_top`	`decimal(21,6)`
`segment_5_top`	`decimal(21,6)`
`currency_code`	`string`
`frequency_code`	`string`
`compensation_plan_id`	`string`
`is_override_allowed`	`boolean`

Column	Data type
`compensation_grade_id`	`string`
`id`	`string`
`compensation_grade_profile_code`	`string`
`effective_date`	`date`
`name`	`string`
`description`	`string`
`inactive`	`boolean`
`number_of_segments`	`decimal(12,0)`
`minimum`	`decimal(21,6)`
`midpoint`	`decimal(21,6)`
`maximum`	`decimal(32,6)`
`spread`	`decimal(32,6)`
`segment_1_top`	`decimal(21,6)`
`segment_2_top`	`decimal(21,6)`
`segment_3_top`	`decimal(21,6)`
`segment_4_top`	`decimal(21,6)`
`segment_5_top`	`decimal(21,6)`
`currency_code`	`string`
`frequency_code`	`string`
`compensation_plan_id`	`string`
`is_override_allowed`	`boolean`

`compensation_step`

Column	Data type
`compensation_grade_id`	`string`
`id`	`string`
`compensation_step_code`	`string`
`effective_date`	`date`
`sequence`	`string`
`name`	`string`
`amount`	`decimal(21,6)`
`interval`	`decimal(12,0)`
`progression_period_code`	`string`
`progression_rule_code`	`string`

Column	Data type
`compensation_grade_id`	`string`
`id`	`string`
`compensation_step_code`	`string`
`effective_date`	`date`
`sequence`	`string`
`name`	`string`
`amount`	`decimal(21,6)`
`interval`	`decimal(12,0)`
`progression_period_code`	`string`
`progression_rule_code`	`string`

Absence inputs

Ingestion mode: Full refresh

Destination tables: 1

`absence_input`

Column	Data type
`id`	`string`
`absence_input_code`	`string`
`batch_code`	`string`
`worker_id`	`string`
`position_id`	`string`
`absence_component_code`	`string`
`start_date`	`date`
`end_date`	`date`
`reference_date`	`date`
`hours`	`decimal(18,6)`
`adjustment`	`boolean`
`comment`	`string`

Column	Data type
`id`	`string`
`absence_input_code`	`string`
`batch_code`	`string`
`worker_id`	`string`
`position_id`	`string`
`absence_component_code`	`string`
`start_date`	`date`
`end_date`	`date`
`reference_date`	`date`
`hours`	`decimal(18,6)`
`adjustment`	`boolean`
`comment`	`string`

Override balances

Ingestion mode: Full refresh

Destination tables: 1

`override_balance`

Column	Data type
`id`	`string`
`worker_id`	`string`
`batch_code`	`string`
`position_id`	`string`
`time_off_plan_code`	`string`
`override_balance_date`	`date`
`override_balance_units`	`decimal(18,6)`
`comments`	`string`

Time off plan balances

Ingestion mode: Full refresh

Destination tables: 2

`time_off_plan_balance`

Column	Data type
`worker_id`	`string`
`id`	`string`
`time_off_plan_code`	`string`
`time_off_plan_descriptor`	`string`
`unit_of_time_code`	`string`

`time_off_plan_balance_position`

Column	Data type
`time_off_plan_balance_id`	`string`
`worker_id`	`string`
`position_id`	`string`
`time_off_plan_balance`	`decimal(26,6)`
`index`	`int`

Connection properties

When you create a connection to Workday HCM, you must provide the following properties. To retrieve these values, see Configure authentication to Workday HCM. For steps to create the connection, see Create a Workday HCM connection.

Property	Description
Client ID	The OAuth client ID from the registered API client in Workday.
Client Secret	The OAuth client secret from the registered API client in Workday.
Refresh Token	The OAuth refresh token generated for the integration system user account.
Tenant Name	Your Workday tenant identifier. To find this value, select My Account > Organization ID in Workday.
Instance URL	The URL of your Workday instance (for example, `https://wd2-impl-services1.workday.com`).

Property	Description
Client ID	The OAuth client ID from the registered API client in Workday.
Client Secret	The OAuth client secret from the registered API client in Workday.
Refresh Token	The OAuth refresh token generated for the integration system user account.
Tenant Name	Your Workday tenant identifier. To find this value, select My Account > Organization ID in Workday.
Instance URL	The URL of your Workday instance (for example, `https://wd2-impl-services1.workday.com`).

On this page

Supported data
Automated transformations
Destination table schemas
Workers
- worker_collective_agreement
- worker_leave_status
- worker_position_compensation
- worker_position_end_employment_reason
- worker_position_job_classification
- worker_position_manager
- worker_position_organization
- worker_position_payroll_reporting_code
- worker_positions
- worker_probation_period
- worker_secondary_termination_reason
- workers
Ethnicities
- ethnicity
Gender identities
- gender_identity
LGBT identifications
- lgbt_identification
Pronouns
- pronoun
Sexual orientations
- sexual_orientation
Organizations
- organization
- organization_assignment
- organization_leader
- organization_role
- organization_role_worker
Job profiles
- job_family_job_profile
- job_profile
- job_profile_certification
- job_profile_classification
- job_profile_company_insider
- job_profile_competency
- job_profile_education
- job_profile_exempt
- job_profile_language
- job_profile_language_ability
- job_profile_pay_rate
- job_profile_responsibility
- job_profile_restrict_to_country
- job_profile_skill
- job_profile_training
- job_profile_work_experience
- job_profile_worker_compensation
Positions
- position
- position_bonus_plan
- position_certification
- position_competency
- position_education
- position_job_family
- position_job_profile
- position_language
- position_location
- position_merit_plan
- position_organization
- position_pay_plan
- position_responsibility
- position_skill
- position_stock_plan
- position_training
- position_work_experience
- position_worker_type_restriction
Candidates
- candidate
- candidate_certification
- candidate_education
- candidate_experience
- candidate_language
- candidate_name
- candidate_pool_membership
- candidate_skill
- candidate_tag
- candidate_website
Questionnaires
- questionnaire
- questionnaire_setup
Interviews
- interview
- interview_competency
- interview_questionnaire
- interview_session
- interview_session_detail
- interviewer
External reference
- external_reference_line
- external_reference_participant
- questionnaire_answer
Job requisitions
- job_requisition
- job_requisition_additional_job_posting_location
- job_requisition_additional_job_profile
- job_requisition_additional_location
- job_requisition_allowance_plan
- job_requisition_bonus_plan
- job_requisition_calculated_plan
- job_requisition_certification
- job_requisition_commission_plan
- job_requisition_compensation
- job_requisition_competency
- job_requisition_custom_organization
- job_requisition_default_assessment_test
- job_requisition_education
- job_requisition_language
- job_requisition_language_ability
- job_requisition_merit_plan
- job_requisition_organization
- job_requisition_pay_plan
- job_requisition_period_salary_plan
- job_requisition_position
- job_requisition_responsibility
- job_requisition_skill
- job_requisition_stock_plan
- job_requisition_training
- job_requisition_unit_allowance_plan
- job_requisition_unit_salary_plan
- job_requisition_work_experience
Payroll results
- payroll_line
- payroll_line_pay_component
- payroll_line_related_calculation
- payroll_line_withholding
- payroll_local_city_authority_tax_worktag
- payroll_local_county_authority_tax_worktag
- payroll_national_id
- payroll_result
- payroll_state_authority_tax_worktag
Compensation plans
- compensation_allowance_plan_amount_profile
- compensation_allowance_plan_percent_profile
- compensation_bonus_plan_coverage_date_eligibility_rule
- compensation_bonus_plan_performance_factor_scorecard
- compensation_bonus_plan_replacement_percent
- compensation_bonus_tranche
- compensation_commission_plan_profile
- compensation_future_payment_bonus_plan
- compensation_merit_plan_replacement_percent
- compensation_plan
- compensation_stock_plan_amount_profile
- compensation_stock_plan_grant
- compensation_stock_plan_unit_profile
- compensation_stock_profile_grant_split
- deferred_compensation_eligibility_rule
Compensation grades
- compensation_grade
- compensation_grade_profile
- compensation_step
Absence inputs
- absence_input
Override balances
- override_balance
Time off plan balances
- time_off_plan_balance
- time_off_plan_balance_position
Connection properties

Supported data​

Automated transformations​

Destination table schemas​

Workers​

worker_collective_agreement​

worker_leave_status​

worker_position_compensation​

worker_position_end_employment_reason​

worker_position_job_classification​

worker_position_manager​

worker_position_organization​

worker_position_payroll_reporting_code​

worker_positions​

worker_probation_period​

worker_secondary_termination_reason​

workers​

Ethnicities​

ethnicity​

Gender identities​

gender_identity​

LGBT identifications​

lgbt_identification​

Pronouns​

pronoun​

Sexual orientations​

sexual_orientation​

Organizations​

organization​

organization_assignment​

organization_leader​

organization_role​

organization_role_worker​

Job profiles​

job_family_job_profile​

job_profile​

job_profile_certification​

job_profile_classification​

job_profile_company_insider​

job_profile_competency​

job_profile_education​

job_profile_exempt​

job_profile_language​

job_profile_language_ability​

job_profile_pay_rate​

job_profile_responsibility​

job_profile_restrict_to_country​

job_profile_skill​

job_profile_training​

job_profile_work_experience​

job_profile_worker_compensation​

Positions​

position​

position_bonus_plan​

position_certification​

position_competency​

position_education​

position_job_family​

position_job_profile​

position_language​

position_location​

position_merit_plan​

position_organization​

position_pay_plan​

position_responsibility​

position_skill​

position_stock_plan​

position_training​

position_work_experience​

position_worker_type_restriction​

Candidates​

candidate​

candidate_certification​

candidate_education​

candidate_experience​

candidate_language​

candidate_name​

candidate_pool_membership​

candidate_skill​

candidate_tag​

candidate_website​

Supported data

Automated transformations

Destination table schemas

Workers

`worker_collective_agreement`

`worker_leave_status`

`worker_position_compensation`

`worker_position_end_employment_reason`

`worker_position_job_classification`

`worker_position_manager`

`worker_position_organization`

`worker_position_payroll_reporting_code`

`worker_positions`

`worker_probation_period`

`worker_secondary_termination_reason`

`workers`

Ethnicities

`ethnicity`

Gender identities

`gender_identity`

LGBT identifications

`lgbt_identification`

Pronouns

`pronoun`

Sexual orientations

`sexual_orientation`

Organizations

`organization`

`organization_assignment`

`organization_leader`

`organization_role`

`organization_role_worker`

Job profiles

`job_family_job_profile`

`job_profile`

`job_profile_certification`

`job_profile_classification`

`job_profile_company_insider`

`job_profile_competency`

`job_profile_education`

`job_profile_exempt`

`job_profile_language`

`job_profile_language_ability`

`job_profile_pay_rate`

`job_profile_responsibility`

`job_profile_restrict_to_country`

`job_profile_skill`

`job_profile_training`

`job_profile_work_experience`

`job_profile_worker_compensation`

Positions

`position`

`position_bonus_plan`

`position_certification`

`position_competency`

`position_education`

`position_job_family`

`position_job_profile`

`position_language`

`position_location`

`position_merit_plan`

`position_organization`

`position_pay_plan`

`position_responsibility`

`position_skill`

`position_stock_plan`

`position_training`

`position_work_experience`

`position_worker_type_restriction`

Candidates

`candidate`

`candidate_certification`

`candidate_education`

`candidate_experience`

`candidate_language`

`candidate_name`

`candidate_pool_membership`

`candidate_skill`

`candidate_tag`

`candidate_website`