TimeCardsPeriodTotals
View the worker Time Cards period totals aggregate.
Table Specific Information
Select
The add-in uses the ADP API to process WHERE clause conditions built with the following column and operator. The AssociateOID is required to make a request and the rest of the filter is executed client side within the add-in.
- AssociateOID supports the '=' comparison.
SELECT * FROM TimeCardsPeriodTotals WHERE AssociateOID = 'G3349PZGBADQY8H7'
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | |
| WorkerID | String | ||
| TimeCardID | String | ||
| payCodecodeValue | String | ||
| payCodeshortName | String | ||
| RateBaseMultiplierValue | String | ||
| RateAmountValue | Double | ||
| RateCurrencyCode | String | ||
| TimeDuration | String | ||
| periodCodeValue | String | Supported values: current, next, previous, etc. | |
| TimePeriodStartDate | String |