observation
One row per clinical observation that is not a lab result or a coded condition, such as vitals and assessment values.
At a glance
| Schema | dax_core |
| Table | observation |
| Layer | Core Data Model |
| Object type | table |
| Columns | 23 |
| Grain | observation_id, data_source |
| Tags | core |
Columns
| Column | Type | Key | Terminology | Constraints | Description |
|---|---|---|---|---|---|
observation_id | varchar | PK | — | not null | — |
person_id | varchar | — | not null | — | |
patient_id | varchar | — | — | — | |
encounter_id | varchar | — | — | — | |
panel_id | varchar | — | — | — | |
observation_date | date | — | — | — | |
observation_type | varchar | — | — | — | |
source_code_type | varchar | Code type | — | — | |
source_code | varchar | — | — | — | |
source_description | varchar | — | — | — | |
normalized_code_type | varchar | — | — | — | |
normalized_code | varchar | — | — | — | |
normalized_description | varchar | — | — | — | |
result | varchar | — | — | — | |
source_units | varchar | — | — | — | |
normalized_units | varchar | — | — | — | |
source_reference_range_low | varchar | — | — | — | |
source_reference_range_high | varchar | — | — | — | |
normalized_reference_range_low | varchar | — | — | — | |
normalized_reference_range_high | varchar | — | — | — | |
ingest_datetime | timestamp | — | — | — | |
dax_last_run | timestamp | — | — | — | |
data_source | varchar | PK | — | not null | — |
Querying
select *
from dax_core.observation
limit 100;