Core 5.2 Model | Unified | encounter

encounter

The encounter table is related to the Encounter resource that is available via the FHIR API.
The encounter table combines all encounters from all EHR sources for a HIEBus person (recordgroup) into a consolidated structure.

Additional References:

Overview of the Unified Model
Using Terminology Concepts Mapped By Rosetta for columns represented with Rosetta-mapped terms.
Galileo Encounter Reconciliation for computed columns related to primary care setting.
Refer to the condition table for diagnoses associated with the encounter. Refer to the procedure table for procedures associated with the encounter.

Table Schema

Name	Type	Description
personid	VARCHAR	GUID. An internal identifier representing a unique `person` that may include data from several sources that have been linked. This identifier is the person_id of a HIEBus recordgroup.
encounterid	VARCHAR	GUID. An internal identifier representing a unique `encounter`. This identifier is the id of the row in the HIEBus source table.s
identifier	VARCHAR	External identifier used by the source system to uniquely identify the encounter.
datasource	VARCHAR	The name of the data source. Commonly determined from the HIEBus record authority name of the source patient record.
class	VARCHAR	Mapped by Rosetta. Patient class concept, used as a primary indicator of the care setting in which the encounter took place. This is the preferred mapped concept determined by the Rosetta Terminology Service.
classcode	VARCHAR	Mapped by Rosetta. Coded value. Patient class concept, used as a primary indicator of the care setting in which the encounter took place. This is the preferred mapped concept determined by the Rosetta Terminology Service.
classtermid	INTEGER	Reference to HIEBus terminology properties for the encounter.
type	VARCHAR	Mapped by Rosetta. Department or service. This is the preferred mapped concept determined by the Rosetta Terminology Service.
typecode	VARCHAR	Mapped by Rosetta. Coded value. Department or service. This is the preferred mapped concept determined by the Rosetta Terminology Service.
typetermid	INTEGER	Reference to HIEBus terminology properties for the encounter.
admitsource	VARCHAR	Mapped by Rosetta. For bed-assigned encounters, the disposition of the patient prior to admission. Useful to determine admission via ED or transfer. This is the preferred mapped concept determined by the Rosetta Terminology Service.
admitsourcecode	VARCHAR	Mapped by Rosetta. Coded value. For bed-assigned encounters, the disposition of the patient prior to admission. Useful to determine admission via ED or transfer. This is the preferred mapped concept determined by the Rosetta Terminology Service.
admitsourcetermid	INTEGER	Reference to HIEBus terminology properties for the encounter.
dischargedisposition	VARCHAR	Mapped by Rosetta. For bed-assigned encounters, the disposition of patient after discharge. Useful to determine transfers to another facility. This is the preferred mapped concept determined by the Rosetta Terminology Service.
dischargedispositioncode	VARCHAR	Mapped by Rosetta. Coded value. For bed-assigned encounters, the disposition of patient after discharge. Useful to determine transfers to another facility. This is the preferred mapped concept determined by the Rosetta Terminology Service.
dischargedispositiontermid	INTEGER	Reference to HIEBus terminology properties for the encounter.
admitdate	TIMESTAMP	If the encounter is related to a bed-assigned inpatient encounter, the admit date of the encounter. Otherwise, the date of service.
dischargedate	TIMESTAMP	If the encounter is related to a bed-assigned inpatient encounter, the discharge date of the encounter. Otherwise, the date of service.
provideridentifier	VARCHAR	The identifier assigned to the primary provider associated with the encounter.
providername	VARCHAR	The name of the primary provider associated with the encounter.
location	VARCHAR	The name of the facility where the encounter occurred.
primarycaresetting	VARCHAR	Computed. A normalized description of the primary place of service for the encounter.
primarycaresettingreason	VARCHAR	Computed. For traceability, an explanation for the primarycaresetting assignment.
secondarycaresettings	VARCHAR	Computed. A comma delimited string of other care settings (for example ED or observation activity on an inpatient encounter) determined for the encounter.
annotations	VARCHAR	Computed. A comma delimited set of strings that represent computed features of the encounter.
lastupdated	TIMESTAMP	System generated timestamp indicating the most recent change to this data row. Used for differential operations. Managed in UTC.

Back to Tables