ODBC Driver for ADP

Build 25.0.9434

WorkersBusinessCommunicationPagers

The view that returns business-pager contact data for workers. This view preserves historical or legacy pager records that are used for on-call or field communication tracking.

Table Specific Information

Select

The driver 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 driver.

  • AssociateOID supports the '=' comparison.
  • WorkerID supports the '=' comparison.
  • AsOfDate supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM WorkersBusinessCommunicationPagers WHERE AssociateOID = 'G3349PZGBADQY8H7'

SELECT * FROM WorkersBusinessCommunicationPagers WHERE WorkerID = 'DRH9M9NPW'

SELECT * FROM WorkersBusinessCommunicationPagers WHERE AsOfDate = '2020-01-01'

Columns

Name Type References Description
AssociateOID String

Workers.AssociateOID

The unique identifier (Id) that represents the associate in the Human Resources (HR) system. This Id links the pager communication record to the correct worker profile.
WorkerID String

Workers.WorkerID

The Id that identifies the worker to whom the pager number belongs. This field ensures consistent reference across HR, payroll, and communication systems.
Access String The access type that defines how the pager number can be used (for example, Internal, External, or Restricted). This field supports communication control and access security within HR systems.
AreaDialing String The area dialing code that is used for the worker's business pager number. This field supports regional identification and routing for communication management.
CountryDialing String The country dialing code that is used for the worker's business pager number. This field ensures international dialing compliance and supports communication across geographic regions.
DialNumber String The primary pager number that is associated with the worker's business contact record. This field supports critical notifications, operational alerts, and emergency communication.
Extension String The pager extension number that is assigned for routing or departmental paging. This field supports internal communication workflows and targeted notifications.
FormattedNumber String The fully formatted version of the worker's business pager number. This field ensures uniform display across HR systems and communication directories.
ItemID String The Id that uniquely identifies the business pager record. This Id supports version control, auditing, and historical tracking of contact information.
NameCode String The code that categorizes the purpose or type of pager number (for example, Work, Department, or Alternate). This field supports structured communication management in HR systems.
NameCodeLongName String The full descriptive name of the type code for the pager number. This field provides the complete label that appears in HR documentation and communication directories.
NameCodeShortName String The abbreviated name that corresponds to the type code of the pager number. This field provides a concise label for dashboards, analytics, and HR communication summaries.
NotificationIndicator Boolean The indicator that specifies whether this pager number is used for automated HR or operational notifications (for example, critical alerts, schedule changes, or safety messages, and so on).
AsOfDate Date The date that defines when this pager information became effective. This field supports time-based auditing, compliance validation, and HR record accuracy.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434