WorkersPersonGovernmentIDs
The view that returns government identification data for each worker. This view includes identifiers such as Social Security Numbers, Tax Ids, or national identification codes. It supports verification, payroll compliance, and reporting to government agencies.
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 WorkersPersonGovernmentIDs WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersPersonGovernmentIDs WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersPersonGovernmentIDs 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 government-issued identification record to the correct worker profile. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker associated with the government-issued identification document. This field ensures consistent linkage across HR, payroll, and compliance systems. |
| CountryCode | String | The code that identifies the country that issued the government identification document (for example, US, CA, or UK). This field supports jurisdictional validation and compliance reporting. | |
| ExpirationDate | Date | The date on which the government identification document expires. This field supports compliance tracking, revalidation workflows, and regulatory audits. | |
| IdValue | String | The alphanumeric value of the worker's government-issued identification (for example, a passport number, national ID, or driver's license number). This field is used to verify legal eligibility for employment. | |
| ItemID | String | The Id that uniquely identifies this government-identification record. This field supports version control, historical tracking, and HR compliance documentation. | |
| NameCode | String | The code that classifies the type of government identification (for example, Passport, Driver's License, or Social Security Number). This field supports structured document management and HR verification processes. | |
| NameCodeLongName | String | The full descriptive name of the type code for the government identification. This field provides the complete label that appears in HR documentation and compliance exports. | |
| NameCodeShortName | String | The abbreviated name that corresponds to the type code of the government identification. This field supports compact display in HR dashboards, forms, and reports. | |
| StatusCode | String | The code that represents the current status of the government identification (for example, active, expired, or pending verification). This field supports document lifecycle tracking in HR systems. | |
| StatusCodeEffectiveDate | Date | The date that defines when the current identification status became effective. This field supports compliance validation and historical reporting. | |
| StatusCodeLongName | String | The full descriptive name of the government-identification status code. This field provides a human-readable label that appears in HR records and audits. | |
| StatusCodeShortName | String | The abbreviated name that corresponds to the government-identification status code. This field supports simplified reference in HR reports and user interfaces. | |
| AsOfDate | Date | The date that defines when this government-identification record became effective. This field supports version control, auditing, and historical accuracy in HR data management. |