TeamTimeCardsDayEntries
The view that returns daily time card entries for each worker, along with associated totals. This view provides a day-by-day breakdown of team activity that is used to verify attendance, validate time entries, and approve hours for payroll.
Table Specific Information
Select
The connector uses the ADP API to process WHERE clause conditions that are built with the following column and operator. The ManagerOID column 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 TeamTimeCardsDayEntries WHERE ManagerOID = 'G3349PZGBADQY8H7'
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | The unique identifier (Id) that represents the associate whose daily time card entry is being recorded. This Id links the daily entry to the associate's employment and payroll data in ADP. |
| WorkerID | String | The Id that identifies the worker that is associated with the daily time card entry. This Id connects the entry to payroll and scheduling systems for accurate time-tracking. | |
| TimeCardID | String | The Id that identifies the time card record for the specified payroll period. This Id distinguishes day entries within the broader time card record. | |
| EntryDate | Date | The date that corresponds to the daily time card entry. This date specifies when the recorded work or payable event occurred. | |
| TotalPeriodTimeDuration | String | The total time duration recorded for the payroll period to which the day entry belongs. This value reflects the cumulative time across all entries in the time card. | |
| TimeEntryID | String | The Id that identifies the specific time entry within the daily record. This Id distinguishes individual work or pay segments for the associate. | |
| TimeEntryTypeCode | String | The code that identifies the type of time entry (for example, Regular Hours, Overtime, or Sick Leave). This code determines how the entry is processed for payroll calculation. | |
| TimeEntryStartPeriod | String | The start time of the period that is covered by the time entry. This time marks when the work or paid activity began. | |
| TimeEntryEndPeriod | String | The end time of the period that is covered by the time entry. This time marks when the work or paid activity concluded. | |
| TimeEntryLaborAllocations | String | The labor allocation details that are associated with the time entry. These details identify the cost center or department where the associate's time is charged. | |
| TimeEntryExceptions | String | The list of exceptions that are associated with the time entry. Each exception represents a variance from policy or expected time-tracking behavior (for example, a missed punch or early departure). | |
| TimeEntryTimeDuration | String | The total time duration that is recorded for the time entry. This value reflects the specific length of the work or paid period. | |
| TimeEntryActions | String | The actions that are associated with the time entry (for example, Edit, Approve, or Delete). These actions define the available operations for managing the entry. | |
| TimeEntryStatusCodeValue | String | The code that identifies the current status of the time entry (for example, Draft, Submitted, or Approved). This code supports workflow and approval tracking. | |
| TimeEntryStatusShortName | String | The short descriptive name that corresponds to the time entry status code. This field provides a concise label for use in reports and dashboards. | |
| TimeEntryTotalsPayCodeValue | String | The pay code that is associated with the total for the time entry (for example, Regular Pay or Overtime Pay). This code defines how the recorded time is classified for payroll. | |
| TimeEntryTotalsRateMultiplier | String | The multiplier that is applied to the base pay rate for the time entry. This value is used for earnings adjustments (for example, overtime or shift differential). | |
| TimeEntryTotalsRateAmountValue | String | The pay rate that applies to the time recorded for the entry. This rate determines the amount payable for the specified period. | |
| TimeEntryTotalsRateCurrencyCode | String | The currency code that specifies the monetary unit for the pay rate (for example, USD or CAD). This code ensures accurate payroll calculations across regions. | |
| TimeEntryTotalsTimeDuration | String | The total time duration that is associated with the pay code total. This value represents the amount of time that contributes to payroll for that specific entry. | |
| ManagerOID | String |
Workers.AssociateOID | The Id that identifies the manager who oversees the associate's day-level time entries. This Id links the entries to the appropriate approver for workflow processing. |
| periodCodeValue | String | The code that identifies the time-tracking period that the day entry belongs to (for example, Current, Next, or Previous). This code determines which payroll period the data applies to. | |
| TimePeriodStartDate | String | The start date of the time card period to which the day entry belongs. This date marks when the payroll or work period begins. | |
| TimePeriodEndDate | String | The end date of the time card period to which the day entry belongs. This date marks when the payroll or work period concludes. |