SSIS Components for Workday

Build 25.0.9434

WorkersTimeOffDetails

Provides a detailed breakdown of a worker’s time off, including leave type, usage, and remaining balance.

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 String The Workday ID of the worker who owns this time off entry.
Comment String A comment associated with the time off entry.
Date Datetime The date of the time off entry (format: yyyy-mm-dd).
Position_Descriptor String A preview of the worker's position.
Position_Href String A link to the position instance.
Position_Id String The Workday ID of the position.
Quantity Decimal The amount of time off taken, in units specified by the Unit response field.
Reason_Descriptor String A preview of the reason for the time off.
Reason_Href String A link to the reason instance.
Reason_Id String The Workday ID of the reason.
Status_Descriptor String A preview of the time off entry's status.
Status_Href String A link to the status instance.
Status_Id String The Workday ID of the status.
TimeOffType_Descriptor String The name of the time off type or absence category.
TimeOffType_Id String The Workday ID of the time off type.
Unit_Descriptor String A preview of the unit type for the time off entry.
Unit_Href String A link to the unit instance.
Unit_Id String The Workday ID of the unit type.
Worker_Descriptor String A preview of the worker associated with this entry.
Worker_Href String A link to the worker instance.
Worker_Id String The Workday ID of the worker.
FromDate_Prompt Date Filters time off entries from this start date (format: yyyy-mm-dd).
Status_Prompt String Filters entries by status using Workday IDs. Supports multiple statuses.
TimeOffType_Prompt String Filters entries by time off type using Workday IDs. Supports multiple types.
ToDate_Prompt Date Filters time off entries up to this end date (format: yyyy-mm-dd).
IncludeTerminatedWorkers_Prompt Bool If true, includes terminated workers in the output.
Search_Prompt String Searches workers by name or Workday ID. Case-insensitive and supports space-delimited OR searches.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434