| Name | Type | Nullable | Default value | Comment |
|---|
| SUBJECT_ID | NUMBER(7) | N | | The unique patient identifier |
| HADM_ID | NUMBER(7) | Y | | The hospital admission |
| ICUSTAY_ID | NUMBER(7) | Y | | The ICU stay id |
| ITEMID | NUMBER(7) | N | | The identifier for the laboratory test name |
| CHARTTIME | TIMESTAMP(6) WITH TIME ZONE | N | | The date and time that the test relates to |
| VALUE | VARCHAR2(100) | Y | | The result value of the laboratory test |
| VALUENUM | NUMBER(38) | Y | | The numeric representation of the laboratory test if the result was numeric |
| FLAG | VARCHAR2(10) | Y | | Flag or annotation on the lab result |
| VALUEUOM | VARCHAR2(10) | Y | | The units of measurement for the lab result value |
