Skip to main content

MDC

ColumnData TypeDescription

Maintenance Instructions​

  1. Navigate to the CMS MS DRG website
  2. Under the section "MS-DRG Definitions and Manual and Software", click on "V41 Definitions and Manual Table of Contents - Full Titles - HTML Versions"
    • The version (e.g. V41) will change with each new release.
  3. Click on the hyperlink "Appendix A List of MS-DRGs Version 41.0"
  4. Click on the hyperlink "Design and development of the Diagnosis Related Group (DRGs)"
  5. Scroll through the PDF to find the "Major Diagnostic Categories" table

Follow steps 5-11 if there are any changes. Otherwise, skip to step 12

  1. Copy and paste the code list into any text editor
  2. Format the codes as a CSV and save
  3. Import the CSV file into any data warehouse
  4. 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/mdc.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 updated codes into the MDC file
  3. Submit a pull request
  4. Create a branch in docs. Update the last_updated column in the table above with the current date
  5. Submit a pull request