# CMS Hospital-Acquired Condition Reduction Program (HACRP)

`medicare_silver.fact_hacrp` · Hospital price transparency · status live · 3,055 rows

The CMS HAC Reduction Program hospital file. It carries PSI-90, CLABSI, CAUTI, SSI, CDI, and MRSA values and standardized scores, the Total HAC Score, and whether the hospital receives the one-percent Medicare payment reduction.

**Grain.** One row per (fiscal_year, hospital CCN) with PSI-90, five HAI measures, Total HAC Score, and payment-reduction status.

| column | type | meaning |
|---|---|---|
| fiscal_year | int |  |
| ccn | string |  |
| facility_name | string |  |
| state | string |  |
| psi_90_composite_value_footnote | string |  |
| psi_90_w_z_footnote | string |  |
| psi_90_start_date | string |  |
| psi_90_end_date | string |  |
| clabsi_sir_footnote | string |  |
| clabsi_w_z_footnote | string |  |
| cauti_sir_footnote | string |  |
| cauti_w_z_footnote | string |  |
| ssi_sir_footnote | string |  |
| ssi_w_z_footnote | string |  |
| cdi_sir_footnote | string |  |
| cdi_w_z_footnote | string |  |
| mrsa_sir_footnote | string |  |
| mrsa_w_z_footnote | string |  |
| hai_measures_start_date | string |  |
| hai_measures_end_date | string |  |
| total_hac_score_footnote | string |  |
| payment_reduction | string |  |
| payment_reduction_footnote | string |  |
| psi_90_composite_value | double |  |
| psi_90_w_z_score | double |  |
| clabsi_sir | double |  |
| clabsi_w_z_score | double |  |
| cauti_sir | double |  |
| cauti_w_z_score | double |  |
| ssi_sir | double |  |
| ssi_w_z_score | double |  |
| cdi_sir | double |  |
| cdi_w_z_score | double |  |
| mrsa_sir | double |  |
| mrsa_w_z_score | double |  |
| total_hac_score | double |  |
| observed_period | date |  |
| asserted_at | date |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| cms_vintage_sequence | int |  |
| parse_revision | int |  |
| parser_artifact_hash | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| source_id | string |  |
| is_current | boolean |  |
| bronze_object_key | string |  |
| s3_version_id | string |  |
| vintage_tag | string |  |
| drug_source_version_id | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.fact_hacrp WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.fact_hacrp")` first.