WorkersWorkAssignmentsWorkerGroups
The view that returns worker group associations within work assignments. This view identifies teams, projects, or groups that workers are assigned to for management and operational reporting.
Table Specific Information
Select
The driver 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 driver.
- AssociateOID supports the '=' comparison.
- WorkerID supports the '=' comparison.
- AsOfDate supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM WorkersWorkAssignmentsWorkerGroups WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersWorkAssignmentsWorkerGroups WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersWorkAssignmentsWorkerGroups WHERE AsOfDate = '2020-01-01'
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | The unique identifier (Id) that represents the associate linked to the worker group record. This field supports Human Resources (HR) recordkeeping, data synchronization, and workforce assignment tracking. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker whose assignment is associated with a specific worker group. This field supports HR data integration, workforce categorization, and reporting alignment across systems. |
| GroupCode | String | The code that identifies the worker group to which the assignment belongs. This field supports HR grouping logic, payroll integration, and organization-based analytics. | |
| GroupCodeLongName | String | The full descriptive name that corresponds to the worker group code. This field supports HR documentation, compliance reports, and workforce segmentation analysis. | |
| GroupCodeShortName | String | The abbreviated name that corresponds to the worker group code. This field supports HR dashboards, summary reporting, and system interfaces that require compact field names. | |
| ItemID | String | The Id that represents the individual worker group record associated with a work assignment. This field supports data tracking, version control, and auditability across HR and payroll systems. | |
| NameCode | String | The code that defines the naming convention or type of group that is associated with the worker assignment (for example, Union, Departmental, or Project). This field supports HR organization mapping and workforce classification. | |
| NameCodeLongName | String | The full descriptive name that corresponds to the code defining the type of worker group. This field supports HR reporting, workforce analysis, and compliance documentation. | |
| NameCodeShortName | String | The abbreviated name that corresponds to the code defining the worker group. This field supports HR summaries, user interfaces, and integration with external workforce systems. | |
| AsOfDate | Date | The date that defines when the worker group record became effective. This field supports HR historical tracking, auditing, and synchronization across workforce management systems. |