Column Name |
Data Type |
Nullable |
Default value |
Comments |
SUBJECT_ID |
NUMBER |
N |
|
The patient for the
medication event. |
ITEMID |
NUMBER |
N |
|
The medication item id for
the event. |
CHARTTIME |
DATE |
N |
|
The chart time of the medication
event. |
ELEMID |
NUMBER |
N |
|
|
REALTIME |
DATE |
N |
|
|
CGID |
NUMBER |
Y |
|
The care giver for the medication event. |
CUID |
NUMBER |
Y |
|
The care unit for the medication event. |
VOLUME |
NUMBER |
Y |
|
The volume of the medication event. |
DOSE |
NUMBER |
Y |
|
The doseage of the medication event. |
DOSEUOM |
VARCHAR2 |
Y |
|
The units of measurement of the doseage of the medication
event. |
SOLUTIONID |
NUMBER |
Y |
|
The solution used in the
medication event. |
SOLVOLUME |
NUMBER |
Y |
|
The volume of solution
used in the medication event. |
SOLUNITS |
VARCHAR2 |
Y |
|
The units
of the volume of solution used in the medication event. |
ROUTE |
VARCHAR2 |
Y |
|
|
SITE |
VARCHAR2 |
Y |
|
The site of the
medication event. |
STOPPED |
VARCHAR2 |
Y |
|
|
ANNOTATION |
VARCHAR2 |
Y |
|
|
ICUSTAY_ID |
NUMBER |
Y |
|
|