Excel Add-In for ADP

Build 25.0.9434

Input_DeductionInputs

The temporary table that is used to create aggregates for the PayrollRuns.DeductionInputs table. The table supports staging of deduction entries for payroll runs and exists only while the connection remains active. When the connection to ADP is closed, all Input_ tables are cleared.

Columns

Name Type ReadOnly References Description
AssociateOID String True

The associate identifier (Id) that identifies the worker to whom the deduction applies. This Id links the deduction input to the corresponding worker's payroll and employment data in ADP.

PayrollGroupCode String True

The code that identifies the payroll group to which the deduction input applies. This code ensures that deductions are processed within the correct payroll run or company entity.

DeductionCodeValue String True

DeductionInputCode.CodeValue

The code that identifies the specific deduction type (for example, Health Insurance, 401(k), or Garnishment). This code maps the deduction input to its associated payroll rule or benefits setup.

DeductionRateValue Decimal True

The rate that is applied to calculate the deduction amount for the associate. This rate defines the percentage or fixed value that determines the deduction total.

DeductionAmountcurrencyCode String True

The currency code that specifies the monetary unit for the deduction amount (for example, USD or CAD). This code ensures that all deduction values are processed in the correct currency.

DeductionBaseUnitCodeValue String True

The code (for example, hourly or per-pay-period) that defines the base unit that is used for calculating the deduction rate. This code ensures that deductions are computed consistently across payroll runs.

DeductionConfigurationTags String True

The configuration tags that are associated with the deduction input. These tags are used to categorize, filter, or link deductions to specific configuration rules within ADP.

ReferenceNumber Integer True

The configuration tag reference number that uniquely identifies each deduction input record. This number links the record to related configuration data or tag definitions.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434