CData Python Connector for Workday

Build 25.0.9454

Balances

Stores balance information for all absence-plan and leave-of-absence types. This table enables tracking of employee entitlements, accruals, and remaining leave balances for payroll processing and compliance with leave policies.

Workday Resource Information

Retrieves the specified balance of all absence plan and leave of absence types for the specified balance ID. You can use a returned id from GET /balances.

Secured by: Self-Service: Leave of Absence Entitlements, Self-Service: Time Off Balances, Worker Data: Leave of Absence, Worker Data: Time Off (Time Off Balances Manager View), Worker Data: Time Off (Time Off Balances)

Scope: Time Off and Leave

Aggregate Fields

The connector represents the following fields as aggregates containing JSON text. Each of them conforms to their respective schema. Fields marked with an asterisk are required and must be included if their parent object is. Fields marked with a hyphen are read-only and must not be included when calling stored procedures or when performing an INSERT or UPDATE.

This information is derived from the Workday REST API specification which does not explicitly list all business rules and validations that apply to each object. More fields may be required than what is listed here.

AbsencePlan_AbsenceTable_Aggregate


[{
  descriptor: Text /* The display name of the instance */
  id: Text /* Id of the instance */
}]

Columns

Name Type Description
AbsencePlan_AbsenceTable_Aggregate String This field returns the absence table associated with the absence balance. The absence table provides detailed records of time off accruals, usage, and remaining balances.
AbsencePlan_Descriptor String This field provides a human-readable summary of the absence container based on the calendar display option. This descriptor ensures clarity in understanding the specific absence plan being referenced.
AbsencePlan_Id String This field contains the unique identifier (Id) for the absence container. The Id ensures that each absence plan is properly linked to a worker's leave or time-off records.
AbsencePlan_Timeoffs String This field returns the name of the time off category for which the balance is being reported. The time-off category defines the type of leave, such as vacation, sick leave, or parental leave.
Category_Descriptor String The display name of the instance
Category_Href String This field contains a direct link to the absence category instance. The link provides programmatic access to retrieve additional details about the category.
Category_Id String This field contains the unique Id for the absence category. The Id ensures accurate classification and grouping of absence balances within the system.
DateOfFirstAbsence Datetime This field records the first day of leave for the corresponding leave type for which the balance is being returned. The date helps track the start of an employee's time off period.
EffectiveDate Datetime This field specifies the date for which the absence balance is reported. The effective date ensures that the balance is accurate based on a specific point in time.
Position_Descriptor String The display name of the instance
Position_Id String This field contains the unique Id for the position associated with the absence balance. The Id ensures that absence balances are accurately linked to a worker's job position.
Quantity Decimal This field represents the balance amount for the time off, absence table, or leave type. The balance value specifies the remaining leave entitlement or accrued time available.
Unit_Descriptor String The display name of the instance
Unit_Href String This field contains a direct link to the unit instance associated with the absence balance. The link provides programmatic access to retrieve additional details about the unit of measure (UOM).
Unit_Id String This field contains the unique Id for the UOM. The Id ensures that the balance is accurately categorized based on the applicable unit type.
Worker_Descriptor String The display name of the instance
Worker_Href String This field contains a direct link to the worker instance. The link provides programmatic access to retrieve additional details about the worker's absence records.
Worker_Id String This field contains the unique Id for the worker associated with the absence balance. The Id ensures that absence balances are correctly attributed to the appropriate employee.
Category_Prompt String The Workday ID of the time off, leave type, or absence table.
Effective_Prompt Date The absence balances as of the specified date using the yyyy-mm-dd format.
Worker_Prompt String The Workday ID of the worker for which balances are returned. This is a required query parameter.

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