Managing Clinician Aggregation Group Performance

The Managing Clinician Aggregation Group Performance dataset provides performance information in the End-Stage Renal Disease (ESRD) Treatment Choices (ETC)…

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.MANAGING_CLINICIAN_AGGREGATION_GROUP_PERFORMANCE on Snowflake and Databricks — 13 snapshot releases spanning 2021–2024, aligned to a single schema, refreshed automatically whenever CMS publishes a new file. Every row carries lineage back to the exact CMS source file that produced it.

Key facts

Snowflake	DWV.MANAGING_CLINICIAN_AGGREGATION_GROUP_PERFORMANCE
Databricks	cms_dwv.managing_clinician_aggregation_group_performance
Coverage	Jul 2021 – Dec 2024
Cadence	Semiannual
Update pattern	Full-refresh — each file replaces the prior snapshot
CMS published	2025-12-22
Loaded	2025-12-22
Columns	34 data + 6 lineage
File versions	13
License	CMS public data — U.S. Government work
Platforms	Snowflake Marketplace · Databricks Delta Sharing

Included in the CMS Data Feeds Dataset — start a free trial on Snowflake Marketplace.

Current — CMS last published this feed on 2025-12-22. Coverage runs through 2024-12-31.

Full-refresh feed — each file version is a complete snapshot and newer files supersede older ones. Filter to the latest file (see the sample query) to avoid double-counting across versions.

Sample queries

Snowflake

-- Latest snapshot only (avoids double-counting across file versions)
SELECT *
FROM DWV.MANAGING_CLINICIAN_AGGREGATION_GROUP_PERFORMANCE
WHERE FILE_ID IN (
  SELECT ID FROM DWV.FEEDS_FILES WHERE IS_LATEST = 1
)
LIMIT 100;

Databricks

About this feed

The Managing Clinician Aggregation Group Performance dataset provides performance information in the End-Stage Renal Disease (ESRD) Treatment Choices (ETC) Model. The dataset includes information on Performance Payment Adjustment (PPA), Modality Performance Score (MPS), home dialysis rate, and transplant rate, as well as the individual components of each rate for each model participant Managing Clinician aggregation group.

All Managing Clinicians within the same aggregation group share the same performance information. The supplementary aggregation group crosswalk file may be used to map aggregation groups to individual ETC Participant Managing Clinicians.

— Source: CMS feed metadata

Keywords: Medicare, Original Medicare, Hospitals & Facilities, Outpatient Facilities, Clinics, End Stage Renal Disease Facilities, Value-Based Care, Coordinated Care, Service Delivery Models Theme: Medicare

Coverage timeline

2021 🟩 · 2022 🟩 · 2023 🟩 · 2024 🟩

4 of 4 years with snapshot releases — no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
Snapshot as of 2025-12-22	2025-12-22	2025-12-22	✓
Snapshot as of 2025-07-01	2025-07-01	2025-10-18
Snapshot as of 2025-06-30	2025-06-30	2025-06-30
Snapshot as of 2025-06-09	2025-06-09	2025-06-17
Snapshot as of 2024-08-09	2024-08-09	2025-06-17
Snapshot as of 2024-02-20	2024-02-20	2025-06-17
Snapshot as of 2023-11-30	2023-11-30	2025-06-17
Snapshot as of 2023-11-30	2023-11-30	2025-06-17
Snapshot as of 2025-06-09	2025-06-09	2025-06-10
Snapshot as of 2024-08-09	2024-08-09	2024-08-09

Show 3 earlier file versions

Reporting period	CMS published	Loaded	Latest file
Snapshot as of 2024-02-20	2024-02-20	2024-02-20
Snapshot as of 2023-11-30	2023-11-30	2023-11-30
Snapshot as of 2023-11-30	2023-11-30	2023-11-30

Data dictionary

📋 34 data columns + 6 lineage columns

Column-level definitions are maintained by CMS in the official Managing Clinician Aggregation Group Performance data dictionary.

Data columns

