WorkersBusinessCommunicationMobiles
The view that returns business mobile-phone contact data for workers. This view captures mobile numbers that are linked to corporate communication systems and used for workforce contact management.
Table Specific Information
Select
The server 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 server.
- AssociateOID supports the '=' comparison.
- WorkerID supports the '=' comparison.
- AsOfDate supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM WorkersBusinessCommunicationMobiles WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersBusinessCommunicationMobiles WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersBusinessCommunicationMobiles WHERE AsOfDate = '2020-01-01'
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | The unique identifier (Id) that represents the associate in the Human Resources (HR) system. This Id links the mobile communication record to the correct worker profile. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker to whom the business mobile number belongs. This field ensures consistent reference across HR, payroll, and communication systems. |
| Access | String | The access type that defines how the mobile number can be used (for example, Internal, External, or Restricted). This field supports communication permissions and corporate access controls. | |
| AreaDialing | String | The area dialing code that is used for the worker's business mobile number. This field supports regional identification and accurate call routing. | |
| CountryDialing | String | The country dialing code that is used for the worker's business mobile number. This field ensures compliance with international dialing standards and supports global workforce communication. | |
| DialNumber | String | The primary mobile number that is associated with the worker's business contact record. This field supports official communication, remote accessibility, and identity verification. | |
| Extension | String | The mobile extension number that is assigned for routing or secondary contact purposes. This field supports internal call management and device linking within HR systems. | |
| FormattedNumber | String | The fully formatted version of the worker's business mobile number. This field ensures display consistency across HR, payroll, and contact management systems. | |
| ItemID | String | The Id that uniquely identifies the business mobile record. This Id supports version control, auditing, and traceability of contact information changes. | |
| NameCode | String | The code that categorizes the purpose or type of mobile number (for example, Work, Department, or Alternate). This field supports structured communication classification in HR systems. | |
| NameCodeLongName | String | The full descriptive name of the type code for the mobile number. This field provides the complete label that appears in HR documentation and communication reports. | |
| NameCodeShortName | String | The abbreviated name that corresponds to the type code for the mobile number. This field provides a concise label for dashboards, analytics, and HR summaries. | |
| NotificationIndicator | Boolean | The indicator that specifies whether this mobile number is used for HR notifications or alerts (for example, schedule changes, compliance notices, or system messages). | |
| AsOfDate | Date | The date that defines when this mobile-number information became effective. This field supports time-based reporting, auditing, and data validation across HR systems. |