WorkersWorkAssignmentsHomeWorkLocationCommunicationMobiles
The view that returns mobile phone communication data for workers' home work locations. This view supports contact and scheduling coordination for employees based at specific sites.
Table Specific Information
Select
The connector 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 connector.
- AssociateOID supports the '=' comparison.
- WorkerID supports the '=' comparison.
- AsOfDate supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM WorkersWorkAssignmentsHomeWorkLocationCommunicationMobiles WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersWorkAssignmentsHomeWorkLocationCommunicationMobiles WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersWorkAssignmentsHomeWorkLocationCommunicationMobiles WHERE AsOfDate = '2020-01-01'
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | The unique identifier (Id) that represents the associate linked to mobile communication record for the home work location. This field supports Human Resources (HR) contact management, payroll coordination, and data synchronization across organizational systems. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker whose home work location includes this mobile record. This field supports HR communication tracking, personnel verification, and cross-system data consistency. |
| Access | String | The access code that is required to place an outbound mobile call from the home work location. This field supports HR telecommunication setup, facilities management, and secure dialing configuration. | |
| AreaDialing | String | The area code that corresponds to the geographic dialing region for the mobile number. This field supports HR record accuracy, regional workforce validation, and telecommunication mapping. | |
| CountryDialing | String | The country dialing code that is associated with the mobile number for the home work location. This field supports international HR operations, global workforce communication, and compliance with telecommunication standards. | |
| DialNumber | String | The main mobile number that is assigned to the home work location or the associated worker. This field supports HR communication, emergency notifications, and real-time employee contact. | |
| Extension | String | The mobile line extension that is associated with a department or role. This field supports HR routing, departmental coordination, and internal contact structures. | |
| FormattedNumber | String | The fully formatted mobile number, including country code, area code, and extension (for example, +1 415 555 0175 ext. 100). This field supports HR record validation, system integration, and automated communication workflows. | |
| ItemID | String | The Id that represents the mobile communication record for the home work location. This field supports data traceability, auditing, and version control within HR and payroll systems. | |
| NameCode | String | The code that identifies the category or label assigned to the mobile record (for example, Payroll, Benefits, or Emergency Contact). This field supports structured HR communication, automation, and consistent data classification. | |
| NameCodeLongName | String | The full descriptive name of the code that classifies the mobile record. This field supports HR documentation, compliance auditing, and system transparency. | |
| NameCodeShortName | String | The abbreviated name that corresponds to the mobile record's code. This field supports concise HR dashboards, user interfaces, and summary reporting. | |
| NotificationIndicator | Boolean | A Boolean value that indicates whether the mobile number is designated for automated or emergency notifications. This field supports HR alert routing, compliance communication, and employee safety programs. | |
| AsOfDate | Date | The date that defines when the mobile record for the home work location became effective. This field supports HR auditing, historical tracking, and synchronization with payroll and compliance systems. |