...
Business Logic Flow
...
Schema changes
Note that the main This section details the new tables and relationships added to the OpenMRS data model to support factor-based concept ranges.
Note: The complete data model is documented here: Concept Data Model . Therefore, this page shows only the new changes in the data model. This document only highlights the new schema additions relevant to factor-based concept ranges.
...
1. concept_reference_range Table
The concept_reference_range table is designed to store detailed reference ranges for concepts, along with criteria that determine when these ranges apply. The criteria are dynamic and can involve multiple patient factors.
Table Structure:
Column Name | Data Type | Description |
|---|---|---|
|
| Primary key. Unique identifier for each concept reference range. |
|
| Foreign key linking to |
|
| An expression that specifies conditions for when the reference range is applicable. |
|
| The high critical for the concept. |
|
| The high normal for the concept. |
|
| The upper absolute for the concept. |
|
| The lower critical for the concept. |
|
| The lower normal for the concept. |
|
| The lower absolute for the concept. |
Relationships:
1:N relationship with concept_numeric: A single concept can have multiple reference ranges based on different criteria.
...
2. obs_reference_range Table
The obs_reference_range table records the validated reference range for a specific observation (Obs).
Table Structure:
Column Name | Data Type | Description |
|---|---|---|
|
| Primary key. Unique identifier for each observation reference range. |
|
| Foreign key linking to the |
|
| The high critical limit for the observation. |
|
| The high normal limit for the observation. |
|
| The high absolute limit for the observation. |
|
| The low critical limit for the observation. |
|
| The low normal limit for the observation. |
|
| The low absolute limit for the observation. |
Relationships:
Has 1:1 relationship with obs: Each observation has one associated reference range.