AssociatePaymentsSummaryStatutoryDeductions
The view that summarizes all statutory deductions (for example, tax withholdings and mandated contributions) for each associate in payroll outputs. This view is used for compliance reporting and reconciliation with government filings.
Table Specific Information
Select
The cmdlet 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 cmdlet.
- ItemId supports the '=' and IN comparisons.
SELECT * FROM AssociatePaymentsSummaryStatutoryDeductions WHERE ItemId = 'TXSMIb+yh9UbJ9-im9au7g=='
SELECT * FROM AssociatePaymentsSummaryStatutoryDeductions 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 statutory-deduction summary entry within the associate's payroll record. |
| AssociateOID | String | The associate Id that identifies the worker whose statutory deductions are represented in this summary. This Id links each deduction entry to the corresponding worker profile in ADP. | |
| SectionCategory | String | The category that classifies the statutory deduction type. This value determines how the deduction is grouped, processed, and reported for payroll and compliance purposes. | |
| SectionName | String | The name of the section that is associated with the statutory deduction. This name identifies the deduction grouping as it appears in payroll output, such as Federal Income Tax or State Income Tax. | |
| 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 legal requirements and payroll rules. | |
| 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 modify deduction processing within payroll configuration. | |
| 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 used to calculate employer contributions. | |
| PayrollAccumulations | String | The payroll accumulation data that is associated with the statutory deduction. This field tracks cumulative totals that are used for reconciliation and compliance reporting. | |
| 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. | |
| StatutoryDeductionTypeCodeASortName | String | The short descriptive name that corresponds to the statutory-deduction type code. This field provides a readable label for payroll and compliance documentation. | |
| StatutoryJurisdictionAdministrativeLevel1CodeValue | String | The code that identifies the administrative jurisdiction in which the statutory deduction applies (for example, state, province, or region). This code supports jurisdiction-based reporting and ensures tax 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. |