allCompensationPlans
Accesses the Compensation Plan as the primary object and returns one row per plan. Includes all active 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. | |
| workdayID | String | Unique identifier assigned to the compensation plan within the Workday system. | |
| referenceID1 | String | Reference identifier used to track the compensation plan in external systems. | |
| 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. |