Inpatient Psychiatric Facility Quality Measure Data - by Facility

This dataset includes provider-level data for quality measures included under the IPFQR program, including HBIPS, SUB, TOB, Transition Record (TR), Screening…

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.INPATIENT_PSYCHIATRIC_FACILITY_QUALITY_MEASURE_DATA__BY_FACILITY on Snowflake and Databricks — six 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.INPATIENT_PSYCHIATRIC_FACILITY_QUALITY_MEASURE_DATA__BY_FACILITY

Databricks

cms_dwv.inpatient_psychiatric_facility_quality_measure_data__by_facility

Update pattern

Full-refresh — each file replaces the prior snapshot

CMS published

2026-04-28

Loaded

2026-05-15

Columns

95 data + 6 lineage

Identifiers

ZIP codes

File versions

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-04-28. Coverage runs through 2026-04-28. Next CMS release expected ~Jul 2026.

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

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

-- Latest snapshot only (avoids double-counting across file versions)
SELECT *
FROM cms_dwv.inpatient_psychiatric_facility_quality_measure_data__by_facility
WHERE file_id IN (
  SELECT id FROM cms_dwv.feeds_files WHERE is_latest = 1
)
LIMIT 100;

About this feed

This dataset includes provider-level data for quality measures included under the IPFQR program, including HBIPS, SUB, TOB, Transition Record (TR), Screening for Metabolic Disorders (SMD), FAPH, IMM, Readmissions (READM), and Medication Continuation (MedCont, formerly known as MedCoPsy). Psychiatric facilities that are eligible for the Inpatient Psychiatric Facility Quality Reporting (IPFQR) program are required to meet all program requirements, otherwise their Medicare payments may be reduced.
— Source: CMS feed metadata

Keywords: Medicare, Inpatient Psychiatric Facility Quality Measure Data - by Facility 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-04-28

2026-04-28

2026-05-15

✓

Snapshot as of 2026-01-26

2026-01-26

2026-02-28

Snapshot as of 2025-10-14

2025-10-14

2025-11-28

Snapshot as of 2025-07-16

2025-07-16

2025-08-06

Snapshot as of 2025-01-08

2025-01-08

2025-02-27

Snapshot as of 2024-10-10

2024-10-10

2024-12-07

Data dictionary

📋 95 data columns + 6 lineage columns

Data columns

Column

Type

Description

FACILITY_ID

NUMBER

FACILITY_NAME

TEXT

ADDRESS

TEXT

CITY_TOWN

TEXT

CITY/TOWN

STATE

TEXT

ZIP_CODE

TEXT

COUNTY_PARISH

TEXT

COUNTY/PARISH

HBIPS_2_MEASURE_DESCRIPTION

TEXT

HBIPS-2 MEASURE DESCRIPTION

HBIPS_2_OVERALL_RATE_PER_1000

TEXT

HBIPS-2 OVERALL RATE PER 1000

HBIPS_2_OVERALL_NUM

TEXT

HBIPS-2 OVERALL NUM

HBIPS_2_OVERALL_DEN

TEXT

HBIPS-2 OVERALL DEN

HBIPS_2_OVERALL_FOOTNOTE

NUMBER

HBIPS-2 OVERALL FOOTNOTE

HBIPS_3_MEASURE_DESCRIPTION

TEXT

HBIPS-3 MEASURE DESCRIPTION

HBIPS_3_OVERALL_RATE_PER_1000

TEXT

HBIPS-3 OVERALL RATE PER 1000

HBIPS_3_OVERALL_NUM

TEXT

HBIPS-3 OVERALL NUM

HBIPS_3_OVERALL_DEN

TEXT

HBIPS-3 OVERALL DEN

HBIPS_3_OVERALL_FOOTNOTE

NUMBER

HBIPS-3 OVERALL FOOTNOTE

SMD_MEASURE_DESCRIPTION

TEXT

SMD_

TEXT

SMD %

SMD_DENOMINATOR

TEXT

SMD_FOOTNOTE

NUMBER

SUB_2_2A_MEASURE_DESCRIPTION

TEXT

