TimeCardsDailyTotals
The view that returns daily time card totals for individual workers. This view summarizes hours worked each day by category (for example, Regular, Overtime, or Leave) to support payroll review and reporting.
Table Specific Information
Select
The server 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 server.
- AssociateOID supports the '=' comparison.
SELECT * FROM TimeCardsDailyTotals 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 links daily time totals to the correct worker record across Human Resources (HR) and payroll processes. |
| WorkerID | String | The Id that identifies the specific worker associated with the time card. This field ensures that each daily total is attributed to the correct employee for labor costing and payroll accuracy. | |
| TimeCardID | String | The Id for the time card record that the daily totals belong to. This Id is used to connect individual day entries with the overall time card summary for a given pay period. | |
| EntryDate | Date | The specific calendar date for which the time is recorded. This field defines the day of work within the time period and is used for scheduling, payroll, and compliance tracking. | |
| PayCodeCodeValue | String | The code value that represents the type of pay that is applied to the recorded time (for example, Regular, Overtime, or Holiday). This field determines how hours are categorized for payroll calculation. | |
| PayCodeShortName | String | The short, human-readable name for the pay code value. This field provides a simplified label for quick reference in reports and user interfaces. | |
| RateBaseMultiplierValue | String | The multiplier value that is applied to the base pay rate to calculate adjusted pay. This field supports complex pay structures such as shift differentials or overtime premiums. | |
| RateAmountValue | Double | The numeric pay rate that is applied to the recorded hours for the day. This value is used by payroll systems to determine gross earnings. | |
| RateCurrencyCode | String | The three-letter ISO currency code that identifies the currency in which the pay rate is denominated (for example, USD or CAD). This field ensures accurate monetary conversion and reporting. | |
| TimeDuration | String | The total duration of time that is recorded for the day. This field includes all payable and non-payable hours and provides visibility into total hours worked or charged. | |
| periodCodeValue | String | The code value that represents the payroll or reporting period. Supported values include current, next, previous, and so on. This field determines which payroll cycle the daily total belongs to. | |
| TimePeriodStartDate | String | The start date of the time period that the daily total falls within. This field defines the beginning of the reporting or payroll cycle. | |
| TimePeriodEndDate | String | The end date of the time period that the daily total falls within. This field defines the closing date of the reporting or payroll cycle and is used to calculate period totals. |