next up previous contents
Next: 6.1.21.2 Primary key(s) Up: 6.1.21 MEDEVENTS Previous: 6.1.21 MEDEVENTS   Contents

6.1.21.1 Columns

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    

next up previous contents
Next: 6.1.21.2 Primary key(s) Up: 6.1.21 MEDEVENTS Previous: 6.1.21 MEDEVENTS   Contents
djscott 2010-08-24