Medication events.
| Name | Type | Nullable | Default value | Comment |
|---|
| SUBJECT_ID | NUMBER(7) | N | | Patient for the medication event. |
| ICUSTAY_ID | NUMBER(7) | Y | | ICU stay for the medication event. |
| ITEMID | NUMBER(7) | N | | Medication item id for the event. |
| CHARTTIME | TIMESTAMP(6) WITH TIME ZONE | N | | Chart time of the medication event. |
| ELEMID | NUMBER(7) | N | | Element id for the event. |
| REALTIME | TIMESTAMP(6) WITH TIME ZONE | N | | Real time of the medication event. |
| CGID | NUMBER(7) | Y | | Care giver for the medication event. |
| CUID | NUMBER(7) | Y | | Care unit for the medication event. |
| VOLUME | NUMBER(38) | Y | | Volume of the medication event. |
| DOSE | NUMBER(38) | Y | | Doseage of the medication event. |
| DOSEUOM | VARCHAR2(20) | Y | | Units of measurement of the doseage of the medication event. |
| SOLUTIONID | NUMBER(7) | Y | | Solution used in the medication event. |
| SOLVOLUME | NUMBER(38) | Y | | Volume of solution used in the medication event. |
| SOLUNITS | VARCHAR2(20) | Y | | Units of the volume of solution used in the medication event. |
| ROUTE | VARCHAR2(20) | Y | | Route of the medication |
| STOPPED | VARCHAR2(20) | Y | | Medication stopped |