Time Off - ADP Data Target Requirements
DataBlend supports the standard API call to Create Time Off Balances plus Create and Update Time Off Requests leveraging the ADP API.
The Update action for Time Off Requests cancel the request submitted. It does not, for example, update the hours in the request due to the ADP business rule.
The following fields are supported for:
Time Off Balances
| DataBlend Query Field Example | ADP Object (API) | Required | Notes |
| G3DR3T7HAZC95Y92 | associateoid | Yes | Associate OID of the worker. |
| 47159915N | workassignmentid | Yes | Item ID of the worker's work assignment. |
| 4/28/2026 | effectivedatetime | Yes | As-of date/time for the balance adjustment |
| 11393_71 | policycode | Yes | The OID of the Time Off Policy to adjust (e.g. 1234_1 for PTO, 5678_1 for Sick). |
| 8 | quantityvalue | Yes | Numeric balance amount. When using SUMMED as the modificationtypecode, this value should be the difference between the source system balance and the current ADP balance (i.e. source balance minus ADP balance). Rows where the difference equals zero should be excluded from the query to avoid unnecessary API calls. Partial hours are supported. |
| 04/22/2026 | recorddatetime | Yes | Defaults to current UTC time if omitted, however, is a required field |
| H | unittimecode | Unit of the balance quantity. Use H for Hours or D for Days. |
|
| SUMMED TAKEN TRANSACTION | modificationtypecode | Controls how ADP applies the balance value. Common values:SUMMED — sets the balance to the provided value (use for a balance sync/override).TAKEN — records a taken amount against the balance.TRANSACTION — records a transaction against the balance.Leave blank for a standard accrual entry; "SUMMED TAKEN TRANSACTION" to adjust the taken value. |
|
| FALSE | notificationindicator | Whether to send a notification to the worker. Use true or false. |
|
| YearlyAccrual | eventreasoncode | Reason code for the adjustment. Common values include ManualAdjustment and YearlyAccrual. |
|
| Complete | eventstatuscode | ||
| 123 | contextexpressionid | Optional context expression ID. | |
| ADJUSTMENT | balanceadjustmentreasoncode | ||
| 1.0 | balanceadjustmentamount | ||
| H | balanceadjustmentunitcode | ||
| Test Adjustment | balanceadjustmentnote |
For more information, please visit Time Off Balances API Guide for ADP Workforce.
Time Off Requests
| DataBlend Query Field Example | ADP Object (API) | Required | Notes |
| G3DR3T7HAZC95Y92 | aoid | Yes | Associate OID |
| P | requeststatuscode | Yes | P = Pending, A = Approved, I = Denied, C = Cancelled |
| 129340_5722 | paidtimeoffpolicycode | Yes | Policy OID. May also go by paidtimeoffpolicycode. |
| Personal | fpolicylabel | Yes | Policy display name. May also go by paidtimeoffpolicylabel. |
| 132852_9531 | earningtypecode | Yes | Reason code OID |
| P | earningtypelabel | Yes | Reason code description |
| 2026-04-28 | startdate | Yes | Entry start. May also go by startdatetime. |
| 2026-04-29 | enddate | Yes | Entry end. May also go by enddatetime. |
| 1 | entryquantityvalue | Yes | Per-entry quantity |
| P | requestid | Required for Update action; path parameter | |
| 47159915N | positionid | ||
| AA | positiontitle | ||
| 1 | totaltimeoffamount |
Aggregate quantity for the full request. Partial hours are supported. May also go by totalquantityvalue. |
|
| day | unittimecode | H = Hours, D = Days. May also go by totaltimeoffunitcode. | |
| P | statuscode | Update action only: per-entry status (P/A/D/I/C). May also go by entrystatuscode. | |
| userentry | statuslabel | ||
| 123 | paidtimeoffid | Update action only: TOR line OID | |
| datePeriod | entrytypecodes |
For more information, please visit Time Off Request API Guide for ADP Workforce Now.