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 | Unique identifier for the supervisory organization hierarchy. | |
| cf_SupervisoryOrganizationHierarchy_descriptor | String | Descriptive label for the supervisory organization hierarchy. | |
| cf_EarliestHireDate_Quarter | String | The earliest hire date categorized by quarter. | |
| cf_MonthsFromEarliestHireDate | Int | Number of months that have passed since the earliest hire date. | |
| cf_TimeToFill1 | Int | Number of days required to fill an open position. | |
| cf_OpenPositionCountAtEndOfLastQuarter | Int | Total number of open positions at the end of the last quarter. | |
| cf_ExecutiveGroup1_id | String | Unique identifier for the executive group. | |
| cf_ExecutiveGroup1_descriptor | String | Descriptive label for the executive group. | |
| cf_AnnualPositionBurdenInUSD1_value | Decimal | Annual cost associated with a position, expressed in USD. | |
| cf_AnnualPositionBurdenInUSD1_currency | String | Currency used for the annual position burden amount. | |
| cf_DaysFromEarliestHireDate | Int | Number of days that have passed since the earliest hire date. | |
| cf_NumberOfMonthsPositionUnfilled | Int | Number of months a position has remained unfilled. | |
| cf_PositionCount_Frozen | Int | Number of positions that are currently frozen. | |
| cf_AnnualPositionBurdenInUSDOpenPositionsOnly_value | Decimal | Annual position burden in USD for open positions only. | |
| cf_AnnualPositionBurdenInUSDOpenPositionsOnly_currency | String | Currency used for the annual position burden of open positions. | |
| cf_IsPositionOpenAndEarliestHireDateCurrent | Bool | Indicates whether the position is open and the earliest hire date is current (True/False). | |
| cf_EarliestHireDate9Months1 | Date | Earliest hire date plus nine months. | |
| cf_CompensationRangeMidpointInUSD_value | Decimal | Midpoint value of the compensation range, expressed in USD. | |
| cf_CompensationRangeMidpointInUSD_currency | String | Currency used for the compensation range midpoint. | |
| cf_EarliestHireDate6Months1 | Date | Earliest hire date plus six months. | |
| cf_OpenPositionCount_GAndA | Int | Total number of open positions in General and Administrative (G and A) departments. | |
| 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_IsInGAndA | Bool | Indicates whether the position falls under General and Administrative (G and A) (True/False). | |
| cf_AvailableYearQuarter | String | The year and quarter when the position became available. | |
| cf_EarliestHireDate3Months1 | Date | Earliest hire date plus three months. | |
| effectiveAsOfDate | Date | A pseudo-column used to filter data based on the effective date of the open position. | |
| effectiveAsOfMoment | Datetime | A pseudo-column used to filter data based on the exact timestamp of the open position's effectiveness. | |
| entryDate | Date | A pseudo-column used to filter data based on the date the open position entry was recorded. | |
| entryMoment | Datetime | A pseudo-column used to filter data based on the exact timestamp of when the open position entry was recorded. |