| Wait time capture rate | Completed visits with both check-in time and consultation start time divided by all completed visits. Measures the completeness of the HIS data behind the wait time metric.= hc_wait_measured_visits / Visits | Ratio (%) |
|---|
| Departments viewing dashboards | Number of distinct departments with at least one dashboard view in the period. | Count |
|---|
| Average request lead time (days) | Average days from when a department submits a request to when the data team delivers it, for requests delivered in the period.= da_request_lead_days_total / Delivered requests | Number |
|---|
| Average run duration (minutes) | Average minutes from start to finish of successful runs in the period.= da_run_minutes_total / da_successful_runs | Number |
|---|
| Check pass rate | Passed checks divided by all data quality checks in the period.= (Data quality checks - Failed checks) / Data quality checks | Ratio (%) |
|---|
| Dashboard views | Total dashboard views by users across departments in the period. | Count |
|---|
| Delivered requests | Delivered requests with a delivery date in the period (by delivery date). | Count |
|---|
| Failed checks | Data quality checks with a standardized result of fail in the period. | Count |
|---|
| Failed runs | Pipeline runs with a standardized status of failed (including errors and timeouts), by start date. | Count |
|---|
| Freshness breaches | Successful runs where the gap since the previous successful load of the same table exceeds that table's freshness commitment (freshness_sla_hours). | Count |
|---|
| Pipeline runs | Data loading pipeline runs started in the period, including successful, failed and skipped runs. | Count |
|---|
| Data quality checks | Data quality checks run in the period (freshness, completeness, uniqueness, validity). | Count |
|---|
| Analysis requests | Analysis and report requests that departments submitted to the data team in the period (by submission date). | Count |
|---|
| Run success rate | Successful runs divided by runs with an outcome (successful plus failed). Skipped runs are excluded.= da_successful_runs / (da_successful_runs + Failed runs) | Ratio (%) |
|---|
| Appointments | Total appointments by appointment date, in every status (completed, no-show, cancelled). | Count |
|---|
| Average wait time (minutes) | Average minutes from check-in to the start of the consultation, over completed visits that have both timestamps.= hc_wait_minutes_total / hc_wait_measured_visits | Number |
|---|
| Insurance-paid amount | Total amount covered by insurance (public health insurance and private insurance) in the service charges of completed visits. | Currency |
|---|
| Insurance share | Insurance-paid amount divided by service revenue.= Insurance-paid amount / Service revenue | Ratio (%) |
|---|
| No-show rate | No-shows divided by (completed visits + no-shows). Appointments cancelled in advance are excluded.= No-shows / (Visits + No-shows) | Ratio (%) |
|---|
| No-shows | Appointments with the standard status no_show (the patient did not attend). | Count |
|---|
| Service revenue | Total service charges of completed visits (insurance portion plus patient portion), by visit date. | Currency |
|---|
| Revenue per visit | Service revenue divided by completed visits.= Service revenue / Visits | Currency |
|---|
| Unique patients | Distinct patients with at least one completed visit in the period. | Count |
|---|
| Visits | Appointments with the standard status completed, by visit date. | Count |
|---|
| Visits per doctor day | Completed visits divided by doctor days (days on which a doctor had at least one completed visit).= Visits / hc_doctor_days | Number |
|---|