Level 1 · Enterprise
Flat tables matching the legacy SSRS report layout — one at market level, one at practice level with the market carried as a column.
48 patients in facility now · current
Discharges with no appointment or no completed visit · current
7 IP admissions · Sep 2026
3 ED visits · Sep 2026
Of 20 discharges · Sep 2026
0% of IP admissions · Sep 2026
One row per market · Sep 2026
| Market | Panel size | Admits | Admit status | ER visits | ER status | Admit cap <250 | Admit cap <300 | ER cap <350 | ER cap <400 | PCP visit ≤7d | 60d readmit |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Desert Ridge | 87 | 1 | 1 | 2 | 2 | 3 | 3 | 0% | 0% | ||
| Gulf Coast | 98 | 0 | 1 | 2 | 2 | 3 | 3 | 0% | 0% | ||
| North Valley | 150 | 5 | 1 | 3 | 4 | 4 | 5 | 0% | 0% | ||
| Piedmont | 165 | 1 | 0 | 3 | 4 | 5 | 6 | 0% | 0% |
Caps convert the per-1,000-per-year goal into a raw monthly count for each panel. Green = under the tighter cap (admits <250 / ER <350), amber = under the looser cap, red = over.
One row per practice, with its market · Sep 2026
| Market | Practice | Panel size | Admits | Admit status | ER visits | ER status | Admit cap <250 | Admit cap <300 | ER cap <350 | ER cap <400 | PCP visit ≤7d | 60d readmit |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Desert Ridge | Mesa Family Medicine | 47 | 0 | 1 | 1 | 1 | 1 | 2 | 0% | 0% | ||
| Desert Ridge | Saguaro Care | 40 | 1 | 0 | 1 | 1 | 1 | 1 | 0% | 0% | ||
| Gulf Coast | Bayside Medical | 45 | 0 | 1 | 1 | 1 | 1 | 2 | 0% | 0% | ||
| North Valley | Cedar Hills Family | 50 | 2 | 0 | 1 | 1 | 1 | 2 | 0% | 0% | ||
| North Valley | Lakeview Internal | 58 | 0 | 1 | 1 | 1 | 2 | 2 | 0% | 0% | ||
| North Valley | Redwood Primary | 42 | 3 | 0 | 1 | 1 | 1 | 1 | 0% | 0% | ||
| Piedmont | Millbrook Clinic | 55 | 1 | 0 | 1 | 1 | 2 | 2 | 0% | 0% |
Caps convert the per-1,000-per-year goal into a raw monthly count for each panel. Green = under the tighter cap (admits <250 / ER <350), amber = under the looser cap, red = over.
Patient-level admission and ED event detail · Sep 2026 · 15 events
| Event ID | Patient | MRN | Event type | Facility | Market | Practice | Provider | Admitted | Discharged | Risk | Visit status | PCP ≤7d | 60d readmit |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CEN-10293 | Gerald Petrov | M470588 | Inpatient | St. Aldon Regional | Desert Ridge | Saguaro Care | Dr. D. Moreau | Sep 3 | — | Serious | Not scheduled | ||
| CEN-10405 | Dwight Tanaka | M419612 | ED | Valley Baptist ED | North Valley | Lakeview Internal | Dr. L. Castellanos | Sep 3 | Sep 3 | Fair | Scheduled | ||
| CEN-10439 | Bernard Abernathy | M417041 | Inpatient | Northside Medical Center | North Valley | Cedar Hills Family | Dr. L. Castellanos | Sep 3 | — | Critical | Not scheduled | ||
| CEN-10546 | Willie Mbeki | M415591 | Home Health | BrightPath Home Health | Desert Ridge | Saguaro Care | Dr. K. Vasquez | Sep 3 | — | Good | Not scheduled | ||
| CEN-10575 | Ingrid Tanaka | M450769 | ED | Mercy General ED | Gulf Coast | Bayside Medical | Dr. E. Boateng | Sep 3 | Sep 3 | Good | Not scheduled | ||
| CEN-10720 | Terrance Guillory | M443908 | Inpatient | Northside Medical Center | North Valley | Cedar Hills Family | Dr. T. Lindqvist | Sep 3 | — | Serious | Not scheduled | ||
| CEN-10723 | Harold Lindstrom | M452724 | Inpatient | Mercy General | North Valley | Redwood Primary | Dr. K. Vasquez | Sep 3 | — | Critical | Not scheduled | ||
| CEN-10150 | Hattie Ferreira | M469023 | ED | St. Aldon Regional ED | Desert Ridge | Mesa Family Medicine | Dr. K. Vasquez | Sep 2 | Sep 2 | Good | Not scheduled | ||
| CEN-10375 | Ruth Abernathy | M444984 | Home Health | Comfort Care at Home | Desert Ridge | Saguaro Care | Dr. L. Castellanos | Sep 2 | — | Good | Not scheduled | ||
| CEN-10732 | Jonas Abernathy | M495404 | Inpatient | Valley Baptist | North Valley | Redwood Primary | Dr. P. Aiyer | Sep 2 | — | Fair | Not scheduled | ||
| CEN-10040 | Cora Salazar | M449659 | Inpatient | Valley Baptist | North Valley | Redwood Primary | Dr. A. Whitfield | Sep 1 | — | Serious | Not scheduled | ||
| CEN-10104 | Alma Mbeki | M444975 | Inpatient | Mercy General | Piedmont | Millbrook Clinic | Dr. K. Vasquez | Sep 1 | — | Good | Not scheduled | ||
| CEN-10336 | Cora Rios | M422697 | SNF | Golden Oaks Rehab | North Valley | Cedar Hills Family | Dr. R. Nakamura | Sep 1 | — | Good | Not scheduled | ||
| CEN-10540 | Willie Mbeki | M483501 | Home Health | Comfort Care at Home | Desert Ridge | Saguaro Care | Dr. A. Whitfield | Sep 1 | — | Fair | Not scheduled | ||
| CEN-10616 | Harold Ionescu | M469259 | Home Health | Comfort Care at Home | Desert Ridge | Mesa Family Medicine | Dr. P. Aiyer | Sep 1 | — | Fair | Not scheduled |