WorkersWorkAssignmentReportsTo
The view that returns reporting relationships for worker assignments. This view identifies each associate's direct manager or supervisor and supports organizational hierarchy reporting.
Table Specific Information
Select
The connector uses the ADP API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
- AssociateOID supports the '=' comparison.
- WorkerID supports the '=' comparison.
- AsOfDate supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM WorkersWorkAssignmentReportsTo WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersWorkAssignmentReportsTo WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersWorkAssignmentReportsTo WHERE AsOfDate = '2020-01-01'
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | The unique identifier (Id) that represents the associate in the Human Resources (HR) system. This Id links the reporting relationship record to the correct worker profile. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker whose reporting relationship is being defined. This field ensures accurate linkage between the worker's record and supervisory hierarchy data. |
| ItemID | String | The Id that uniquely identifies the reporting relationship record. This field supports version control, auditing, and HR reporting structure management. | |
| PositionID | String | The Id that identifies the worker's current position within the organization. This field supports organizational hierarchy mapping and HR role assignment tracking. | |
| ReportsToAssociateOID | String | The associate Id that identifies the manager or supervisor to whom the worker reports. This field ensures accurate linkage between reporting relationships and leadership structures within HR systems. | |
| ReportsToWorkerID | String | The worker Id that identifies the supervisor or manager in the reporting relationship. This field supports consistency between HR, payroll, and organizational data. | |
| WorkerIDSchemeCode | String | The code that identifies the scheme or standard under which the worker Id is assigned (for example, ADP Worker Schema or Internal HR Schema). This field supports data governance and integration consistency. | |
| WorkerIDSchemeCodeShortName | String | The abbreviated name that corresponds to the scheme code for the worker Id. This field provides a compact label for HR reports and technical data exports. | |
| ReportsToWorkerNameFormattedName | String | The formatted name of the supervisor or manager in the reporting relationship (for example, Jane Q. Smith). This field supports human-readable hierarchy reporting and HR analytics. | |
| AsOfDate | Date | The date that defines when this reporting relationship record became effective. This field supports historical tracking, auditing, and HR compliance management. |