AssociatePaymentsSummaryNonStatutoryDeductions
The view that summarizes non-statutory deductions for each associate in payroll outputs. This view allows payroll teams to verify optional deductions that are applied according to employee elections or company policies.
Table Specific Information
Select
The connector 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 connector.
- ItemId supports the '=' and IN comparisons.
SELECT * FROM AssociatePaymentsSummaryNonStatutoryDeductions WHERE ItemId = 'TXSMIb+yh9UbJ9-im9au7g=='
SELECT * FROM AssociatePaymentsSummaryNonStatutoryDeductions 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 nonstatutory-deduction summary entry within the associate's payroll record. |
| AssociateOID | String | The associate Id that identifies the worker whose nonstatutory deductions are represented in this summary. This Id links each deduction entry to the corresponding worker profile in ADP. | |
| SectionName | String | The name of the section that is associated with the nonstatutory deduction. This name identifies the deduction grouping (for example, Retirement Plan or Union Dues) as it appears in payroll output. | |
| SectionCategory | String | The category that classifies the type of nonstatutory deduction. This value determines how the deduction is processed, grouped, and displayed in payroll reports. | |
| AssociateDeductionAmountValue | Double | The total deduction amount that is calculated for the associate. This amount represents the gross deduction before any adjustments or employer contributions. | |
| AssociateDeductionTakenAmountValue | Double | The deduction amount that is actually taken from the associate's pay. This amount reflects the finalized withholding that is applied according to company policies or employee elections. | |
| DeductionIDDescription | String | The description of the deduction Id that explains the purpose or definition of the deduction. This description provides context for payroll configuration and auditing. | |
| DeductionIDValue | String | The deduction Id that uniquely identifies the specific nonstatutory deduction within the payroll configuration. This Id is used to map each deduction to its corresponding payroll rule or benefits setup. | |
| PayrollAccumulations | String | The payroll accumulation data that is associated with the nonstatutory deduction. This data tracks cumulative totals that are used for payroll reconciliation and reporting. | |
| DepartmentId | String | The department Id that identifies the department or cost center responsible for the deduction. This Id supports department-level expense tracking and reconciliation. |