Workday HCM connector reference

Important

This feature is in Beta.

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

Automated transformations

Workday Object APIs return deeply nested responses. Azure 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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)

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

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

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

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

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

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

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).