procedures

The procedures table manages all procedure and services sent from a clinical data source.

Table Schema

Name Type Description
id VARCHAR

Surrogate key. Primary key for the procedures table.

description VARCHAR

A text description of the procedure.

date VARCHAR

The date the procedure was performed.

verifiedbycaregiver_id VARCHAR

Surrogate key. Foreign key reference to caregivers.id

typeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

term_id INTEGER

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

locationterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

performedbycaregiver_id VARCHAR

Surrogate key. Foreign key reference to caregivers.id

patient_id VARCHAR

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

comment VARCHAR

An uncoded, human-readable text field provided by the source that contains additional information about the procedure.

termalternateterms VARCHAR

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

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

statusterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

properties VARCHAR

An xml representation of additional properties that were sent by the source system to describe the procedure.


Back to Tables