ACO Realizing Equity, Access and Community Health Financial and Quality Results

The Accountable Care Organization Realizing Equity, Access and Community Health (ACO REACH) Model Financial and Quality Results Public Use File (PUF) details…

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.ACO_REALIZING_EQUITY_ACCESS_AND_COMMUNITY_HEALTH_FINANCIAL_AND_QUALITY_RESULTS on Snowflake and Databricks — coverage from 2021 to 2021 in a single aligned 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_REALIZING_EQUITY_ACCESS_AND_COMMUNITY_HEALTH_FINANCIAL_AND_QUALITY_RESULTS
Databricks	cms_dwv.aco_realizing_equity_access_and_community_health_financial_and_quality_results
Coverage	Jan 2021 – Dec 2021
Cadence	Annual
CMS published	2023-07-17
Loaded	2023-08-29
Columns	58 data + 6 lineage
Identifiers	ACO ID
File versions	1
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.

Last CMS publication 2023-07-17 — awaiting the next release. New files load automatically when CMS publishes.

Sample queries

Snowflake

SELECT *
FROM DWV.ACO_REALIZING_EQUITY_ACCESS_AND_COMMUNITY_HEALTH_FINANCIAL_AND_QUALITY_RESULTS
LIMIT 100;

Databricks

About this feed

The Accountable Care Organization Realizing Equity, Access and Community Health (ACO REACH) Model 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.

The expanded quality performance results are expected to be released in the fall.

— Source: CMS feed metadata

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

Coverage timeline

2021 🟩

1 of 1 years covered — no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
2021-01-01 – 2021-12-31	2023-07-17	2023-08-29	✓

Data dictionary

📋 58 data columns + 6 lineage columns

Column-level definitions are maintained by CMS in the official ACO Realizing Equity, Access and Community Health 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
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
ALIGNED_BENEFICIARIES	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
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

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_REALIZING_EQUITY_ACCESS_AND_COMMUNITY_HEALTH_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 Realizing Equity, Access and Community Health Financial and Quality Results updated?

Annually. CMS last published this feed on 2023-07-17, and Dataplex loaded it to the warehouse on 2023-08-29. New releases are added automatically when CMS publishes them.

What years does ACO Realizing Equity, Access and Community Health Financial and Quality Results cover?

2021 through 2021.

How many records are in ACO Realizing Equity, Access and Community Health Financial and Quality Results?

Count the current snapshot yourself once the share is mounted:

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

How do I get ACO Realizing Equity, Access and Community Health 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_REALIZING_EQUITY_ACCESS_AND_COMMUNITY_HEALTH_FINANCIAL_AND_QUALITY_RESULTS directly — no pipeline setup required.

Related feeds

ACO REACH Financial and Quality ResultsACO REACH ProvidersACO REACH Aligned BeneficiariesRealizing Equity, Access, and Community Health ACOsACO REACH Eligible 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 →