Release Notes

October 2024

The Workday HCM connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

We have renamed the existing JOB_REQUISITION table to JOB_REQUISITION_BACKUP_2024_10_28. We will stop syncing data to the JOB_REQUISITION_BACKUP_2024_10_28 table after October 28, 2024.

We have renamed the JOB_REQUISITION_INCOMING table to JOB_REQUISITION. Be sure to update your queries.

July 2024

We have added the following new tables:

JOB_REQUISITION_INCOMING
JOB_REQUISITION_ADDITIONAL_LOCATION
JOB_REQUISITION_ADDITIONAL_JOB_PROFILE
JOB_REQUISITION_ADDITIONAL_JOB_POSTING_LOCATION
JOB_REQUISITION_ALLOWANCE_PLAN
JOB_REQUISITION_BONUS_PLAN
JOB_REQUISITION_CALCULATED_PLAN
JOB_REQUISITION_CERTIFICATION
JOB_REQUISITION_CERTIFICATION_SPECIALTY
JOB_REQUISITION_CERTIFICATION_SUBSPECIALTY
JOB_REQUISITION_COMMISSION_PLAN
JOB_REQUISITION_COMPENSATION
JOB_REQUISITION_COMPETENCY
JOB_REQUISITION_CUSTOM_ORGANIZATION
JOB_REQUISITION_DEFAULT_ASSESSMENT_TEST
JOB_REQUISITION_DOCUMENT_FIELD
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_ROLE_ASSIGNMENT
JOB_REQUISITION_ROLE_ASSIGNEE
JOB_REQUISITION_SKILL
JOB_REQUISITION_STOCK_PLAN
JOB_REQUISITION_TRAINING
JOB_REQUISITION_WORK_EXPERIENCE
JOB_REQUISITION_UNIT_ALLOWANCE_PLAN
JOB_REQUISITION_UNIT_SALARY_PLAN
LINKED_JOB_REQUISITION

To sync these tables, you must enable the security domains necessary for the Recruiting module. We are gradually rolling out these changes to all the existing connectors.

May 2024

We now support OAuth authentication to connect to Workday HCM.

April 2024

Our Workday HCM connector now supports Workday's Absence Management and Time Tracking modules. To support this enhancement, we have added the following new tables:

To support the Absence Management module, we have added:
- ABSENCE_INPUT
- CARRYOVER_OVERRIDE
- CARRYOVER_OVERRIDE_BALANCE
- OVERRIDE_BALANCE
- TIME_OFF_PLAN_BALANCE
- TIME_OFF_PLAN_BALANCE_POSITION
To support the Time Tracking module, we have added the CALCULATED_TIME_BLOCK table.

To sync these tables, enable the security domains necessary for these modules. We are gradually rolling out these changes to all existing connectors.

February 2024

We have added support for Workday Custom and Calculated fields. For more information about configuring custom and calculated fields, see our documentation, setup instructions, and REST API.

We have released a pre-built, dbt Core-compatible data model for Workday HCM. Find the model in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

We have added new Quickstart packages for the following connectors:

January 2024

We have added the following new tables:

PERSONAL_INFORMATION_HISTORY
WORKER_HISTORY
WORKER_PAY_GROUP_ASSIGNMENT_HISTORY
WORKER_POSITION_HISTORY
WORKER_POSITION_COMPENSATION_HISTORY
WORKER_POSITION_JOB_CLASSIFICATION_HISTORY
WORKER_POSITION_ORGANIZATION_HISTORY
WORKER_POSITION_PAYROLL_REPORTING_CODE_HISTORY

To sync these tables, you must enable the security domains necessary for the HR module. We are gradually rolling out these changes to all existing connectors.

December 2023

We have added a new field, Workday Tenant, to the connector setup form to allow you to specify your Workday tenant. Previously, you had to specify it together with your Workday username in the {Workday_Username}@{Tenant} format.

We have restored the position_time_type column in the WORKER_POSITION table to track employee time type changes (for example, full-time to part-time). The position_time_type_code column in the POSITION table does not capture the employee time type changes. Be sure to re-sync the WORKER table to backfill the historical data for this column or contact our support team to re-sync it for you.

October 2023

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

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 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 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 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 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 have added two new columns, compensation_grade_id and compensation_grade_profile_id, to the WORKER table. Be sure to re-sync the WORKER table to backfill the data for these columns or contact Fivetran Support to re-sync it for you.

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

September 2023

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

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 September 15, 2023:

CERTIFICATION_SPECIALTY_ACHIEVEMENT
LANGUAGE_ABILITY_PROFILE
UNION_MEMBERSHIP
WORKER_COMPENSATION
WORK_STUDY

Be sure to update your queries.

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 2023

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 2023

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 2023

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 2023

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 2022

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 2022

Workday HCM is a cloud-based human capital management platform 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.