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 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 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. |