JDBC Driver for Workday

Build 22.0.8462

allOpenPositions

Accesses the Position as its primary object. The Position object returns one row per position. Includes only open positions that are in supervisory organizations that the user has access. Does not contain any built-in prompts.

Columns

Name Type References Description
cf_SupervisoryOrganizationHierarchy_id String Supervisory Organization Hierarchy id
cf_SupervisoryOrganizationHierarchy_descriptor String Supervisory Organization Hierarchy descriptor
cf_EarliestHireDate_Quarter String Earliest Hire Date - Quarter
cf_MonthsFromEarliestHireDate Int Months from Earliest Hire Date
cf_TimeToFill1 Int Time to Fill
cf_OpenPositionCountAtEndOfLastQuarter Int Open Position Count at End of Last Quarter
cf_ExecutiveGroup1_id String Executive Group id
cf_ExecutiveGroup1_descriptor String Executive Group descriptor
cf_AnnualPositionBurdenInUSD1_value Decimal Annual Position Burden in USD value
cf_AnnualPositionBurdenInUSD1_currency String Annual Position Burden in USD currency
cf_DaysFromEarliestHireDate Int Days from Earliest Hire Date
cf_NumberOfMonthsPositionUnfilled Int # of Months Position Unfilled
cf_PositionCount_Frozen Int Position Count - Frozen
cf_AnnualPositionBurdenInUSDOpenPositionsOnly_value Decimal Annual Position Burden in USD (Open Positions Only) value
cf_AnnualPositionBurdenInUSDOpenPositionsOnly_currency String Annual Position Burden in USD (Open Positions Only) currency
cf_IsPositionOpenAndEarliestHireDateCurrent Bool Is Position Open and Earliest Hire Date Current
cf_EarliestHireDate9Months1 Date Earliest Hire Date + 9 Months
cf_CompensationRangeMidpointInUSD_value Decimal Compensation Range Midpoint in USD value
cf_CompensationRangeMidpointInUSD_currency String Compensation Range Midpoint in USD currency
cf_EarliestHireDate6Months1 Date Earliest Hire Date + 6 Months
cf_OpenPositionCount_GAndA Int Open Position Count - G and A
cf_TimeInPositionRange_id String Time in Position Range id
cf_TimeInPositionRange_descriptor String Time in Position Range descriptor
cf_IsInGAndA Bool Is in G and A
cf_AvailableYearQuarter String Available Year Quarter
cf_EarliestHireDate3Months1 Date Earliest Hire Date + 3 Months
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.8462