TeamTimeCardsPeriodTotals
The view that returns aggregated period totals from team time cards. This view summarizes total hours, regular pay, and overtime over a complete payroll period. This data supports payroll calculation and compliance with labor regulations.
Table Specific Information
Select
The component 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 component.
- ManagerOID supports the '=' comparison.
SELECT * FROM TeamTimeCardsPeriodTotals WHERE ManagerOID = 'G3349PZGBADQY8H7'
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | The unique identifier (Id) that represents the associate whose payroll-period total is recorded. This Id links the period totals to the associate's employment and payroll information in ADP. |
| WorkerID | String | The Id that identifies the worker that is associated with the payroll-period total. This Id connects the total to the worker's time-tracking and payroll records. | |
| TimeCardID | String | The Id that identifies the time card record for the specified payroll period. This Id distinguishes the period totals from other entries in the associate's time card. | |
| payCodecodeValue | String | The code that identifies the pay category used to calculate the period total (for example, Regular Pay, Overtime, or Holiday). This code defines how the time and earnings are classified for payroll processing. | |
| RateBaseMultiplierValue | String | The multiplier that is applied to the base pay rate for the payroll period. This value adjusts the base rate when calculating earnings (for example, for overtime or differential pay). | |
| RateAmountValue | Double | The pay rate that applies to the time recorded for the payroll period. This rate determines the total payable amount for the associated time and pay category. | |
| RateCurrencyCode | 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 regional and international operations. | |
| TimeDuration | String | The total time duration that is recorded for the payroll period. This value represents the total worked or payable time accumulated across all days in the period. | |
| ManagerOID | String |
Workers.AssociateOID | The Id that identifies the manager responsible for approving or reviewing the associate's payroll period totals. This Id links the totals to the manager's profile for approval workflows. |
| periodCodeValue | String | The code that identifies the time-tracking period that the totals apply to (for example, Current, Next, or Previous). This code determines which payroll period the data belongs to. | |
| TimePeriodStartDate | String | The start date of the payroll period to which the totals belong. This date marks when the work or pay cycle begins. | |
| TimePeriodEndDate | String | The end date of the payroll period to which the totals belong. This date marks when the work or pay cycle concludes. |