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 server 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 server.
- 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. |