ACO REACH Financial and Quality Results

The Accountable Care Organization (ACO) REACH Financial and Quality Results Public Use File (PUF) details performance for the ACO REACH Model, formerly Global…

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.ACO_REACH_FINANCIAL_AND_QUALITY_RESULTS on Snowflake and Databricks — four annual reporting periods (2021–2023) 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.ACO_REACH_FINANCIAL_AND_QUALITY_RESULTS
Databricks	cms_dwv.aco_reach_financial_and_quality_results
Coverage	Jan 2021 – Dec 2023 (3 of 3 annual reporting periods)
Rows	416 (total across all reporting periods)
Cadence	Annual
Update pattern	Time-partitioned — each file adds one reporting year
CMS published	2025-09-10
Loaded	2025-10-18
Columns	133 data + 6 lineage
Identifiers	ACO ID
File versions	4
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-09-10. Coverage is complete through the 2023 reporting year. Next CMS release expected ~Sep 2026.

Time-partitioned feed — each file version covers one reporting year, so history is additive. Query the full table for all years; filter on the reporting period columns for a single period. Do not filter to the latest file only — that would return just the 2023 reporting year.

Sample queries

Snowflake

-- Each file version covers one reporting period (2021, 2022, 2023) — history is additive
SELECT *
FROM DWV.ACO_REACH_FINANCIAL_AND_QUALITY_RESULTS
LIMIT 100;

Databricks

About this feed

The Accountable Care Organization (ACO) REACH Financial and Quality Results Public Use File (PUF) details performance for the ACO REACH Model, formerly Global and Professional Direct Contracting (GPDC) Model, prior to settlement. This data includes information such as the ACOs risk arrangement, stop loss, capitation, savings rate, and quality results.

— Source: CMS feed metadata

Keywords: Medicare, Original Medicare, Value-Based Care, Coordinated Care, Payment Models, Accountable Care Organizations Theme: Medicare

Coverage timeline

2021 🟩 · 2022 🟩 · 2023 🟩

3 of 3 annual reporting periods present — no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
2023-01-01 – 2023-12-31	2025-09-10	2025-10-18	✓
2023-01-01 – 2023-12-31	2025-05-21	2025-05-21
2022-01-01 – 2022-12-31	2025-05-21	2025-05-21
2021-01-01 – 2021-12-31	2025-04-25	2025-04-25

Data dictionary

📋 133 data columns + 6 lineage columns

Column-level definitions are maintained by CMS in the official ACO REACH Financial and Quality Results data dictionary.

Data columns

