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 connector 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 connector.
- 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. |