The inputevents_cv table

Table source: CareVue ICU databases.

Table purpose: Input data for patients.

Number of rows: 17,527,935

Links to:

• PATIENTS on SUBJECT_ID
• ADMISSIONS on HADM_ID
• ICUSTAYS on ICUSTAY_ID
• D_ITEMS on ITEMID
• CAREGIVERS on CGID

A high level description of the data is available here.

Table columns

Name	Postgres data type
ROW_ID	INT
SUBJECT_ID	INT
HADM_ID	INT
ICUSTAY_ID	INT
CHARTTIME	TIMESTAMP(0)
ITEMID	INT
AMOUNT	DOUBLE PRECISION
AMOUNTUOM	VARCHAR(30)
RATE	DOUBLE PRECISION
RATEUOM	VARCHAR(30)
STORETIME	TIMESTAMP(0)
CGID	BIGINT
ORDERID	BIGINT
LINKORDERID	BIGINT
STOPPED	VARCHAR(30)
NEWBOTTLE	INT
ORIGINALAMOUNT	DOUBLE PRECISION
ORIGINALAMOUNTUOM	VARCHAR(30)
ORIGINALROUTE	VARCHAR(30)
ORIGINALRATE	DOUBLE PRECISION
ORIGINALRATEUOM	VARCHAR(30)
ORIGINALSITE	VARCHAR(30)

Detailed Description

SUBJECT_ID, HADM_ID, ICUSTAY_ID

Identifiers which specify the patient: SUBJECT_ID is unique to a patient, HADM_ID is unique to a patient hospital stay and ICUSTAY_ID is unique to a patient ICU stay.

CHARTTIME

CHARTTIME represents the time at which the measurement was charted - that is - recorded on the clinical information system at the bedside. For amounts received (usually volumes), the CHARTTIME represents the time at which that volume was received. That is, it can be considered an “end time”, i.e. X millilitres of solution was administered to the patient by this CHARTTIME. For rates, the CHARTTIME represents the time at which that rate was set. That is, it can be considered a “start time”, i.e. the patient is now receiving X mcg/kg/min of a drug at this CHARTTIME.

See the Inputs and outputs page for a bit more detail about how this table was formed from the raw data.

ITEMID

Identifier for a single measurement type in the database. Each row associated with one ITEMID (e.g. 212) corresponds to an instantiation of the same measurement (e.g. heart rate). Metavision ITEMID values are all above 220000. A subset of commonly used medications in CareVue data have ITEMID values are between 30000-39999. The remaining input/output ITEMID values are between 40000-49999.

AMOUNT, AMOUNTUOM

AMOUNT and AMOUNTUOM list the amount of a drug or substance administered to the patient either between the STARTTIME and ENDTIME (if both are available) or at the ENDTIME (when the exact start time is unknown, but usually up to an hour before).

RATE, RATEUOM

RATE and RATEUOM list the rate at which the drug or substance was administered to the patient either between the STARTTIME and ENDTIME (if both are available), or it lists the rate at which the drug is currently administered at the ENDTIME.

STORETIME

STORETIME records the time at which an observation was manually input or manually validated by a member of the clinical staff.

CGID

CGID is the identifier for the caregiver who validated the given measurement.

ORDERID, LINKORDERID

ORDERID links multiple items contained in the same solution together. For example, when a solution of noradrenaline and normal saline is administered both noradrenaline and normal saline occur on distinct rows but will have the same ORDERID.

LINKORDERID links the same order across multiple instantiations: for example, if the rate of delivery for the solution with noradrenaline and normal saline is changed, two new rows which share the same new ORDERID will be generated, but the LINKORDERID will be the same.

STOPPED, NEWBOTTLE

STOPPED indicates whether the infusion has been disconnected or continued. NEWBOTTLE indicates if a new preparation of the solution was hung at the bedside.

ORIGINALAMOUNT, ORIGINALAMOUNTUOM, ORIGINALROUTE, ORIGINALRATE, ORIGINALRATEUOM , ORIGINALSITE

These columns provide information about the solution the medication was a part of when it was first entered into the information system.