AssociatePaymentsSummaryEarningsSections
The view that aggregates earnings by section (for example, regular earnings, overtime, or bonuses) for each associate in payroll outputs. This view provides structured data for compliance and reporting purposes.
Table Specific Information
Select
The connector 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 connector.
- ItemId supports the '=' and IN comparisons.
SELECT * FROM AssociatePaymentsSummaryEarningsSections WHERE ItemId = 'TXSMIb+yh9UbJ9-im9au7g=='
SELECT * FROM AssociatePaymentsSummaryEarningsSections 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 earning-section summary entry within the associate's payroll record. |
| AssociateOID | String | The associate Id that identifies the worker whose earnings are represented in the earning-section summary. This Id links the earning section data to the corresponding worker profile in ADP. | |
| ConfigurationTags | String | The configuration tags that are associated with the earning section. These tags are used to classify, group, or filter earnings for payroll processing and reporting. | |
| EarningAmountValue | Double | The total earning amount that is recorded for the section. This amount represents the pay that is due to the associate for the corresponding earning category. | |
| EarningClassificationCodeValue | String | The code that defines the earning classification, such as regular pay, overtime, or bonus. This code is used to categorize earnings for compliance and reporting purposes. | |
| EarningClassificationCodeShortName | String | The short descriptive name that corresponds to the earning classification code. This field provides a readable label for payroll and Human Resources (HR) reporting. | |
| EarningIDDescription | String | The description of the earning Id that explains the purpose or nature of the earning. This description provides additional context for payroll configuration and audit review. | |
| EarningIDValue | String | The earning Id that uniquely identifies the earning definition in the payroll configuration. This Id is used to map earnings to the correct pay rule or category. | |
| PayRateBaseUnitCodeValue | String | The code that defines the base unit of measure for the pay rate, such as hourly or salary. It determines how the pay rate is calculated and displayed in payroll outputs. | |
| PayRateBaseUnitCodeShortName | String | The short descriptive name that represents the base pay-rate unit. This name provides a clear label for HR administrators and payroll analysts. | |
| PayRateRateValue | Double | The pay rate that is applied to the earning section. This rate represents the amount that the associate is compensated per defined unit of time or work. | |
| PayrollAccumulations | String | The payroll accumulation data that is associated with the earning section. This field captures cumulative totals that are used for payroll reconciliation and financial analysis. | |
| TimeWorkedQuantityValue | Double | The total quantity of time that is worked for the earning section. This quantity, when multiplied by the pay rate, determines the total earning amount. | |
| TimeWorkedQuantityUnitTimeCodeValue | String | The code that represents the unit of time that is used to measure the time worked (for example, hours or days). This code ensures consistent calculation across payroll outputs. | |
| TimeWorkedQuantityUnitTimeCodeName | String | The short name that corresponds to the time-unit code. This field provides a human-readable reference for displaying the unit of measure in reports. | |
| DepartmentId | String | The department Id that identifies the department or cost center to which the earning section is allocated. This Id enables department-level reporting and expense tracking. |