Column	Type
ACO_ID	TEXT
ACO_NAME	TEXT
ACO_TYPE	TEXT
FIRST_PART_YEAR	NUMBER
PERF_YEAR	NUMBER
RISK_ARRANGEMENT	TEXT
STOP_LOSS_ELECTION	BOOLEAN
CAPITATION_ARRANGEMENT	TEXT
ENHANCED_PCC_ELECTION	BOOLEAN
APO_ELECTION	BOOLEAN
ALIGNMENT_PLUS	BOOLEAN
DISCOUNT	NUMBER
RETENTION_WITHHOLD	NUMBER
UNADJ_BENCHMARK	NUMBER
FINAL_BENCHMARK	NUMBER
NORM_RISK_SCORE	NUMBER
CIF_CAP_RISK	NUMBER
HEBA_UP_AMT	NUMBER
HEBA_DOWN_AMT	NUMBER
HEBA_UP_MNTHS	NUMBER
HEBA_DOWN_MNTHS	NUMBER
SAV_RATE	NUMBER
TRENDED_AD_BASELINE	NUMBER
TRENDED_ESRD_BASELINE	NUMBER
REGIONAL_AD_BASELINE	NUMBER
REGIONAL_ESRD_BASELINE	NUMBER
HIST_AD_BASELINE_ADJ	NUMBER
HIST_ESRD_BASELINE_ADJ	NUMBER
TOT_COST_CARE_NET	NUMBER
TOT_COST_CARE	NUMBER
GROSS_SAVINGS	NUMBER
SHARED_SAVINGS	NUMBER
SHARED_SAVINGS_SEQ	NUMBER
CAP_PMT_AMT	NUMBER
EPCC_PMT_AMT	NUMBER
CLM_PMT_AMT	NUMBER
EXPND_DME	NUMBER
EXPND_HHA	NUMBER
EXPND_HSP	NUMBER
EXPND_INP_ALL	NUMBER
EXPND_OPD	NUMBER
EXPND_PB	NUMBER
EXPND_SNF	NUMBER
HIST_BY1_AD_PBPM	NUMBER
HIST_BY1_ESRD_PBPM	NUMBER
HIST_BY2_AD_PBPM	NUMBER
HIST_BY2_ESRD_PBPM	NUMBER
HIST_BY3_AD_PBPM	NUMBER
HIST_BY3_ESRD_PBPM	NUMBER
HIST_BY1_AD_RISKSCORE	NUMBER
HIST_BY1_ESRD_RISKSCORE	NUMBER
HIST_BY2_AD_RISKSCORE	NUMBER
HIST_BY2_ESRD_RISKSCORE	NUMBER
HIST_BY3_AD_RISKSCORE	NUMBER
HIST_BY3_ESRD_RISKSCORE	NUMBER
HIST_BY4_AD_RISKSCORE	NUMBER
HIST_BY4_ESRD_RISKSCORE	NUMBER
PY_AD_BLEND_MNTHS	NUMBER
PY_ESRD_BLEND_MNTHS	NUMBER
PY_AD_RATEBOOK_MNTHS	NUMBER
PY_ESRD_RATEBOOK_MNTHS	NUMBER
PY_AD_BLEND_RISKSCORE	NUMBER
PY_ESRD_BLEND_RISKSCORE	NUMBER
PY_AD_RATEBOOK_RISKSCORE	NUMBER
PY_ESRD_RATEBOOK_RISKSCORE	NUMBER
N_ETA	NUMBER
N_CAH	NUMBER
N_FQHC	NUMBER
N_RHC	NUMBER
N_HOSP	NUMBER
N_FAC_OTHER	NUMBER
N_PCP	NUMBER
N_SPEC	NUMBER
N_NP	NUMBER
N_PA	NUMBER
N_CNS	NUMBER
QUAL_SCR	TEXT
ACR_SCR	NUMBER
UAMCC_SCR	NUMBER
DAH_SCR	NUMBER
TFU_SCR	NUMBER
SSM_TACI_SCR	TEXT
SSM_COM_SCR	TEXT
SSM_CC_SCR	TEXT
SSM_SDM_SCR	TEXT
SSM_PR_SCR	TEXT
SSM_CHOS_SCR	TEXT
SSM_HPE_SCR	TEXT
SSM_SPR_SCR	TEXT
CISEP_FLAG	TEXT
HPP_FLAG	TEXT
HDR_ADJUST	NUMBER
BENE_CNT	NUMBER
N_BEN_AGE_0_64	NUMBER
N_BEN_AGE_65_74	NUMBER
N_BEN_AGE_75_84	NUMBER
N_BEN_AGE_85PLUS	NUMBER
N_BEN_MALE	NUMBER
N_BEN_FEMALE	NUMBER
N_BEN_SEX_UNKNOWN	NUMBER
N_BEN_RACE_WHITE	NUMBER
N_BEN_RACE_BLACK	NUMBER
N_BEN_RACE_ASIAN	NUMBER
N_BEN_RACE_HISP	NUMBER
N_BEN_RACE_NATIVE	NUMBER
N_BEN_RACE_PI	NUMBER
N_BEN_RACE_OTHER	NUMBER
PERC_DUAL	NUMBER
PERC_LTI	NUMBER
EXPND_INP_S_TRM	NUMBER
EXPND_INP_L_TRM	NUMBER
EXPND_INP_REHAB	NUMBER
EXPND_INP_PSYCH	NUMBER
EXPND_AMBUPAY	NUMBER
ADM_S_TRM_N	NUMBER
ADM_L_TRM_N	NUMBER
ADM_REHAB_N	NUMBER
ADM_PSYCH_N	NUMBER
ADM_N	NUMBER
P_EDV_VIS	NUMBER
P_EDV_VIS_HOSP	NUMBER
P_CT_VIS	NUMBER
P_MRI_VIS	NUMBER
P_EM_PCP_VIS	NUMBER
P_EM_SP_VIS	NUMBER
P_EM_TOTAL	NUMBER
P_NURSE_VIS	NUMBER
P_FQHC_RHC_VIS	NUMBER
P_SNF_ADM	NUMBER
SNF_LOS	NUMBER
SNF_PAYPERSTAY	NUMBER
ALIGNED_BENEFICIARIES	NUMBER
ACH_SCR	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.ACO_ID, d.ACO_NAME, d.ACO_TYPE,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.ACO_REACH_FINANCIAL_AND_QUALITY_RESULTS 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

• ACO REACH Model Methodology

Frequently asked questions

How often is ACO REACH Financial and Quality Results updated?

Annually. CMS last published this feed on 2025-09-10, and Dataplex loaded it to the warehouse on 2025-10-18. New releases are added automatically when CMS publishes them.

What years does ACO REACH Financial and Quality Results cover?

2021 through 2023 — three annual reporting periods with no gaps. Each reporting year arrives as its own file version, and all years remain queryable side by side.

How many records are in ACO REACH Financial and Quality Results?

416 rows across all four reporting periods. Because this feed is time-partitioned, the full table total is the meaningful count — no deduplication needed.

How do I get ACO REACH Financial and Quality Results 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.ACO_REACH_FINANCIAL_AND_QUALITY_RESULTS directly — no pipeline setup required.

Related feeds

Next Generation Accountable Care Organization Model DataRealizing Equity, Access, and Community Health ACOsACO Realizing Equity, Access and Community Health Financial and Quality ResultsACO REACH Eligible BeneficiariesCounty-level Aggregate Expenditure and Risk Score Data on Assignable Beneficiaries

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 →