WorkAssignmentHistoryCommunicationsEmails
The view that returns historical email communication details that are associated with work assignments. This view maintains a record of email addresses used by workers over time for internal correspondence and audit verification.
View-Specific Information
Select
The driver uses the ADP API to process WHERE clause conditions built with the following column and operator. The AssociateOID is required to make a request, while the remaining filters are executed client-side within the driver.
- AssociateOID supports the = operator.
SELECT * FROM WorkAssignmentHistoryCommunicationsEmails WHERE AssociateOID = 'AOID4J5VGEX1620N'
Columns
| Name | Type | References | Description |
| EmailUri | String | The uniform resource identifier (URI) that represents the worker's email address. This field stores the primary or alternate email contact used for official communications (for example, work, personal, or notification). | |
| ItemID | String | The unique identifier (Id) that represents the individual email record within the worker's communication history. This Id enables tracking of historical contact information across assignment periods. | |
| NameCodeCodeValue | String | The code value that identifies the type of email address associated with the worker. This field defines the classification of the email (for example, Business, Personal, or Emergency Contact). | |
| NameCodeLongName | String | The full descriptive name of the email-address type code. This field provides the complete label that appears in Human Resources (HR) reports and communication records. | |
| NameCodeShortName | String | The abbreviated name that corresponds to the email-address type code. This field provides a short label for dashboards, reports, and HR analytics. | |
| AssociateOID | String |
Workers.AssociateOID | The Id that represents the associate to whom this email record belongs. This field links the communication record to the correct worker profile in HR and payroll systems. |