JDBC Driver for Workday

Build 24.0.9062

WorkersTimeOffDetails

Retrieves a collection of time off details for the specified worker.

Workday Resource Information

Retrieves the Time Off Entries for the specified worker ID. You can filter by date range, status, and type. If you don't specify query parameters, this method returns all Time Off Entries.

Secured by: Self-Service: Time Off, Worker Data: Time Off (Time Off Manager View), Worker Data: Time Off (Time Off)

Scope: Time Off and Leave

Columns

Name Type Description
Workers_Id [KEY] String The Workday ID of the Workers that owns this.
Comment String Supported for: SELECT. The comment on the time off entry.
Date Datetime Supported for: SELECT. The Date of the Time Off Entry using the format yyyy-mm-dd.
Position_Descriptor String Supported for: SELECT. A description of the instance
Position_Href String Supported for: SELECT. A link to the instance
Position_Id String Supported for: SELECT. wid / id / reference id
Quantity Decimal Supported for: SELECT. The Quantity of the Time Off Entry in the units specified by the Unit response field.
Reason_Descriptor String Supported for: SELECT. A description of the instance
Reason_Href String Supported for: SELECT. A link to the instance
Reason_Id String Supported for: SELECT. wid / id / reference id
Status_Descriptor String Supported for: SELECT. A description of the instance
Status_Href String Supported for: SELECT. A link to the instance
Status_Id String Supported for: SELECT. wid / id / reference id
TimeOffType_Descriptor String Supported for: SELECT. The Time Off Type Name or Absence Table Name for Coordinated Time Off Entry.
TimeOffType_Id String Supported for: SELECT. Id of the instance
Unit_Descriptor String Supported for: SELECT. A description of the instance
Unit_Href String Supported for: SELECT. A link to the instance
Unit_Id String Supported for: SELECT. wid / id / reference id
Worker_Descriptor String Supported for: SELECT. A description of the instance
Worker_Href String Supported for: SELECT. A link to the instance
Worker_Id String Supported for: SELECT. wid / id / reference id
FromDate_Prompt Date The start of a date range filter using the yyyy-mm-dd format.
Status_Prompt String Accepts multiple inputs. The Workday ID of the time off status. You can specify multiple status query parameters. This method returns the most recent instance of a time off entry based on this query parameter.
TimeOffType_Prompt String Accepts multiple inputs. The Workday ID of the Time Off Type. You can specify multiple timeOffType query parameters.
ToDate_Prompt Date The end of a date range filter using the yyyy-mm-dd format.
IncludeTerminatedWorkers_Prompt Bool Only used when a Workers_Id filter is not provided. Include terminated workers in the output
Search_Prompt String Only used when a Workers_Id filter is not provided. Searches workers by name or worker ID. The search is case-insensitive. You can include space-delimited search strings for an OR search.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062