PaidTimeOffRequests
The view that returns detailed records of paid time-off (PTO) requests that are submitted by associates. It includes information such as request dates, hours, reasons, and approval statuses. This view is used to track leave management and synchronize approved requests with payroll and scheduling systems.
Table Specific Information
Select
The provider 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 provider.
- AssociateOID supports the '=' comparison.
SELECT * FROM PaidTimeOffRequests 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 request record to the associate's employment profile in ADP. | |
| RequestID | String | The Id that identifies the PTO request record. This Id groups all related time-off entries under a single submission in the ADP system. | |
| RequestStatusCode | String | The code that identifies the current status of the PTO request (for example, Pending, Approved, or Denied). This code supports workflow tracking and process automation. | |
| RequestStatusLabelName | String | The descriptive name that corresponds to the request status code. This field provides a human-readable label for reports, dashboards, and manager views. | |
| TotalQuantityvalueNumber | String | The total quantity of time that is requested in the PTO record. This quantity represents the total hours or days covered by the request. | |
| TotalQuantityunitTimeCode | String | The code that identifies the unit of time (for example, Hours or Days) that is associated with the total quantity. This code ensures correct interpretation and calculation across systems. | |
| TotalQuantitylabelName | String | The descriptive label that corresponds to the time unit for the PTO request. This label provides a readable display value in reports and self-service pages. | |
| TotalTime | String | The total time value that represents the overall length of the PTO request. This field can include formatted duration data that is used for summary display. | |
| paidTimeOffEntries | String | The individual PTO entries that are associated with the current request. Each entry represents a specific date range or time segment of the overall request. | |
| RequestURI | String | The uniform resource identifier (URI) that points to the detailed PTO request record. This URI provides a link reference for integration or API access. | |
| RequestDesc | String | The description that provides additional context or notes for the PTO request. This field can contain system-generated comments or employee-entered explanations. | |
| RequestStartDate | Date | The start date of the requested time-off period. This date marks when the associate's leave is scheduled to begin. | |
| MetadataEntitlementCodes | String | The entitlement codes that are associated with the PTO request. These codes identify the specific leave types or balances that are applied during the request process. | |
| MetaMultiPeriodRequestIndicator | Boolean | The indicator that specifies whether the PTO request spans multiple pay periods. A value of 'true' indicates that the request covers more than one pay period, while a value of 'false' indicates that it is contained within a single pay period. | |
| Actions | String | The available actions that are associated with the PTO request (for example, Approve, Deny, or Cancel). These actions determine the possible next steps in the approval workflow. | |
| RequestorComment | String | The comment that is entered by the associate when submitting the PTO request. This comment provides additional information for the approver or Human Resources (HR) reviewer. | |
| ApprovalDueDate | Date | The date that indicates when approval is due for the PTO request. This date supports timely workflow management and escalation tracking. | |
| PositionRefPositionID | String | The position Id that identifies the associate's current job position. This Id links the PTO request to the position record for organizational reporting. | |
| PositionRefSchemeName | String | The name of the reference scheme that is associated with the position record. This name identifies the structure or naming convention used for position references. | |
| PositionRefSchemeAgencyName | String | The name of the agency or system that manages the position reference scheme. This field distinguishes references that originate from different HR or payroll systems. | |
| PositionReftitle | String | The title of the position that is associated with the PTO request. This title provides a readable reference for display in reports and dashboards. |