+++ date = "2015-09-01T19:34:46-04:00" title = "The procedureevents_mv table" linktitle = "PROCEDUREEVENTS_MV" weight = 32 toc = "true"
+++
Table source: Metavision ICU database.
Table purpose: Contains procedures for patients
Number of rows: 258,066
Links to:
- PATIENTS on
SUBJECT_ID
- ADMISSIONS on
HADM_ID
- ICUSTAYS on
ICUSTAY_ID
- D_ITEMS on
ITEMID
Name | Postgres data type |
---|---|
ROW_ID | INT NOT NULL |
SUBJECT_ID | INT NOT NULL |
HADM_ID | INT NOT NULL |
ICUSTAY_ID | INT |
STARTTIME | TIMESTAMP(0) |
ENDTIME | TIMESTAMP(0) |
ITEMID | INT |
VALUE | DOUBLE PRECISION |
VALUEUOM | VARCHAR(30) |
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) |