TeamTimeCardsDailyTotals
View the Team Time Cards daily 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 ManagerOID is required to make a request and the rest of the filter is executed client side within the add-in.
- ManagerOID supports the '=' comparison.
SELECT * FROM TeamTimeCardsDailyTotals WHERE ManagerOID = 'G3349PZGBADQY8H7'
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | |
| WorkerID | String | ||
| TimeCardID | String | ||
| EntryDate | Date | ||
| PayCodeCodeValue | String | ||
| RateBaseMultiplierValue | String | ||
| RateAmountValue | Double | ||
| RateCurrencyCode | String | ||
| TimeDuration | String | ||
| HomeLaborAllocations | String | ||
| DayEntries | String | ||
| ManagerOID | String |
Workers.AssociateOID | |
| periodCodeValue | String | Supported values: current, next, and previous | |
| TimePeriodStartDate | String | ||
| TimePeriodEndDate | String |