TimeCardsPeriodTotals
The view that returns total hours and earnings that are aggregated over an entire payroll period for each worker. This view provides summarized data that is used for payroll calculation and compliance tracking.
Table Specific Information
Select
The connector uses the ADP API to process WHERE clause conditions built with the following column and operator. The AssociateOID is required to make a request and the rest of the filter is executed client side within the connector.
- AssociateOID supports the '=' comparison.
SELECT * FROM TimeCardsPeriodTotals WHERE AssociateOID = 'G3349PZGBADQY8H7'
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | The unique identifier (Id) that represents the associate within the ADP system. This Id connects period-level totals to the correct worker record across Human Resources (HR) and payroll systems. |
| WorkerID | String | The Id that identifies the worker to whom the time card belongs. This field ensures accurate linkage between time worked and the corresponding employee for payroll processing. | |
| TimeCardID | String | The Id for the time card record that the period totals summarize. This field enables the aggregation of daily totals into a single view for a defined time period. | |
| payCodecodeValue | String | The code value that represents the pay category applied to the time total (for example, Regular, Overtime, or Holiday). This field defines how hours are classified for payroll calculation. | |
| payCodeshortName | String | The short name for the pay code that corresponds to the pay category value. This field provides a readable label that is displayed in reports and dashboards. | |
| RateBaseMultiplierValue | String | The multiplier value that is applied to the base rate to calculate adjusted pay. This field supports pay differentials and other rate-based adjustments. | |
| RateAmountValue | Double | The pay rate that is applied to the time period's recorded hours. This field provides the numeric basis for gross pay calculation and audit reporting. | |
| RateCurrencyCode | String | The three-letter ISO currency code that identifies the currency of the pay rate (for example, USD or CAD). This field ensures consistency in payroll and accounting reports. | |
| TimeDuration | String | The total duration of hours recorded for the pay period. This field includes both payable and non-payable time and is used for labor distribution and payroll validation. | |
| periodCodeValue | String | The code value that identifies the payroll or reporting period. Supported values include Current, Next, or Previous. This field determines which cycle the period totals belong to. | |
| TimePeriodStartDate | String | The start date of the reporting or payroll period. This field defines when the time period begins for calculation and reporting purposes. | |
| TimePeriodEndDate | String | The end date of the reporting or payroll period. This field defines when the time period closes and marks the end of the payroll cycle for reconciliation and review. |