| Column Name | Data Type | Nullable | Default value | Comments |
|---|---|---|---|---|
| SUBJECT_ID | NUMBER | N | The patient for the ICD9 code record. | |
| HADM_ID | NUMBER | N | The hospital admission for the ICD9 code record. | |
| SEQUENCE | NUMBER | N | The order/priority of the code for the hospital admission referred by the column HADM_ID, for example: sequence = 1 is the primary ICD9 code | |
| CODE | VARCHAR2 | N | The ICD9 code. | |
| DESCRIPTION | VARCHAR2 | Y | A description of the ICD9 code. |