SUB-2/-2A MEASURE DESCRIPTION

SUB_2_

TEXT

SUB-2 %

SUB_2_DENOMINATOR

TEXT

SUB-2 DENOMINATOR

SUB_2_FOOTNOTE

TEXT

SUB-2 FOOTNOTE

SUB_2A_

TEXT

SUB-2A %

SUB_2A_DENOMINATOR

TEXT

SUB-2A DENOMINATOR

SUB_2A_FOOTNOTE

TEXT

SUB-2A FOOTNOTE

SUB_3_3A_MEASURE_DESCRIPTION

TEXT

SUB-3/-3A MEASURE DESCRIPTION

SUB_3_

TEXT

SUB-3 %

SUB_3_DENOMINATOR

TEXT

SUB-3 DENOMINATOR

SUB_3_FOOTNOTE

TEXT

SUB-3 FOOTNOTE

SUB_3A_

TEXT

SUB-3A %

SUB_3A_DENOMINATOR

TEXT

SUB-3A DENOMINATOR

SUB_3A_FOOTNOTE

TEXT

SUB-3A FOOTNOTE

TOB_3_3A_MEASURE_DESCRIPTION

TEXT

TOB-3/-3A MEASURE DESCRIPTION

TOB_3_

TEXT

TOB-3 %

TOB_3_DENOMINATOR

TEXT

TOB-3 DENOMINATOR

TOB_3_FOOTNOTE

TEXT

TOB-3 FOOTNOTE

TOB_3A_

TEXT

TOB-3A %

TOB_3A_DENOMINATOR

TEXT

TOB-3A DENOMINATOR

TOB_3A_FOOTNOTE

TEXT

TOB-3A FOOTNOTE

TR_1_MEASURE_DESCRIPTION

TEXT

TR-1 MEASURE DESCRIPTION

TR_1_

TEXT

TR-1 %

TR_1_DENOMINATOR

TEXT

TR-1 DENOMINATOR

TR_1_FOOTNOTE

NUMBER

TR-1 FOOTNOTE

START_DATE

DATE

END_DATE

DATE

FAPH_MEASURE_DESCRIPTION

TEXT

FAPH_30_

TEXT

FAPH-30 %

FAPH_30_DENOMINATOR

TEXT

FAPH-30 DENOMINATOR

FAPH_30_FOOTNOTE

NUMBER

FAPH-30 FOOTNOTE

FAPH_7_

TEXT

FAPH-7 %

FAPH_7_DENOMINATOR

TEXT

FAPH-7 DENOMINATOR

FAPH_7_FOOTNOTE

NUMBER

FAPH-7 FOOTNOTE

FAPH_MEASURE_START_DATE

DATE

FAPH_MEASURE_END_DATE

DATE

MEDCONT_MEASURE_DESC

TEXT

MEDCONT_

TEXT

MEDCONT %

MEDCONT_DENOMINATOR

TEXT

MEDCONT_FOOTNOTE

TEXT

MEDCONT_MEASURE_START_DATE

DATE

MEDCONT_MEASURE_END_DATE

DATE

READM_30_IPF_MEASURE_DESC

TEXT

READM-30-IPF MEASURE DESC

READM_30_IPF_CATEGORY

TEXT

READM-30-IPF CATEGORY

READM_30_IPF_DENOMINATOR

TEXT

READM-30-IPF DENOMINATOR

READM_30_IPF_RATE

TEXT

READM-30-IPF RATE

READM_30_IPF_LOWER_ESTIMATE

TEXT

READM-30-IPF LOWER ESTIMATE

READM_30_IPF_HIGHER_ESTIMATE

TEXT

READM-30-IPF HIGHER ESTIMATE

READM_30_IPF_FOOTNOTE

NUMBER

READM-30-IPF FOOTNOTE

READM_30_IPF_START_DATE

DATE

READM-30-IPF START DATE

READM_30_IPF_END_DATE

DATE

READM-30-IPF END DATE

IMM_2_MEASURE_DESCRIPTION

TEXT

IMM-2 MEASURE DESCRIPTION

IMM_2_

