AssociatePaymentsAllocationsStatutoryDeductions
The view that displays statutory deduction information for associate payment allocations in payroll outputs. This view includes deductions that are required by law, such as income taxes, social security contributions, and other government withholdings.
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 AssociatePaymentsSummaryEarningsSections WHERE ItemId = 'TXSMIb+yh9UbJ9-im9au7g=='
SELECT * FROM AssociatePaymentsSummaryEarningsSections 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 statutory deduction entries within an associate's payroll allocation record. |
| AssociateOID | String | The associate Id that identifies the worker to whom the statutory deduction applies. This value links each deduction record to the corresponding worker's payroll and employment data in ADP. | |
| SectionName | String | The name of the section that is associated with the statutory deduction. This value describes the deduction grouping as it appears in payroll reporting, such as Federal Tax or State Income Tax. | |
| SectionCategory | String | The category code that classifies the statutory deduction type. This value determines how the deduction is processed, grouped, and displayed in payroll summaries and compliance reports. | |
| AssociateDeductionTakenAmountValue | Double | The total amount that is deducted from the associate's pay for the statutory deduction. This amount reflects the required deduction that is applied according to jurisdictional and legal requirements. | |
| AssociateTaxableAmountValue | Double | The taxable amount that is associated with the statutory deduction. This amount represents the portion of the associate's pay that is subject to statutory taxes or withholdings. | |
| ConfigurationTags | String | The configuration tags that are associated with the statutory deduction. These tags are used to categorize, filter, or control deduction behavior within payroll processing and reporting. | |
| EmployerPaidAmountValue | Double | The total amount that is paid by the employer for the statutory deduction. This amount represents employer contributions that are required under tax or benefits regulations. | |
| EmployerTaxableAmountValue | Double | The taxable amount that is associated with the employer-paid portion of the statutory deduction. This field identifies the taxable base that is used for calculating employer contributions. | |
| StatutoryDeductionTypeCodeValue | String | The code that identifies the specific statutory deduction type (for example, Federal Income Tax, Social Security, or Medicare). This code ensures accurate classification within ADP's payroll and compliance framework. | |
| StatutoryDeductionTypeCodeShortName | String | The short descriptive name that corresponds to the statutory deduction-type code. This field provides a readable label for payroll output and compliance documentation. | |
| StatutoryJurisdictionAdministrativeLevel1.codeValue | String | The code that identifies the administrative jurisdiction in which the statutory deduction applies (for example, a state, province, or regional authority). This code supports jurisdiction-based reporting and tax withholding accuracy. | |
| StatutoryJurisdictionWorkedInIndicator | Boolean | The indicator that specifies whether the statutory deduction is based on the jurisdiction in which the associate works. A value of 'true' indicates that the deduction is applied to the work location jurisdiction, while 'false' indicates that it applies to the resident jurisdiction. | |
| DepartmentId | String | The department Id that identifies the department or cost center to which the statutory deduction is allocated. This Id supports department-level reconciliation and financial reporting. |