Observation

The observation table contains information on measurements other than lab tests e.g. blood pressure, height, and weight.

Primary Keys:

• observation_id

Foreign Keys:

• patient_id
• encounter_id

Column	Data Type	Description	Terminology
observation_id	varchar	Unique identifier for each observation in the dataset.	no
person_id	varchar	Unique identifier for each person in the dataset.	no
patient_id	varchar	Identifier that links a patient to a particular clinical source system.	no
encounter_id	varchar	Unique identifier for each encounter in the dataset.	no
panel_id	varchar	Unique identifier for the panel.	no
observation_date	date	Date the observation was recorded.	no
observation_type	varchar	Type of observation.	no
source_code_type	varchar	The type of code reported in the source system (e.g., ICD-10 code, NDC, lab, etc)	yes
source_code	varchar	The code in the source system (e.g., the ICD-10 code, NDC, lab, etc)	no
source_description	varchar	Description of the source code in the source system.	no
normalized_code_type	varchar	The normalized type of code.	no
normalized_code	varchar	The normalized code.	no
normalized_description	varchar	Normalized description of the code.	no
mapping_method	varchar	mapping method used to populate the normalized codes and descriptions. Can be manual (fields were populated in input layer), automatic (dictionary codes matching the source code were found and was automatically populated) or custom (populated by normalization engine)	no
result	varchar	The result of the record (e.g., lab test, observation, etc).	no
source_units	varchar	Source units of the lab test.	no
normalized_units	varchar	Normalized units of the lab test.	no
source_reference_range_low	varchar	The low end of the reference range from the source system.	no
source_reference_range_high	varchar	The high end of the reference range from the source system.	no
normalized_reference_range_low	varchar	The normalized low end of the reference range.	no
normalized_reference_range_high	varchar	The normalized high end of the reference range.	no
data_source	varchar	User-configured field that indicates the data source.	no
tuva_last_run	timestamp_ntz	The last time the data was refreshed. Generated by `dbt_utils.pretty_time` as the local time of the `dbt run` environment. Timezone is configurable via the `tuva_last_run` var.	no