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