WorkersBusinessCommunicationEmails
The view that returns business-email contact information for workers. This view includes primary and secondary email addresses that are used for company communication and identity verification.
Table Specific Information
Select
The add-in 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 add-in.
- AssociateOID supports the '=' comparison.
- WorkerID supports the '=' comparison.
- AsOfDate supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM WorkersBusinessCommunicationEmails WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersBusinessCommunicationEmails WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersBusinessCommunicationEmails WHERE AsOfDate = '2020-01-01'
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | The unique identifier (Id) that represents the associate within the Human Resources (HR) system. This Id links the email communication record to the correct worker profile. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker to whom the email address belongs. This field ensures consistent association across payroll, compliance, and communication records. |
| EmailUri | String | The complete email address that is used for business communication. This field supports internal correspondence, HR notifications, and identity verification. | |
| ItemID | String | The Id that uniquely identifies this email record. This Id allows tracking of historical changes to the worker's contact information. | |
| NameCode | String | The code that categorizes the purpose or type of business email (for example, Work, Alternate Work, or Departmental). This field supports structured communication management. | |
| NameCodeLongName | String | The full descriptive name of the business-email code. This field provides the complete label that appears in HR documentation and directory listings. | |
| NameCodeShortName | String | The abbreviated name that corresponds to the business-email code. This field provides a concise label for HR dashboards and communication reports. | |
| NotificationIndicator | Boolean | The indicator that specifies whether this email address is used for automated HR notifications (for example, pay statements, onboarding updates, or benefits alerts). | |
| AsOfDate | Date | The date that defines when this email information became effective. This field supports audit history, reporting, and time-based data validation. |