The termination_date Field Has a null Value

Issue

The termination_date field in the WORKER table displays a NULL value.

Environment

Connector: Workday HCM

Resolution

Find the termination_date using the effective_date of employees in the WORKER and WORKER_EVENT tables. Use the following SQL query:

select worker_id, event_type, effective_date from <connector_name>.worker_event we  
join <connector_name>.worker w on we.worker_id = w.id
where we.effective_date > CURRENT_DATE() and we.event_type = 'Termination'

Cause

This issue is caused by a Workday API limitation, which causes the connector to incrementally receive data by modifying the As_Of_Effective_Date field.

Fivetran sets the As_Of_Effective_Date to the present date to receive the correct values for the Terminated and Active fields. However, the Termination_Date will be received from the API and synced to the destination when it becomes effective.