Release Noteslink

December 2023link

You can now specify your Workday tenant separately in the connector setup form. We have added a new field, Workday Tenant, to the setup form to support this. Previously, you had to specify it together with your Workday username in the {Workday_Username}@{Tenant} format. This change has no impact on the existing connectors.

October 2023link

We have made the following schema changes for the connectors created before October 6, 2023:

We no longer sync the following columns in the tables below:

TABLE	COLUMNS
`JOB_REQUISITION_ADDITIONAL_LOCATION`	`id`
`ORGANIZATION`	`position_availability_date` `position_earliest_hire_date` `position_worker_type` `position_time_type` `code`
`ORGANIZATION_ROLE`	`id`
`POSITION_ALLOWANCE_PLAN`	`id`
`POSITION_BONUS_PLAN`	`id`
`POSITION_CALCULATED_PLAN`	`id`
`POSITION_COMMISSION_PLAN`	`id`
`POSITION_DOCUMENT_FIELD_RESULT`	`id` `field_name`
`POSITION_JOB_FAMILY`	`id` `job_family_code`
`POSITION_JOB_PROFILE`	`id`
`POSITION_LOCATION`	`id`
`POSITION_MERIT_PLAN`	`id`
`POSITION_PAY_PLAN`	`id`
`POSITION_PERIOD_SALARY_PLAN`	`id`
`POSITION_STOCK_PLAN`	`id`
`POSITION_UNIT_ALLOWANCE_PLAN`	`id`
`POSITION_UNIT_SALARY_PLAN`	`id`
`WORKER_LEAVE_REQUEST_DETAIL`	`id`
`WORKER_LEAVE_STATUS`	`id`
`WORKER_POSITION`	`headcount_restriction_id` `job_category_id` `job_family_id` `job_profile_name` `management_level_id` `position_code` `position_title` `position_time_type`
`WORKER_POSITION_JOB_CLASSIFICATION`	`job_group_id`
`WORKER_POSITION_PAYROLL_REPORTING_CODE`	`id` `code`

Be sure to update your queries.

We will stop syncing the following tables after October 13, 2023
- COMMUNICATION_USAGE_DATA
- ORG_DOCUMENT_FIELD_RESULT
- ORG_JOB_PROFILE_EXEMPT
- ORG_LEADER
- ORG_POSITION_GRP_POSITION_TYPE
- POSITION_COMPANY_ASSIGNMENT
- POSITION_COST_CENTER_ASSIGNMENT
- POSITION_CUSTOM_ORGANIZATION_ASSIGNMENT
- POSITION_JOB_PROFILE_EXEMPT
- POSITION_REGION_ASSIGNMENT
- POSITION_STATUS
- POSITION_WORKER_TYPE_REFERENCE
- SUPERVISORY_ORG_LOCATION
- WORKER_CONTINGENT_CONTRACT
Be sure to update your queries.
We have added the following new tables:
- POSITION_ORGANIZATION
- POSITION_WORKER_TYPE_RESTRICTION
- COMMUNICATION_USAGE
- ORGANIZATION_POSITION_GROUP_POSITION
- ORGANIZATION_LEADER
- ORGANIZATION_POSITION_GROUP_POSITION
- ORGANIZATION_DOCUMENT_FIELD_RESULT
- SUPERVISORY_ORGANIZATION_LOCATION
We have added the following new columns to the tables below:

