DATA LAYOUT ----------- --> The DRGDX-FTXT file contains five fields separated by tabs. Field 1 DRG: Diagnosis related group number Field 2 MDC: Major diagnostic code number Field 3 ICD9: ICD-9 code Field 4 PROC_REQ: 0: No procedure required 1: Requires a procedure from DRGMPROC-F Field 5 CC_Flag: 0: not applicable, 1: with comorbidities or complications, 2: without comorbidities or complications Field 6 MCC_Flag: 0: not applicable, 1: with major comorbidities or complications, 2: without major comorbidities or complications Field 7 Mult_Trauma: 0: No tramua sites required, 1: DRG requires codes from 2 different sites from TLDX-F --> The DRGPROC-F file contains seven fields seperated by tabs. Field 1 DRG: Diagnosis related group number Field 2 MDC: Major diagnostic code number Field 3 ICD9-1: ICD-9 code Field 4 ICD9-2: Second ICD-9 code if requrired Field 4 ICD9-3: Third ICD-9 code if requrired Field 6 PDXREQ: 0:No primary diagnosis code required 1:Requires a primary diagnosis code from the DRGDX-F file Field 7 CC_Flag: 0: not applicable, 1: with comorbidities or complications, 2: without comorbidities or complications Field 8 MCC_Flag: 0: not applicable, 1: with major comorbidities or complications, 2: without major comorbidities or complications Field 9 Mult_Trauma: 0: No tramua sites required, 1: DRG requires codes from 2 different sites from TLDX-F -- The TLDX-F file contains two fields seperated by tabs. Field 1 Region: Trauma site Field 2 ICD9: ICD9 Volume 1 code --> The DRGDESC-F contains three fields separated by tabs. Field 1 DRG: numeric designation Field 2 Description: Description of DRG Field 3 Med_Surg: M for medical, S for surgical DRG numbers missing from the ranges are no longer valid. -->The MDCDESC-F contains two fields seperated by tabs. Field 1 MDC: numeric designation Field 2 Description: Description of MDC The file can read in any text editor, like Notepad, the default Windows editor, or in standard spreadsheet or database programs that can import CSV files. The data file contains data for the Inpatient Prospective Payment System (IPPS). Sample sets DRGDESC-F DRG Description Med_Surg 001 HEART TRANSPLANT OR IMPLANT OF HEART ASSIST SYSTEM W MCC S 002 HEART TRANSPLANT OR IMPLANT OF HEART ASSIST SYSTEM W/O MCC S 003 ECMO OR TRACH W MV 96+ HRS OR PDX EXC FACE, MOUTH & NECK W MAJ O.R. S 004 TRACH W MV 96+ HRS OR PDX EXC FACE, MOUTH & NECK W/O MAJ O.R. S 005 LIVER TRANSPLANT W MCC OR INTESTINAL TRANSPLANT S 006 LIVER TRANSPLANT W/O MCC S 007 LUNG TRANSPLANT S 008 SIMULTANEOUS PANCREAS/KIDNEY TRANSPLANT S 009 BONE MARROW TRANSPLANT S 010 PANCREAS TRANSPLANT S ...... DRM-F DRG MDC ICD9 Proc_REQ CC_FLAG MCC_FLAG Mult_Trauma 998 641.10 0 0 0 0 998 641.30 0 0 0 0 998 641.80 0 0 0 0 998 641.90 0 0 0 0 998 642.00 0 0 0 0 998 642.10 0 0 0 0 998 642.20 0 0 0 0 998 642.30 0 0 0 0 998 642.40 0 0 0 0 998 642.50 0 0 0 0 998 642.60 0 0 0 0 998 642.70 0 0 0 0 998 642.90 0 0 0 0 998 643.10 0 0 0 0 998 643.20 0 0 0 0 998 643.80 0 0 0 0 998 643.90 0 0 0 0 998 645.10 0 0 0 0 998 645.20 0 0 0 0 998 646.10 0 0 0 0 998 646.20 0 0 0 0 998 646.30 0 0 0 0 998 646.40 0 0 0 0 998 646.50 0 0 0 0 998 646.60 0 0 0 0 998 646.80 0 0 0 0 998 646.90 0 0 0 0 998 647.00 0 0 0 0 998 647.10 0 0 0 0 998 647.20 0 0 0 0 998 647.30 0 0 0 0 998 647.40 0 0 0 0 998 647.50 0 0 0 0 998 647.60 0 0 0 0 998 647.80 0 0 0 0 998 647.90 0 0 0 0 998 648.00 0 0 0 0 998 648.20 0 0 0 0 998 648.30 0 0 0 0 998 648.40 0 0 0 0 ...... DRGS-F DRG MDC PROCEDURE 691 11 98.51 691 11 98.51 691 11 98.51 691 11 98.51 691 11 98.51 691 11 98.51 691 11 98.51 691 11 98.51 691 11 98.51 691 11 98.51 691 11 98.51 691 11 98.51 692 11 98.51 ..... DRGS-F DRG MDC ICD9-1 ICD9-2 ICD9-3 PDX_REQ CC_Flag MCC_Flag Mult_Trauma 001 33.6 0 0 1 0 001 37.51 0 0 1 0 001 37.52 0 0 1 0 001 37.60 0 0 1 0 001 37.63 0 0 1 0 001 37.64 0 0 1 0 001 37.65 0 0 1 0 001 37.66 0 0 1 0 002 33.6 0 0 2 0 002 37.51 0 0 2 0 002 37.52 0 0 2 0 002 37.60 0 0 2 0 002 37.63 0 0 2 0 002 37.64 0 0 2 0 002 37.65 0 0 2 0 002 37.66 0 0 2 0 003 39.65 96.72 53.42 0 0 0 0 003 39.65 53.42 1 0 0 0 003 39.65 65.95 1 0 0 0 003 39.65 80.95 1 0 0 0 ...... DRGSPDX-F DRG MDC DX1 DX2 004 151.1 004 716.81 004 716.82 004 716.84 004 716.86 004 716.87 004 716.88 004 716.89 004 718.13 004 718.50 004 718.51 004 718.56 004 718.57 004 718.89 004 719.04 004 719.05 004 719.06 004 719.07 004 719.08 004 719.09 004 719.23 004 719.69 004 719.80 004 719.82 004 719.83 004 719.90 004 719.97 004 719.99 004 719.7 004 720.0 004 750.21 004 V50.2 004 341.20 004 V65.43 004 342.00 004 342.01 004 342.02 004 342.11 004 342.12 004 342.80 004 342.82 004 730.24 004 341.21 004 341.22 004 341.8 004 341.9 004 722.83 004 722.90 004 722.91 004 726.62 004 726.63 004 726.65 004 727.63 004 727.64 004 729.73 004 729.79 004 753.15 004 157.0 004 V57.1 .... MDCDESC-F MDC Description Pre MDC 1 Diseases and Disorders of the Nervous System 2 Diseases and Disorders of the Eye 3 Diseases and Disorders of the Ear, Nose, Mouth and Throat 4 Diseases and Disorders of the Respiratory System ... TLDX-F REGION ICD9 Head 800.02 Head 800.03 Head 800.04 Head 800.05 Head 800.10 Head 800.12 ...