WorkersWorkAssignmentsAssignedWorkLocationsCommunicationEmails
The view that returns email contact information that is associated with assigned work locations. This view enables communication with site administrators or location-specific Human Resources (HR) personnel.
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 WorkersWorkAssignmentsAssignedWorkLocationsCommunicationEmails WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersWorkAssignmentsAssignedWorkLocationsCommunicationEmails WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersWorkAssignmentsAssignedWorkLocationsCommunicationEmails WHERE AsOfDate = '2020-01-01'
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | The unique identifier (Id) that represents the associate linked to the assigned work location's communication email record. This field supports HR communication tracking and organizational reporting. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker whose assigned work location includes this email contact record. This field supports HR correspondence, notification routing, and data synchronization. |
| EmailUri | String | The email address that is associated with the assigned work location (for example, [email protected], [email protected]). This field supports HR communication, employee contact management, and facility coordination. | |
| ItemID | String | The Id that represents the specific email record for the assigned work location. This field supports HR data integrity, communication tracking, and system auditing. | |
| NameCode | String | The code that identifies the name or category assigned to the email address (for example, General, Payroll, or Emergency). This field supports structured HR communication management and reporting. | |
| NameCodeLongName | String | The full descriptive name of the email type code. This field provides context for HR reporting, documentation, and audit trails. | |
| NameCodeShortName | String | The abbreviated name that corresponds to the email type code. This field supports compact display in HR dashboards and communication exports. | |
| NotificationIndicator | Boolean | A Boolean value that indicates whether the email address is designated for system-generated or high-priority notifications. This field supports HR alert distribution and compliance messaging. | |
| AsOfDate | Date | The date that defines when the assigned work-location email record became effective. This field supports HR historical tracking, communication auditing, and compliance reporting. |