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
toWORKER_COLLECTIVE_AGREEMENT
COLLECTIVE_AGREEMENT_FACTOR
toWORKER_COLLECTIVE_AGREEMENT_FACTOR
CONTINGENT_WORKER_CONTRACT_INFO
toWORKER_CONTINGENT_CONTRACT
LEAVE_REQUEST_DETAIL
toWORKER_LEAVE_REQUEST_DETAIL
LEAVE_STATUS
toWORKER_LEAVE_STATUS
POSITION_END_EMPLOYMENT_REASON
toWORKER_POSITION_END_EMPLOYMENT_REASON
POSITION_JOB_CLASSIFICATION
toWORKER_POSITION_JOB_CLASSIFICATION
POSITION_PAYROLL_REPORTING_CODE
toWORKER_POSITION_PAYROLL_REPORTING_CODE
SECONDARY_TERMINATION
toWORKER_SECONDARY_TERMINATION_REASON
WORKER_MANAGER
toWORKER_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.