The procedureevents_mv table

Table source: Metavision ICU database.

Table purpose: Contains procedures for patients

Number of rows: 258,066

Links to:

Table columns

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)

Was this page helpful?

Glad to hear it! Please raise an issue here to tell us how we can improve.

Sorry to hear that. Please raise an issue here to tell us how we can improve.