patientassociatedparties

The patientassociatedparties table manages relationships between a patient (patient_id) and another individuals such as an emergency contact.

Table Schema

Name Type Description
id VARCHAR

Surrogate key. Primary key for the patientassociatedparties table.

relationshiptypetext VARCHAR

An uncoded, human-readable description of the relationship between the patient and another individual.

patient_id VARCHAR

Surrogate key. Foreign key reference to patients.id

relationshiptypeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

relationshiptypealternateterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

contacttypeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

associatedpartydemographic_id VARCHAR

Surrogate key. Foreign key reference to associatedpartydemographics.id

contactpersondemographic_id VARCHAR

Surrogate key. Foreign key reference to contactpersondemographics.id

associatedorganizationdemographic_id VARCHAR

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

tenant_id SMALLINT

Surrogate key. Foreign key reference to tenants.id


Back to Tables