Table source: CareVue and Metavision ICU databases.

Table purpose: Definition table for all items in the p_zero tables.

Links to:

• chartevents on item_id

Important considerations

• There will be important considerations.

Table columns

Name	Postgres data type
item_id	INT
label	VARCHAR()
links_to	VARCHAR()
category	VARCHAR()
unit	VARCHAR()
description	VARCHAR()
source	VARCHAR()

Detailed Description

The dic_items table defines item_id, which represents measurements in the database. Measurements of the same type (e.g. heart rate) will have the same item_id. The item_id column is an alternate primary key to this table: it is unique to each row.

Note that the dic_items table is sourced from several tables.

item_id

As an alternate primary key to the table, item_id is unique to each row.

label

Describes the concept which is represented by the item_id.

source

Clarifies which database the given item_id was sourced from: 'r_monitor' indicates the item_id was sourced from , while '*' indicated the item_id was sourced from ********.

category

Provides some information of the type of data the item_id corresponds to.

unit

UNITNAME specifies the unit of measurement used for the item_id.

description

Describes the type of data which is recorded with detailed information.

Wiki Dictionary

item_id	original name	parsed_name	description	unit
1	ESTADO_CONCIENC_	conc_state
2	FC_EKG	hr_ecg
3	FC_OSC	hr_osc
4	FR_IP	rr_ip
5	FREC_RESP	rr
6	O2_DIS_	o2_sup
7	PA_S	pa_s
8	PRESN_SIS	presn
9	PULSIOX	pulsiox
10	PULSO	pulse
11	TEMP_AXI	temp_axi