| Column Name | Data Type | Nullable | Default value | Comments |
|---|---|---|---|---|
| SUBJECT_ID | NUMBER | N | The unique patient identifier | |
| ITEMID | NUMBER | N | The identifier for the laboratory test name | |
| CHARTTIME | DATE | N | The date the test was done | |
| HADM_ID | NUMBER | N | The reference to the hospital admission | |
| VALUE | VARCHAR2 | Y | The result value of the laboratory test | |
| VALUENUM | NUMBER | Y | The numeric representation of the laboratory test if the result was numeric | |
| FLAG | VARCHAR2 | Y | Flag or annotation on the lab result | |
| VALUEUOM | VARCHAR2 | Y | The units of measurement for the lab result value | |
| ICUSTAY_ID | NUMBER | Y |