Business meaning
Daily ward occupancy facts used to monitor live pressure and breach risk.
Grain: One row per ward per day
Asset detail
Governance asset
Ward Occupancy Fact
Inspect the governed asset behind the KPI story, including contract shape, lineage proof, freshness, tests, and downstream impact.
Bed Pressure Intelligence
Ward Occupancy Fact
analytics.fct_bed_occupancy
Owner and steward
Clinical Operations Analytics
Steward: Capacity Planning Lead | Contact path not yet instrumented
Trust signals
- Freshness: fresh
- Quality: passing
- Lineage: complete
- Certification: certified
Related dashboards and consumers
Ward Occupancy TrendsBed Occupancy IntelligenceForecast runtimeAnomaly runtimeStatus workspaceSuperset dashboard
Column contract
| Column | Type | Class | Workspace |
|---|---|---|---|
ward_id | text | internal | Exposed |
date_day | date | internal | Exposed |
occupied_beds | integer | internal | Exposed |
staffed_beds | integer | internal | Exposed |
occupancy_rate | numeric | internal | Exposed |
pressure_flag | boolean | internal | Exposed |
Glossary links
Occupancy Rate
Open glossaryTraceability
Data Lineage
Freshness
Source Freshness
Operational SLAs with live elapsed-time tracking against the source landing zone.
No use-case-specific freshness sources are connected for this governance view yet.
Change Management
Impact Analysis
If a source changes, this shows the downstream models and product surfaces that need revalidation.
0models affected
Quality
Data Quality Coverage
dbt tests are surfaced alongside the live data product so every metric carries visible validation coverage.
0 tests tracked
No use-case-specific test coverage is connected for this governance view yet.
Compliance
Compliance & Data Classification
PII tagging, retention, masking posture, and audit expectations brought into the same product surface as the live metrics.
Data Classification
PII Tracking
Freshness SLAs
Critical models: 0 hours
Analytics models: 0 hours
Reference data: 0 hours
Status: Some sources need attention
Audit Trail
All data access logged with 0-day retention.
PII access requires authentication and an audit entry.
Last audit query: unknown.