TimeCards
The view that returns time card data for individual workers. This view includes daily and period totals, job codes, and pay types. This view supports time tracking, payroll preparation, and compliance with attendance policies.
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 | The unique identifier (Id) that represents the associate whose time card record is being processed. This Id links the time entry to the associate's employment and payroll information in ADP. |
| WorkerID | String | The Id that identifies the worker that is associated with the time card record. This Id connects the worker's time data to payroll and scheduling records. | |
| TimeCardID | String | The Id that identifies the time card record for the payroll period. This Id distinguishes each time card entry in the associate's time-tracking data. | |
| PersonLegalName | String | The legal name of the associate as recorded in Human Resources (HR) systems. This name is used for reporting, compliance, and time card identification. | |
| PersonLegalFamilyName1 | String | The first family name or surname of the associate. This value supports naming consistency across ADP's HR and payroll modules. | |
| PersonLegalFormattedName | String | The formatted full legal name of the associate. This field provides a standardized name format for display in reports and dashboards. | |
| ProcessingStatusCodeValue | String | The code that identifies the processing status of the time card (for example, Draft, Submitted, or Approved). This code supports time card workflow tracking. | |
| ProcessingStatusCodeShortName | String | The short descriptive name that corresponds to the processing status code. This field provides a readable label for use in dashboards and reports. | |
| periodCodeValue | String | The code that identifies the time-tracking period that the time card represents (for example, Current, Next, or Previous). This code determines which pay period's data is being viewed or processed. | |
| periodCodeShortName | String | The short descriptive name that corresponds to the period code. This field provides a concise label for display in reports and dashboards. | |
| periodCodeLongName | String | The long descriptive name that corresponds to the period code. This field provides the full label that is used in reports and time-tracking summaries. | |
| TimePeriodStartDate | String | The start date of the time card period. This date marks when the pay or work period begins. | |
| TimePeriodEndDate | String | The end date of the time card period. This date marks when the pay or work period concludes. | |
| TimePeriodPeriodStatus | String | The status of the time period that the time card represents (for example, Open, Closed, or Locked). This value supports payroll readiness and workflow control. | |
| PositionID | String | The Id that identifies the associate's job position that is linked to the time card. This Id connects time records to position-based reporting and labor cost allocation. | |
| ExceptionCounts | String | The number of time-tracking exceptions that are associated with the time card. Each exception represents an issue that must be reviewed before payroll approval (for example, a missed punch or overtime violation). | |
| PeriodTotals | String | The summarized totals for the time card period. This field aggregates hours, earnings, or other time-based values for reporting and payroll processing. | |
| DailyTotals | String | The daily totals that are associated with the time card. Each entry represents the total worked time or pay data for a single day within the period. | |
| TotalPeriodTimeDuration | String | The total time duration recorded across the entire time card period. This value reflects the cumulative worked or payable time for the associate. | |
| HomeLaborAllocations | String | The home labor allocation details that are associated with the time card. These details indicate the cost center or department where the associate's time is charged. | |
| Actions | String | The actions that are available for the time card record (for example, Edit, Submit, or Approve). These actions define the workflow options for managing the time card in ADP. |