Dimension table: items
The d_items table
Table source: Metavision ICU databases.
Table purpose: Definition table for all items in the ICU databases.
Number of rows: 3,816
- CHARTEVENTS on
- DATETIMEEVENTS on
- INPUTEVENTS on
- OUTPUTEVENTS on
- PROCEDUREEVENTS on
- If the
LINKSTOcolumn is null, then the data is currently unavailable, but planned for a future release.
|Name||Postgres data type|
|LOWNORMALVALUE||Floating point number|
|HIGHNORMALVALUE||Floating point number|
The D_ITEMS table defines
ITEMID, which represents measurements in the database. Measurements of the same type (e.g. heart rate) will have the same
ITEMID (e.g. 220045). Values in the
ITEMID column are unique to each row. All
ITEMIDs will have a value > 220000.
As an alternate primary key to the table,
ITEMID is unique to each row.
LABEL column describes the concept which is represented by the
ABBREVIATION column, only available in Metavision, lists a common abbreviation for the label.
LINKSTO provides the table name which the data links to. For example, a value of ‘chartevents’ indicates that the
ITEMID of the given row is contained in CHARTEVENTS. A single
ITEMID is only used in one event table, that is, if an
ITEMID is contained in CHARTEVENTS it will not be contained in any other event table (e.g. IOEVENTS, CHARTEVENTS, etc).
CATEGORY provides some information of the type of data the
ITEMID corresponds to. Examples include ‘ABG’, which indicates the measurement is sourced from an arterial blood gas, ‘IV Medication’, which indicates that the medication is administered through an intravenous line, and so on.
UNITNAME specifies the unit of measurement used for the
ITEMID. This column is not always available, and this may be because the unit of measurement varies, a unit of measurement does not make sense for the given data type, or the unit of measurement is simply missing. Note that there is sometimes additional information on the unit of measurement in the associated event table, e.g. the
VALUEUOM column in CHARTEVENTS.
PARAM_TYPE describes the type of data which is recorded: a date, a number or a text field.
These columns store reference ranges for the measurement. Note that a reference range encompasses the expected value of a measurement: values outside of this may still be physiologically plausible, but are considered unusual.
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.