termination_date Field Has a
Updated 13 days ago
termination_date field in the
WORKER table displays a NULL value.
Connector: Workday HCM
termination_date using the
effective_date of employees in the
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'content_copy
This issue is caused by a Workday API limitation, which causes the connector to incrementally receive data by modifying the
Fivetran sets the
As_Of_Effective_Date to the present date to receive the correct values for the
Active fields. However, the
Termination_Date will be received from the API and synced to the destination when it becomes effective.