Hospital-Acquired Condition (HAC) Reduction Program

Hospital-Acquired Condition (HAC) Reduction Program (HACRP) - In October 2014, CMS began reducing Medicare fee-for-service payments for subsection (d)…

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.HOSPITALACQUIRED_CONDITION_HAC_REDUCTION_PROGRAM on Snowflake and Databricks — three snapshot releases spanning 2024–2026, 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.HOSPITALACQUIRED_CONDITION_HAC_REDUCTION_PROGRAM
Databricks	cms_dwv.hospitalacquired_condition_hac_reduction_program
Update pattern	Full-refresh — each file replaces the prior snapshot
CMS published	2026-01-26
Loaded	2026-02-28
Columns	36 data + 6 lineage
File versions	3
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 2026-01-26. Coverage runs through 2026-01-26. Next CMS release expected ~Feb 2027.

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.HOSPITALACQUIRED_CONDITION_HAC_REDUCTION_PROGRAM
WHERE FILE_ID IN (
  SELECT ID FROM DWV.FEEDS_FILES WHERE IS_LATEST = 1
)
LIMIT 100;

Databricks

About this feed

Hospital-Acquired Condition (HAC) Reduction Program (HACRP) - In October 2014, CMS began reducing Medicare fee-for-service payments for subsection (d) hospitals that rank in the worst-performing quartile with respect to hospital-acquired condition (HAC) quality measures. Hospitals with a Total HAC Score above the 75th percentile of the Total HAC Score distribution will be subject to a 1-percent payment reduction. This table contains hospitals' measure and Total HAC scores. The Total HAC Score is calculated as the equally weighted average of hospitals' individual measure scores.

— Source: CMS feed metadata

Keywords: Medicare, Hospital-Acquired Condition (HAC) Reduction Program Theme: Medicare

Coverage timeline

2024 🟩 · 2025 🟩 · 2026 🟩

3 of 3 years with snapshot releases — no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
Snapshot as of 2026-01-26	2026-01-26	2026-02-28	✓
Snapshot as of 2025-01-08	2025-01-08	2025-02-27
Snapshot as of 2024-01-08	2024-01-08	2024-12-14

Data dictionary

📋 36 data columns + 6 lineage columns

Column-level definitions are maintained by CMS in the official Hospital-Acquired Condition (HAC) Reduction Program data dictionary.

Data columns

Column	Type
FACILITY_NAME	TEXT
FACILITY_ID	NUMBER
STATE	TEXT
FISCAL_YEAR	NUMBER
PSI_90_COMPOSITE_VALUE	TEXT
PSI_90_COMPOSITE_VALUE_FOOTNOTE	TEXT
PSI_90_W_Z_SCORE	TEXT
PSI_90_W_Z_FOOTNOTE	NUMBER
PSI_90_START_DATE	DATE
PSI_90_END_DATE	DATE
CLABSI_SIR	TEXT
CLABSI_SIR_FOOTNOTE	NUMBER
CLABSI_W_Z_SCORE	TEXT
CLABSI_W_Z_FOOTNOTE	NUMBER
CAUTI_SIR	TEXT
CAUTI_SIR_FOOTNOTE	NUMBER
CAUTI_W_Z_SCORE	TEXT
CAUTI_W_Z_FOOTNOTE	NUMBER
SSI_SIR	TEXT
SSI_SIR_FOOTNOTE	NUMBER
SSI_W_Z_SCORE	TEXT
SSI_W_Z_FOOTNOTE	NUMBER
CDI_SIR	TEXT
CDI_SIR_FOOTNOTE	NUMBER
CDI_W_Z_SCORE	TEXT
CDI_W_Z_FOOTNOTE	NUMBER
MRSA_SIR	TEXT
MRSA_SIR_FOOTNOTE	NUMBER
MRSA_W_Z_SCORE	TEXT
MRSA_W_Z_FOOTNOTE	NUMBER
HAI_MEASURES_START_DATE	DATE
HAI_MEASURES_END_DATE	DATE
TOTAL_HAC_SCORE	TEXT
TOTAL_HAC_SCORE_FOOTNOTE	NUMBER
PAYMENT_REDUCTION	TEXT
PAYMENT_REDUCTION_FOOTNOTE	TEXT

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.FACILITY_NAME, d.FACILITY_ID, d.STATE,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.HOSPITALACQUIRED_CONDITION_HAC_REDUCTION_PROGRAM d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID;

Source & provenance

Published by the Centers for Medicare & Medicaid Services.

• Official CMS documentation

Frequently asked questions

How often is Hospital-Acquired Condition (HAC) Reduction Program updated?

CMS last published this feed on 2026-01-26. New releases are added automatically when CMS publishes them.

What years does Hospital-Acquired Condition (HAC) Reduction Program cover?

2024 through 2026.

How many records are in Hospital-Acquired Condition (HAC) Reduction Program?

Count the current snapshot yourself once the share is mounted:

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

How do I get Hospital-Acquired Condition (HAC) Reduction Program 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.HOSPITALACQUIRED_CONDITION_HAC_REDUCTION_PROGRAM directly — no pipeline setup required.

Related feeds

Market Saturation & Utilization Core-Based Statistical AreasMedicare Post-Acute Care Utilization - Inpatient Rehabilitation Facility by Geography and ProviderSpecific Chronic ConditionsInnovation Center Webinars and ForumsPayment - State

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 →