JDBC Driver for ADP

Build 22.0.8462

PaidTimeOffRequests

Returns PaidTimeOff Requests.

Table Specific Information

Select

The driver will use 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 driver.

  • AssociateOID supports the '=' comparison.

SELECT * FROM PaidTimeOffRequests WHERE AssociateOID = 'G3349PZGBADQY8H7'

Columns

Name Type References Description
AssociateOID String

Workers.AssociateOID

RequestID String
RequestStatusCode String
RequestStatusLabelName String
TotalQuantityvalueNumber String
TotalQuantityunitTimeCode String
TotalQuantitylabelName String
TotalTime String
paidTimeOffEntries String
RequestURI String
RequestDesc String
RequestStartDate Date
MetadataEntitlementCodes String
MetaMultiPeriodRequestIndicator Boolean
Actions String
RequestorComment String
ApprovalDueDate Date
PositionRefPositionID String
PositionRefSchemeName String
PositionRefSchemeAgencyName String
PositionReftitle String

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462