AssociatePaymentsAllocationsNonStatutoryDeductions
The view that returns non-statutory deduction details for associate payment allocations in payroll outputs. This view includes deductions that are not legally mandated, such as employee-elected benefits, charitable contributions, or loan repayments.
Table Specific Information
Select
The add-in 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 add-in.
- ItemId supports the '=' and IN comparisons.
SELECT * FROM AssociatePaymentsAllocationsNonStatutoryDeductions WHERE ItemId = 'TXSMIb+yh9UbJ9-im9au7g=='
SELECT * FROM AssociatePaymentsAllocationsNonStatutoryDeductions 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 is used to distinguish individual non-statutory deduction entries within an associate's payroll allocation record. |
| AssociateOID | String | The associate Id that identifies the worker to whom the non-statutory deduction applies. This value links each deduction record to the corresponding worker's payroll profile in ADP. | |
| SectionName | String | The name of the section that is associated with the non-statutory deduction. This value describes the deduction category as it appears in payroll output or reporting, such as Retirement Plan or Union Dues. | |
| SectionCategory | String | The category code that classifies the type of non-statutory deduction. This value determines how the deduction is processed, grouped, and displayed within payroll summaries. | |
| AssociateDeductionTakenAmountValue | Double | The total amount that is deducted from the associate's pay for the specific non-statutory deduction. This amount reflects voluntary deductions that are applied based on worker elections or company policy. | |
| DeductionIDDescription | String | The description of the deduction Id that explains the purpose or definition of the deduction. This field provides additional context for payroll reporting and configuration review. | |
| DeductionIDValue | String | The deduction Id value that uniquely identifies the non-statutory deduction within the payroll configuration. This Id is used to map each deduction to its corresponding deduction rule or benefits setup. | |
| DepartmentId | String | The department Id that identifies the department or cost center responsible for the deduction. This Id supports payroll expense tracking and departmental reconciliation. |