hcris-file-rendering

20210825

Contains demos shared during meeting on 8/30/21 and some helpful supplementary files.

20210705

generating-lookup folder

Contains:

1. utils.R file with functions to (a) load hcris cost report tables, (b) get user input from excel spreadsheet, (c) create lookup tables
2. R notebook with example workflow

generating-fy folder

Contains:

1. utils.R file with functions to calculate weighted fiscal years
2. R notebook with example workflow

supplementary folder

Contains supplementary files referenced while writing functions.
Specifically contains HCRIS Data Dictionary and HCRIS database diagram. Used to (a) appropriately set the column names of the Report, Numeric, and Alpha-numeric tables, (b) appropriately set the column types for the Report, Numeric, and Alpha-numeric tables, (c) determine how to link tables for lookup table function.

DATA

Contains HCRIS cost report tables organized by fiscal year. Each year's folder contains Report, Numeric, and Alpha-numeric tables. DATA directory created by download-cost-reports.py script. There is one Hospital Provider ID Info table for the years 1995-2009 and Hospital Provider ID Info table for the years 2010-2020 foudn in the 1996 and 2010 Hospital Reports Zip files at CMS.gov.