WorkersWorkAssignmentsAssignedWorkLocationsCommunicationPagers
Returns workers work assignments assigned work locations communication pagers.
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 WorkersWorkAssignmentsAssignedWorkLocationsCommunicationPagers WHERE AssociateOID = 'G3349PZGBADQY8H7' SELECT * FROM WorkersWorkAssignmentsAssignedWorkLocationsCommunicationPagers WHERE WorkerID = 'DRH9M9NPW' SELECT * FROM WorkersWorkAssignmentsAssignedWorkLocationsCommunicationPagers WHERE AsOfDate = '2020-01-01'
Columns
Name | Type | References | Description |
AssociateOID | String |
Workers.AssociateOID | |
WorkerID | String |
Workers.WorkerID | |
Access | String | ||
AreaDialing | String | ||
CountryDialing | String | ||
DialNumber | String | ||
Extension | String | ||
FormattedNumber | String | ||
ItemID | String | ||
NameCode | String | ||
NameCodeLongName | String | ||
NameCodeShortName | String | ||
NotificationIndicator | Boolean | ||
AsOfDate | Date |