TeamTimeCardsDailyTotals
The view that returns aggregated daily totals from team time cards. This view summarizes the total hours that are worked by team and day, enabling supervisors to monitor attendance patterns and manage overtime compliance.
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 TeamTimeCardsDailyTotals WHERE ManagerOID = 'G3349PZGBADQY8H7'
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | The unique identifier (Id) that represents the associate whose daily time card total is recorded. This Id links the daily totals to the associate's employment and payroll records in ADP. |
| WorkerID | String | The Id that identifies the worker that is associated with the team time card. This Id connects the worker's daily totals to related payroll and scheduling data. | |
| TimeCardID | String | The Id that identifies the time card record for the current pay period. This Id distinguishes daily total entries within the overall time card record. | |
| EntryDate | Date | The date that corresponds to the daily time card entry. This date represents the specific day for which time and pay data are recorded. | |
| PayCodeCodeValue | String | The code that identifies the pay category for the daily entry (for example, Regular Hours, Overtime, or Holiday Pay). This code determines how the time is classified for payroll calculation. | |
| RateBaseMultiplierValue | String | The multiplier that is applied to the base pay rate for the day. This value is used to calculate earnings adjustments (for example, overtime or shift differentials). | |
| RateAmountValue | Double | The pay rate that applies to the time recorded for the day. This rate determines the amount paid to the associate for the specified work period. | |
| RateCurrencyCode | String | The currency code that specifies the monetary unit for the pay rate (for example, USD or CAD). This code ensures that daily pay calculations are performed in the correct currency. | |
| TimeDuration | String | The total time duration that is recorded for the day. This value represents the total worked, paid, or payable time for the daily entry. | |
| HomeLaborAllocations | String | The home-labor allocation details that are associated with the daily time card entry. These details identify the cost center or department where the associate's time is charged. | |
| DayEntries | String | The detailed daily time entries that are associated with the record. Each entry can represent a separate segment of worked time or pay category within the day. | |
| ManagerOID | String |
Workers.AssociateOID | The Id that identifies the manager who oversees the associate's daily time card entries. This Id links the record to the manager's profile for review and approval workflows. |
| periodCodeValue | String | The code that identifies the time-tracking period that the daily total belongs to (for example, Current, Next, or Previous). This code determines which pay period's data is being viewed or processed. | |
| TimePeriodStartDate | String | The start date of the time card period to which the daily total belongs. This date marks when the payroll or work period begins. | |
| TimePeriodEndDate | String | The end date of the time card period to which the daily total belongs. This date marks when the payroll or work period concludes. |