WorkersWorkAssignmentsAssignedWorkLocationsCommunicationLandlines
The view that returns landline phone numbers that are associated with assigned work locations. This view provides fixed-line contact details for Human Resources (HR) and operational communication.
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 WorkersWorkAssignmentsAssignedWorkLocationsCommunicationLandlines WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersWorkAssignmentsAssignedWorkLocationsCommunicationLandlines WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersWorkAssignmentsAssignedWorkLocationsCommunicationLandlines 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 landline communication record. This field supports HR contact management and location-based reporting. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker whose assigned work location includes this landline number. This field supports HR communication tracking, payroll coordination, and organizational recordkeeping. |
| Access | String | The access type or dialing prefix that is required to reach the landline number (for example, 9 for an outside line). This field supports HR telecommunication configuration and compliance management. | |
| AreaDialing | String | The area code or regional dialing prefix associated with the landline number. This field supports HR contact standardization and geographic analysis. | |
| CountryDialing | String | The country dialing code for the landline number (for example, 1 for the United States or 44 for the United Kingdom). This field supports HR international communication and compliance tracking. | |
| DialNumber | String | The primary landline telephone number for the assigned work location. This field supports HR communication, departmental coordination, and workforce accessibility. | |
| Extension | String | The internal extension associated with the landline number. This field supports HR call routing within large offices or multi-department facilities. | |
| FormattedNumber | String | The landline number that is formatted for readability and standardization (for example, +1 (617) 555-1234). This field supports HR data validation, document templates, and reporting accuracy. | |
| ItemID | String | The Id that represents the landline communication record for the assigned work location. This field supports HR data integrity, version control, and audit processes. | |
| NameCode | String | The code that identifies the category or type of landline (for example, Main Line, Department, or Security). This field supports structured HR contact organization and reporting. | |
| NameCodeLongName | String | The full descriptive name of the type code for the landline. This field provides context in HR documentation and system reporting. | |
| NameCodeShortName | String | The abbreviated name that corresponds to the type code for the landline. This field supports compact display in HR dashboards and exported datasets. | |
| NotificationIndicator | Boolean | A Boolean value that indicates whether the landline number is designated to receive system notifications or automated messages. This field supports HR communication alerts and internal escalation workflows. | |
| AsOfDate | Date | The date that defines when the assigned work-location landline record became effective. This field supports HR historical tracking, auditing, and compliance management. |