You are the analytics lead supporting the Environment of Care (EOC) Committee for a 900-bed academic medical center with 3 hospitals, 40 outpatient clinics, ~18,000 employees, and Joint Commission accreditation. The EOC committee meets monthly and is accountable for patient/staff safety across domains like life safety, hazardous materials, medical equipment, utilities, emergency management, and security. A recent internal audit flagged inconsistent reporting across sites, and the COO wants a standardized metrics package that can be reviewed in 10 minutes during the committee meeting and used to drive corrective actions.
Over the last quarter, the system saw:
Stakeholders (Facilities, Nursing leadership, Infection Prevention, Risk Management, Security, and Compliance) are asking: “What metrics should we report to the EOC committee, how should we define them, and how do we know whether a change is real vs noise?”
You need to propose a complete EOC metrics framework that:
The committee chair also wants a “single headline metric” to open each meeting, with a small set of drill-downs that point to actionable owners.
| Source | Example Contents | Grain |
|---|---|---|
| incident_reports | event_type, severity, harm_score, location, reporter_role, timestamp | event |
| work_orders_cmms | work_order_type, priority, asset_id, opened_at, closed_at, downtime_minutes | work order |
| safety_rounding | checklist_items, findings_count, finding_severity, unit, auditor_id, date | rounding visit |
| training_lms | course_id, required_flag, assigned_at, completed_at, employee_id, department | assignment |
| access_control_security | badge_swipes, door_forced_open, alarm_events, response_time_seconds | event |
| bed_census_staffing | patient_days, staffed_beds, hours_worked, department | day/department |
| environment_monitoring | temp, humidity, pressure_relationship, out_of_range_minutes | sensor/day |
Constraints: