WorkersWorkAssignmentsHomeOrganizationalUnits
The view that returns home organizational unit data for worker assignments. This view identifies the primary organizational unit that is associated with each worker for payroll allocation and hierarchy reporting.
Table Specific Information
Select
The component 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 component.
- AssociateOID supports the '=' comparison.
- WorkerID supports the '=' comparison.
- AsOfDate supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM WorkersWorkAssignmentsHomeOrganizationalUnits WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersWorkAssignmentsHomeOrganizationalUnits WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersWorkAssignmentsHomeOrganizationalUnits 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 home organizational unit record. This field supports Human Resources (HR) reporting, hierarchy management, and workforce alignment. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker assigned to the home organizational unit. This field supports HR recordkeeping, reporting structure validation, and position tracking. |
| ItemID | String | The Id that represents the specific home organizational-unit entry for the worker. This field supports HR data integrity, version control, and historical audit accuracy. | |
| NameCodeValue | String | The code that identifies the name of the home organizational unit (for example, Corporate Headquarters or Manufacturing Division). This field supports structured HR organization mapping and departmental classification. | |
| NameCodeLongName | String | The full descriptive name of the home organizational-unit code. This field provides clarity in HR documentation, organizational charts, and system reporting. | |
| NameCodeShortName | String | The abbreviated name that corresponds to the home organizational-unit code. This field supports concise HR displays and compact data exports. | |
| TypeCodeValue | String | The code that specifies the type of organizational unit (for example, Department, Division, or Business Segment). This field supports HR structural categorization and workflow routing. | |
| TypeCodeLongName | String | The full descriptive name of the type code for the organizational unit. This field provides clarity for HR structure documentation and reporting. | |
| TypeCodeShortName | String | The abbreviated name that corresponds to the type code for the organizational unit. This field supports space-efficient HR dashboards and export views. | |
| AsOfDate | Date | The date that defines when the home organizational-unit record became effective. This field supports HR historical tracking, audit compliance, and organizational change management. |