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 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 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. |