Excel Add-In for ADP

Build 25.0.9434

WorkersWorkAssignmentsAssignedWorkLocationsCommunicationFaxes

The view that returns fax communication data that is associated with assigned work locations. This view preserves site-level fax information for administrative or compliance correspondence.

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

SELECT * FROM WorkersWorkAssignmentsAssignedWorkLocationsCommunicationFaxes WHERE WorkerID = 'DRH9M9NPW'

SELECT * FROM WorkersWorkAssignmentsAssignedWorkLocationsCommunicationFaxes 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 assigned work location's fax communication record. This field supports Human Resources (HR) correspondence tracking and organizational record management.
WorkerID String

Workers.WorkerID

The Id that identifies the worker whose assigned work location includes this fax number. This field supports HR contact management, site communication, and historical recordkeeping.
Access String The access type or dialing prefix that is required to reach the fax number (for example, 9 for an outside line). This field supports HR telecommunication configuration and compliance tracking.
AreaDialing String The area code or regional dialing prefix associated with the fax number. This field supports HR contact standardization and geographic data validation.
CountryDialing String The country dialing code for the fax number (for example, 1 for the United States or 44 for the United Kingdom). This field supports HR global communication and international contact compliance.
DialNumber String The primary fax number assigned to the work location. This field supports HR communication routing, document delivery, and contact identification.
Extension String The internal extension associated with the fax line. This field supports HR routing for large facilities or multi-department locations.
FormattedNumber String The fax number that is formatted for readability and standardization (for example, +1 (212) 555-6789). This field supports HR display, document templates, and audit reports.
ItemID String The Id that represents the fax record for the assigned work location. This field supports HR data integrity, record versioning, and communication audits.
NameCode String The code that identifies the category or purpose of the fax number (for example, Payroll, HR Office, or Recruiting). This field supports structured communication management within HR systems.
NameCodeLongName String The full descriptive name of the fax-number category. This field provides clarity for HR documentation and organizational reporting.
NameCodeShortName String The abbreviated name that corresponds to the fax-number category. This field supports compact display in HR dashboards and exported reports.
NotificationIndicator Boolean A Boolean value that indicates whether the fax number is designated to receive system-generated notifications or automated transmissions. This field supports HR operational alerts and compliance messaging.
AsOfDate Date The date that defines when the assigned work-location fax record became effective. This field supports HR historical tracking, auditing, and compliance reporting.

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