Open Positions
Open Positions: Number of open requisitions (unfilled roles) at the end of the period.
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_endUnit: 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.