TABLE	NEW COLUMNS
`POSITION_JOB_PROFILE`	`job_profile_id`
`JOB_REQUISITION_ADDITIONAL_LOCATION`	`location_id`
`POSITION_LOCATION`	`location_id`
`POSITION_DOCUMENT_FIELD_RESULT`	`integration_document_field` `index`
`POSITION_JOB_FAMILY`	`job_family_id`
`WORKER_LEAVE_STATUS`	`leave_request_event_id`
`WORKER_LEAVE_REQUEST_DETAIL`	`leave_request_event_id`
`WORKER`	`contract_pay_rate` `contract_assignment_details` `contract_end_date` `contract_currency_code` `contract_frequency_name` `contract_vendor_name`
`WORKER_POSITION`	`headcount_restriction_code` `management_level_code`
`WORKER_POSITION_PAYROLL_REPORTING_CODE`	`payroll_reporting_id`
`WORKER_POSITION_JOB_CLASSIFICATION`	`job_group_code`
`ORGANIZATION`	`supervisory_position_availability_date` `supervisory_position_earliest_hire_date` `supervisory_position_worker_type` `supervisory_position_time_type`
`ORGANIZATION_ROLE`	`role_id`
`POSITION_PERIOD_SALARY_PLAN`	`period_salary_plan_id` `period_salary_plan_code`
`POSITION_UNIT_SALARY_PLAN`	`unit_salary_plan_id` `unit_salary_plan_code`
`POSITION_MERIT_PLAN`	`merit_plan_id` `merit_plan_code`
`POSITION_COMMISSION_PLAN`	`commission_plan_id` `commission_plan_code`
`POSITION_PAY_PLAN`	`pay_plan_id` `pay_plan_code`
`POSITION_CALCULATED_PLAN`	`calculated_plan_id` `calculated_plan_code`
`POSITION_UNIT_ALLOWANCE_PLAN`	`unit_allowance_plan_id` `unit_allowance_plan_code`
`POSITION_ALLOWANCE_PLAN`	`allowance_plan_id` `allowance_plan_code`
`POSITION_STOCK_PLAN`	`stock_plan_id` `stock_plan_code`
`POSITION_BONUS_PLAN`	`bonus_plan_id` `bonus_plan_code`

We have added two new columns compensation_grade_id and compensation_grade_profile_id to the WORKER table. Please resync the WORKER table to backfill the data for these columns or contact Fivetran Support to re-sync it for you.

We have added the following new tables to support the Workday Recruiting module:

CANDIDATE
CANDIDATE_CERTIFICATION
CANDIDATE_EDUCATION
CANDIDATE_EXPERIENCE
CANDIDATE_GOVERNMENT_ID
CANDIDATE_LANGUAGE
CANDIDATE_NAME
CANDIDATE_NATIONAL_ID
CANDIDATE_POOL_MEMBERSHIP
CANDIDATE_SKILL
CANDIDATE_SOCIAL_MEDIA_ACCOUNT
CANDIDATE_TAG
CANDIDATE_WEBSITE
EXTERNAL_REFERENCE_LINE
EXTERNAL_REFERENCE_PARTICIPANT
INTERVIEW
INTERVIEW_COMPETENCY
FEEDBACK_COMPETENCY_ASSESSMENT
INTERVIEW_FEEDBACK
INTERVIEW_FEEDBACK_DETAIL
INTERVIEW_SESSION
INTERVIEW_SESSION_DETAIL
INTERVIEW_QUESTIONNAIRE
INTERVIEWER
JOB_APPLICATION
JOB_APPLIED_TO
MULTIPLE_CHOICE_ANSWER
PRE_HIRE
PRE_HIRE_REFERRED_BY_WORKER
PRE_HIRE_POSITIONS_CONSIDERED
PRE_HIRE_BACKGROUND_CHECK_STATUS
PRE_HIRE_RESUME
PRE_HIRE_EDUCATION
PRE_HIRE_JOB_HISTORY
PRE_HIRE_TRAINING_ACHIEVEMENT
PRE_HIRE_INTERNAL_PROJECT_EXPERIENCE
PRE_HIRE_COMPETENCY_ACHIEVEMENT
PRE_HIRE_CERTIFICATION_ACHIEVEMENT
PRE_HIRE_LANGUAGE_ACHIEVEMENT
PRE_HIRE_LANGUAGE_ABILITY
PRE_HIRE_WORK_EXPERIENCE
PRE_HIRE_PROFESSIONAL_AFFILIATION
PRE_HIRE_AWARD_AND_ACTIVITY
QUESTIONNAIRE
QUESTIONNAIRE_ANSWER
QUESTIONNAIRE_SETUP
SCORE_FOR_MULTIPLE_CHOICE

