patients

The patients table manages one row for each unique patient record that is sent from each data source. A record group will group one or more patient records together to describe a unique person with data from one or more sources. All data that is sent from a source system is directly linked to a row in the patients table.

Table Schema

Name Type Description
id VARCHAR

Surrogate key. Primary key for the patients table.

isoptedout VARCHAR

A T/F flag indicating that the patient has opted out of data sharing.

optdecisiondate VARCHAR

the last date that the isoptedout flag was modified.

identifier VARCHAR

The primary external identifier sent by a data source to uniquely identify a patient.

encryptedidentifier VARCHAR

Encrypted identifier values are not made available in external data marts.

issensitive VARCHAR

A T/F flag indicating that the patient has been identified as an individual to which specialized sensitive data handling rules should be applied. For example, a VIP or an employee of the organization.

sensitivedecisiondate VARCHAR

The last date that the issensitive flag was modified.

demographic_id VARCHAR

Surrogate key. Foreign key reference to demographics.id

record_id VARCHAR

Surrogate key. Foreign key reference to records.id

accesspolicy_id VARCHAR

Surrogate key. Foreign key reference to accesspolicies.id

recordauthority_id VARCHAR

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