next up previous contents
Next: 6.2 Multiple ID mappings Up: 6.1 Database Schema Previous: 6.1.25.3 Foreign key(s)   Contents

6.1.26 Tables

ADDITIVES  
ADMISSIONS The list of patient admissions to the ICU or other hospital room
A_CHARTDURATIONS Chart event durations
A_IODURATIONS Duration of IO events
A_MEDDURATIONS Duration of medication events
CENSUSEVENTS Events which record ICU transfers
CHARTEVENTS Events which occur on a patient chart.
DB_SCHEMA Database schema information.
DELIVERIES  
D_CAREGIVERS Care giver records
D_CAREUNITS Care unit records
D_CHARTITEMS Chart items
D_IOITEMS IO items.
D_LABITEMS  
D_MEDITEMS Medication items.
D_PARAMMAP_ITEMS Mappings between parameters.
D_PATIENTS Patient records.

Date of death is obtained by 2 methods: 1. If the patient died in the hospital, the died_in_hospital flag is 'Y' and the date of discharge is used as the date of death. 2. Patient social security numbers are matched to the US death records to obtain out of hospital date of death.

ICD9 ICD9 code records.
IOEVENTS IO events.
LABEVENTS Laboratory tests
MEDEVENTS Medication events.
PARAMETER_MAPPING Mappings between parameters.
POE_MED  
POE_ORDER  
TOTALBALEVENTS Total balance events.


next up previous contents
Next: 6.2 Multiple ID mappings Up: 6.1 Database Schema Previous: 6.1.25.3 Foreign key(s)   Contents
djscott 2010-08-24