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