WorkersWorkAssignmentReportsTo
Returns workers work assignment ReportsTo.
Table Specific Information
Select
The add-in 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 add-in.
- 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 | |
WorkerID | String |
Workers.WorkerID | |
ItemID | String | ||
PositionID | String | ||
ReportsToAssociateOID | String | ||
ReportsToWorkerID | String | ||
WorkerIDSchemeCode | String | ||
WorkerIDSchemeCodeShortName | String | ||
ReportsToWorkerNameFormattedName | String | ||
AsOfDate | Date |