ADO.NET Provider for Workday

Build 25.0.9434

WorkersLeavesOfAbsence

Retrieves detailed information on leaves of absence taken by a worker, including duration, type of leave, and status.

Workday Resource Information

Retrieves information about the leave of absence for the worker with the specified ID.

Secured by: Self-Service: Leave of Absence, Worker Data: Leave of Absence

Scope: Time Off and Leave

Columns

Name Type Description
Id [KEY] String Unique identifier for the leave of absence record.
Workers_Id [KEY] String The Workday ID of the worker associated with this leave of absence.
ActualLastDayOfLeave Datetime The actual last day of work for the leave of absence (yyyy-mm-dd format).
AdditionalFields_AdoptionNotificationDate Datetime The date the adoption was notified (yyyy-mm-dd format).
AdditionalFields_AdoptionPlacementDate Datetime The date the adopted child was placed (yyyy-mm-dd format).
AdditionalFields_AgeOfDependent Decimal The age of the dependent at the time of the leave.
AdditionalFields_CaesareanSectionBirth Bool Indicates whether the leave is due to a caesarean birth, which may affect leave entitlements.
AdditionalFields_ChildDisabilityIndicator Bool Indicates whether the leave is related to a child with a disability, which may affect leave entitlements.
AdditionalFields_ChildsBirthDate Datetime The birth date of the child (yyyy-mm-dd format).
AdditionalFields_ChildsDateOfDeath Datetime The date of the child’s death (yyyy-mm-dd format).
AdditionalFields_DateBabyArrivedHomeFromHospital Datetime The date the baby arrived home from the hospital (yyyy-mm-dd format).
AdditionalFields_DateChildEnteredCountry Datetime The date the adopted child entered the country (yyyy-mm-dd format).
AdditionalFields_DateOfRecall Datetime The recall date for the leave (yyyy-mm-dd format).
AdditionalFields_Dependent_Descriptor String A summary of the dependent associated with the leave.
AdditionalFields_Dependent_Href String A link to the dependent's details in Workday.
AdditionalFields_Dependent_Id String The Workday ID of the dependent.
AdditionalFields_ExpectedDueDate Datetime The expected due date for the leave (yyyy-mm-dd format).
AdditionalFields_LastDateForWhichPaid Datetime The last date for which the worker received paid leave (yyyy-mm-dd format).
AdditionalFields_LeaveEntitlementOverride Decimal Custom leave entitlement override amount.
AdditionalFields_LeavePercentage Decimal Percentage of leave entitlement used.
AdditionalFields_LocationDuringLeave String The location where the worker will be during the leave.
AdditionalFields_MultipleChildIndicator Bool Indicates whether the leave is for multiple children (for example, twins, triplets).
AdditionalFields_NeonatalCareDischargeDate Datetime Neonatal Care Discharge Date.
AdditionalFields_NeonatalCareStartDate Datetime Neonatal Care Start Date.
AdditionalFields_NumberOfBabiesAdoptedChildren Decimal The number of babies or adopted children associated with this leave.
AdditionalFields_NumberOfChildDependents Decimal The number of child dependents relevant to the leave.
AdditionalFields_NumberOfPreviousBirths Decimal The number of previous births recorded for the worker.
AdditionalFields_NumberOfPreviousMaternityLeaves Decimal The number of previous maternity leaves taken.
AdditionalFields_SingleParentIndicator Bool Indicates whether the worker is a single parent, which may affect leave entitlements.
AdditionalFields_SocialSecurityDisabilityCode String The social security disability code associated with the leave.
AdditionalFields_StillbirthBabyDeceased Bool Indicates whether the leave is related to a stillbirth or deceased baby.
AdditionalFields_StopPaymentDate Datetime The date when payments stop for this leave (yyyy-mm-dd format).
AdditionalFields_WeekOfConfinement Datetime The week of confinement related to maternity leave (yyyy-mm-dd format).
AdditionalFields_WorkRelated Bool Indicates whether the leave is work-related, which may impact certain legal and payroll considerations.
BusinessProcessStepStatus String Current step status of the business process associated with the leave.
EstimatedLastDayOfLeave Datetime The estimated last day of the leave (yyyy-mm-dd format).
FirstDayOfLeave Datetime The first day of the leave (yyyy-mm-dd format).
LastDayOfWork Datetime The last working day before the leave started (yyyy-mm-dd format).
LatestLeaveComment String The most recent comment related to the leave request.
LeaveImpactFields_AbsenceAccrualEffect Bool Indicates whether this leave impacts the worker's absence accrual balance.
LeaveImpactFields_BenefitEffect Bool Indicates whether this leave affects the worker’s benefits eligibility.
LeaveImpactFields_ContinuousServiceAccrualEffect Bool Indicates whether this leave affects the worker’s continuous service accrual.
LeaveImpactFields_InactivateWorker Bool If true, the worker will be inactivated in the Workday system for the duration of the leave.
LeaveImpactFields_PayrollEffect Bool Indicates whether this leave has an impact on payroll processing.
LeaveImpactFields_ProfessionalLeaveEffect Bool Indicates whether this leave is classified as a professional leave.
LeaveImpactFields_SabbaticalEffect Bool Indicates whether this leave affects sabbatical eligibility.
LeaveImpactFields_SchedulingEffect Bool Indicates whether the worker can still be scheduled to work during the leave.
LeaveImpactFields_StockVestingEffect Bool Indicates whether this leave affects stock vesting schedules.
LeaveImpactFields_TalentEffect Bool Indicates whether this leave affects the worker’s participation in talent-related processes.
LeaveImpactFields_TenureEffect Bool Indicates whether this leave affects the worker’s tenure record.
LeaveType_Descriptor String A summary of the type of leave taken.
LeaveType_Href String A link to the leave type details in Workday.
LeaveType_Id String The Workday ID of the leave type.
Position_Descriptor String A summary of the worker's position at the time of leave.
Position_Href String A link to the position details in Workday.
Position_Id String The Workday ID of the position.
PriorLeaveEvent_Descriptor String A summary of the prior leave event, if applicable.
PriorLeaveEvent_Href String A link to the prior leave event details in Workday.
PriorLeaveEvent_Id String The Workday ID of the prior leave event.
Reason_Descriptor String A summary of the reason for the leave.
Reason_Href String A link to the leave reason details in Workday.
Reason_Id String The Workday ID of the leave reason.
Status_Descriptor String A summary of the leave status.
Status_Href String A link to the leave status details in Workday.
Status_Id String The Workday ID of the leave status.
Worker_Descriptor String A summary of the worker taking the leave.
Worker_Href String A link to the worker’s profile in Workday.
Worker_Id String The Workday ID of the worker taking the leave.
FromDate_Prompt Date The start date for filtering leave records (yyyy-mm-dd format).
LeaveType_Prompt String The Workday ID of the leave type being filtered.
Status_Prompt String The Workday ID of the leave status being filtered (for example, Completed, In Progress, Canceled).
ToDate_Prompt Date The end date for filtering leave records (yyyy-mm-dd format).
IncludeTerminatedWorkers_Prompt Bool If true, includes terminated workers in the output.
Search_Prompt String Allows searching workers by name or Workday ID. The search is case-insensitive and supports space-separated OR searches.

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