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 |