Power BI Connector for ADP

Build 25.0.9454

WorkersPersonCommunicationFaxes

The table that stores personal fax contact data for workers. This table preserves personal fax information for employees in cases where legacy communication records must be retained for compliance.

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 WorkersPersonCommunicationFaxes WHERE AssociateOID = 'G3349PZGBADQY8H7'

SELECT * FROM WorkersPersonCommunicationFaxes WHERE WorkerID = 'DRH9M9NPW'

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

Update

Following is an example of how to Update a WorkersPersonCommunicationFaxes table:

UPDATE WorkersPersonCommunicationFaxes 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 fax record to the correct worker profile.

WorkerID String True

Workers.WorkerID

The Id that identifies the worker associated with this fax number. This field ensures accurate linkage between worker records and personal communication details across HR systems.

Access String False

The access type that defines how the fax number can be used (for example, Internal, External, or Restricted). This field supports security and communication governance within HR systems.

AreaDialing String False

The area dialing code that is used for the worker's personal fax number. This field supports regional dialing compliance and proper routing of communication.

CountryDialing String False

The country dialing code that is used for the worker's personal fax number. This field ensures international dialing accuracy and supports cross-border communication management.

DialNumber String False

The fax number that is assigned to the worker for personal or HR-related correspondence. This field supports documentation exchange and compliance communication processes.

Extension String False

The fax extension number that is assigned for routing or department-level delivery. This field supports accurate document transmission and HR record routing.

FormattedNumber String True

The fully formatted version of the worker's fax number. This field ensures consistent presentation across HR records, forms, and communication outputs.

ItemID String True

The Id that uniquely identifies the fax record. This field supports version control, data lineage, and historical recordkeeping within HR systems.

NameCode String True

The code that categorizes the type or purpose of the fax number (for example, Personal, Emergency, or Alternate). This field supports structured contact classification across HR and compliance records.

NameCodeLongName String True

The full descriptive name of the code for the fax type. This field provides the complete name that appears in HR documentation and exported reports.

NameCodeShortName String True

The abbreviated name that corresponds to the code of the fax type. This field supports compact display in HR dashboards, forms, and data exports.

NotificationIndicator Boolean True

The indicator that specifies whether this fax number is used for automated HR notifications or formal correspondence (for example, policy updates or benefits documentation).

AsOfDate Date True

The date that defines when this fax record became effective. This field supports compliance verification, auditing, and historical data tracking within HR systems.

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