Workforce Planning April 26, 2026
Workforce Planning
A scenario-based headcount planning system. The system tracks the current org (departments, locations, cost centers, jobs, employees, positions) as the source-of-truth baseline, and lets planners draft alternative future-state plans through scenarios containing staged headcount actions (add, eliminate, transfer). Approved scenarios materialize into real position records, which can then be handed off to recruiting via lightweight hiring requisitions.
Customize this Workforce Planning model
/semantic-model-analyst customize https://www.semantius.com/models/workforce_planning-semantic-model.md Build your own Workforce Planning
/semantic-model-analyst I need to plan the workforce for my org Entity summary
| # | Table name | Singular label | Purpose |
|---|---|---|---|
| 1 | departments |
Department | Org units the workforce is grouped into; supports hierarchy via parent_department_id |
| 2 | locations |
Location | Offices, regions, or remote pools where positions sit |
| 3 | cost_centers |
Cost Center | Financial buckets used to budget headcount cost |
| 4 | jobs |
Job | Catalog of role definitions — title, level, family — used to template positions |
| 5 | employees |
Employee | Current workforce members; can occupy a position and report to a manager |
| 6 | positions |
Position | A discrete seat (filled, open, or approved-future), tied to a job, department, location, cost center |
| 7 | headcount_plans |
Headcount Plan | A named plan covering a timeframe (e.g. "FY2026") with status (draft → in-review → approved → active → archived) |
| 8 | scenarios |
Scenario | A what-if version of a plan (base, optimistic, conservative, custom). Many per plan; one is marked active |
| 9 | headcount_actions |
Headcount Action | A staged change within a scenario — add, eliminate, or transfer — with effective date and cost impact |
| 10 | hiring_requisitions |
Hiring Requisition | A lightweight handoff record marking that a position has been cleared to start recruiting |
Entity-relationships
flowchart LR
departments -->|parent of| departments
employees -->|heads| departments
departments -->|primary dept for| cost_centers
employees -->|owns| cost_centers
employees -->|manages| employees
locations -->|home for| employees
jobs -->|templates| positions
departments -->|contains| positions
locations -->|hosts| positions
cost_centers -->|funds| positions
employees ---|fills| positions
positions -->|backfilled by| positions
headcount_actions -->|materializes as| positions
employees -->|owns| headcount_plans
employees -->|approves| headcount_plans
headcount_plans -->|contains| scenarios
employees -->|creates| scenarios
scenarios -->|contains| headcount_actions
positions -->|targeted by| headcount_actions
jobs -->|specified in| headcount_actions
departments -->|target of| headcount_actions
locations -->|target of| headcount_actions
cost_centers -->|target of| headcount_actions
positions -->|opens| hiring_requisitions
employees -->|recruits| hiring_requisitions
employees -->|hiring manager for| hiring_requisitions