WorkersPersonMilitaryClassificationCodes
The view that returns military classification codes for workers who have served or are serving in the military. This view supports compliance reporting and veteran status tracking for workforce diversity and government reporting.
Table Specific Information
Select
The connector 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 connector.
- AssociateOID supports the '=' comparison.
- WorkerID supports the '=' comparison.
- AsOfDate supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM WorkersPersonMilitaryClassificationCodes WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersPersonMilitaryClassificationCodes WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersPersonMilitaryClassificationCodes WHERE AsOfDate = '2020-01-01'
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | The unique identifier (Id) that represents the associate in the Human Resources (HR) system. This Id links the military classification record to the correct worker profile. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker whose record includes a military classification. This field ensures consistent linkage between HR data and government reporting requirements. |
| CodeValue | String | The code that represents the worker's military classification (for example, Active Duty Wartime or Campaign Badge Veteran, Recently Separated Veteran, or Armed Forces Service Medal Veteran). This field standardizes classification data for HR reporting and compliance tracking. | |
| LongName | String | The full descriptive name of the military classification code. This field provides the complete label that appears in HR reports, compliance documentation, and federal filings. | |
| ShortName | String | The abbreviated version of the military classification code. This field supports concise display in HR dashboards, employee summaries, and data exports. | |
| AsOfDate | Date | The date that defines when this military classification record became effective. This field supports version control, auditing, and compliance verification for HR and government reporting. |