To sync these tables, enable the security domains necessary for the Recruiting module.

We are gradually rolling out these changes to all existing connectors.

September 2023link

We have made the following schema changes for the connectors created before September 9, 2023:

Breaking changeslink

We no longer sync the following columns of the tables below:

TABLE	COLUMNS
`COMPENSATION_GRADE_PROFILE`	`compensation_grade_profile` `index` `job_profile_id`
`JOB_PROFILE_CERTIFICATION`	`certification_id` `country`
`JOB_PROFILE_COMPETENCY`	`id`
`JOB_PROFILE_EDUCATION`	`degree_id`
`JOB_PROFILE_LANGUAGE`	`id`
`JOB_PROFILE_PAY_RATE`	`country` `pay_rate_id`
`JOB_PROFILE_RESTRICT_TO_COUNTRY`	`country` `id`
`JOB_PROFILE_SKILL`	`job_profile_skill_id`
`JOB_PROFILE_WORK_EXPERIENCE`	`id`

We will stop syncing the following tables after Sept 15, 2023

CERTIFICATION_SPECIALTY_ACHIEVEMENT
LANGUAGE_ABILITY_PROFILE
UNION_MEMBERSHIP
WORKER_COMPENSATION
WORK_STUDY

Be sure to update your queries.

Non-breaking changeslink

We have added the following new tables:

COMPENSATION_GRADE
JOB_PROFILE_CERTIFICATION_SPECIALTY
JOB_PROFILE_COMPENSATION_GRADE_PROFLE
JOB_PROFILE_LANGUAGE_ABILITY
JOB_PROFILE_WORKER_COMPENSATION

We have added the following new columns to the tables below:

TABLE	NEW COLUMNS
`JOB_PROFILE`	`compensation_grade_id` `union_code` `union_membership_requirement` `work_study_award_source_code` `work_study_requirement_option_code`
`JOB_PROFILE_CERTIFICATION`	`country_code`
`JOB_PROFILE_COMPETENCY`	`competency_id`
`JOB_PROFILE_LANGUAGE`	`language_id`
`JOB_PROFILE_PAY_RATE`	`country_code`
`JOB_PROFILE_RESTRICT_TO_COUNTRY`	`country_code` `country_id`
`JOB_PROFILE_SKILL`	`skill_code`
`JOB_PROFILE_WORK_EXPERIENCE`	`work_experience_id`

We now support table level re-syncs for the Workday HCM connectors. You can now select or deselect the child tables to sync from the Schema tab on your connector details page. We are gradually rolling out these improvements to all existing connectors. For more information, see our Workday HCM documentation.

June 2023link

We have changed the primary key of the PAYROLL table. The primary key is now a Fivetran-generated column and is the hash of the employee_id and period_id columns. Previously, we populated the primary key with the Payroll_ID_Reference.WID value that we obtained from the WorkdayHCM API response. Be sure to update your queries.

May 2023link

We have added a new table, WORKER_EVENT, which stores the event history data of Workers. We are gradually rolling out this change to all existing connectors. For more information, see our Workday HCM ERD.

April 2023link

We have added the following new tables to support the Compensation module:

