AssociatePaymentsSummaryEarningsAndBenefits
The view that summarizes all earnings and benefits for each associate within a payroll output. This view provides a high-level snapshot for auditing and financial reconciliation of payroll data.
Table Specific Information
Select
The add-in 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 add-in.
- ItemId supports the '=' and IN comparisons.
SELECT * FROM AssociatePaymentsSummaryEarningsAndBenefits WHERE ItemId = 'TXSMIb+yh9UbJ9-im9au7g=='
SELECT * FROM AssociatePaymentsSummaryEarningsAndBenefits 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 or benefit summary entry within the associate's payroll record. |
| AssociateOID | String | The associate Id that identifies the worker whose earnings and benefits are summarized. This Id links the summary record to the corresponding worker profile in ADP. | |
| Payments | String | The payment data that is associated with each earning or benefit summary. This field contains payment details that are used to calculate, report, and reconcile payroll results for the associate. |