Inventory
All 33 customers in the snapshot. These figures measure configuration footprint, not business importance — there is no revenue, claim volume, or patient count in this data. What they do measure well is how much work each customer represents.
The inversion
ECP has the most SQL calculations of any customer and looks worst-blocked. But those uses are four distinct bodies, and nearly all are one modifier-55 rule. Femwellis mid-tier by SQL uses and has 123 distinct bodies, 119 of them needing legacy ETL data — by a wide margin the hardest customer, and counting uses hides it completely.
| Customer | Fee logics | Calcs | Types | SQL bodies | Blocked | Overlaps | Cannot fire |
|---|---|---|---|---|---|---|---|
| ECP | 191 | 4,838 | 23 | 4 | 1 | 4 | 8 |
| OneGI | 157 | 3,374 | 22 | 6 | 1 | 0 | 27 |
| SGP | 141 | 3,420 | 19 | 4 | 4 | 0 | 11 |
| MNEye | 140 | 1,855 | 21 | 58 | 0 | 5 | 17 |
| OrthoAlliance | 108 | 2,298 | 26 | 8 | 2 | 8 | 17 |
| RIA | 108 | 2,425 | 21 | 2 | 1 | 7 | 3 |
| Commonwealth | 79 | 1,907 | 21 | 2 | 0 | 0 | 37 |
| EyeSouth | 67 | 608 | 19 | 17 | 9 | 0 | 13 |
| ARSA | 47 | 689 | 16 | 1 | 0 | 0 | 9 |
| Femwell | 43 | 668 | 15 | 123 | 119 | 0 | 9 |
| EugeneGI | 42 | 111 | 4 | 0 | 0 | 0 | 4 |
| PAA | 42 | 43 | 2 | 7 | 7 | 1 | 0 |
| StrideCare | 41 | 776 | 19 | 2 | 1 | 0 | 3 |
| HeatonEye | 40 | 826 | 21 | 3 | 1 | 0 | 6 |
| USDH | 39 | 908 | 16 | 0 | 0 | 0 | 2 |
| PrecisionHealth | 31 | 735 | 17 | 2 | 1 | 0 | 30 |
| TFOC | 30 | 595 | 10 | 6 | 0 | 0 | 30 |
| JewishBoard | 29 | 379 | 15 | 5 | 3 | 0 | 1 |
| MiddletownMedical | 28 | 475 | 18 | 1 | 0 | 0 | 6 |
| SeaRad | 26 | 246 | 12 | 4 | 0 | 1 | 0 |
| ISpine | 25 | 554 | 18 | 1 | 0 | 0 | 0 |
| TheOregonClinic | 24 | 249 | 17 | 0 | 0 | 0 | 21 |
| USHP | 23 | 502 | 20 | 3 | 1 | 0 | 0 |
| MannEye | 18 | 306 | 8 | 0 | 0 | 1 | 0 |
| SouthSoundRadiology | 18 | 298 | 18 | 12 | 0 | 2 | 2 |
| CCP | 15 | 53 | 8 | 3 | 3 | 0 | 0 |
| NWDerm | 14 | 198 | 14 | 0 | 0 | 0 | 0 |
| HillsboroEye | 12 | 308 | 17 | 1 | 0 | 0 | 1 |
| Monarch | 12 | 213 | 11 | 0 | 0 | 0 | 1 |
| SWOrofacial | 10 | 174 | 14 | 3 | 0 | 1 | 0 |
| SunLife | 7 | 16 | 4 | 0 | 0 | 0 | 0 |
| PPRM | 3 | 3 | 2 | 1 | 1 | 0 | 1 |
| Wildflower | 2 | 2 | 1 | 0 | 0 | 0 | 0 |
SQL bodies = distinct queries to port, the real effort driver.Blocked = of those, how many need legacy ETL or payer-crosswalk data the replacement cannot reach. Overlaps = contract-map conflicts, each an onboarding blocker. Cannot fire = fee logics with no contract map, or one that selects nothing.
7 customers have no SQL calculations and no contract-map conflicts:EugeneGI, USDH, TheOregonClinic, NWDerm, Monarch, SunLife, Wildflower.
The estate is heavily skewed at every level. One adjustment type is nearly half of all calculations. Two SQL bodies are a third of all SQL. 172 of 268 SQL bodies are used exactly once. Plans built on averages will be wrong in both directions.