AssociatePaymentsAllocationsEarningsAndBenefits
The view that presents detailed information about how each associate's earnings and benefits are allocated in payroll outputs. This view enables reconciliation of earnings categories with corresponding benefit components to ensure accurate financial reporting.
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 AssociatePaymentsAllocationsEarningsAndBenefits WHERE ItemId = 'TXSMIb+yh9UbJ9-im9au7g=='
SELECT * FROM AssociatePaymentsAllocationsEarningsAndBenefits 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 or benefit allocation items within an associate's payroll record. |
| AssociateOID | String | The associate Id that represents the worker to whom the earnings or benefits are allocated. This value links each allocation record to the corresponding worker profile in ADP. | |
| payments | String | The payment element that is associated with each earning or benefit allocation. This column contains payment-specific information that is used to calculate, report, and reconcile payroll amounts for the associate. |