WorkersWorkAssignmentsHomeWorkLocationCommunicationEmails
The view that returns email communication information for workers' home work locations. This view provides site-level contact details that are used for administrative coordination.
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 WorkersWorkAssignmentsHomeWorkLocationCommunicationEmails WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersWorkAssignmentsHomeWorkLocationCommunicationEmails WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersWorkAssignmentsHomeWorkLocationCommunicationEmails 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 home work location's email communication record. This field supports Human Resources (HR) contact management, payroll notifications, and system data alignment across associated entities. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker whose home work location includes this email record. This field supports HR correspondence tracking, personnel verification, and synchronization with organizational reporting systems. |
| EmailUri | String | The email address that is assigned to the home work location (for example, [email protected] or [email protected]). This field supports formal business communication, employee notifications, and document routing within HR systems. | |
| ItemID | String | The Id that represents the record entry for the email communication for the home work location. This field supports record versioning, data integrity, and traceability in HR information systems. | |
| NameCode | String | The code that identifies the label or classification assigned to the email address (for example, Payroll, Benefits, or Emergency Contact). This field supports structured HR communication, automation workflows, and integration with organizational directories. | |
| NameCodeLongName | String | The full descriptive name of the code that categorizes the email address. This field supports clarity in HR reporting, employee directories, and compliance documentation. | |
| NameCodeShortName | String | The abbreviated name that corresponds to the email code. This field supports concise display in HR dashboards, exports, and payroll system summaries. | |
| NotificationIndicator | Boolean | A Boolean value that indicates whether the email address is configured to receive automated or critical system notifications. This field supports HR alert management, policy compliance, and employee communication tracking. | |
| AsOfDate | Date | The date that defines when the email record for the home work location became effective. This field supports historical recordkeeping, auditing, and HR compliance tracking for data synchronization across systems. |