ODBC Driver for Workday

Build 22.0.8479

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.

Columns

Name Type References Description
cf_SupervisoryOrganizationHierarchy_id String Supervisory Organization Hierarchy id
cf_SupervisoryOrganizationHierarchy_descriptor String Supervisory Organization Hierarchy descriptor
cf_TimeInPositionRange_id String Time in Position Range id
cf_TimeInPositionRange_descriptor String Time in Position Range descriptor
cf_PositionsFrozen Int Positions Frozen
cf_QuarterAvailable String Quarter Available
cf_PositionText String Position Text
cf_AnnualPositionBurdenInUSD_value Decimal Annual Position Burden in USD value
cf_AnnualPositionBurdenInUSD_currency String Annual Position Burden in USD currency
cf_NumberOfMonthsUnfilledRange_id String Number of Months Unfilled Range id
cf_NumberOfMonthsUnfilledRange_descriptor String Number of Months Unfilled Range descriptor
cf_EarliestHireDate9Months Date Earliest Hire Date + 9 Months
cf_TimeInPosition_Days Int Time in Position - Days
cf_AnnualEmployeeBurdenInUSD_value Decimal Annual Employee Burden in USD value
cf_AnnualEmployeeBurdenInUSD_currency String Annual Employee Burden in USD currency
cf_DefaultCompensationRangeMidpointInUSD_value Decimal Default Compensation Range Midpoint in USD value
cf_DefaultCompensationRangeMidpointInUSD_currency String Default Compensation Range Midpoint in USD currency
cf_EarliestHireDate6Months Date Earliest Hire Date + 6 Months
cf_AnnualContingentWorkerBurdenInUSD_value Decimal Annual Contingent Worker Burden in USD value
cf_AnnualContingentWorkerBurdenInUSD_currency String Annual Contingent Worker Burden in USD currency
cf_EarliestHireDate3Months Date Earliest Hire Date + 3 Months
cf_MyOrganizations_id String My Organizations id
cf_MyOrganizations_descriptor String My Organizations descriptor
cf_PositionCount_AllStatuses Int Position Count - All Statuses
cf_AnnualCompensationPayWithBurdenInUSD_value Decimal Annual Compensation / Pay with Burden in USD value
cf_AnnualCompensationPayWithBurdenInUSD_currency String Annual Compensation / Pay with Burden in USD currency
cf_Worker_id String Worker id
cf_Worker_descriptor String Worker descriptor
cf_AnnualCompensationPayInUSD_value Decimal Annual Compensation / Pay in USD value
cf_AnnualCompensationPayInUSD_currency String Annual Compensation / Pay in USD currency
cf_WorkerType_id String Worker Type id
cf_WorkerType_descriptor String Worker Type descriptor
effectiveAsOfDate Date Pseudo-column used to filter the data source
effectiveAsOfMoment Datetime Pseudo-column used to filter the data source
entryDate Date Pseudo-column used to filter the data source
entryMoment Datetime Pseudo-column used to filter the data source

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479