Workday Human Capital Management (HCM) link

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.

Fivetran's Workday HCM connector only supports the Compensation, Payroll, and core HCM modules.

Featureslink

NOTE: When you re-sync a child table, it automatically triggers a re-sync for the parent table and its associated child tables. When you select a child table that was previously deselected, you need to re-sync its parent table to backfill the data.

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
• Re-import

Incrementallink

We update tables incrementally if they have a bsvc:Updated_From, bsvc:Updated_Through, bsvc:Effective_From , or bsvc:Effective_Through column. We query the data with the following parameters:

<bsvc:Transaction_Log_Criteria_Data>
<bsvc:Transaction_Date_Range_Data>
    <bsvc:Updated_From>1970-01-01T16:33:18.795Z</bsvc:Updated_From>
    <bsvc:Updated_Through>2023-08-10T13:15:14.366Z</bsvc:Updated_Through>
    <bsvc:Effective_From>2023-08-08T13:15:14.366Z</bsvc:Effective_From>
    <bsvc:Effective_Through>2023-08-10T13:15:14.366Z</bsvc:Effective_Through>
</bsvc:Transaction_Date_Range_Data>
</bsvc:Transaction_Log_Criteria_Data>

<bsvc:Transaction_Log_Criteria_Data>
<bsvc:Transaction_Date_Range_Data>
    <bsvc:Updated_From>2023-08-08T13:15:14.366Z</bsvc:Updated_From>
    <bsvc:Updated_Through>2023-08-10T13:15:14.366Z</bsvc:Updated_Through>
    <bsvc:Effective_From>1970-01-01T16:33:18.795Z</bsvc:Effective_From>
    <bsvc:Effective_Through>2023-08-10T13:15:14.366Z</bsvc:Effective_Through>
</bsvc:Transaction_Date_Range_Data>
</bsvc:Transaction_Log_Criteria_Data>
content_copy

The first instance of the transaction log records any newly effective changes up to the Effective_Through date, regardless of when the change was made. This instance includes changes that were made prior to the historical sync that have since become effective.

The second instance captures any new changes that were entered since the last sync that are effective up to the Effective_Through date. This instance includes the backdated transactions that are effective prior to the historical sync.

Re-importlink

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.

NOTE: WORKER,WORKER_EVENT,JOB_PROFILE,POSITION and their respective child tables are synced incrementally. All other tables are once a day re-imported tables.

Deleted rowslink

We track deleted rows differently for parent tables and child tables:

• For parent tables, we capture soft deletes during re-syncs only. We do not capture deletes for these tables during normal syncs.
• For child tables, we capture hard deletes during both syncs and re-syncs.

Schema informationlink

This schema applies to all Workday Human Capital Management connectors.