AssociatePaymentsSummaryPayrollAccumulations
The view that provides cumulative payroll totals for each associate, including accumulated earnings, deductions, and benefits. This view supports audit trail validation and long-term payroll analytics.
Table Specific Information
Select
The server uses the ADP API to process WHERE clause conditions built with the following column and operator. The ItemId is required to make a request and the rest of the filter is executed client side within the server.
- ItemId supports the '=' and IN comparisons.
SELECT * FROM AssociatePaymentsSummaryPayrollAccumulations WHERE ItemId = 'TXSMIb+yh9UbJ9-im9au7g=='
SELECT * FROM AssociatePaymentsSummaryPayrollAccumulations WHERE ItemId IN ('TXSMIb+yh9UbJ9-im9au7g==', 'XXSMIb+yh9UbJ9-im9au7g==')
Columns
| Name | Type | References | Description |
| ItemID | String |
PayrollRuns.ItemID | The unique identifier (Id) that is assigned to each record in the collection. This Id distinguishes each payroll-accumulation record within the associate's payroll summary. |
| AssociateOID | String | The associate Id that identifies the worker whose payroll accumulations are represented in this summary. This Id links the accumulation data to the corresponding worker profile in ADP. | |
| AccumulatedAmountValue | Double | The total accumulated amount that represents the monetary value of all earnings or deductions that are aggregated for the associate across defined payroll periods. | |
| AccumulatedTimeWorkedQuantityValue | Double | The accumulated quantity of time that is worked by the associate. This quantity reflects the total hours or units of time recorded over multiple payroll periods. | |
| AccumulatedTimeWorkedQuantityUnitTimeCodeValue | String | The code that defines the unit of time that is used for accumulated time worked (for example, hours or days). This code ensures consistent measurement across payroll calculations. | |
| AccumulatedTimeWorkedQuantityUnitTimeCodeShortName | String | The short descriptive name that corresponds to the accumulated time-unit code. This field provides a human-readable label for reporting and payroll outputs. | |
| AccumulatorCodeValue | String | The code that identifies the specific accumulator that is used to track payroll totals (for example, year-to-date earnings or tax withholdings). This code enables accurate categorization of accumulated payroll data. | |
| AccumulatorCodeLongName | String | The long descriptive name that represents the payroll accumulator. This field provides a complete label that is used for display in reports or configuration interfaces. | |
| AccumulatorCodeShortName | String | The short name that corresponds to the payroll accumulator code. This name serves as a concise label for payroll reporting and on-screen displays. | |
| AccumulatorDescription | String | The description that explains the purpose or use of the accumulator. This description provides context for how the accumulated value is applied in payroll calculations or compliance reporting. | |
| AccumulatorTimeUnitCodeValue | String | The code that defines the time unit that is used by the accumulator (for example, hours, weeks, or months). This code ensures proper alignment of accumulated time values across payroll periods. | |
| AccumulatorTimeUnitCodeShortName | String | The short descriptive name that corresponds to the accumulator time-unit code. This field provides a simplified label for payroll review and reporting. | |
| DepartmentId | String | The department Id that identifies the department or cost center to which the payroll accumulation is allocated. This Id supports cost tracking and departmental reconciliation. |