WorkersWorkAssignmentsAssignedOrganizationalUnits
The view that returns the organizational units that are assigned to each worker's work assignment. This view links employees to departments or divisions for workforce management and financial reporting.
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 WorkersWorkAssignmentsAssignedOrganizationalUnits WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersWorkAssignmentsAssignedOrganizationalUnits WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersWorkAssignmentsAssignedOrganizationalUnits WHERE AsOfDate = '2020-01-01'
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | The unique identifier (Id) that represents the associate who is linked to the assigned organizational unit. This field supports Human Resources (HR) tracking, payroll alignment, and workforce reporting. |
| WorkerID | String |
Workers.WorkerID | The Id that represents the worker whose assignment includes the specified organizational unit. This field supports HR personnel management and organizational mapping. |
| ItemID | String | The unique Id that represents the assigned organizational unit record. This field supports HR data integrity and assignment history tracking. | |
| NameCode | String | The code that identifies the name or label for the assigned organizational unit (for example, Department A, Sales, or Division 1). This field supports HR structure mapping and reporting. | |
| NameCodeLongName | String | The full descriptive name of the assigned organizational unit. This field provides clarity in HR documentation, reporting, and analytics. | |
| NameCodeShortName | String | The abbreviated name that corresponds to the organizational unit. This field supports compact HR displays, payroll reports, and data exports. | |
| TypeCode | String | The code that identifies the type or classification of the assigned organizational unit (for example, Department, Division, or Cost Center). This field supports HR categorization and payroll organization. | |
| TypeCodeLongName | String | The full descriptive name of the type code for the organizational unit. This field provides clear context in HR reporting and system configuration. | |
| TypeCodeShortName | String | The abbreviated name that corresponds to the type code for the organizational unit. This field supports compact HR reporting and consistent data exports. | |
| AsOfDate | Date | The date that defines when the assignment to the organizational unit is effective. This field supports HR historical tracking, payroll synchronization, and compliance reporting. |