JDBC Driver for ADP

Build 22.0.8462

WorkersPersonCommunicationFaxes

Returns workers person communication faxes.

Table Specific Information

Select

The driver will use 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 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

WorkerID String True

Workers.WorkerID

Access String False

AreaDialing String False

CountryDialing String False

DialNumber String False

Extension String False

FormattedNumber String True

ItemID String True

NameCode String True

NameCodeLongName String True

NameCodeShortName String True

NotificationIndicator Boolean True

AsOfDate Date True

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462