AssociatePaymentsSummaryEarningsSections
View the associate payments earnings sections items in the payroll outputs.
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 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 of a instance within the collection. |
| AssociateOID | String | ||
| ConfigurationTags | String | ||
| EarningAmountValue | Double | ||
| EarningClassificationCodeValue | String | ||
| EarningClassificationCodeShortName | String | ||
| EarningIDDescription | String | ||
| EarningIDValue | String | ||
| PayRateBaseUnitCodeValue | String | ||
| PayRateBaseUnitCodeShortName | String | ||
| PayRateRateValue | Double | ||
| PayrollAccumulations | String | ||
| TimeWorkedQuantityValue | Double | ||
| TimeWorkedQuantityUnitTimeCodeValue | String | ||
| TimeWorkedQuantityUnitTimeCodeName | String | ||
| DepartmentId | String |