TEXT

IMM-2 %

IMM_2_DENOMINATOR

TEXT

IMM-2 DENOMINATOR

IMM_2_FOOTNOTE

NUMBER

IMM-2 FOOTNOTE

FLU_SEASON_START_DATE

DATE

FLU_SEASON_END_DATE

DATE

HBIPS_5_MEASURE_DESCRIPTION

TEXT

HBIPS-5 MEASURE DESCRIPTION

HBIPS_5_

TEXT

HBIPS-5 %

HBIPS_5_DENOMINATOR

TEXT

HBIPS-5 DENOMINATOR

HBIPS_5_FOOTNOTE

NUMBER

HBIPS-5 FOOTNOTE

TOB_2_2A_MEASURE_DESC

TEXT

TOB-2/-2A MEASURE_DESC

TOB_2_

TEXT

TOB-2 %

TOB_2_DENOMINATOR

TEXT

TOB-2 DENOMINATOR

TOB_2_FOOTNOTE

NUMBER

TOB-2 FOOTNOTE

TOB_2A_

TEXT

TOB-2A %

TOB_2A_DENOMINATOR

TEXT

TOB-2A DENOMINATOR

TOB_2A_FOOTNOTE

NUMBER

TOB-2A FOOTNOTE

IPFQR_HCP_COVID_19_MEASURE_DESCRIPTION

TEXT

IPFQR-HCP COVID-19 MEASURE DESCRIPTION

IPFQR_HCP_COVID_19_

TEXT

IPFQR-HCP COVID-19 %

IPFQR_HCP_COVID_19_DENOMINATOR

TEXT

IPFQR-HCP COVID-19 DENOMINATOR

IPFQR_HCP_COVID_19_FOOTNOTE

NUMBER

IPFQR-HCP COVID-19 FOOTNOTE

IPFQR_HCP_COVID_19_START_DATE

DATE

IPFQR-HCP COVID-19 START DATE

IPFQR_HCP_COVID_19_END_DATE

DATE

IPFQR-HCP COVID-19 END DATE

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_ID, d.FACILITY_NAME, d.ADDRESS,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.INPATIENT_PSYCHIATRIC_FACILITY_QUALITY_MEASURE_DATA__BY_FACILITY 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 Inpatient Psychiatric Facility Quality Measure Data - by Facility updated?

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

What years does Inpatient Psychiatric Facility Quality Measure Data - by Facility cover?

2024 through 2026.

How many records are in Inpatient Psychiatric Facility Quality Measure Data - by Facility?

Count the current snapshot yourself once the share is mounted:

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

How do I get Inpatient Psychiatric Facility Quality Measure Data - by Facility 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.INPATIENT_PSYCHIATRIC_FACILITY_QUALITY_MEASURE_DATA__BY_FACILITY directly — no pipeline setup required.

Quarterly Prescription Drug Plan Formulary, Pharmacy Network, and Pricing Information - plan_data Monthly Prescription Drug Plan Formulary and Pharmacy Network Information - geographic_locator Medicare Part D Opioid Prescribing Rates - by Geography Quality Payment Program Experience Medicare Demonstrations

Get this feed

Start a free trial on Snowflake Marketplace or purchase via Databricks
Mount the share — the database and DWV schema appear in your account immediately
Run the sample query above — no ETL, no pipeline maintenance

Questions about this feed? Contact us at notifications@dataplex-consulting.com.

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

PreviousInpatient Psychiatric Facility Quality Measure Data - National NextInpatient Psychiatric Facility Quality Measure Data - by State

Last updated 11 days ago

Key facts

Sample queries

About this feed

Coverage timeline

Release history

Data dictionary

Row-level lineage

Source & provenance

Frequently asked questions

How often is Inpatient Psychiatric Facility Quality Measure Data - by Facility updated?

What years does Inpatient Psychiatric Facility Quality Measure Data - by Facility cover?

How many records are in Inpatient Psychiatric Facility Quality Measure Data - by Facility?

How do I get Inpatient Psychiatric Facility Quality Measure Data - by Facility data?

Related feeds

Get this feed