WorkersPersonCommunicationFaxes
Returns workers person communication faxes.
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 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 |