WorkersBusinessCommunicationLandlines
The view that returns business landline contact information for workers. This view lists office phone extensions and mainline numbers for Human Resources (HR) and directory reporting.
Table Specific Information
Select
The provider 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 provider.
- AssociateOID supports the '=' comparison.
- WorkerID supports the '=' comparison.
- AsOfDate supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM WorkersBusinessCommunicationLandlines WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersBusinessCommunicationLandlines WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersBusinessCommunicationLandlines WHERE AsOfDate = '2020-01-01'
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | The unique identifier (Id) that represents the associate in the HR system. This Id links the landline communication record to the correct worker profile. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker to whom the business landline number belongs. This field ensures consistent reference across HR, payroll, and communication systems. |
| Access | String | The access type that defines how the landline can be used (for example, Internal, External, or Restricted). This field supports communication control and access security. | |
| AreaDialing | String | The area dialing code that is used for the worker's business landline number. This field supports regional identification and proper telecommunication routing. | |
| CountryDialing | String | The country dialing code that is used for the worker's business landline number. This field ensures compliance with international dialing formats and supports global workforce communication. | |
| DialNumber | String | The primary landline number that is associated with the worker's business contact record. This field supports internal communication, external correspondence, and office directory listings. | |
| Extension | String | The landline extension number that routes calls within the organization. This field supports departmental call management and internal routing. | |
| FormattedNumber | String | The fully formatted version of the worker's business landline number. This field ensures consistency in how phone numbers are displayed across HR systems and employee directories. | |
| ItemID | String | The Id that uniquely identifies the business landline record. This Id supports tracking, version control, and auditing of communication data changes. | |
| NameCode | String | The code that categorizes the purpose or type of landline number (for example, Work, Department, or Alternate). This field supports structured communication management in HR systems. | |
| NameCodeLongName | String | The full descriptive name of the type code for the business landline. This field provides the complete label that appears in HR documentation and reports. | |
| NameCodeShortName | String | The abbreviated name that corresponds to the type code for the business landline. This field provides a concise label for dashboards, analytics, and HR communication summaries. | |
| NotificationIndicator | Boolean | The indicator that specifies whether this landline number is used for automated HR notifications or business communication alerts (for example, compliance reminders, payroll updates, or emergency calls). | |
| AsOfDate | Date | The date that defines when this business landline information became effective. This field supports time-based reporting, audit history, and HR data validation. |