| Name | Type | Nullable | Default value | Comment |
|---|
| SUBJECT_ID | NUMBER(7) | N | | Unique patient identifier. |
| ICUSTAY_ID | NUMBER(7) | Y | | Unique ICU stay identifier |
| ITEMID | NUMBER(7) | N | | The medication item for the duration record |
| ELEMID | NUMBER(7) | N | | The element of a combined medication duration |
| STARTTIME | TIMESTAMP(6) WITH TIME ZONE | N | | The start time of the medication event |
| STARTREALTIME | TIMESTAMP(6) WITH TIME ZONE | Y | | The actual start time of the medication event |
| ENDTIME | TIMESTAMP(6) WITH TIME ZONE | Y | | The end time of the medication event |
| CUID | NUMBER(7) | Y | | The care unit where the medication event took place |
| DURATION | NUMBER(38) | Y | | The duration of the medication event. |
