encounters

The encounters table manages all encounters for the specified patient that are sourced from clinical data sources.

Table Schema

Name Type Description
id VARCHAR

Surrogate key. Primary key for the encounters table.

identifier VARCHAR

The external identifier to uniquely identify the encounter that was provided by the data source.

admitdate VARCHAR

The date and time of admission in the local time associated with the encounter.

dischargedate VARCHAR

If the encounter is a hospitalization or bedded stay, the date and time of discharge in the local time associated with the encounter.

hospitalnumber VARCHAR

If provided by the source, a external identifier used to describe the hospital in which the encounter occurred.

eligibilitydate VARCHAR

If provided by the source, a date that describes the date the related patient was designated as eligible by their payer.

currentasofdate VARCHAR

The date for which the most recent information about the encounter is available.

patient_id VARCHAR

Surrogate key. Foreign key reference to patients.id

patientclassterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

admissiontypeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

dischargetypeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

hospitalserviceterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

vipindicatorterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

patienttypeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

drgterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

accesspolicy_id VARCHAR

Surrogate key. Foreign key reference to accesspolicys.id

inserteddate TIMESTAMP

Timestamp (UTC) indicating the date the row was first inserted into HIEBus.

insertedbyapplication_id SMALLINT

The application that first inserted the row into HIEBus. Foreign key reference to applications.id.

insertedbyuser_id VARCHAR

The user associated with the process that first inserted the row into HIEBus. Foreign key reference to users.id.

modifieddate TIMESTAMP

Timestamp (UTC) indicating the date the row was last modified.

modifiedbyapplication_id SMALLINT

The application that last modified the row. Foreign key reference to applications.id.

modifiedbyuser_id VARCHAR

The user associated with the process that last modified the row. Foreign key reference to users.id.

admitsourceterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

admitsourcealternateterms VARCHAR

An xml representation of additional terms that were sent by the source system to describe the admit source.

admitsourcetext VARCHAR

An uncoded, human-readable text field that describes the admit source.

datasource_id VARCHAR

Surrogate key. Foreign key reference to datasources.id. The external data source from which the data in this row originated.

tenant_id SMALLINT

Surrogate key. Foreign key reference to tenants.id


Back to Tables