The encounterpatientclasses table manages all patient classes, including historical values, that have been associated with the related encounter. The most current patient class for an encounter is also stored in the encounters.patientclassterm_id column.
Table Schema
| Name |
Type
|
Description |
| id |
VARCHAR |
Surrogate key. Primary key for the encounterpatientclasses table.
|
| startdate |
VARCHAR |
The start date of the period for which this patient class was applicable.
|
| enddate |
VARCHAR |
The end date of the period for which this patient class was applicable.
|
| term_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id. A term that specifies the patient class.
|
| tenant_id |
SMALLINT |
Surrogate key. Foreign key reference to tenants.id
|
| encounter_id |
VARCHAR |
Surrogate key. Foreign key reference to encounters.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.
|
Back to Tables
