TimeCards
View the worker Time Cards.
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 TimeCards WHERE AssociateOID = 'G3349PZGBADQY8H7'
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | |
| WorkerID | String | ||
| TimeCardID | String | ||
| PersonLegalName | String | ||
| PersonLegalFamilyName1 | String | ||
| PersonLegalFormattedName | String | ||
| ProcessingStatusCodeValue | String | ||
| ProcessingStatusCodeShortName | String | ||
| periodCodeValue | String | Supported values: current, next, previous, etc. | |
| periodCodeShortName | String | ||
| periodCodeLongName | String | ||
| TimePeriodStartDate | Date | ||
| TimePeriodEndDate | Date | ||
| TimePeriodPeriodStatus | String | ||
| PositionID | String | ||
| ExceptionCounts | String | ||
| PeriodTotals | String | ||
| DailyTotals | String | ||
| TotalPeriodTimeDuration | String | ||
| HomeLaborAllocations | String | ||
| Actions | String |