WorkersWorkAssignmentsHomeWorkLocationCommunicationLandlines
The view that returns landline communication data for workers' home work locations. This view provides fixed-line contact numbers that are maintained for Human Resources (HR) directory and compliance use.
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 WorkersWorkAssignmentsHomeWorkLocationCommunicationLandlines WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersWorkAssignmentsHomeWorkLocationCommunicationLandlines WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersWorkAssignmentsHomeWorkLocationCommunicationLandlines 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 landline communication record for the home work location. This field supports HR contact management, payroll coordination, and record synchronization across organizational systems. |
| WorkerID | String |
Workers.WorkerID | The Id that identifies the worker whose home work location includes this landline record. This field supports HR communication tracking, personnel verification, and cross-system data consistency. |
| Access | String | The access code that is required to place an outbound call from the home work location. This field supports HR facilities management, telecommunication setup, and enforcement of secure dialing protocols. | |
| AreaDialing | String | The area code that corresponds to the geographic dialing region for the landline number. This field supports HR record accuracy, location validation, and consistency in telecommunication mapping. | |
| CountryDialing | String | The country dialing code that is associated with the landline number for the home work location. This field supports international HR operations, compliance with telecommunication standards, and cross-border communication. | |
| DialNumber | String | The main telephone number that is assigned to the home work location. This field supports HR communication, payroll verification, and employee outreach processes. | |
| Extension | String | The internal phone extension that is assigned to a department or individual within the home work location. This field supports HR routing of calls, departmental communication, and workflow efficiency. | |
| FormattedNumber | String | The fully formatted landline number, including country code, area code, and extension (for example, +1 212 555 0199 ext. 1234). This field supports HR reporting, telecommunication validation, and system integration. | |
| ItemID | String | The Id that represents the landline communication record for the home work location. This field supports data traceability, auditing, and version control within HR and payroll systems. | |
| NameCode | String | The code that identifies the category or label assigned to the landline record (for example, Payroll, Benefits, or Emergency Contact). This field supports structured HR communication, automation workflows, and data classification. | |
| NameCodeLongName | String | The full descriptive name of the code that classifies the landline record. This field supports HR documentation, compliance auditing, and system clarity in reports and exports. | |
| NameCodeShortName | String | The abbreviated name that corresponds to the landline record's code. This field supports concise HR dashboards, summaries, and quick-reference reporting. | |
| NotificationIndicator | Boolean | A Boolean value that indicates whether the landline number is designated to receive automated or emergency notifications. This field supports HR alert routing, policy compliance, and employee communication processes. | |
| AsOfDate | Date | The date that defines when the landline record for the home work location became effective. This field supports HR auditing, historical tracking, and synchronization with payroll and compliance systems. |