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 server 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 server.
- 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. |