BENCHMARK_AMOUNT_REPLACEMENT_DATA
BENCHMARK_JOB
BENCHMARK_JOB_AND_JOB_PROFILE
BENCHMARK_JOB_COMPOSITE_DATA
BENCHMARK_JOB_PROFILE_DATA
COMPENSATION_ALLOWANCE_PLAN_AMOUNT_PROFILE
COMPENSATION_ALLOWANCE_PLAN_PERCENT_PROFILE
COMPENSATION_ALLOWANCE_PLAN_UNIT_PROFILE
COMPENSATION_BONUS_PLAN_COVERAGE_ELIGIBILITY_RULE
COMPENSATION_BONUS_PLAN_PERFORMANCE_FACTOR_SCORECARD
COMPENSATION_BONUS_PLAN_REPLACEMENT_AMOUNT
COMPENSATION_BONUS_PLAN_REPLACEMENT_PERCENT
COMPENSATION_BONUS_TRANCHE
COMPENSATION_COMMISSION_PLAN_PROFILE
COMPENSATION_ELIGIBILITY_COMPENSATION_GRADE
COMPENSATION_ELIGIBILITY_COMPENSATION_GRADE_PROFILE
COMPENSATION_ELIGIBILITY_COMPENSATION_PACKAGE
COMPENSATION_ELIGIBILITY_COMPENSATION_PLAN
COMPENSATION_ELIGIBILITY_RULE
COMPENSATION_ELIGIBILITY_RULE_CONDITION
COMPENSATION_ELIGIBILITY_RULE_CONDITION_CATEGORY
COMPENSATION_ELIGIBILITY_RULE_COUNTRY
COMPENSATION_FUTURE_ONE_TIME_PAYMENT_PLAN
COMPENSATION_FUTURE_PAYMENT_BONUS_PLAN
COMPENSATION_MATRIX
COMPENSATION_MATRIX_AMOUNT
COMPENSATION_MATRIX_PERCENT
COMPENSATION_MATRIX_TARGET_RULE
COMPENSATION_MERIT_PLAN_REPLACEMENT_AMOUNT
COMPENSATION_MERIT_PLAN_REPLACEMENT_PERCENT
COMPENSATION_PERIOD_PLAN_PROFILE
COMPENSATION_PLAN
COMPENSATION_PLAN_ELIGIBILITY_RULE
COMPENSATION_STOCK_PLAN_AMOUNT_PROFILE
COMPENSATION_STOCK_PLAN_GRANT_SPLIT
COMPENSATION_STOCK_PLAN_PERCENT_PROFILE
COMPENSATION_STOCK_PLAN_PROFILE_GRANT_SPLIT
COMPENSATION_STOCK_PLAN_UNIT_PROFILE
DEFERRED_COMPENSATION_ELIGIBILITY_RULE
DEFERRED_COMPENSATION_PROFILE
SCORECARD
SCORECARD_GOAL
SCORECARD_PROFILE
SCORECARD_PROFILE_GOAL

We have added the following new tables to support the Payroll module:

PAY_ACCUMULATION
PAYROLL
PAYROLL_DEDUCTION_INSTANT_MESSENGER
PAYROLL_LINE
PAYROLL_LINE_PAY_COMPONENT
PAYROLL_LINE_RELATED_CALCULATION
PAYROLL_LINE_WITHHOLDING
PAYROLL_NATIONAL_ID

We now capture the data that was synced into the POSITION table into a new table, WORKER_POSITION. Be sure to update your queries.

We now sync the data captured from the Staffing web service into the POSITION table and its child tables.

We have added the following child tables to the POSITION table:

ADDITIONAL_LOCATION
ALLOWANCE_PLAN
BONUS_PLAN
CALCULATED_PLAN
COMMISSION_PLAN
JOB_PROFILE_RESTRICTION_JOB_FAMILY
JOB_REQUISITION
MERIT_PLAN
PAY_PLAN
PERIOD_SALARY_PLAN
POSITION_CERTIFICATION
POSITION_CERTIFICATION_SPECIALITY
POSITION_COMPANY_ASSIGNMENT
POSITION_COMPETENCY
POSITION_COST_CENTER_ASSIGNMENT
POSITION_CUSTOM_ORGANIZATION_ASSIGNMENT
POSITION_DOCUMENT_FIELD_RESULT
POSITION_EDUCATION
POSITION_JOB_FAMILY
POSITION_JOB_PROFILE
POSITION_JOB_PROFILE_EXEMPT
POSITION_LANGUAGE
POSITION_LANGUAGE_ABILITY
POSITION_LOCATION
POSITION_REGION_ASSIGNMENT
POSITION_RESPONSIBILITY
POSITION_STATUS
POSITION_SKILL
POSITION_TRAINING
POSITION_WORK_EXPERIENCE
POSITION_WORKER_TYPE_REFERENCE
STOCK_PLAN
UNIT_ALLOWANCE_PLAN
UNIT_SALARY_PLAN

