Connector Improvement: ADP historical data for 'Reports to' and 'Organizational Unit'
Table 'work_assignment_history' provides historical data for each work assignment. However it is not possible to match each historical work assignment to their corresponding 'reports to' and 'organizational unit' because those tables only show current status.
-
I second the request to add organizational unit to the work_assignment_history table. The main organizational unit we need is business unit. Business unit comes from the same place in ADP as the adp_workforce_now.home_work_location_name field and has the exact same effective dates, so this should be a very easy update.
I believe Fivetran is working on adding historical reports_to info via event notifications.
Please sign in to leave a comment.
Comments
1 comment