Open Positions

Open Positions: Number of open requisitions (unfilled roles) at the end of the period.

Formula

Open Positions = Count of open requisitions at period end

Computable definition

The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.

count_distinct(field.requisition_id where field.requisition_status = 'open') at period_end

Unit: count

Data requirements

Grain: End-of-month snapshot · Frequency: Monthly · Aggregation: snapshot (month) · Staged: no · Main source: ATS.

Field	Dataset	Type
`requisition_id`	requisition	string
`requisition_status`	requisition	string
`snapshot_date`	requisition	date

Example SQL (Postgres)

SELECT (SELECT COUNT(DISTINCT requisition_id) FROM requisition WHERE snapshot_date = :period_end AND requisition_status = 'open') AS open_positions

From an agent: with the GASP MCP server, call lookup_metric({ "name": "Open Positions" }) or generate_query({ "metric": "Open Positions", "adapter": "<your adapter JSON>" }).

What It Tells You

Hiring backlog and growth plans.

← Back to People metrics