WorkersPersonCommunicationEmails
The table that stores personal email communication data for workers. This table includes primary and alternate personal email addresses that are maintained in Human Resources (HR) systems for contact and verification purposes.
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 WorkersPersonCommunicationEmails WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersPersonCommunicationEmails WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersPersonCommunicationEmails WHERE AsOfDate = '2020-01-01'
Update
Following is an example of how to Update a WorkersPersonCommunicationEmails table:
UPDATE WorkersPersonCommunicationEmails SET EmailUri = '[email protected]' WHERE AssociateOID = 'G3349PZGBADQY8H8'
Columns
| Name | Type | ReadOnly | References | Description |
| AssociateOID [KEY] | String | True |
Workers.AssociateOID |
The unique identifier (Id) that represents the associate in the HR system. This Id links the personal email record to the correct worker profile. |
| WorkerID | String | True |
Workers.WorkerID |
The Id that identifies the worker associated with this personal email address. This field ensures proper linkage between worker records and contact details across HR and communication systems. |
| EmailUri | String | False |
The email address that is assigned to or provided by the worker for personal or HR-related communication. This field supports notification delivery, employee correspondence, and contact record accuracy. | |
| ItemID | String | True |
The Id that uniquely identifies the email-address record. This field supports version control, auditing, and historical tracking of communication information within HR data systems. | |
| NameCode | String | True |
The code that categorizes the type or purpose of the email address (for example, Personal, Work, or Alternate). This field supports structured communication management and HR classification. | |
| NameCodeLongName | String | True |
The full descriptive name of the code for the email type. This field provides the complete label that is displayed in HR records and reports. | |
| NameCodeShortName | String | True |
The abbreviated name that corresponds to the code for the email type. This field provides a concise label for HR dashboards, exports, and user interfaces. | |
| NotificationIndicator | Boolean | True |
The indicator that specifies whether this email address is used for automatic HR notifications (for example, onboarding messages, policy updates, or pay alerts). | |
| AsOfDate | Date | True |
The date that defines when this email-address record became effective. This field supports HR data auditing, historical accuracy, and compliance management. |