AssociatePaymentsAllocationsEarningSections
The view that displays the earning section breakdowns for associate payment allocations. This view organizes payroll results by section (for example, regular pay, overtime, and adjustments) to support payroll review and compliance validation.
Table Specific Information
Select
The driver 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 driver.
- ItemId supports the '=' and IN comparisons.
SELECT * FROM AssociatePaymentsAllocationsEarningSections WHERE ItemId = 'TXSMIb+yh9UbJ9-im9au7g=='
SELECT * FROM AssociatePaymentsAllocationsEarningSections 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 earning section items within an associate's payroll allocation record. |
| AssociateOID | String | The associate Id that identifies the worker to whom the earning section applies. This value links each record to the worker's payroll and employment data in ADP. | |
| ConfigurationTags | String | The configuration tags that are associated with the earning section. These tags are used to categorize or group earning elements for processing, filtering, or reporting purposes. | |
| EarningAmountValue | Double | The total earning amount that is associated with the section. This value represents the calculated pay that is due to the associate for the defined earning category. | |
| EarningClassificationCodeValue | String | The code value that defines the classification of the earning, such as regular pay, overtime, or bonus. This value is used for payroll categorization and compliance reporting. | |
| EarningClassificationCodeShortName | String | The short descriptive name that corresponds to the earning classification code. This field provides a readable label for payroll summaries and Human Resources (HR) reports. | |
| EarningIDDescription | String | The description of the earning Id that explains the purpose or nature of the earning. This field provides context for reporting and payroll configuration. | |
| EarningIDValue | String | The earning Id value that uniquely identifies the specific earning within the payroll configuration. This Id is used to map each earning to its corresponding pay rule or category. | |
| PayRateBaseUnitCodeValue | String | The code value that defines the base unit of measure for the pay rate, such as hourly or salary. This value is used to determine how the pay rate is calculated and displayed. | |
| PayRateBaseUnitCodeShortName | String | The short descriptive name that represents the base unit of pay rate measurement. This field provides a readable reference for HR and payroll administrators. | |
| PayRateValue | Double | The numeric pay-rate value that is applied to the earning section. This value represents the rate at which the associate is compensated for the associated time worked or earning type. | |
| TimeWorkedQuantityValue | Double | The total quantity of time that is worked for the earning section. This value, when combined with the pay rate, determines the total earning amount. | |
| TimeWorkedQuantityunitTimeCodeValue | String | The code value that represents the time unit that is used to measure the time worked, such as hours or days. This value supports consistent time and pay calculations. | |
| TimeWorkedQuantityUnitTimeCodeShortName | String | The short descriptive name that corresponds to the time-unit code. This field provides a clear label for displaying or reporting the time unit in payroll outputs. | |
| DepartmentId | String | The department Id that identifies the cost center or department to which the earning section is charged. This Id enables payroll expense allocation and department-level reporting. |