Procedureevents

ICU level table

The procedureevents_mv table

Table source: MetaVision ICU database.

Table purpose: Contains procedures for patients

Number of rows: 592,932

Links to:

  • PATIENTS on subject_id
  • ADMISSIONS on hadm_id
  • ICUSTAYS on stay_id
  • D_ITEMS on itemid

Table columns

Name Data type
SUBJECT_ID Integer
HADM_ID Integer
STAY_ID Integer
ITEMID Integer
CHARTTIME Date with times
STORETIME Date with times
VALUE Text
VALUENUM Decimal number
VALUEUOM Text
WARNING Binary (0 or 1)
LOCATION VARCHAR(30)
LOCATIONCATEGORY VARCHAR(30)
STORETIME TIMESTAMP(0)
CGID INT
ORDERID INT
LINKORDERID INT
ORDERCATEGORYNAME VARCHAR(100)
SECONDARYORDERCATEGORYNAME VARCHAR(100)
ORDERCATEGORYDESCRIPTION VARCHAR(50)
ISOPENBAG SMALLINT
CONTINUEINNEXTDEPT SMALLINT
CANCELREASON SMALLINT
STATUSDESCRIPTION VARCHAR(30)
COMMENTS_EDITEDBY VARCHAR(30)
COMMENTS_CANCELEDBY VARCHAR(30)
COMMENTS_DATE TIMESTAMP(0)

Last modified August 14, 2020: update website to use docsy (adc506c)