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