WorkersPersonCommunicationMobiles
The table that stores personal mobile phone contact information for workers. This table supports Human Resources (HR) communications, emergency alerts, and verification processes requiring mobile contact access.
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 WorkersPersonCommunicationMobiles WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersPersonCommunicationMobiles WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersPersonCommunicationMobiles WHERE AsOfDate = '2020-01-01'
Update
Following is an example of how to Update a WorkersPersonCommunicationMobiles table:
UPDATE WorkersPersonCommunicationMobiles SET AreaDialing = '232', DialNumber = '1234567' WHERE AssociateOID = 'G3349PZGBADQY8H8'
Columns
| Name | Type | ReadOnly | References | Description |
| AssociateOID [KEY] | String | True |
Workers.AssociateOID |
The unique identifier (Id) that represents the associate in the HR system. This Id links the mobile phone record to the correct worker profile. |
| WorkerID | String | True |
Workers.WorkerID |
The Id that identifies the worker associated with this personal mobile phone number. This field ensures consistent linkage between the worker record and contact information across HR systems. |
| Access | String | False |
The access type that defines how the mobile number can be used (for example, Internal, External, or Restricted). This field supports security, access governance, and HR communication policies. | |
| AreaDialing | String | False |
The area dialing code that is used for the worker's mobile phone number. This field supports accurate regional identification and dialing consistency within HR contact systems. | |
| CountryDialing | String | False |
The country dialing code that is used for the worker's mobile phone number. This field ensures international dialing accuracy and supports cross-border HR communication compliance. | |
| DialNumber | String | False |
The primary mobile phone number that is assigned to or provided by the worker for personal or HR-related communication. This field supports direct outreach, alerts, and verification processes. | |
| Extension | String | False |
The mobile extension number that is assigned for internal routing or departmental use. This field supports communication efficiency and HR coordination within distributed organizations. | |
| FormattedNumber | String | True |
The fully formatted version of the worker's mobile phone number. This field ensures consistency across HR systems, communication directories, and exported data. | |
| ItemID | String | True |
The Id that uniquely identifies the mobile phone record. This field supports auditing, version tracking, and historical recordkeeping within HR systems. | |
| NameCode | String | True |
The code that categorizes the purpose or type of mobile number (for example, Personal, Primary, or Alternate). This field supports structured contact classification across HR records. | |
| NameCodeLongName | String | True |
The full descriptive name of the type code for the mobile number. This field provides the complete label that appears in HR documentation and reporting tools. | |
| NameCodeShortName | String | True |
The abbreviated name that corresponds to the type code of the mobile number. This field supports compact display in HR dashboards, reports, and interfaces. | |
| NotificationIndicator | Boolean | True |
The indicator that specifies whether this mobile phone number is used for automated HR notifications (for example, shift alerts, policy messages, or emergency updates). | |
| AsOfDate | Date | True |
The date that defines when this mobile phone record became effective. This field supports historical validation, auditing, and HR data accuracy. |