encounter
The US Core Encounter Profile inherits from the FHIR [Encounter](https://hl7.org/fhir/R4/encounter.html) resource; refer to it for scope and usage definitions.
The US Core Encounter Profile inherits from the FHIR Encounter resource; refer to it for scope and usage definitions. This profile sets minimum expectations for the Encounter resource to record, search, and fetch basic encounter information for an individual patient. It specifies which core elements, extensions, vocabularies, and value sets SHALL be present and constrains how the elements are used. Providing the floor for standards development for specific use cases promotes interoperability and adoption.
Source
| Model | Leg | Role |
|---|
us-core-encounter | FHIR | defines this table |
Columns
| Column | Type | Null | Description | Source |
|---|
id | uuid primary key | no | Encounter.id | — |
created_at | timestamptz | no | Row creation timestamp. | — |
updated_at | timestamptz | no | Row update timestamp; maintained by the application. | — |
created_by | text | no | Actor who created the row. | — |
updated_by | text | no | Actor who last updated the row. | — |
interpreter_required
interpreter_required_code
interpreter_required_system
interpreter_required_valueset_id | coded text
text, text, text, text | yes | 𝗔𝗗𝗗𝗜𝗧𝗜𝗢𝗡𝗔𝗟 𝗨𝗦𝗖𝗗𝗜: Whether the patient needs an interpreter | Encounter.extension |
identifier_value
identifier_system | text, text
text, text | yes | Identifier(s) by which this encounter is known | Encounter.identifier |
status | text | yes | planned | arrived | triaged | in-progress | onleave | finished | cancelled + | Encounter.status |
class
class_code
class_system
class_valueset_id | coded text
text, text, text, text | yes | Classification of patient encounter | Encounter.class |
patient_id | uuid | yes | The patient or group present at the encounter | Encounter.subject |
period_start
period_end | timestamptz, timestamptz
timestamptz, timestamptz | yes | The start and end time of the encounter | Encounter.period |
hospitalization_discharge_disposition
hospitalization_discharge_disposition_code
hospitalization_discharge_disposition_system | text, text, text
text, text, text | yes | Category or kind of location after discharge | Encounter.hospitalization.dischargeDisposition |
service_provider_id | uuid | yes | The organization (facility) responsible for this encounter | Encounter.serviceProvider |
Constraints
check ((interpreter_required is null and interpreter_required_code is null and interpreter_required_system is null and interpreter_required_valueset_id is null) or (interpreter_required is not null and interpreter_required_code is not null and interpreter_required_system is not null and interpreter_required_valueset_id is not null))
check (identifier_system is null or identifier_value is not null)
check ((class is null and class_code is null and class_system is null and class_valueset_id is null) or (class is not null and class_code is not null and class_system is not null and class_valueset_id is not null))
check (period_start is null or period_end is null or period_start <= period_end)
check ((hospitalization_discharge_disposition_code is null and hospitalization_discharge_disposition_system is null) or (hospitalization_discharge_disposition_code is not null and hospitalization_discharge_disposition_system is not null))
References
| Columns | Target | On delete |
|---|
interpreter_required_valueset_id, interpreter_required_code, interpreter_required_system, interpreter_required | valueset_code | restrict |
class_valueset_id, class_code, class_system, class | valueset_code | restrict |
patient_id | patient | no action |
service_provider_id | organization | no action |
Referenced by
Indexes
encounter_patient_id_idx on patient_idencounter_service_provider_id_idx on service_provider_id
Child tables
6 tables hang off encounter, one row per repetition.
encounter_other_identifier
Child table — one row per repetition, deleted with its parent.
| Column | Type | Null | Description | Source |
|---|
id | uuid primary key | no | Primary key. | — |
encounter_id | uuid → encounter | no | — | — |
identifier_value | text | no | — | — |
identifier_system | text | yes | — | — |
identifier_use | text | yes | — | — |
valid_from | timestamptz | yes | — | — |
valid_until | timestamptz | yes | — | — |
Unique
encounter_id, identifier_system, identifier_value
References
| Columns | Target | On delete |
|---|
encounter_id | encounter | cascade |
encounter_type
Child table — one row per repetition, deleted with its parent.
| Column | Type | Null | Description | Source |
|---|
id | uuid primary key | no | Primary key. | — |
encounter_id | uuid → encounter | no | — | — |
type
type_code
type_system
type_valueset_id | coded text
text, text, text, text | yes | Specific type of encounter | Encounter.type |
Constraints
check ((type is null and type_code is null and type_system is null and type_valueset_id is null) or (type is not null and type_code is not null and type_system is not null and type_valueset_id is not null))
References
| Columns | Target | On delete |
|---|
encounter_id | encounter | cascade |
type_valueset_id, type_code, type_system, type | valueset_code | restrict |
Indexes
encounter_type_encounter_id_idx on encounter_id
encounter_participant
Child table — one row per repetition, deleted with its parent.
| Column | Type | Null | Description | Source |
|---|
id | uuid primary key | no | Primary key. | — |
encounter_id | uuid → encounter | no | — | — |
period_start
period_end | timestamptz, timestamptz
timestamptz, timestamptz | yes | Period of time during the encounter that the participant participated | Encounter.participant.period |
individual_practitioner_id
individual_practitioner_role_id
individual_related_person_id | uuid, uuid, uuid
uuid, uuid, uuid | yes | Persons involved in the encounter other than the patient | Encounter.participant.individual |
Constraints
check (period_start is null or period_end is null or period_start <= period_end)
check (num_nonnulls(individual_practitioner_id, individual_practitioner_role_id, individual_related_person_id) <= 1)
References
Referenced by
Indexes
encounter_participant_encounter_id_idx on encounter_idencounter_participant_individual_practitioner_id_idx on individual_practitioner_idencounter_participant_individual_practitioner_role_id_idx on individual_practitioner_role_idencounter_participant_individual_related_person_id_idx on individual_related_person_id
encounter_participant_type
Child table — one row per repetition, deleted with its parent.
| Column | Type | Null | Description | Source |
|---|
id | uuid primary key | no | Primary key. | — |
encounter_participant_id | uuid → encounter_participant | no | — | — |
type
type_code
type_system | text, text, text
text, text, text | yes | Role of participant in encounter | Encounter.participant.type |
Constraints
check ((type_code is null and type_system is null) or (type_code is not null and type_system is not null))
References
Indexes
encounter_participant_type_encounter_participant_id_idx on encounter_participant_id
encounter_reason_code
Child table — one row per repetition, deleted with its parent.
| Column | Type | Null | Description | Source |
|---|
id | uuid primary key | no | Primary key. | — |
encounter_id | uuid → encounter | no | — | — |
reason_code
reason_code_code
reason_code_system | text, text, text
text, text, text | yes | Coded reason the encounter takes place | Encounter.reasonCode |
Constraints
check ((reason_code_code is null and reason_code_system is null) or (reason_code_code is not null and reason_code_system is not null))
References
| Columns | Target | On delete |
|---|
encounter_id | encounter | cascade |
Indexes
encounter_reason_code_encounter_id_idx on encounter_id
encounter_location
Child table — one row per repetition, deleted with its parent.
| Column | Type | Null | Description | Source |
|---|
id | uuid primary key | no | Primary key. | — |
encounter_id | uuid → encounter | no | — | — |
location_id | uuid | yes | Location the encounter takes place | Encounter.location.location |
References
Indexes
encounter_location_encounter_id_idx on encounter_idencounter_location_location_id_idx on location_id
Value sets
| Value set | Codes |
|---|
http://cts.nlm.nih.gov/fhir/ValueSet/2.16.840.1.113762.1.4.1267.16 | 0 |
http://cts.nlm.nih.gov/fhir/ValueSet/2.16.840.1.113762.1.4.1267.23 | 0 |
http://terminology.hl7.org/ValueSet/v3-ActEncounterCode | 0 |