PaidTimeOffBalances
Returns Paid TimeOff Balances.
Table Specific Information
Select
The add-in uses the ADP API to process WHERE clause conditions built with the following column and operator. The AssociateOID is required to make a request and the rest of the filter is executed client side within the add-in.
- AssociateOID supports the '=' comparison.
SELECT * FROM PaidTimeOffBalances WHERE AssociateOID = 'G3349PZGBADQY8H7'
Columns
| Name | Type | References | Description |
| AssociateOID | String | ||
| BalanceTypeCode | String | ||
| BalanceTypeLabelName | String | ||
| TotalQuantityValueNumber | Double | ||
| TotalQuantityUnitTimeCode | String | ||
| TotalQuantityLabelName | String | ||
| TotalTime | String | ||
| AccrualBalances | String | ||
| PaidTimeOffEntries | String | ||
| PaidTimeOffPolicyCode | String | ||
| PaidTimeOffPolicyLabelName | String | ||
| AsOfDate | Date | ||
| PositionRefPositionID | String | ||
| PositionRefSchemeName | String | ||
| PositionRefSchemeAgencyName | String | ||
| PositionReftitle | String |