TeamTimeCards
The view that returns time card data for all workers in a specific team. This view includes time entries, attendance records, and worked hours. This view supports team-level scheduling, payroll validation, and labor reporting.
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 TeamTimeCards WHERE ManagerOID = '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 profile in ADP. |
| WorkerID | String | The Id that identifies the worker that is associated with the team time card. This Id connects the worker's time data to related payroll and scheduling records. | |
| TimeCardID | String | The Id that identifies the time card record for the current payroll period. This Id distinguishes each time card entry within 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 field 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 display in reports and dashboards. | |
| 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 use in dashboards and reports. | |
| periodCodeLongName | String | The long descriptive name that corresponds to the period code. This field provides the full label 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. | |
| 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 that is 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. | |
| ExceptionsIndicator | Boolean | The indicator that specifies whether any exceptions exist in the time card record. A value of 'true' indicates that exceptions are present (for example, missing punches or policy violations), while a value of 'false' indicates that the time card has no exceptions. | |
| ManagerOID | String |
Workers.AssociateOID | The Id that identifies the manager who is responsible for approving or reviewing the associate's time card. This Id links the record to the manager's profile in ADP. |