next up previous contents
Next: 6.1.7.2 Primary key(s) Up: 6.1.7 CHARTEVENTS Previous: 6.1.7 CHARTEVENTS   Contents

6.1.7.1 Columns

Column Name Data Type Nullable Default value Comments
SUBJECT_ID NUMBER N   The patient for the chart event.
ITEMID NUMBER N   The chart item for the event record.
CHARTTIME DATE N   The time of the chart event.
ELEMID NUMBER N    
REALTIME DATE N    
CGID NUMBER Y   The care giver for the chart event.
CUID NUMBER Y   The care unit where the chart event took place.
VALUE1 VARCHAR2 Y   The first chart event value.
VALUE1NUM NUMBER Y   The first chart event value (cast to numeric value).
VALUE1UOM VARCHAR2 Y   The units of measurement for the first chart event value.
VALUE2 VARCHAR2 Y   The second chart event value.
VALUE2NUM NUMBER Y   The second chart event value (cast to numeric value).
VALUE2UOM VARCHAR2 Y   The units of measurement for the second chart event value.
RESULTSTATUS VARCHAR2 Y    
STOPPED VARCHAR2 Y    
ANNOTATION VARCHAR2 Y    
ICUSTAY_ID NUMBER Y    

next up previous contents
Next: 6.1.7.2 Primary key(s) Up: 6.1.7 CHARTEVENTS Previous: 6.1.7 CHARTEVENTS   Contents
djscott 2010-08-24