Extract dually-eligible discharges from a Hospital-Specific Report (HSR)
Source:R/hsr_dual_stays.R
hsr_dual_stays.RdParses the discharge-level records from the HSR of patients who were dually-eligible for Medicare and Medicaid benefits (see details).
Note: CMS changed the format of Hospital-Specific Reports (HSRs) for FY2026 (see here). The current HSR functions support formats through FY2025.
Details
In the Hospital Readmissions Reduction Program (HRRP), hospitals' readmission rates are compared against a peer group of "like" hospitals, which determines whether or not they will get penalized financially.
The peer group allocation done by CMS is determined by creating hospital groupings based
on the share of Medicare beneficiaries who were also eligible for Medicaid benefits, a marker of socioeconomic status
in the hospital population. hsr_dual_stays() extracts the list of discharges accounting for the numerator of this ratio.
Examples
# Access a report
my_report <- hsr_mock_reports("FY2025_HRRP_MockHSR.xlsx")
# Extract dually-eligible stays as a dataset
hsr_dual_stays(my_report)
#> # A tibble: 186 × 6
#> `ID Number` MBI `Beneficiary DOB` `Admission Date` `Discharge Date`
#> <int> <chr> <chr> <chr> <chr>
#> 1 1 9AA9AA9AA99 99/99/9999 99/99/9999 99/99/9999
#> 2 2 9AA9AA9AA99 99/99/9999 99/99/9999 99/99/9999
#> 3 3 9AA9AA9AA99 99/99/9999 99/99/9999 99/99/9999
#> 4 4 9AA9AA9AA99 99/99/9999 99/99/9999 99/99/9999
#> 5 5 9AA9AA9AA99 99/99/9999 99/99/9999 99/99/9999
#> 6 6 9AA9AA9AA99 99/99/9999 99/99/9999 99/99/9999
#> 7 7 9AA9AA9AA99 99/99/9999 99/99/9999 99/99/9999
#> 8 8 9AA9AA9AA99 99/99/9999 99/99/9999 99/99/9999
#> 9 9 9AA9AA9AA99 99/99/9999 99/99/9999 99/99/9999
#> 10 10 9AA9AA9AA99 99/99/9999 99/99/9999 99/99/9999
#> # ℹ 176 more rows
#> # ℹ 1 more variable: `Claim Type` <chr>