CMS TEAM Analyzer
CMS TEAM Analyzer helps hospitals and health systems understand financial performance under the CMS Transforming Episode Accountability Model. It turns claims data into episode-level analytics, target-price comparisons, variance drivers, and prioritized improvement opportunities.
The package is built for organizations that need to prepare for bundled-payment accountability without standing up a new application stack. It runs as a dbt package in the client's warehouse, uses Tuva-conformed claims data, and publishes marts that can power dashboards, finance reviews, and operational worklists.
The included executive dashboard, running out of the box on package marts.
What Leaders Get
- A clear view of TEAM exposure: episode volume, open and closed episodes, total spend, target prices, and projected reconciliation scenarios.
- A shared operating model: finance, clinical operations, and data teams can review the same episode definitions and variance drivers.
- Actionable opportunity lists: the package highlights surgeons, anchor sites, post-acute partners, readmission hotspots, and open episodes that need attention.
- No PHI movement to a vendor app: analytics run inside the client's data platform through dbt and warehouse-native tables.
What Data Teams Get
- A dbt package: install it into your dbt project alongside Tuva and configure a small set of vars.
- Tuva-native inputs: the package reads standardized claims, encounter, eligibility, patient, practitioner, and terminology models.
- Package-managed CMS reference data: trigger codes, episode categories, exclusions, discount factors, and public PY1 regional target-price fallback data ship with the package.
- A clean install path: add CMS TEAM Analyzer to the same dbt project where Tuva is already installed, then run the package with standard dbt commands.
What It Measures
CMS TEAM Analyzer focuses on the five TEAM episode categories:
| Episode category | Examples of analytics |
|---|---|
| Lower Extremity Joint Replacement | Episode spend, outpatient-to-inpatient precedence, PAC utilization, surgeon variation |
| Surgical Hip/Femur Fracture Treatment | Readmission spend, discharge patterns, site-level variance |
| Spinal Fusion | Inpatient and outpatient trigger handling, target-price comparison |
| Coronary Artery Bypass Graft | Episode cost components, readmission drivers |
| Major Bowel Procedures | Bundle-level performance and opportunity ranking |
How Easy Is It To Run?
In a dbt project where Tuva is already installed, teams add one package entry and run standard dbt commands:
dbt deps
dbt seed --full-refresh --select package:cms_team_analyzer
dbt run --select +package:cms_team_analyzer
dbt test --select package:cms_team_analyzer
Reconciliation Context
CMS TEAM Analyzer is built for performance monitoring, planning, and operational action before official CMS reconciliation files are available. It helps teams understand likely exposure, investigate drivers, and prepare interventions using their own claims data, CMS public reference data, and optional participant-specific target prices.
Official CMS reconciliation files remain the financial source of truth for final payment determination.