---
title: "Department"
description: |
  Reference list of the clinical departments that make up the health system, each with the
  clinical specialty it serves and its staffed-bed capacity. Departments are the organizational
  unit behind appointments, provider assignments and daily bed census — staffed beds is the
  denominator for every occupancy and capacity calculation in the model.
tags: ["owox"]
type: "OWOX Data Mart"
timestamp: 2026-07-23T17:34:11.000Z
---

# Schema

| Column | Type | Alias | Description |
|--------|------|-------|-------------|
| `department_id` | STRING | Department ID | PK. Unique department identifier. |
| `name` | STRING | Name | Department name. |
| `specialty` | STRING | Specialty | Clinical specialty the department serves. |
| `staffed_beds` | INTEGER | Staffed Beds | Number of staffed beds — the utilization denominator. |

# Example Questions

- Which departments carry the most staffed-bed capacity, and how does that compare to their `appointment` and `patient volume`?
- How is clinical specialty distributed across departments?
- Which departments are capacity-constrained relative to peers with a similar specialty?
