referrals

Table Schema

Name Type Description
id VARCHAR

Surrogate key. Primary key for the referrals table.

identifier VARCHAR
startdate VARCHAR
enddate VARCHAR
nextreviewdate VARCHAR
admitdate VARCHAR
comment VARCHAR
authorizationnumber VARCHAR
patient_id VARCHAR

Surrogate key. Foreign key reference to patients.id

statusterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

templateterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

assignedtouser_id VARCHAR

Surrogate key. Foreign key reference to assignedtousers.id

referfromcaregiver_id VARCHAR

Surrogate key. Foreign key reference to caregivers.id

refertocaregiver_id VARCHAR

Surrogate key. Foreign key reference to caregivers.id

encounter_id VARCHAR

Surrogate key. Foreign key reference to encounters.id

acuityterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

datasource_id VARCHAR

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

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.

dischargedate VARCHAR
admissiontypeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

assignedtouseridentifier VARCHAR
totalunitsauthorized INTEGER
totalunitsdenied INTEGER
totalunitstypeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

referfromfacilitycaregiver_id VARCHAR

Surrogate key. Foreign key reference to caregivers.id

refertofacilitycaregiver_id VARCHAR

Surrogate key. Foreign key reference to caregivers.id

initiationdate VARCHAR
totalcost NUMERIC
tenant_id SMALLINT

Surrogate key. Foreign key reference to tenants.id


Back to Tables