next up previous contents
Next: 6.1.5.2 Primary key(s) Up: 6.1.5 A_MEDDURATIONS Previous: 6.1.5 A_MEDDURATIONS   Contents

6.1.5.1 Columns

Column Name Data Type Nullable Default value Comments
SUBJECT_ID NUMBER N   The patient for the medication
ITEMID NUMBER N   The medication item for the duration record
ELEMID NUMBER N    
STARTTIME DATE N   The start time of the medication event
STARTREALTIME DATE Y    
ENDTIME DATE Y   The end time of the medication event
CUID NUMBER Y   The care unit where the medication event took place
DURATION NUMBER Y   The duration of the medication event.

next up previous contents
Next: 6.1.5.2 Primary key(s) Up: 6.1.5 A_MEDDURATIONS Previous: 6.1.5 A_MEDDURATIONS   Contents
djscott 2010-08-24