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

Community

Connector Improvement: Workday HCM model does not support reporting historical managers

Not planned
Brad Teague User

While there is a WORKER_POSITION_ORGANIZATION_HISTORY table that identifies the ORGANIZATION_ID for a WORKER and POSITION at a point in time based on the _FIVETRAN_START and _FIVETRAN_END timestamps, the ORGANIZATION table's MANAGER_ID is an "SCD Type 1" and there isn't an ORGANIZATION_HISTORY table that will tell me what the MANAGER_ID might have been for the same point in time. This wouldn't be a problem if there was a WORKER_POSITION_MANAGER_HISTORY table, but that is missing as well.

Please sign in to leave a comment.

Comments

3 comments

Date Votes
  • Official comment
    Frank Fivetranner

    Hi Brad, 

    Unfortunately, we looked into having a manager history table, but there was a limitation with how the Workday API returned data around managers that made it difficult to support at the time. The manager ID was always being returned as the latest manager instead of the historical manager at that time which was confirmed by Workday making it not possible to create manager history. Hope that helps. 

    Thanks, 

    Frank

  • Brad Teague User

    As WORKER_POSITION_HISTORY is a Fivetran-changed-tracked version of WORKER_POSITION, could we simply add MANAGER_ID to the Worker Position History change tracking process?

  • Frank Fivetranner

    Hi Brad, 

    For Workday we generate the history from effective dates and for the managers if we call the endpoint at a historical effective date it still will give us the most recent manager so it's not possible to construct history.

    Thanks, 

    Frank