|
| 1 | +--- |
| 2 | +title: "omr table" |
| 3 | +linktitle: "omr" |
| 4 | +date: 2023-02-03 |
| 5 | +weight: 1 |
| 6 | +description: > |
| 7 | + The Online Medical Record (OMR) table contains miscellaneous information from the EHR. |
| 8 | +--- |
| 9 | + |
| 10 | +## *omr* |
| 11 | + |
| 12 | +The Online Medical Record (OMR) table stores miscellaneous information documented in the electronic health record. |
| 13 | +It is a useful source of outpatient measurements such as blood pressure, weight, height, and body mass index. |
| 14 | + |
| 15 | +## Table columns |
| 16 | + |
| 17 | +Name | Postgres data type |
| 18 | +---- | ---- |
| 19 | +`subject_id` | INTEGER NOT NULL |
| 20 | +`chartdate` | DATE NOT NULL |
| 21 | +`seq_num` | INTEGER NOT NULL |
| 22 | +`result_name` | VARCHAR(100) NOT NULL |
| 23 | +`result_value` | TEXT NOT NULL |
| 24 | + |
| 25 | +## Detailed Description |
| 26 | + |
| 27 | +### `subject_id` |
| 28 | + |
| 29 | +{{% include "/static/include/subject_id.md" %}} |
| 30 | + |
| 31 | +## `chartdate` |
| 32 | + |
| 33 | +The date on which the observation was recorded. |
| 34 | + |
| 35 | +## `seq_num` |
| 36 | + |
| 37 | +An monotonically increasing integer which uniquely distinguishes results of the same type recorded on the same day. |
| 38 | +For example, if two blood pressure measurements occur on the same day, `seq_num` orders them chronologically. |
| 39 | + |
| 40 | +## `result_name` |
| 41 | + |
| 42 | +Each row provides detail regarding a single observation in the EHR. `result_name` provides a human interpretable description of the observation. As of MIMIC-IV v2.2, the following table lists the number of observations and the most common value. |
| 43 | + |
| 44 | +result_name | number of observations | example value |
| 45 | +--- | --- | --- |
| 46 | +eGFR | 240 | >60 |
| 47 | +Blood Pressure Lying | 2764 | 120/70 |
| 48 | +Blood Pressure Sitting | 3400 | 120/70 |
| 49 | +Blood Pressure Standing (1 min) | 2560 | 90/60 |
| 50 | +Blood Pressure Standing | 523 | 110/70 |
| 51 | +Blood Pressure Standing (3 mins) | 626 | 80/50 |
| 52 | +BMI (kg/m2) | 1662112 | 26.6 |
| 53 | +Weight (Lbs) | 1889542 | 150 |
| 54 | +Blood Pressure | 2169549 | 110/70 |
| 55 | +Height (Inches) | 706906 | 64 |
| 56 | +BMI | 554 | 25.0 |
| 57 | +Weight | 354 | 150.00 |
| 58 | +Height | 39 | 64.50 |
| 59 | + |
| 60 | +### `result_value` |
| 61 | + |
| 62 | +`result_value` is the value associated with the given OMR observation. For example, for the `result_name` of 'Blood Pressure', the `field_value` column contains the recorded blood pressure (120/80, 130/70, and so on). |
| 63 | + |
0 commit comments