Demo Health System · Freshness, pipeline health, reconciliation and alerts.
Data Quality
95.6%
Composite score
Reconciliation
92.0%
8,816 mismatches
Open Alerts
5
0 critical
Failed Checks
0
In latest run
EHR
Last successful load 49 min ago
Finance system
Last successful load 16 min ago
OR management system
Last successful load 39 min ago
Workforce Scheduling
Last successful load 0 min ago
| Check | Dimension | Score | Failed | Status | Detail |
|---|---|---|---|---|---|
| EHR feed freshness | freshness | 98.0% | 0 | Pass | ehr feed loaded 30 min ago. |
| Finance system feed freshness | freshness | 97.0% | 0 | Pass | Finance system feed loaded within its refresh window. |
| Appointment completeness | completeness | 97.0% | 3,292 | Pass | Required fields present on 97% of records. |
| Duplicate appointments | duplicates | 96.0% | 439 | Pass | Synthetic-visit-id duplication scan. |
| Valid appointment durations | validity | 94.0% | 658 | Pass | Negative / zero / >8h durations flagged. |
| Room mapping coverage | validity | 95.0% | 4 | Pass | Rooms missing a canonical mapping. |
| ehr vs finance reconciliation | reconciliation | 92.0% | 8,816 | Pass | Schedule records matching across systems: 92.0%. |
| Pipeline success rate (14d) | pipeline | 99.0% | 0 | Pass | All source ingests succeeding on schedule. |
| OR case-log freshness | freshness | 98.0% | 0 | Pass | or_mgmt OR case log loaded today. |
| OR case financial completeness | completeness | 96.0% | 16 | Pass | Revenue/cost present on 96% of completed cases. |
| Workforce roster freshness | freshness | 94.0% | 0 | Pass | workforce roster refreshes on a weekly cadence; last load within window. |
| Staff capacity completeness | completeness | 97.0% | 1 | Pass | Weekly capacity and service line present on 97% of the roster. |
| Pipeline | Source | Started | Status | Rows | Message |
|---|---|---|---|---|---|
| workforce_roster_ingest | workforce | 10/23/2026, 5:50:00 AM | success | 47 | Completed |
| finance_schedule_ingest | finance | 10/23/2026, 5:30:00 AM | success | 4,470 | Completed |
| or_case_log_ingest | or_mgmt | 10/23/2026, 5:12:00 AM | success | 333 | Completed |
| ehr_schedule_ingest | ehr | 10/23/2026, 5:00:00 AM | success | 4,257 | Completed |
| workforce_roster_ingest | workforce | 10/22/2026, 5:50:00 AM | skipped | 0 | No scheduled run (weekly cadence) |
| finance_schedule_ingest | finance | 10/22/2026, 5:30:00 AM | success | 4,840 | Completed |
| or_case_log_ingest | or_mgmt | 10/22/2026, 5:12:00 AM | success | 454 | Completed |
| ehr_schedule_ingest | ehr | 10/22/2026, 5:00:00 AM | success | 4,372 | Completed |
| workforce_roster_ingest | workforce | 10/21/2026, 5:50:00 AM | skipped | 0 | No scheduled run (weekly cadence) |
| finance_schedule_ingest | finance | 10/21/2026, 5:30:00 AM | success | 4,600 | Completed |
| or_case_log_ingest | or_mgmt | 10/21/2026, 5:12:00 AM | success | 403 | Completed |
| ehr_schedule_ingest | ehr | 10/21/2026, 5:00:00 AM | success | 4,457 | Completed |
| workforce_roster_ingest | workforce | 10/20/2026, 5:50:00 AM | skipped | 0 | No scheduled run (weekly cadence) |
| finance_schedule_ingest | finance | 10/20/2026, 5:30:00 AM | success | 4,993 | Completed |
| or_case_log_ingest | or_mgmt | 10/20/2026, 5:12:00 AM | success | 470 | Completed |
| ehr_schedule_ingest | ehr | 10/20/2026, 5:00:00 AM | success | 4,796 | Completed |
| workforce_roster_ingest | workforce | 10/19/2026, 5:50:00 AM | skipped | 0 | No scheduled run (weekly cadence) |
| finance_schedule_ingest | finance | 10/19/2026, 5:30:00 AM | success | 4,261 | Completed |
| or_case_log_ingest | or_mgmt | 10/19/2026, 5:12:00 AM | success | 462 | Completed |
| ehr_schedule_ingest | ehr | 10/19/2026, 5:00:00 AM | success | 4,932 | Completed |
ehr vs finance match rate is 92.0%, below the 95% target.
Expected response: Review mismatched visits on the Monitoring page; prioritise time/room differences.
4 rooms lack a canonical mapping and may be excluded from utilization.
Expected response: Operations to confirm room identifiers and update the mapping table.
A small number of visits share a synthetic visit id across feeds.
Expected response: Auto-dedup applied; review the duplicates data-quality check for details.
Some appointments have implausible durations (zero or >8h) and were excluded.
Expected response: Confirm scheduling templates for affected appointment types.
Dermatology Clinic saw a no-show rate well above its baseline on recent spike days.
Expected response: Consider reminder outreach and overbooking policy for high-risk slots.