encounter

An interaction between a patient and healthcare provider(s) for the purpose of providing healthcare service(s) or assessing the health status of a patient. See the HL7 FHIR R4 spec for full details.

Previous version: encounter

Tables in this resource:

• encounter – Main encounter record (this page)
• encounter_diagnosis – Diagnoses (condition ref) per encounter
• encounter_type – Backbone for encounter type
• encounter_type_coding
• encounter_reasoncode – Backbone for reason code
• encounter_reasoncode_coding
• encounter_priority_coding
• encounter_hospitalization_dischargedisposition_coding
• encounter_extension
• encounter_extension_vcc_coding
• encounter_references – All refs; see Reference Tables

Reference table: encounter_references holds the following reference properties: subject (→ patient), location.location (→ location), participant.individual (→ practitioner), diagnosis.condition (from encounter_diagnosis stage table, → condition). See Reference Tables.

Primary Keys:

• encounter_id

Foreign Keys:

• patient_id - links to the patient table (subject)

_{† Metriport Platform added}

Column	Data Type	Description
encounter_id	varchar	Unique identifier for the encounter
patient_id	varchar	Unique identifier for the patient (subject)
status	varchar	Status of the encounter (e.g. planned, in-progress, finished)
period_start	datetime	Start date/time of the encounter
period_end	datetime	End date/time of the encounter
length_of_stay†	integer	Length of stay in days
act_code†	varchar	ACT code for encounter class when system is v3-ActCode
act_display†	varchar	Human-readable description of ACT code
class_code	varchar	Encounter class code from source system
class_display	varchar	Encounter class display from source system
class_system	varchar	Encounter class system from source system
hospitalization_dischargedisposition_text	varchar	Free-text discharge disposition
hospitalization_dischargedisposition_hl7_code†	varchar	HL7 discharge disposition code (discharge-disposition)
hospitalization_dischargedisposition_hl7_display†	varchar	Human-readable discharge disposition
reasoncode_snomed_code†	varchar	SNOMED CT code for reason for encounter
reasoncode_snomed_display†	varchar	Human-readable SNOMED CT reason for encounter
priority_text	varchar	Free-text priority of the encounter
meta_source	varchar	Source document filename from FHIR meta.source
data_source_ext†	varchar	Integration source of the data, derived from FHIR extension

Related Tables:

Parent:

• patient

Child:

• encounter_diagnosis
• encounter_extension
• encounter_hospitalization_dischargedisposition_coding
• encounter_priority_coding
• encounter_reasoncode
• encounter_type

Version diff

Renamed

• start_date → period_start
• end_date → period_end
• source_class_code → class_code
• source_class_display → class_display
• source_class_system → class_system
• discharge_disposition_hl7_code → hospitalization_dischargedisposition_hl7_code
• discharge_disposition_hl7_display → hospitalization_dischargedisposition_hl7_display
• reason_snomed_code → reasoncode_snomed_code
• reason_snomed_display → reasoncode_snomed_display
• data_source → meta_source

Moved to separate tables

• type_hl7_code → encounter_type_coding.code w/ system = 'http://terminology.hl7.org/CodeSystem/encounter-type'
• type_hl7_display → encounter_type_coding.display w/ system = 'http://terminology.hl7.org/CodeSystem/encounter-type'
• source_type_code → encounter_type_coding.code w/ code_rank = 1
• source_type_display → encounter_type_coding.display w/ code_rank = 1
• source_type_system → encounter_type_coding.system w/ code_rank = 1
• source_discharge_disposition_code → encounter_hospitalization_dischargedisposition_coding.code w/ code_rank = 1
• source_discharge_disposition_display → encounter_hospitalization_dischargedisposition_coding.display w/ code_rank = 1
• source_discharge_disposition_system → encounter_hospitalization_dischargedisposition_coding.system w/ code_rank = 1
• source_reason_code_code → encounter_reasoncode_coding.code w/ code_rank = 1
• source_reason_code_display → encounter_reasoncode_coding.display w/ code_rank = 1
• source_reason_code_system → encounter_reasoncode_coding.system w/ code_rank = 1
• priority_hl7_code → encounter_priority_coding.code w/ system = 'http://terminology.hl7.org/CodeSystem/v3-ActPriority'
• priority_hl7_display → encounter_priority_coding.display w/ system = 'http://terminology.hl7.org/CodeSystem/v3-ActPriority'
• source_priority_code → encounter_priority_coding.code w/ code_rank = 1
• source_priority_display → encounter_priority_coding.display w/ code_rank = 1
• source_priority_system → encounter_priority_coding.system w/ code_rank = 1