Bed Pressure Workspace
Operational Landing Page
Current Status
The bed manager command console: worst-first pressure, active alerts, and lightweight trust cues on every number.
Use Case Workspace
Bed Pressure Intelligence
A self-contained module for occupancy pressure, breach forecasting, trend evidence, operational decisions, and one-click provenance.
Pipeline 8m ago6/6 sources42/42 tests
Ranked Ward Risk Table
Worst first, always
Occupancy cards are sorted by severity, then by occupancy. Click into forecasts or provenance.
DATA 8m OK6/6 sources42/42 tests
Record Specificationanalytics.fct_bed_occupancy
Columns (9)
Source:analytics.fct_bed_occupancy| Column | Type | Description |
|---|---|---|
occupancy_fact_key | text | occupancy fact key column from analytics.fct_bed_occupancy. |
date_day | date | date day column from analytics.fct_bed_occupancy. |
ward_id | text | ward id column from analytics.fct_bed_occupancy. |
occupied_beds | integer | occupied beds column from analytics.fct_bed_occupancy. |
licensed_beds | integer | licensed beds column from analytics.fct_bed_occupancy. |
staffed_beds | integer | staffed beds column from analytics.fct_bed_occupancy. |
available_beds | integer | available beds column from analytics.fct_bed_occupancy. |
occupancy_rate | numeric | occupancy rate column from analytics.fct_bed_occupancy. |
pressure_flag | boolean | pressure flag column from analytics.fct_bed_occupancy. |
Sample Data (3 rows)
Preview Row 1
- occupancy_fact_key
- d19fe4bec411cfc1b5b925c8e42d04b0
- date_day
- 2026-03-31
- ward_id
- WARD-01
- occupied_beds
- 21
- licensed_beds
- 32
- staffed_beds
- 28
- available_beds
- 7
- occupancy_rate
- 0.7500
- pressure_flag
- false
Preview Row 2
- occupancy_fact_key
- 5066d050efee9f372fe446fcd14fa2ce
- date_day
- 2026-03-31
- ward_id
- WARD-02
- occupied_beds
- 20
- licensed_beds
- 30
- staffed_beds
- 26
- available_beds
- 6
- occupancy_rate
- 0.7692
- pressure_flag
- false
Preview Row 3
- occupancy_fact_key
- e1eed7f16882c8007c6e2be7ba6df090
- date_day
- 2026-03-31
- ward_id
- WARD-03
- occupied_beds
- 16
- licensed_beds
- 24
- staffed_beds
- 20
- available_beds
- 4
- occupancy_rate
- 0.8000
- pressure_flag
- false
Tests (6 passing)
PASS not_null(occupancy_fact_key)PASS unique(occupancy_fact_key)PASS not_null(date_day)PASS not_null(ward_id)PASS relationships(ward_id)PASS not_null(occupancy_rate)