allergyreactions

The allergyreactions table describes the effect observed on the associated patient due to the associated allergy.

Table Schema

Name Type Description
id VARCHAR

Surrogate key. Primary key for the allergyreactions table.

reactionorder INTEGER
reactionfreetext VARCHAR

An uncoded, human readable description of the allergy reaction.

term_id INTEGER

Surrogate key. Foreign key reference to terms.id. A term that describes the reaction.

severityterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

allergy_id VARCHAR

Surrogate key. Foreign key reference to allergys.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.

termtext VARCHAR
termalternateterms VARCHAR

An xml representation of additional terms (beyond the primary term managed in term_id) that were sent by the source system to describe the reaction caused by the allergy.

tenant_id SMALLINT

Surrogate key. Foreign key reference to tenants.id


Back to Tables