- 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
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
- 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 |
- encounter_diagnosis
- encounter_extension
- encounter_hospitalization_dischargedisposition_coding
- encounter_priority_coding
- encounter_reasoncode
- encounter_type
Version diff
Renamedstart_date→period_startend_date→period_endsource_class_code→class_codesource_class_display→class_displaysource_class_system→class_systemdischarge_disposition_hl7_code→hospitalization_dischargedisposition_hl7_codedischarge_disposition_hl7_display→hospitalization_dischargedisposition_hl7_displayreason_snomed_code→reasoncode_snomed_codereason_snomed_display→reasoncode_snomed_displaydata_source→meta_source
type_hl7_code→encounter_type_coding.codew/system = 'http://terminology.hl7.org/CodeSystem/encounter-type'type_hl7_display→encounter_type_coding.displayw/system = 'http://terminology.hl7.org/CodeSystem/encounter-type'source_type_code→encounter_type_coding.codew/code_rank = 1source_type_display→encounter_type_coding.displayw/code_rank = 1source_type_system→encounter_type_coding.systemw/code_rank = 1source_discharge_disposition_code→encounter_hospitalization_dischargedisposition_coding.codew/code_rank = 1source_discharge_disposition_display→encounter_hospitalization_dischargedisposition_coding.displayw/code_rank = 1source_discharge_disposition_system→encounter_hospitalization_dischargedisposition_coding.systemw/code_rank = 1source_reason_code_code→encounter_reasoncode_coding.codew/code_rank = 1source_reason_code_display→encounter_reasoncode_coding.displayw/code_rank = 1source_reason_code_system→encounter_reasoncode_coding.systemw/code_rank = 1priority_hl7_code→encounter_priority_coding.codew/system = 'http://terminology.hl7.org/CodeSystem/v3-ActPriority'priority_hl7_display→encounter_priority_coding.displayw/system = 'http://terminology.hl7.org/CodeSystem/v3-ActPriority'source_priority_code→encounter_priority_coding.codew/code_rank = 1source_priority_display→encounter_priority_coding.displayw/code_rank = 1source_priority_system→encounter_priority_coding.systemw/code_rank = 1

