WorkersWorkAssignmentsOccupationalClassifications
The view that returns occupational classification codes for worker assignments. This view categorizes workers by occupation for regulatory compliance, labor reporting, and analytics.
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 WorkersWorkAssignmentsOccupationalClassifications WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersWorkAssignmentsOccupationalClassifications WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersWorkAssignmentsOccupationalClassifications 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 occupational classification record. This field supports Human Resources (HR) compliance reporting, workforce analytics, and integration with labor market standards. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker whose assignment is associated with the occupational classification. This field supports HR record management, employment tracking, and regulatory reporting alignment. |
| ClassificationCode | String | The code that represents the occupational classification assigned to the worker's position. This field supports HR workforce categorization, reporting to government entities, and adherence to occupational coding standards. | |
| ClassificationCodeShortName | String | The abbreviated name that corresponds to the occupational classification code. This field supports HR dashboards, summary reports, and compact displays in workforce analytics tools. | |
| ItemID | String | The Id that represents the occupational classification record for the worker's assignment. This field supports auditing, data synchronization, and version control across HR systems and reporting platforms. | |
| NameCode | String | The code that identifies the specific naming convention or group associated with the occupational classification (for example, Engineering, Administrative, or Technical). This field supports HR data organization and workforce segmentation. | |
| NameCodeShortName | String | The abbreviated name that corresponds to the code identifying the occupational classification's group or label. This field supports HR user interfaces, summarized reports, and efficient data retrieval. | |
| AsOfDate | Date | The date that defines when the occupational classification record became effective. This field supports HR auditing, historical reporting, and synchronization with compliance-driven systems. |