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. |