Workday HCM is a cloud-based human capital management that brings human resources (HR), recruiting, staffing, benefits administration, compensation management and related functions together in one system.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| Custom data | ||
| Data blocking | check | Column level and table level |
| Column hashing | check | |
| Re-sync | check | Connector level |
| History | ||
| API configurable | check | |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking |
Setup guidelink
Follow our step-by-step Workday HCM setup guide to connect Workday HCM with your destination using Fivetran connectors.
Sync overviewlink
Initial synclink
When you first connect a new account, Fivetran scans every table you selected and copies every row that we have permission to view. We import each table in full before moving onto the next table. Depending on the number and size of tables to be imported, the initial sync can take a while.
Updating datalink
Fivetran uses one of the following strategies to update the tables that you included in your sync:
Incremental
We update tables incrementally if they have a bsvc:Updated_From, bsvc:Updated_Through, bsvc:Effective_From , or bsvc:Effective_Through column.
Re-import
We re-import tables in full if they do not have a bsvc:Updated_From, bsvc:Updated_Through, bsvc:Effective_From , or bsvc:Effective_Through column. We re-import these tables once a day to avoid slowing down our syncs.
| Table Name |
|---|
| ORGANIZATION |
| JOB_CATEGORY |
| JOB_FAMILY_GROUP |
| JOB_FAMILY |
| JOB_CLASSIFICATION_GROUP |
| ORG_LEADER |
| ORGANIZATION_ROLE |
| ORGANIZATION_HIERARCHY_DETAIL |
| ORG_DOCUMENT_FIELD_RESULT |
| ORGANIZATION_ASSIGNMENT |
| SUPERVISORY_ORG_LOCATION |
| ORGANIZATION_JOB_FAMILY |
| ORGANIZATION_JOB_PROFILE |
| ORG_POSITION_GRP_POSITION_TYPE |
| JOB_FAMILY_DOCUMENT_FIELD |
| DOCUMENT_FIELD |
| JOB_CLASSIFICATION |
Schema informationlink
This schema applies to all Workday HCM connectors.