Input_EarningInputs
The temporary table that is used to create aggregates for the PayrollRuns.EarningInputs table. The table supports payroll run preparation by holding earning entries that are processed in temporary session storage. When the connection to ADP is closed, the data is cleared.
Columns
| Name | Type | ReadOnly | References | Description |
| AssociateOID | String | True |
The unique identifier (Id) that represents the associate to whom the earning input applies. This Id links the earning record to the corresponding worker profile in ADP. | |
| PayrollGroupCode | String | True |
The code that identifies the payroll group under which the earning input is processed. This code ensures that earnings are calculated and reported within the correct company or payroll entity. | |
| EarningCodeValue | String | True |
EarningInputCode.CodeValue |
The code that identifies the specific earning type (for example, Regular Pay, Overtime, or Bonus). This code maps the earning input to its corresponding payroll rule or configuration. |
| RateValue | Decimal | True |
The pay rate that is applied to the earning input. This rate determines how much the associate is compensated per unit of time or work performed. | |
| RatecurrencyCode | String | True |
The currency code that specifies the monetary unit for the pay rate (for example, USD or CAD). This code ensures consistent currency alignment across payroll calculations. | |
| NumberOfHours | String | True |
The number of hours that is associated with the earning input. This value represents the total time worked that is used to calculate the corresponding earning amount. | |
| EarningsAmountValue | Decimal | True |
The total earning amount that is calculated for the associate based on the rate and number of hours. This amount reflects the gross pay before deductions or adjustments. | |
| EarningsCurrencyCode | String | True |
The currency code that specifies the monetary unit for the total earning amount. This code ensures that all earnings are reported in the correct currency during payroll processing. | |
| EarningConfigurationTags | String | True |
The configuration tags that are associated with the earning input. These tags are used to categorize, filter, or link earnings to specific configuration or reporting rules within ADP. | |
| ReferenceNumber | Integer | True |
The configuration tag reference number that uniquely identifies each earning input record. This number links the earning input to related configuration data or tag definitions. |