Managing Clinician Aggregation Group Performance
U.S. Department of Health & Human Services
@usgov.hhs_gov_managing_clinician_aggregation_group_performance_c90f0
U.S. Department of Health & Human Services
@usgov.hhs_gov_managing_clinician_aggregation_group_performance_c90f0
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.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:26:42.380651
Tags: clinics, coordinated-care, end-stage-renal-disease-facilities, hospitals-facilities, medicare, original-medicare, outpatient-facilities, service-delivery-models, value-based-care
CREATE TABLE managing_clinician_aggregation_group_performance_2021_12_31 (
"agg_id" VARCHAR,
"hrr_num_my" BIGINT,
"hdr_my" DOUBLE,
"hdr_dnm_my" DOUBLE,
"hdr_num_my" DOUBLE,
"hd_num_my" DOUBLE,
"sd_num_my" DOUBLE,
"nocd_num_my" BIGINT,
"tr_my_achscr" DOUBLE,
"tr_my_impscr" DOUBLE,
"twr_dnm_my" DOUBLE,
"twr_num_my" DOUBLE,
"ldt_dnm_l_my" DOUBLE,
"ldt_num_l_my" DOUBLE,
"ldt_num_r_my" DOUBLE,
"benecnt_ldt_my" DOUBLE,
"benecnt_pmp_my" DOUBLE,
"hei_hdr" BIGINT,
"hdr_delis_diff" BIGINT,
"hdr_delis_my" BIGINT,
"hdr_dnm_delis_my" BIGINT,
"hdr_num_delis_my" BIGINT,
"hei_tr" BIGINT,
"tr_delis_diff" BIGINT,
"tr_delis_my" BIGINT,
"twr_dnm_delis_my" BIGINT,
"twr_num_delis_my" BIGINT,
"ldt_dnm_l_delis_my" BIGINT,
"ldt_num_l_delis_my" BIGINT,
"ldt_num_r_delis_my" BIGINT,
"mps" DOUBLE,
"ppa" DOUBLE,
"ppa_period" BIGINT,
"my" BIGINT
);CREATE TABLE managing_clinician_aggregation_group_performance_2022_06_30 (
"agg_id" VARCHAR,
"hrr_num_my" BIGINT,
"hdr_my" DOUBLE,
"hdr_dnm_my" DOUBLE,
"hdr_num_my" DOUBLE,
"hd_num_my" DOUBLE,
"sd_num_my" DOUBLE,
"nocd_num_my" BIGINT,
"tr_my_achscr" DOUBLE,
"tr_my_impscr" DOUBLE,
"twr_dnm_my" DOUBLE,
"twr_num_my" DOUBLE,
"ldt_dnm_l_my" DOUBLE,
"ldt_num_l_my" DOUBLE,
"ldt_num_r_my" DOUBLE,
"benecnt_ldt_my" DOUBLE,
"benecnt_pmp_my" DOUBLE,
"hei_hdr" DOUBLE,
"hdr_delis_diff" DOUBLE,
"hdr_delis_my" DOUBLE,
"hdr_dnm_delis_my" BIGINT,
"hdr_num_delis_my" DOUBLE,
"hei_tr" DOUBLE,
"tr_delis_diff" DOUBLE,
"tr_delis_my" DOUBLE,
"twr_dnm_delis_my" BIGINT,
"twr_num_delis_my" BIGINT,
"ldt_dnm_l_delis_my" BIGINT,
"ldt_num_l_delis_my" BIGINT,
"ldt_num_r_delis_my" BIGINT,
"mps" DOUBLE,
"ppa" DOUBLE,
"ppa_period" BIGINT,
"my" BIGINT
);CREATE TABLE managing_clinician_aggregation_group_performance_2022_12_31 (
"agg_id" VARCHAR,
"hrr_num_my" BIGINT,
"hdr_my" DOUBLE,
"hdr_dnm_my" DOUBLE,
"hdr_num_my" DOUBLE,
"hd_num_my" DOUBLE,
"sd_num_my" DOUBLE,
"nocd_num_my" DOUBLE,
"tr_my_achscr" DOUBLE,
"tr_my_impscr" DOUBLE,
"twr_dnm_my" DOUBLE,
"twr_num_my" DOUBLE,
"ldt_dnm_l_my" DOUBLE,
"ldt_num_l_my" DOUBLE,
"ldt_num_r_my" DOUBLE,
"benecnt_ldt_my" DOUBLE,
"benecnt_pmp_my" DOUBLE,
"hei_hdr" DOUBLE,
"hdr_delis_diff" DOUBLE,
"hdr_delis_my" DOUBLE,
"hdr_dnm_delis_my" DOUBLE,
"hdr_num_delis_my" DOUBLE,
"hei_tr" DOUBLE,
"tr_delis_diff" DOUBLE,
"tr_delis_my" DOUBLE,
"twr_dnm_delis_my" DOUBLE,
"twr_num_delis_my" DOUBLE,
"ldt_dnm_l_delis_my" DOUBLE,
"ldt_num_l_delis_my" DOUBLE,
"ldt_num_r_delis_my" DOUBLE,
"mps" DOUBLE,
"ppa" DOUBLE,
"ppa_period" BIGINT,
"my" BIGINT
);CREATE TABLE managing_clinician_aggregation_group_performance_2023_06_01 (
"agg_id" VARCHAR,
"hrr_num_my" BIGINT,
"hdr_my" DOUBLE,
"hdr_dnm_my" DOUBLE,
"hdr_num_my" DOUBLE,
"hd_num_my" DOUBLE,
"sd_num_my" DOUBLE,
"nocd_num_my" DOUBLE,
"tr_my_achscr" DOUBLE,
"tr_my_impscr" DOUBLE,
"twr_dnm_my" DOUBLE,
"twr_num_my" DOUBLE,
"ldt_dnm_l_my" DOUBLE,
"ldt_num_l_my" DOUBLE,
"ldt_num_r_my" DOUBLE,
"benecnt_ldt_my" DOUBLE,
"benecnt_pmp_my" DOUBLE,
"hei_hdr" DOUBLE,
"hdr_delis_diff" DOUBLE,
"hdr_delis_my" DOUBLE,
"hdr_dnm_delis_my" DOUBLE,
"hdr_num_delis_my" DOUBLE,
"hei_tr" DOUBLE,
"tr_delis_diff" DOUBLE,
"tr_delis_my" DOUBLE,
"twr_dnm_delis_my" DOUBLE,
"twr_num_delis_my" DOUBLE,
"ldt_dnm_l_delis_my" DOUBLE,
"ldt_num_l_delis_my" DOUBLE,
"ldt_num_r_delis_my" DOUBLE,
"mps" DOUBLE,
"ppa" DOUBLE,
"ppa_period" BIGINT,
"my" BIGINT
);CREATE TABLE managing_clinician_aggregation_group_performance_2023_12_01 (
"agg_id" VARCHAR,
"hrr_num_my" BIGINT,
"hdr_my" DOUBLE,
"hdr_dnm_my" DOUBLE,
"hdr_num_my" DOUBLE,
"hd_num_my" DOUBLE,
"sd_num_my" DOUBLE,
"nocd_num_my" DOUBLE,
"tr_my_achscr" DOUBLE,
"tr_my_impscr" DOUBLE,
"twr_dnm_my" DOUBLE,
"twr_num_my" DOUBLE,
"ldt_dnm_l_my" DOUBLE,
"ldt_num_l_my" DOUBLE,
"ldt_num_r_my" DOUBLE,
"benecnt_ldt_my" DOUBLE,
"benecnt_pmp_my" DOUBLE,
"hei_hdr" DOUBLE,
"hdr_delis_diff" DOUBLE,
"hdr_delis_my" DOUBLE,
"hdr_dnm_delis_my" DOUBLE,
"hdr_num_delis_my" DOUBLE,
"hei_tr" DOUBLE,
"tr_delis_diff" DOUBLE,
"tr_delis_my" DOUBLE,
"twr_dnm_delis_my" DOUBLE,
"twr_num_delis_my" DOUBLE,
"ldt_dnm_l_delis_my" DOUBLE,
"ldt_num_l_delis_my" DOUBLE,
"ldt_num_r_delis_my" DOUBLE,
"mps" DOUBLE,
"ppa" DOUBLE,
"ppa_period" BIGINT,
"my" BIGINT
);CREATE TABLE managing_clinician_aggregation_group_performance_2024_06_01 (
"agg_id" VARCHAR,
"hrr_num_my" BIGINT,
"hdr_my" DOUBLE,
"hdr_dnm_my" DOUBLE,
"hdr_num_my" DOUBLE,
"hd_num_my" DOUBLE,
"sd_num_my" DOUBLE,
"nocd_num_my" DOUBLE,
"tr_my_achscr" DOUBLE,
"tr_my_impscr" DOUBLE,
"twr_dnm_my" DOUBLE,
"twr_num_my" DOUBLE,
"ldt_dnm_l_my" DOUBLE,
"ldt_num_l_my" DOUBLE,
"ldt_num_r_my" DOUBLE,
"benecnt_ldt_my" DOUBLE,
"benecnt_pmp_my" DOUBLE,
"hei_hdr" DOUBLE,
"hdr_delis_diff" DOUBLE,
"hdr_delis_my" DOUBLE,
"hdr_dnm_delis_my" DOUBLE,
"hdr_num_delis_my" DOUBLE,
"hei_tr" DOUBLE,
"tr_delis_diff" DOUBLE,
"tr_delis_my" DOUBLE,
"twr_dnm_delis_my" DOUBLE,
"twr_num_delis_my" DOUBLE,
"ldt_dnm_l_delis_my" DOUBLE,
"ldt_num_l_delis_my" DOUBLE,
"ldt_num_r_delis_my" DOUBLE,
"mps" DOUBLE,
"ppa" DOUBLE,
"ppa_period" BIGINT,
"my" BIGINT
);Anyone who has the link will be able to view this.