JDBC Driver for ADP

Build 24.0.9062

WorkersPersonCommunicationFaxes

Returns workers person communication faxes.

Table Specific Information

Select

The 本製品 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 本製品.

  • 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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062