dic_items
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
- There will be important considerations.
| Name | Postgres data type |
|---|---|
| item_id | INT |
| label | VARCHAR() |
| links_to | VARCHAR() |
| category | VARCHAR() |
| unit | VARCHAR() |
| description | VARCHAR() |
| source | VARCHAR() |
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.
As an alternate primary key to the table, item_id is unique to each row.
Describes the concept which is represented by the item_id.
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 ********.
Provides some information of the type of data the item_id corresponds to.
UNITNAME specifies the unit of measurement used for the item_id.
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 |
