demographicnames

The demographicnames table manages names associated with patients and caregivers.

Table Schema

Name Type Description
id VARCHAR

Surrogate key. Primary key for the demographicnames table.

firstname VARCHAR

The given name of a patient or caregiver.

lastname VARCHAR

The last name of a patient or caregiver.

middlename VARCHAR

The middle name of a patient or caregiver.

title VARCHAR

If available, the title of a patient or caregiver.

credentials VARCHAR

If available, credentials of a patient or caregiver.

suffix VARCHAR

If available, the name suffix (Jr., Sr., etc) of a patient or caregiver.

typeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

demographic_id VARCHAR

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