Release Notes
October 2025
We have added a new column country_alpha_2_code to the ADDRESS table. Be sure to re-sync the table to backfill the historical data or reach out to Fivetran Support to re-sync it for you.
We unified each connector’s pre-built dbt Core*–compatible data models into a single model. It standardizes and documents the Fivetran schemas created in your destination and outputs analytics-ready tables. Previously, most connectors used distinct source and transform models.
* 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.
September 2025
We have added a new column, job_family_id, to the WORKER_POSITION_HISTORY and WORKER_POSITION tables.
We have added a new column, job_family_short_code, to the JOB_FAMILY table.
We have added the following new columns to the PAYROLL table:
arrco_agirc_category_codebusiness_unit_worktag_codecustom_worktag_06_codecustom_worktag_07_codecustom_worktag_08_codecustom_worktag_09_codecustom_worktag_10_codecustom_worktag_11_codecustom_worktag_12_codecustom_worktag_13_codecustom_worktag_14_codecustom_worktag_15_codeexemption_codefund_worktag_codegift_worktag_codegrant_worktag_codeincome_codeni_category_codeobject_class_worktag_codeprogram_worktag_codeproject_phase_worktag_codeproject_task_worktag_codetax_residency_country_codeworker_compensation_code
We have added the following new child tables to the PAYROLL table:
COMPANY_WORKTAGCOST_CENTER_WORKTAGJOB_PROFILE_WORKTAGLOCATION_WORKTAGPAYROLL_CUSTOM_ORGANIZATION_WORKTAGPAYROLL_CUSTOM_WORKTAGPAYROLL_LOCAL_CITY_AUTHORITY_TAX_WORKTAGPAYROLL_LOCAL_COUNTY_AUTHORITY_TAX_WORKTAGPAYROLL_LOCAL_OTHER_AUTHORITY_TAX_WORKTAGPAYROLL_LOCAL_SCHOOL_DISTRICT_AUTHORITY_TAX_WORKTAGPAYROLL_STATE_AUTHORITY_TAX_WORKTAGPROJECT_WORKTAGREGION_WORKTAGWITHHOLDING_ORDER_CASE_WORKTAG
August 2025
We no longer sync data for the time_calculation_tag_code column in the CALCULATED_TIME_BLOCK table. We now sync this data in the new CALCULATION_TAG table, which is a child table of CALCULATED_TIME_BLOCK.
We have removed the toggle button to choose between different OAuth authentication options in the setup form for all connections set up before February 25, 2025. For all connections, we now only support API client for integrations method if you use OAuth based authentication.
July 2025
We have added two new columns, organization_type_id and organization_type_code, to the WORKER_POSITION_ORGANIZATION table. Re-sync the table if you want to backfill historical data.
June 2025
We have added a new column, id_type, to the PERSON_IDENTITY_DOCUMENT table.
We have made the following schema changes to the ASSESS_TALENT_NOMINATION table:
- Added a new primary key column,
index - Removed the
jobProfileIdcolumn from the composite primary key
We have added a new Quickstart package for the Microsoft Dynamics 365 CRM connector.
We have updated the Quickstart packages for the following connectors:
- Connectors supporting the Ad Reporting data model to version 1.15.0.
- Connectors supporting the App Reporting data model to version 0.6.0.
- Connectors supporting the Shopify Holistic Reporting data model to version 0.8.0.
- Amazon Ads to version 0.5.0.
- Amplitude to version 0.7.0.
- Apple App Store to version 0.6.0.
- Apple Search Ads to version 0.6.0.
- Asana to version 0.9.0.
- Facebook Ads to version 0.10.0.
- Fivetran Platform to version 2.2.0.
- GitHub to version 0.9.0.
- Google Ads to version 0.14.0.
- Google Play to version 0.5.0.
- Greenhouse to version 0.9.0.
- HubSpot to version 0.24.0.
- Intercom to version 0.10.0.
- Jira to version 0.21.0.
- Klaviyo to version 0.9.0.
- Lever to version 0.8.0.
- LinkedIn Ad Analytics to version 0.12.0.
- Mailchimp to version 0.12.0.
- Microsoft Advertising to version 0.12.0.
- Mixpanel to version 0.13.0.
- NetSuite SuiteAnalytics to version 0.20.0.
- Pendo to version 0.6.0.
- Pinterest Ads to version 0.13.0.
- QuickBooks to version 0.20.0.
- Recurly to version 0.7.0.
- Reddit Ads to version 0.5.0.
- Sage Intacct to version 0.7.0.
- Salesforce to version 1.3.0.
- Snapchat Ads to version 0.10.0.
- Stripe to version 0.19.0.
- TikTok Ads to version 0.9.0.
- Twilio to version 0.5.0.
- Twitter Ads to version 0.10.0.
- Workday HCM to version 0.4.0.
- Zendesk Support to version 0.24.1.
May 2025
We have made the following schema changes to the connector:
| Table Name(s) | Deprecated Primary Key Column(s) |
|---|---|
WORKER_COSTING_ALLOCATION_INTERVAL | id |
WORKER_COSTING_ALLOCATION_DETAIL | worker_costing_allocation_interval_id |
SALARY_OVER_THE_CAP_COSTING_ALLOCATION_DETAIL | worker_costing_allocation_interval_id |
| Table Name(s) | New Primary Key Column(s) |
|---|---|
WORKER_COSTING_ALLOCATION_INTERVAL | index |
WORKER_COSTING_ALLOCATION_DETAIL | worker_costing_allocation_interval_index |
SALARY_OVER_THE_CAP_COSTING_ALLOCATION_DETAIL | worker_costing_allocation_interval_index |
| Table Name | New Column |
|---|---|
WORKER_COSTING_ALLOCATION_INTERVAL | costing_override_code |
March 2025
We have added the following new tables to support the Performance_Management module:
ACCOMPLISHMENT_COMPONENTACCOMPLISHMENT_SECTIONADDITIONAL_MANAGER_ACCOMPLISHMENT_COMPONENTADDITIONAL_MANAGER_ACCOMPLISHMENT_SECTIONADDITIONAL_MANAGER_CAREER_SECTIONADDITIONAL_MANAGER_COMPETENCY_COMPONENTADDITIONAL_MANAGER_COMPETENCY_SECTIONADDITIONAL_MANAGER_DEVELOPMENT_ITEM_COMPONENTADDITIONAL_MANAGER_DEVELOPMENT_ITEM_SECTIONADDITIONAL_MANAGER_FEEDBACK_SECTIONADDITIONAL_MANAGER_GOAL_COMPONENTADDITIONAL_MANAGER_GOAL_SECTIONADDITIONAL_MANAGER_OVERALL_EVALUATIONADDITIONAL_MANAGER_QUESTION_COMPONENTADDITIONAL_MANAGER_QUESTION_SECTIONADDITIONAL_MANAGER_RESPONSIBILITY_COMPONENTADDITIONAL_MANAGER_RESPONSIBILITY_SECTIONCAREER_INTEREST_COMPONENTCAREER_SECTIONCOMPETENCY_COMPONENTCOMPETENCY_SECTIONDEVELOPMENT_AREA_COMPONENTDEVELOPMENT_ITEM_COMPONENTDEVELOPMENT_ITEM_SECTIONEMPLOYEE_REVIEWFEEDBACK_SECTIONGOAL_COMPONENTGOAL_MILESTONE_DETAILGOAL_SECTIONOVERALL_EVALUATIONPOST_EVALUATION_FEEDBACKQUESTION_COMPONENTQUESTION_SECTIONRESPONSIBILITY_COMPONENTRESPONSIBILITY_SECTIONREVIEW_QUESTIONREVIEW_QUESTION_CATEGORYREVIEW_TYPE
Our Workday HCM connector now allows you to select between an API client and an API client for integrations on the setup page when configuring the connector. For more information, see our Workday HCM connector documentation.
February 2025
Our Workday HCM connector now supports the Workday Talent module. To support this enhancement, we have added the following new tables:
ASSESS_TALENTASSESS_TALENT_NOMINATIONCALIBRATION_PROGRAMCALIBRATION_VALUE_MAPCELL_TARGET_PERCENTAGETALENT_POOLTALENT_POOL_WORKER
We have added the following new tables to support the Learning Module:
LEARNING_COURSE_ADVANCED_PRICING_RULELEARNING_COURSE_CONTACT_PERSONLEARNING_COURSE_LANGUAGELEARNING_COURSE_OFFERINGLEARNING_COURSE_OFFERING_DATALEARNING_COURSE_OFFERING_DATA_FROM_COURSELEARNING_COURSE_OFFERING_DETAILLEARNING_COURSE_OFFERING_LESSONLEARNING_COURSE_OTHER_UNIT_TYPELEARNING_COURSE_SALES_ITEMLEARNING_ENROLLMENTLEARNING_LESSONLEARNING_LESSON_LANGUAGELEARNING_LESSON_SKILLLEARNING_LESSON_TOPIC
We are gradually rolling out these features to all existing connections. If you have any questions, contact our Support team.
November 2024
We have added the following new tables:
ADDRESS_USE_FOR_REFERENCEADDRESS_USE_FOR_TENANTED_REFERENCEADDRESS_USAGE_TYPEETHNICITYGENDER_IDENTITYLGBT_IDENTIFICATIONLOCATIONLOCATION_ADDRESSLOCATION_HIERARCHYLOCATION_TYPELOCATION_USAGEPRONOUNQUALIFICATION_AWARD_AND_ACTIVITYQUALIFICATION_CERTIFICATIONQUALIFICATION_CERTIFICATION_ATTACHMENTQUALIFICATION_COMPETENCY_ACHIEVEMENTQUALIFICATION_EDUCATIONQUALIFICATION_INTERNAL_PROJECT_EXPERIENCEQUALIFICATION_JOB_HISTORY_ACHIEVEMENTQUALIFICATION_LANGUAGEQUALIFICATION_LANGUAGE_ABILITYQUALIFICATION_PROFESSIONAL_AFFILIATIONQUALIFICATION_SPECIALITY_ACHIEVEMENTQUALIFICATION_TRAININGQUALIFICATION_WORK_EXPERIENCESALARY_OVER_THE_CAP_COSTING_ALLOCATION_DETAILSEXUAL_ORIENTATIONWORKER_ALLOWANCE_PLANWORKER_BONUS_PLANWORKER_COMMMISION_PLANWORKER_COSTING_ALLOCATIONWORKER_COSTING_ALLOCATION_DETAILWORKER_COSTING_ALLOCATION_INTERVALWORKER_FUTURE_PAYMENT_PLANWORKER_MERIT_PLANWORKER_PERIOD_SALARY_PLANWORKER_SALARY_AND_HOURLYWORKER_UNIT_ALLOWANCE_PLANWORKER_UNIT_SALARY_PLAN
We have added the following columns to the WORKER and WORKER_HISTORY tables:
user_namesimplified_viewuser_language_codepreferred_language_codelocale_codehour_clock_codecurrency_codecurrency_numeric_codetime_zone_codedisplay_language_code
We are gradually rolling out these changes to all the existing connections.
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_INCOMINGJOB_REQUISITION_ADDITIONAL_LOCATIONJOB_REQUISITION_ADDITIONAL_JOB_PROFILEJOB_REQUISITION_ADDITIONAL_JOB_POSTING_LOCATIONJOB_REQUISITION_ALLOWANCE_PLANJOB_REQUISITION_BONUS_PLANJOB_REQUISITION_CALCULATED_PLANJOB_REQUISITION_CERTIFICATIONJOB_REQUISITION_CERTIFICATION_SPECIALTYJOB_REQUISITION_CERTIFICATION_SUBSPECIALTYJOB_REQUISITION_COMMISSION_PLANJOB_REQUISITION_COMPENSATIONJOB_REQUISITION_COMPETENCYJOB_REQUISITION_CUSTOM_ORGANIZATIONJOB_REQUISITION_DEFAULT_ASSESSMENT_TESTJOB_REQUISITION_DOCUMENT_FIELDJOB_REQUISITION_EDUCATIONJOB_REQUISITION_LANGUAGEJOB_REQUISITION_LANGUAGE_ABILITYJOB_REQUISITION_MERIT_PLANJOB_REQUISITION_ORGANIZATIONJOB_REQUISITION_PAY_PLANJOB_REQUISITION_PERIOD_SALARY_PLANJOB_REQUISITION_POSITIONJOB_REQUISITION_RESPONSIBILITYJOB_REQUISITION_ROLE_ASSIGNMENTJOB_REQUISITION_ROLE_ASSIGNEEJOB_REQUISITION_SKILLJOB_REQUISITION_STOCK_PLANJOB_REQUISITION_TRAININGJOB_REQUISITION_WORK_EXPERIENCEJOB_REQUISITION_UNIT_ALLOWANCE_PLANJOB_REQUISITION_UNIT_SALARY_PLANLINKED_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 connections.
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_INPUTCARRYOVER_OVERRIDECARRYOVER_OVERRIDE_BALANCEOVERRIDE_BALANCETIME_OFF_PLAN_BALANCETIME_OFF_PLAN_BALANCE_POSITION
To support the Time Tracking module, we have added the
CALCULATED_TIME_BLOCKtable.
To sync these tables, enable the security domains necessary for these modules. We are gradually rolling out these changes to all existing connections.
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_HISTORYWORKER_HISTORYWORKER_PAY_GROUP_ASSIGNMENT_HISTORYWORKER_POSITION_HISTORYWORKER_POSITION_COMPENSATION_HISTORYWORKER_POSITION_JOB_CLASSIFICATION_HISTORYWORKER_POSITION_ORGANIZATION_HISTORYWORKER_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 connections.
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 connections created before October 6, 2023:
We have added the following new tables:
POSITION_ORGANIZATIONPOSITION_WORKER_TYPE_RESTRICTIONCOMMUNICATION_USAGEORGANIZATION_POSITION_GROUP_POSITIONORGANIZATION_LEADERORGANIZATION_POSITION_GROUP_POSITIONORGANIZATION_DOCUMENT_FIELD_RESULTSUPERVISORY_ORGANIZATION_LOCATION
We will stop syncing the following tables after October 13, 2023
COMMUNICATION_USAGE_DATAORG_DOCUMENT_FIELD_RESULTORG_JOB_PROFILE_EXEMPTORG_LEADERORG_POSITION_GRP_POSITION_TYPEPOSITION_COMPANY_ASSIGNMENTPOSITION_COST_CENTER_ASSIGNMENTPOSITION_CUSTOM_ORGANIZATION_ASSIGNMENTPOSITION_JOB_PROFILE_EXEMPTPOSITION_REGION_ASSIGNMENTPOSITION_STATUSPOSITION_WORKER_TYPE_REFERENCESUPERVISORY_ORG_LOCATIONWORKER_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:
CANDIDATECANDIDATE_CERTIFICATIONCANDIDATE_EDUCATIONCANDIDATE_EXPERIENCECANDIDATE_GOVERNMENT_IDCANDIDATE_LANGUAGECANDIDATE_NAMECANDIDATE_NATIONAL_IDCANDIDATE_POOL_MEMBERSHIPCANDIDATE_SKILLCANDIDATE_SOCIAL_MEDIA_ACCOUNTCANDIDATE_TAGCANDIDATE_WEBSITEEXTERNAL_REFERENCE_LINEEXTERNAL_REFERENCE_PARTICIPANTINTERVIEWINTERVIEW_COMPETENCYFEEDBACK_COMPETENCY_ASSESSMENTINTERVIEW_FEEDBACKINTERVIEW_FEEDBACK_DETAILINTERVIEW_SESSIONINTERVIEW_SESSION_DETAILINTERVIEW_QUESTIONNAIREINTERVIEWERJOB_APPLICATIONJOB_APPLIED_TOMULTIPLE_CHOICE_ANSWERPRE_HIREPRE_HIRE_REFERRED_BY_WORKERPRE_HIRE_POSITIONS_CONSIDEREDPRE_HIRE_BACKGROUND_CHECK_STATUSPRE_HIRE_RESUMEPRE_HIRE_EDUCATIONPRE_HIRE_JOB_HISTORYPRE_HIRE_TRAINING_ACHIEVEMENTPRE_HIRE_INTERNAL_PROJECT_EXPERIENCEPRE_HIRE_COMPETENCY_ACHIEVEMENTPRE_HIRE_CERTIFICATION_ACHIEVEMENTPRE_HIRE_LANGUAGE_ACHIEVEMENTPRE_HIRE_LANGUAGE_ABILITYPRE_HIRE_WORK_EXPERIENCEPRE_HIRE_PROFESSIONAL_AFFILIATIONPRE_HIRE_AWARD_AND_ACTIVITYQUESTIONNAIREQUESTIONNAIRE_ANSWERQUESTIONNAIRE_SETUPSCORE_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 connections.
September 2023
We have made the following schema changes for the Workday HCM connections 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_ACHIEVEMENTLANGUAGE_ABILITY_PROFILEUNION_MEMBERSHIPWORKER_COMPENSATIONWORK_STUDY
Be sure to update your queries.
We have added the following new tables:
COMPENSATION_GRADEJOB_PROFILE_CERTIFICATION_SPECIALTYJOB_PROFILE_COMPENSATION_GRADE_PROFLEJOB_PROFILE_LANGUAGE_ABILITYJOB_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 connector. 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 connections. 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 connections. 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_DATABENCHMARK_JOBBENCHMARK_JOB_AND_JOB_PROFILEBENCHMARK_JOB_COMPOSITE_DATABENCHMARK_JOB_PROFILE_DATACOMPENSATION_ALLOWANCE_PLAN_AMOUNT_PROFILECOMPENSATION_ALLOWANCE_PLAN_PERCENT_PROFILECOMPENSATION_ALLOWANCE_PLAN_UNIT_PROFILECOMPENSATION_BONUS_PLAN_COVERAGE_ELIGIBILITY_RULECOMPENSATION_BONUS_PLAN_PERFORMANCE_FACTOR_SCORECARDCOMPENSATION_BONUS_PLAN_REPLACEMENT_AMOUNTCOMPENSATION_BONUS_PLAN_REPLACEMENT_PERCENTCOMPENSATION_BONUS_TRANCHECOMPENSATION_COMMISSION_PLAN_PROFILECOMPENSATION_ELIGIBILITY_COMPENSATION_GRADECOMPENSATION_ELIGIBILITY_COMPENSATION_GRADE_PROFILECOMPENSATION_ELIGIBILITY_COMPENSATION_PACKAGECOMPENSATION_ELIGIBILITY_COMPENSATION_PLANCOMPENSATION_ELIGIBILITY_RULECOMPENSATION_ELIGIBILITY_RULE_CONDITIONCOMPENSATION_ELIGIBILITY_RULE_CONDITION_CATEGORYCOMPENSATION_ELIGIBILITY_RULE_COUNTRYCOMPENSATION_FUTURE_ONE_TIME_PAYMENT_PLANCOMPENSATION_FUTURE_PAYMENT_BONUS_PLANCOMPENSATION_MATRIXCOMPENSATION_MATRIX_AMOUNTCOMPENSATION_MATRIX_PERCENTCOMPENSATION_MATRIX_TARGET_RULECOMPENSATION_MERIT_PLAN_REPLACEMENT_AMOUNTCOMPENSATION_MERIT_PLAN_REPLACEMENT_PERCENTCOMPENSATION_PERIOD_PLAN_PROFILECOMPENSATION_PLANCOMPENSATION_PLAN_ELIGIBILITY_RULECOMPENSATION_STOCK_PLAN_AMOUNT_PROFILECOMPENSATION_STOCK_PLAN_GRANT_SPLITCOMPENSATION_STOCK_PLAN_PERCENT_PROFILECOMPENSATION_STOCK_PLAN_PROFILE_GRANT_SPLITCOMPENSATION_STOCK_PLAN_UNIT_PROFILEDEFERRED_COMPENSATION_ELIGIBILITY_RULEDEFERRED_COMPENSATION_PROFILESCORECARDSCORECARD_GOALSCORECARD_PROFILESCORECARD_PROFILE_GOAL
We have added the following new tables to support the Payroll module:
PAY_ACCUMULATIONPAYROLLPAYROLL_DEDUCTION_INSTANT_MESSENGERPAYROLL_LINEPAYROLL_LINE_PAY_COMPONENTPAYROLL_LINE_RELATED_CALCULATIONPAYROLL_LINE_WITHHOLDINGPAYROLL_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_LOCATIONALLOWANCE_PLANBONUS_PLANCALCULATED_PLANCOMMISSION_PLANJOB_PROFILE_RESTRICTION_JOB_FAMILYJOB_REQUISITIONMERIT_PLANPAY_PLANPERIOD_SALARY_PLANPOSITION_CERTIFICATIONPOSITION_CERTIFICATION_SPECIALITYPOSITION_COMPANY_ASSIGNMENTPOSITION_COMPETENCYPOSITION_COST_CENTER_ASSIGNMENTPOSITION_CUSTOM_ORGANIZATION_ASSIGNMENTPOSITION_DOCUMENT_FIELD_RESULTPOSITION_EDUCATIONPOSITION_JOB_FAMILYPOSITION_JOB_PROFILEPOSITION_JOB_PROFILE_EXEMPTPOSITION_LANGUAGEPOSITION_LANGUAGE_ABILITYPOSITION_LOCATIONPOSITION_REGION_ASSIGNMENTPOSITION_RESPONSIBILITYPOSITION_STATUSPOSITION_SKILLPOSITION_TRAININGPOSITION_WORK_EXPERIENCEPOSITION_WORKER_TYPE_REFERENCESTOCK_PLANUNIT_ALLOWANCE_PLANUNIT_SALARY_PLAN
We have removed the following columns from the POSITION table:
academic_pay_setup_data_*business_site_summary_*business_titledefault_weekly_hoursend_dateend_employment_dateexclude_from_headcountfederal_withholding_feinfull_time_equivalent_percentageheadcount_restriction_idinternational_assignment_data_*is_primary_jobjob_exemptjob_profile_idpaid_ftepay_rate_typepay_through_datepayroll_interface_processing_*position_time_typeposition_titleregular_paid_equivalent_hoursscheduled_weekly_hoursspecify_paid_ftespecify_working_ftestart_datework_hours_profilework_shiftwork_spaceworker_hours_profile_classificationworker_idworking_fteworking_time_frequencyworking_time_unitworking_time_value
We have changed the primary keys in the following tables:
EMPLOYEE_PROBATION_PERIOD_DETAILPOSITIONWORKER_COLLECTIVE_AGREEMENTWORKER_POSITION_COMPENSATIONWORKER_POSITION_END_EMPLOYMENT_REASONWORKER_POSITION_JOB_CLASSIFICATIONWORKER_POSITION_MANAGERWORKER_POSITION_ORGANIZATIONWORKER_POSITION_PAYROLL_REPORTING_CODE
We have renamed the following tables:
COLLECTIVE_AGREEMENTtoWORKER_COLLECTIVE_AGREEMENTCOLLECTIVE_AGREEMENT_FACTORtoWORKER_COLLECTIVE_AGREEMENT_FACTORCONTINGENT_WORKER_CONTRACT_INFOtoWORKER_CONTINGENT_CONTRACTLEAVE_REQUEST_DETAILtoWORKER_LEAVE_REQUEST_DETAILLEAVE_STATUStoWORKER_LEAVE_STATUSPOSITION_END_EMPLOYMENT_REASONtoWORKER_POSITION_END_EMPLOYMENT_REASONPOSITION_JOB_CLASSIFICATIONtoWORKER_POSITION_JOB_CLASSIFICATIONPOSITION_PAYROLL_REPORTING_CODEtoWORKER_POSITION_PAYROLL_REPORTING_CODESECONDARY_TERMINATIONtoWORKER_SECONDARY_TERMINATION_REASONWORKER_MANAGERtoWORKER_POSITION_MANAGER
We will discontinue the old tables in July, 2023. However, for connections created before April 17, 2023, we will continue to support both the old and renamed tables till we discontinue the old tables. For connections created after April 17, 2023, the schema contains only the renamed tables.
We are gradually rolling out these changes to all existing connections. 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.