ODBC Driver for Workday

Build 25.0.9434

allAllowancePlans

Accesses the Allowance Plan as the primary object and returns one row per plan. Includes all allowance plans. Does not contain built-in prompts. This data source delivers the additions and removals for plans over time.

Columns

Name Type References Description
classOfInstance1_id String Unique identifier for the class of the compensation plan instance.
classOfInstance1_descriptor String Human-readable label for the class of the compensation plan instance.
cf_CompensationPlanEqualToHourly Bool Indicates whether the compensation plan is categorized as an hourly wage plan (True/False).
cf_FrequencyForCompensationPlan_id String Unique identifier for the frequency of the compensation plan (e.g., weekly, bi-weekly, monthly).
cf_FrequencyForCompensationPlan_descriptor String Descriptive name for the frequency of the compensation plan.
cf_CompensationPlanEqualToAllowance Bool Indicates whether the compensation plan includes allowances (True/False).
cf_CompensationPlanEqualToBonus Bool Indicates whether the compensation plan includes bonuses (True/False).
cf_CompensationPlanTypeEqualToMerit Bool Indicates whether the compensation plan is classified as a merit-based plan (True/False).
cf_CompensationPlanEqualToCommission Bool Indicates whether the compensation plan includes commission-based payments (True/False).
cf_CompensationPlanEqualToStock Bool Indicates whether the compensation plan includes stock-based compensation (True/False).
cf_CompensationPlanEqualToSalaryPlanUnitPeriodOrSalary Bool Indicates whether the compensation plan is structured as a salary plan, defined by unit, period, or a fixed salary (True/False).
compensationPlanName String The official name assigned to the compensation plan.
description String A general description of the compensation plan.
compensationPlanDefaults_id String Unique identifier for the default settings associated with the compensation plan.
compensationPlanDefaults_descriptor String Human-readable description of the default settings for the compensation plan.
compensationPlanProcessHistory String Records and tracks historical changes made to the compensation plan.
compensationPackages String Lists the different compensation packages associated with the plan.
eligibilityRules String Defines the rules that determine employee eligibility for the compensation plan.
compensationPlan_id String Unique identifier for the specific compensation plan.
compensationPlan_descriptor String Descriptive label for the compensation plan.
positionsInCompensationPlan String Lists the job positions that fall under this compensation plan.
employeesInCompensationPlan String Lists employees enrolled in this compensation plan.
calculationType_id String Unique identifier for the calculation method used in the compensation plan.
calculationType_descriptor String Descriptive label for the calculation method applied to the compensation plan.
calculation_id String Unique identifier for the specific calculation associated with the compensation plan.
calculation_descriptor String Descriptive label for the specific calculation applied within the compensation plan.
effectiveAsOfDate Date A pseudo-column used to filter data based on the effective date of the compensation plan.
effectiveAsOfMoment Datetime A pseudo-column used to filter data based on the exact timestamp of the compensation plan's effectiveness.
entryDate Date A pseudo-column used to filter data based on the date the compensation plan entry was recorded.
entryMoment Datetime A pseudo-column used to filter data based on the exact timestamp of when the compensation plan entry was recorded.

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