WorkersPersonCommunicationPagers
The table that stores personal pager communication data for workers. This table retains historical pager information that can be required for compliance review or archival purposes.
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 WorkersPersonCommunicationPagers WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersPersonCommunicationPagers WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersPersonCommunicationPagers WHERE AsOfDate = '2020-01-01'
Update
Following is an example of how to Update a WorkersPersonCommunicationPagers table:
UPDATE WorkersPersonCommunicationPagers 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 Human Resources (HR) system. This Id links the personal pager record to the correct worker profile. |
| WorkerID | String | True |
Workers.WorkerID |
The Id that identifies the worker associated with this pager number. This field ensures accurate linkage between the worker's personal contact information and HR data records. |
| Access | String | False |
The access type that defines how the pager number can be used (for example, Internal, External, or Restricted). This field supports secure communication access management within HR systems. | |
| AreaDialing | String | False |
The area dialing code that is used for the worker's pager number. This field supports proper regional dialing and routing across communication networks. | |
| CountryDialing | String | False |
The country dialing code that is used for the worker's pager number. This field ensures international dialing compliance and accurate routing for global HR communication. | |
| DialNumber | String | False |
The pager number that is assigned to the worker for personal or HR-related communication. This field supports emergency contact, shift alerts, and business continuity operations. | |
| Extension | String | False |
The pager extension number that is assigned for department or location-based routing. This field supports communication precision within organizational workflows. | |
| FormattedNumber | String | True |
The fully formatted version of the worker's pager number. This field ensures consistent presentation across HR databases, directories, and reporting tools. | |
| ItemID | String | True |
The Id that uniquely identifies the pager record. This field supports auditing, version tracking, and historical recordkeeping within HR systems. | |
| NameCode | String | True |
The code that categorizes the purpose or type of pager number (for example, Personal, Emergency, or Alternate). This field supports structured contact classification within HR communication records. | |
| NameCodeLongName | String | True |
The full descriptive name of the pager type code. This field provides the complete label that appears in HR documentation and formal reports. | |
| NameCodeShortName | String | True |
The abbreviated name that corresponds to the pager type code. This field supports concise labeling in HR dashboards, data exports, and user interfaces. | |
| NotificationIndicator | Boolean | True |
The indicator that specifies whether this pager number is used for automated HR notifications (for example, system alerts, emergency messages, or status updates). | |
| AsOfDate | Date | True |
The date that defines when this pager record became effective. This field supports version control, time-based auditing, and HR compliance tracking. |