The inputevents_cv table
Table source: CareVue ICU databases.
Table purpose: Input data for patients.
Number of rows: 17,527,935
- PATIENTS on
- ADMISSIONS on
- ICUSTAYS on
- D_ITEMS on
- CAREGIVERS on
A high level description of the data is available here.
|Name||Postgres data type|
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 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
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
See the understanding IOEVENTS page for a bit more detail about how this table was formed from the raw data.
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).
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.
AMOUNTUOM list the amount of a drug or substance administered to the patient either between the
ENDTIME (if both are available) or at the
ENDTIME (when the exact start time is unknown, but usually up to an hour before).
RATEUOM list the rate at which the drug or substance was administered to the patient either between the
ENDTIME (if both are available), or it lists the rate at which the drug is currently administered at the
STORETIME records the time at which an observation was manually input or manually validated by a member of the clinical staff.
CGID is the identifier for the caregiver who validated the given measurement.
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
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 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.