WorkersWorkAssignmentsAssignedWorkLocationsCommunicationMobiles
The view that returns mobile phone contact data that is associated with assigned work locations. This view captures mobile communication numbers that are used for coordination and emergency communication.
Table Specific Information
Select
The component 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 component.
- AssociateOID supports the '=' comparison.
- WorkerID supports the '=' comparison.
- AsOfDate supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM WorkersWorkAssignmentsAssignedWorkLocationsCommunicationMobiles WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersWorkAssignmentsAssignedWorkLocationsCommunicationMobiles WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersWorkAssignmentsAssignedWorkLocationsCommunicationMobiles 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 mobile communication record. This field supports Human Resources (HR) contact management, field accessibility, and workforce reporting. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker whose assigned work location includes this mobile number. This field supports HR communication routing, emergency response planning, and record accuracy. |
| Access | String | The access type or dialing prefix that is required to reach the mobile number (for example, 9 for an outside line). This field supports HR telecommunication setup and compliance management. | |
| AreaDialing | String | The area code or regional dialing prefix associated with the mobile number. This field supports HR contact standardization and geographic reporting. | |
| CountryDialing | String | The country dialing code for the mobile number (for example, 1 for the United States or 44 for the United Kingdom). This field supports HR international communication and compliance management. | |
| DialNumber | String | The primary mobile number associated with the assigned work location. This field supports HR communication, employee accessibility, and emergency coordination. | |
| Extension | String | The internal or departmental extension, if applicable, associated with the mobile number. This field supports HR contact routing and organizational structure. | |
| FormattedNumber | String | The mobile number that is formatted for readability and consistency (for example, +1 (646) 555-9012). This field supports HR documentation, system validation, and payroll reporting. | |
| ItemID | String | The Id that represents the mobile communication record for the assigned work location. This field supports HR data integrity, version control, and auditing. | |
| NameCode | String | The code that identifies the category or purpose of the mobile number (for example, Supervisor, Emergency, or Department Contact). This field supports structured HR communication and organizational mapping. | |
| NameCodeLongName | String | The full descriptive name of the category code for the mobile number. This field provides clarity for HR documentation, audit logs, and organizational charts. | |
| NameCodeShortName | String | The abbreviated name that corresponds to the category code for the mobile number. This field supports compact display in HR dashboards and exported reports. | |
| NotificationIndicator | Boolean | A Boolean value that indicates whether the mobile number is designated for system alerts or automated notifications. This field supports HR emergency alerts, compliance messaging, and escalation workflows. | |
| AsOfDate | Date | The date that defines when the assigned work-location mobile record became effective. This field supports HR historical tracking, compliance verification, and system synchronization. |