positionsValidForCompensationSelectionRule
Accesses the Position Group as its primary object. The Position Group object returns one row per Position Group. Includes all unfilled and filled Positions. Prompts the user at run-time for a Compensation Rule to automatically filter the report results.
Table Specific Information
Select
The Workday provider requires filtering on compensationEligibilityRule_Prompt in order to perform the query.
For example:
SELECT * FROM positionsValidForCompensationSelectionRule WHERE compensationEligibilityRule_Prompt = '1fcf0b79747a43d1a4de334e0c214b1b';
Columns
| Name | Type | References | Description |
| cf_SupervisoryOrganizationHierarchy_id | String | Unique identifier for the supervisory organization hierarchy. | |
| cf_SupervisoryOrganizationHierarchy_descriptor | String | Descriptive label for the supervisory organization hierarchy. | |
| cf_TimeInPositionRange_id | String | Unique identifier for the time in position range. | |
| cf_TimeInPositionRange_descriptor | String | Descriptive label for the time in position range. | |
| cf_PositionsFrozen | Int | Total number of frozen positions. | |
| cf_QuarterAvailable | String | Quarter in which the position is available. | |
| cf_PositionText | String | Descriptive text associated with the position. | |
| cf_AnnualPositionBurdenInUSD_value | Decimal | Total annual burden cost of the position, expressed in USD. | |
| cf_AnnualPositionBurdenInUSD_currency | String | Currency in which the annual position burden is measured. | |
| cf_NumberOfMonthsUnfilledRange_id | String | Unique identifier for the range of months a position has been unfilled. | |
| cf_NumberOfMonthsUnfilledRange_descriptor | String | Descriptive label for the range of months a position has been unfilled. | |
| cf_EarliestHireDate9Months | Date | Earliest hire date plus nine months. | |
| cf_TimeInPosition_Days | Int | Number of days the position has been occupied. | |
| cf_AnnualEmployeeBurdenInUSD_value | Decimal | Total annual burden cost of an employee in this position, expressed in USD. | |
| cf_AnnualEmployeeBurdenInUSD_currency | String | Currency in which the annual employee burden is measured. | |
| cf_DefaultCompensationRangeMidpointInUSD_value | Decimal | Midpoint of the default compensation range, expressed in USD. | |
| cf_DefaultCompensationRangeMidpointInUSD_currency | String | Currency in which the default compensation range midpoint is measured. | |
| cf_EarliestHireDate6Months | Date | Earliest hire date plus six months. | |
| cf_AnnualContingentWorkerBurdenInUSD_value | Decimal | Total annual burden cost of a contingent worker, expressed in USD. | |
| cf_AnnualContingentWorkerBurdenInUSD_currency | String | Currency in which the annual contingent worker burden is measured. | |
| cf_EarliestHireDate3Months | Date | Earliest hire date plus three months. | |
| cf_MyOrganizations_id | String | Unique identifier for the associated organization. | |
| cf_MyOrganizations_descriptor | String | Descriptive label for the associated organization. | |
| cf_PositionCount_AllStatuses | Int | Total number of positions across all statuses. | |
| cf_AnnualCompensationPayWithBurdenInUSD_value | Decimal | Annual compensation or pay including burden costs, expressed in USD. | |
| cf_AnnualCompensationPayWithBurdenInUSD_currency | String | Currency in which the annual compensation with burden is measured. | |
| cf_Worker_id | String | Unique identifier for the worker assigned to the position. | |
| cf_Worker_descriptor | String | Descriptive label for the worker assigned to the position. | |
| cf_AnnualCompensationPayInUSD_value | Decimal | Total annual compensation or pay, expressed in USD. | |
| cf_AnnualCompensationPayInUSD_currency | String | Currency in which the annual compensation or pay is measured. | |
| cf_WorkerType_id | String | Unique identifier for the worker type classification. | |
| cf_WorkerType_descriptor | String | Descriptive label for the worker type classification. | |
| effectiveAsOfDate | Date | A pseudo-column used to filter data based on the effective date of the position. | |
| effectiveAsOfMoment | Datetime | A pseudo-column used to filter data based on the exact timestamp of the position's effectiveness. | |
| entryDate | Date | A pseudo-column used to filter data based on the date the position entry was recorded. | |
| entryMoment | Datetime | A pseudo-column used to filter data based on the exact timestamp of when the position entry was recorded. |