Observation

Schema documentation for the Observation table in the Metriport data model

The observation resource is used to support diagnosis, monitor progress, determine baselines and patterns and even capture demographic characteristics.

Reference Table:

The observation_references table contains normalized references from the observation to other entities. It supports the following reference properties:

• subject (required): links to the patient who is the subject of the observation
• encounter: links to the encounter where the observation was made
• performer: links to practitioners who performed the observation

For detailed information about reference table structure and indexing, see the Reference Tables documentation.

Observation Table:

Primary Keys:

• observation_id

Foreign Keys:

• patient_id

Column	Data Type	Description
observation_id	varchar	Unique identifier for the observation
patient_id	varchar	Unique identifier for the patient
status	varchar	Status of the observation. Possible values: – registered: The existence of the observation is registered, but there is no result yet available. – preliminary: This is an initial or interim observation: data may be incomplete or unverified. – final: The observation is complete and verified by an authorized person. – amended: Subsequent to being final, the observation has been modified; the current version is complete and verified. – corrected: Subsequent to being final, the observation has been modified to correct an error in the result. – cancelled: The observation is unavailable because the measurement was not started or not completed. – entered-in-error: The observation has been withdrawn following erroneous entry. – unknown: The authoring/source system does not know the current status of the observation.
effective_date	date	Start date of the observation
end_date	date	End date of the observation
loinc_code	varchar	LOINC code for the observation
loinc_display	varchar	Human-readable description of LOINC code
source_code_code	varchar	Original code from source system
source_code_display	varchar	Original code display from source system
source_code_system	varchar	Original code system from source system
value	varchar	Value of the observation
units	varchar	Unit of measurement
reference_range_low	varchar	Lower bound of the reference range
reference_range_high	varchar	Upper bound of the reference range
category_hl7_code	varchar	HL7 category code
category_hl7_display	varchar	Human-readable description of HL7 category
interpretation_hl7_code	varchar	HL7 interpretation code
interpretation_hl7_display	varchar	Human-readable description of HL7 interpretation
bodysite_snomed_ct_code	varchar	SNOMED CT body site code
bodysite_snomed_ct_display	varchar	Human-readable description of SNOMED CT body site
note_text	varchar	Additional notes about the observation
meta_source	varchar	Source document filename from FHIR meta.source
data_source	varchar	Deprecated. Use meta_source instead.
data_source_ext	varchar	Integration source of the data, derived from FHIR extension