Skip to main content

APR-DRG

Maintenance Instructions

  1. Navigate to the AHRQ HCUP website
  2. Click the header tab "Database Information"
  3. Click on the hyperlink "NIS Database Documentation"
  4. Under "Additional Resources for Data Elements" click on the hyperlink "APR-DRGs Methodology Overview Version 31"
  5. Scroll to the bottom of the PDF, copy and paste the codes found in "Appendix A - List of All Patient refined DRGs" into any text editor
  6. Format the codes as a CSV file and save
  7. Import the CSV file into any data warehouse
  8. Upload the CSV file from the data warehouse to S3 (credentials with write permissions to the S3 bucket are required)
-- example code for Snowflake
copy into s3://tuva-public-resources/terminology/apr_drg.csv
from [table_created_in_step_7]
file_format = (type = csv field_optionally_enclosed_by = '"')
storage_integration = [integration_with_s3_write_permissions]
OVERWRITE = TRUE;
  1. Create a branch in The Tuva Project
  2. Copy and paste the CSV formatted code list into the APR-DRG file
  3. Create a branch in docs. Update the last_updated column in the table above with the current date
  4. Submit a pull request