We have removed the following columns from the POSITION table:

academic_pay_setup_data_*
business_site_summary_*
business_title
default_weekly_hours
end_date
end_employment_date
exclude_from_headcount
federal_withholding_fein
full_time_equivalent_percentage
headcount_restriction_id
international_assignment_data_*
is_primary_job
job_exempt
job_profile_id
paid_fte
pay_rate_type
pay_through_date
payroll_interface_processing_*
position_time_type
position_title
regular_paid_equivalent_hours
scheduled_weekly_hours
specify_paid_fte
specify_working_fte
start_date
work_hours_profile
work_shift
work_space
worker_hours_profile_classification
worker_id
working_fte
working_time_frequency
working_time_unit
working_time_value

We have changed the primary keys in the following tables:

EMPLOYEE_PROBATION_PERIOD_DETAIL
POSITION
WORKER_COLLECTIVE_AGREEMENT
WORKER_POSITION_COMPENSATION
WORKER_POSITION_END_EMPLOYMENT_REASON
WORKER_POSITION_JOB_CLASSIFICATION
WORKER_POSITION_MANAGER
WORKER_POSITION_ORGANIZATION
WORKER_POSITION_PAYROLL_REPORTING_CODE

We have renamed the following tables:

COLLECTIVE_AGREEMENT to WORKER_COLLECTIVE_AGREEMENT
COLLECTIVE_AGREEMENT_FACTOR to WORKER_COLLECTIVE_AGREEMENT_FACTOR
CONTINGENT_WORKER_CONTRACT_INFO to WORKER_CONTINGENT_CONTRACT
LEAVE_REQUEST_DETAIL to WORKER_LEAVE_REQUEST_DETAIL
LEAVE_STATUS to WORKER_LEAVE_STATUS
POSITION_END_EMPLOYMENT_REASON to WORKER_POSITION_END_EMPLOYMENT_REASON
POSITION_JOB_CLASSIFICATION to WORKER_POSITION_JOB_CLASSIFICATION
POSITION_PAYROLL_REPORTING_CODE to WORKER_POSITION_PAYROLL_REPORTING_CODE
SECONDARY_TERMINATION to WORKER_SECONDARY_TERMINATION_REASON
WORKER_MANAGER to WORKER_POSITION_MANAGER

We will deprecate the old tables in July, 2023. However, for connectors created before April 17, 2023, we will continue to support both the old and renamed tables till we deprecate the old tables. For connectors created after April 17, 2023, the schema contains only the renamed tables.

We are gradually rolling out these changes to all existing connectors. See the Workday HCM ERD for more details.

February 2023link

We now capture deletes for the POSITION table. Perform a table re-sync if you want to capture deletes for the data we have already synced to the destination table.

November 2022link

We have added a new table, PERSONAL_INFORMATION_ETHNICITY.

We have added a new column, employee_type, to the POSITION table. Trigger a re-sync of this table to backfill the data for this column.

We have added a new column, usage_type, to the COMMUNICATION_USAGE_DATA table. Trigger a re-sync of this table to backfill the data for this column.

July 2022link

Workday HCM is a cloud-based human capital management that brings HR, recruiting, staffing, benefits administration, compensation management and related functions together in one system.

Read our Workday HCM connector documentation.

Our Workday HCM connector is now generally available. Read our Workday HCM connector documentation.

Documentation