Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Workday HCM: Add flags to identify rescinded and corrected transactions in worker_history

Answered
Michael Kam User

Hi Fivetran team,

We have found that the `worker_event` table contains rescinded or corrected Termination transactions, however there is no columns or flags to identify these transactions. I am aware that these are not provided in Get_Worker_Event_History but provided in Get_Worker endpoint in Transaction_Log_Data. 

As these transactions include more than `worker_pay_group_assignment_history` records, could we have the event_rescinded  and event_corrected columns also in `worker_history` table?

Thank you,
Michael

Please sign in to leave a comment.

Comments

3 comments

Date Votes
  • Official comment
    Frank Fivetranner

    Hi Michael, 

    Thanks for submitting this feature request. We will have to investigate to see if it's feasible to implement this request and I will add it to our backlog. 

    Frank

  • Michael Kam User

    An alternative way would be to soft delete the rescinded transactions in `worker_event` table.

  • Michael Kam User
    • Edited

    Hey Frank,

    Thanks for looking into this.
    After reviewing this feature request, it seems these rescinded business transactions should be soft deleted in `worker_event` table. When I tested this using Workday SOAP API, the rescinded transactions are not returned anymore by the endpoint. Hence, would it be possible when Fivetran runs a sync to check if any of the events are no longer returned by the API should be marked as _fivetran_deleted = TRUE?

    The current use case we have is to report on termination events or business processes, and this becomes problematic if in our report we include rescinded termination events.

    Thank you.
    Michael