WorkersPersonCommunicationLandlines
The table that stores personal landline contact information for workers. This table includes residential phone numbers that are maintained in Human Resources (HR) profiles for emergency or verification purposes.
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 WorkersPersonCommunicationLandlines WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersPersonCommunicationLandlines WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersPersonCommunicationLandlines WHERE AsOfDate = '2020-01-01'
Update
Following is an example of how to Update a WorkersPersonCommunicationLandlines table:
UPDATE WorkersPersonCommunicationLandlines SET AreaDialing = '232', DialNumber = '1234567' WHERE AssociateOID = 'G3349PZGBADQY8H8'
Columns
| Name | Type | ReadOnly | References | Description |
| AssociateOID [KEY] | String | True |
Workers.AssociateOID |
The unique identifier (Id) that represents the associate in the HR system. This Id links the personal landline record to the correct worker profile. |
| WorkerID | String | True |
Workers.WorkerID |
The Id that identifies the worker associated with this personal landline number. This field ensures consistent linkage between worker records and communication details across HR systems. |
| Access | String | False |
The access type that defines how the landline number can be used (for example, Internal, External, or Restricted). This field supports communication access control and HR policy compliance. | |
| AreaDialing | String | False |
The area dialing code that is used for the worker's landline number. This field supports geographic identification and regional dialing accuracy in HR contact management. | |
| CountryDialing | String | False |
The country dialing code that is used for the worker's landline number. This field ensures international dialing compliance and supports accurate routing of calls across regions. | |
| DialNumber | String | False |
The primary landline number that is assigned to the worker for personal or HR-related use. This field supports employee contact, verification, and formal HR communication processes. | |
| Extension | String | False |
The landline extension number that is used for departmental or office-level routing. This field supports structured contact management and communication efficiency within HR systems. | |
| FormattedNumber | String | True |
The fully formatted version of the worker's landline number. This field ensures consistency in data presentation across HR records, reports, and communication templates. | |
| ItemID | String | True |
The Id that uniquely identifies the landline record. This field supports version control, historical recordkeeping, and data integrity within HR systems. | |
| NameCode | String | True |
The code that categorizes the type or purpose of the landline number (for example, Personal, Home, or Alternate). This field supports structured classification and HR data organization. | |
| NameCodeLongName | String | True |
The full descriptive name of the type code for the landline. This field provides the complete label that appears in HR documentation and exported data sets. | |
| NameCodeShortName | String | True |
The abbreviated name that corresponds to the type code of the landline. This field provides a concise label for dashboards, HR interfaces, and summary reports. | |
| NotificationIndicator | Boolean | True |
The indicator that specifies whether this landline number is used for automated HR notifications (for example, alert messages, verification calls, or onboarding updates). | |
| AsOfDate | Date | True |
The date that defines when this landline record became effective. This field supports time-based data auditing, compliance tracking, and HR record accuracy. |