WorkAssignmentHistoryOccupationalClassifications
The view that returns historical occupational classification codes for work assignments. This view maintains standardized occupation data for regulatory reporting and labor statistics tracking.
View-Specific Information
Select
The driver uses the ADP API to process WHERE clause conditions built with the following column and operator. The AssociateOID is required to make a request, while the remaining filters are executed client-side within the driver.
- AssociateOID supports the = operator.
SELECT * FROM WorkAssignmentHistoryOccupationalClassifications WHERE AssociateOID = 'AOID4J5VGEX1620N'
Columns
| Name | Type | References | Description |
| nameCodeValue | String | The code value that identifies the occupational classification name associated with the worker's assignment. This field specifies the role or job category that defines the nature of the worker's duties (for example, Administrative, Technical, or Professional). | |
| nameCodeshortName | String | The abbreviated name that corresponds to the code for the occupational classification name. This field provides a concise label that is used in dashboards, Human Resources (HR) reports, and organizational analytics. | |
| nameCodelongName | String | The full descriptive name of the code for the occupational classification name. This field provides the complete label that appears in HR documentation, payroll systems, and compliance reports. | |
| classificationCodeValue | String | The code value that identifies the specific occupational classification standard that is applied to the worker's role (for example, SOC, ISCO, or O*NET). This field defines how the job is categorized for reporting and regulatory purposes. | |
| classificationCodeshortName | String | The abbreviated name that corresponds to the code for the occupational classification. This field provides a short label for HR dashboards, reports, and analytics summaries. | |
| classificationCodelongName | String | The full descriptive name of the code for the occupational classification. This field provides the complete label that is used in HR, compliance, and workforce planning documentation. | |
| itemID | String | The unique identifier (Id) that represents the individual occupational-classification record within the worker's assignment history. This Id enables tracking and auditing of occupational data across time. | |
| AssociateOID | String |
Workers.AssociateOID | The Id that represents the associate to whom this occupational-classification record belongs. This field links the classification record to the correct worker profile within HR and payroll systems. |