WorkersWorkAssignmentsIndustryClassifications
The view that returns industry classification data for worker assignments. This view aligns job functions and departments with industry-standard classification codes that are used in compliance and statistical reporting.
Table Specific Information
Select
The driver 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 driver.
- AssociateOID supports the '=' comparison.
- WorkerID supports the '=' comparison.
- AsOfDate supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM WorkersWorkAssignmentsIndustryClassifications WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersWorkAssignmentsIndustryClassifications WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersWorkAssignmentsIndustryClassifications 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 industry classification record for the work assignment. This field supports Human Resources (HR) data management, compliance tracking, and reporting alignment across organizational systems. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker whose assignment is associated with a specific industry classification. This field supports HR workforce segmentation, analytics, and integration with payroll and compliance systems. |
| ClassificationCode | String | The code that identifies the industry classification applicable to the worker's assignment. This field supports HR categorization, regulatory compliance, and reporting aligned with standard industry codes. | |
| ClassificationCodeLongName | String | The full descriptive name that corresponds to the industry classification code. This field supports HR documentation, labor analytics, and compliance reporting with detailed classification context. | |
| ClassificationCodeShortName | String | The abbreviated name that represents the industry classification code. This field supports compact HR dashboards, summaries, and other views where concise labeling is required. | |
| ItemID | String | The Id that represents the industry classification record for the worker's assignment. This field supports record traceability, version control, and synchronization across HR and payroll systems. | |
| NameCode | String | The code that identifies the name or label assigned to the industry classification entry (for example, Manufacturing, Retail, or Healthcare). This field supports HR categorization and reporting automation. | |
| NameCodeLongName | String | The full descriptive name associated with the code that classifies the worker's industry assignment. This field supports HR compliance documentation, reporting accuracy, and workforce analytics. | |
| NameCodeShortName | String | The abbreviated name that corresponds to the code that is used to identify the industry classification. This field supports compact HR dashboards and data exports. | |
| AsOfDate | Date | The date that defines when the industry classification record became effective. This field supports HR auditing, historical tracking, and system synchronization for compliance reporting. |