Column	Type
AGG_ID	TEXT
HRR_NUM_MY	NUMBER
HDR_MY	NUMBER
HDR_DNM_MY	NUMBER
HDR_NUM_MY	NUMBER
HD_NUM_MY	NUMBER
SD_NUM_MY	NUMBER
NOCD_NUM_MY	NUMBER
TR_MY_ACHSCR	NUMBER
TR_MY_IMPSCR	NUMBER
TWR_DNM_MY	NUMBER
TWR_NUM_MY	NUMBER
LDT_DNM_L_MY	NUMBER
LDT_NUM_L_MY	NUMBER
LDT_NUM_R_MY	NUMBER
BENECNT_LDT_MY	NUMBER
BENECNT_PMP_MY	NUMBER
HEI_HDR	NUMBER
HDR_DELIS_DIFF	NUMBER
HDR_DELIS_MY	NUMBER
HDR_DNM_DELIS_MY	NUMBER
HDR_NUM_DELIS_MY	NUMBER
HEI_TR	NUMBER
TR_DELIS_DIFF	NUMBER
TR_DELIS_MY	NUMBER
TWR_DNM_DELIS_MY	NUMBER
TWR_NUM_DELIS_MY	NUMBER
LDT_DNM_L_DELIS_MY	NUMBER
LDT_NUM_L_DELIS_MY	NUMBER
LDT_NUM_R_DELIS_MY	NUMBER
MPS	NUMBER
PPA	NUMBER
PPA_PERIOD	NUMBER
MY	NUMBER

Lineage columns (present on every feed table)

Column	Type	Description
ROW_ID	TEXT	Unique row ID for this table (PK)
FILE_ID	TEXT	Source file — joins to FEEDS_FILES.ID (FK)
FILE_FEED_ID	TEXT	Parent feed — joins to FEEDS.ID (FK)
FILE_NAME	TEXT	Source file name as published by CMS
ROWNUM	NUMBER	Row number within the source file
CREATED_AT	TIMESTAMP_NTZ	Timestamp when the record was loaded

Row-level lineage

Every row in this table traces to the exact CMS source file that produced it. The FILE_ID column joins to the FEEDS_FILES catalog table, and FILE_FEED_ID joins to the FEEDS master table:

Trace any row back to its source file and reporting period:

SELECT d.AGG_ID, d.HRR_NUM_MY, d.HDR_MY,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.MANAGING_CLINICIAN_AGGREGATION_GROUP_PERFORMANCE d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID;

Source & provenance

Published by the Centers for Medicare & Medicaid Services (bureau 009:38).

• Official CMS data dictionary

• Esrd Treatment Choices Etc Model Methodology

Frequently asked questions

How often is Managing Clinician Aggregation Group Performance updated?

Semiannually. CMS last published this feed on 2025-12-22, and Dataplex loaded it to the warehouse the same day. New releases are added automatically when CMS publishes them.

What years does Managing Clinician Aggregation Group Performance cover?

2021 through 2024.

How many records are in Managing Clinician Aggregation Group Performance?

Count the current snapshot yourself once the share is mounted:

SELECT COUNT(*)
FROM DWV.MANAGING_CLINICIAN_AGGREGATION_GROUP_PERFORMANCE d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID
WHERE ff.IS_LATEST = 1;

How do I get Managing Clinician Aggregation Group Performance data?

It's included in the CMS Data Feeds Dataset on the Snowflake Marketplace (free trial available) and via Databricks Delta Sharing. Once mounted, query DWV.MANAGING_CLINICIAN_AGGREGATION_GROUP_PERFORMANCE directly — no pipeline setup required.

Related feeds

End-Stage Renal Disease Facility Aggregation Group PerformanceComprehensive End-Stage Renal Disease Care Model DataProvider of Services File - Clinical LaboratoriesMedicare Dialysis FacilitiesAmbulatory Specialty Model Participants

Get this feed

1. Start a free trial on Snowflake Marketplace or purchase via Databricks

2. Mount the share — the database and DWV schema appear in your account immediately

3. Run the sample query above — no ETL, no pipeline maintenance

Questions about this feed? Contact us at [e-mail].

---

Part of the CMS Data Feeds Dataset — 280+ feeds · 245B+ records · updated daily. Back to the full catalog →