Skip to main content
Measurements and simple assertions made about a patient, device or other subject. See the HL7 FHIR R4 spec for full details. Previous version: observation Tables in this resource: 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. Primary Keys:
  • observation_id
Foreign Keys:
  • patient_id - links to the patient table (subject)
† Metriport Platform added
ColumnData TypeDescription
observation_idvarcharUnique identifier for the observation
patient_idvarcharUnique identifier for the patient (subject)
statusvarcharStatus of the observation (e.g. final, preliminary)
effectivedatetimedatetimeEffective date/time if provided directly
effectiveperiod_startdatetimeStart of effective period
effective_date†datetimeCoalesced effective date (effectivedatetime or effectiveperiod_start)
effectiveperiod_enddatetimeEnd of effective period
code_textvarcharFree-text description of the observation type
code_loinc_code†varcharLOINC code for the observation
code_loinc_display†varcharHuman-readable LOINC description
valuequantity_valuevarcharQuantity value when observation value is a Quantity
valuequantity_comparatorvarcharComparator for quantity value (e.g. <, <=, >=, >)
valuestringvarcharString value when observation value is a string
valuecodeableconcept_textvarcharText when observation value is a CodeableConcept
value†varcharCoalesced value (quantity, string, or codeable concept text)
valuerange_high_valuevarcharHigh value when the observation value is a Range
valuerange_high_unitvarcharUnit for high range value
valuerange_low_valuevarcharLow value when the observation value is a Range
valuerange_low_unitvarcharUnit for low range value
valuequantity_unitvarcharUnit when observation value is a Quantity
units†varcharCoalesced unit of measurement
referencerange_low_value†varcharLower bound of the reference range (first range)
referencerange_high_value†varcharUpper bound of the reference range (first range)
interpretation_hl7_code†varcharHL7 interpretation code (ObservationInterpretation)
interpretation_hl7_display†varcharHuman-readable description of HL7 interpretation
category_hl7_code†varcharHL7 category code (observation-category, preferred binding)
category_hl7_display†varcharHuman-readable description of HL7 category
bodysite_textvarcharFree-text body site
note_text†varcharAdditional notes about the observation (first note)
meta_sourcevarcharSource document filename from FHIR meta.source
data_source_ext†varcharIntegration source of the data, derived from FHIR extension
Related Tables: Parent: Child:

​
Version diff

Renamed
  • end_date → effectiveperiod_end
  • reference_range_low → referencerange_low_value
  • reference_range_high → referencerange_high_value
  • loinc_code → code_loinc_code
  • loinc_display → code_loinc_display
  • data_source → meta_source
Moved to separate tables