PaidTimeOffRequestEntries
The view that returns associate paid time-off (PTO) requests, including dates, hours, and request statuses. It supports HR workflows that manage approvals, scheduling, and payroll synchronization.
Table Specific Information
Select
The connector 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 connector.
- AssociateOID supports the '=' comparison.
SELECT * FROM PaidTimeOffRequestEntries WHERE AssociateOID = 'G3349PZGBADQY8H7'
Columns
| Name | Type | References | Description |
| AssociateOID | String | The unique identifier (Id) that represents the associate who submitted the PTO request. This Id links the PTO request entry to the associate's employment record in ADP. | |
| RequestID | String | The Id that identifies the overall PTO request record. This Id groups individual time-off entries that are associated with the same request submission. | |
| timeOffEntryID | String | The Id that identifies a specific time-off entry within the overall PTO request. This Id distinguishes individual date ranges or time segments in multi-day requests. | |
| paidTimeOffID | String | The Id that represents the PTO record that is associated with this entry. This Id links the request entry to the corresponding balance or policy record. | |
| paidTimeOffPolicyCode | String | The code that identifies the PTO policy that governs this request. This code ensures that accrual rules, eligibility, and limits are applied according to company policy. | |
| paidTimeOffPolicyLabelName | String | The descriptive name that corresponds to the PTO policy code. This field provides a readable label for Human Resources (HR) and payroll teams when reviewing time-off requests. | |
| EntryStatusCode | String | The code that identifies the current status of the PTO entry (for example, Pending, Approved, or Denied). This code supports workflow tracking and reporting. | |
| EntryStatusLabelName | String | The descriptive name that corresponds to the entry status code. This field provides a human-readable label for display in dashboards and self-service applications. | |
| EarningTypeCode | String | The code that identifies the earning type that is associated with the PTO entry (for example, Paid Leave or Unpaid Leave). This code ensures that payroll calculations are applied correctly. | |
| EarningTypeName | String | The descriptive name that corresponds to the earning type code. This field provides a clear label for use in HR and payroll reporting. | |
| StartDate | Date | The start date of the requested time-off period. This date marks the beginning of the associate's scheduled leave. | |
| EndDate | Date | The end date of the requested time-off period. This date marks when the associate is expected to return or when the leave concludes. | |
| startTime | String | The start time of the requested leave on the first day of absence. This value helps define partial-day or hourly leave requests. | |
| TotalQuantityvalueNumber | String | The total quantity of time that is requested for the PTO entry. This quantity represents the total hours or days covered by the request. | |
| TotalQuantityunitTimeCode | String | The code that identifies the unit of time, such as Hours or Days, that is associated with the total quantity. This code ensures consistency in reporting and calculation. | |
| TotalQuantitylabelName | String | The descriptive label that corresponds to the time unit for the PTO entry. This field provides a readable value for dashboards and approval views. | |
| Meta | String | The metadata that is associated with the PTO request entry. This field can contain system-generated attributes or additional context used for auditing and integration purposes. |