JobRequisitionsOrganizationalUnits
The view that returns organizational unit details that are associated with each job requisition. It enables mapping between requisitions and the company's hierarchical structure for planning and reporting.
Table Specific Information
Select
No filters are supported server side for this table. All criteria will be handled client side within the connector.
For example, the following query is processed server side:
SELECT * FROM JobRequisitionsOrganizationalUnits
Columns
| Name | Type | References | Description |
| JobRequisitionID | String | The unique identifier (Id) that represents the job requisition record. This Id links the requisition to its corresponding organizational units in ADP. | |
| OrganizationalUnitID | String | The Id that identifies the organizational unit that is associated with the job requisition. This Id establishes the reporting or departmental relationship between the position and its organizational structure. | |
| typeCodeValue | String | The code that identifies the type of organizational unit (for example, Department, Division, or Region). This code supports classification and filtering of requisition data. | |
| typeCodeShortName | String | The short descriptive name that corresponds to the organizational unit type code. This field provides a concise label for use in reports and dashboards. | |
| nameCodeValue | String | The code that identifies the specific organizational unit name that is linked to the job requisition. This code is used for cross-referencing and reporting. | |
| nameCodeShortName | String | The short descriptive name that represents the organizational unit name code. This field provides a readable label for display in user interfaces and analytics. |