recordauthorities

Used to scope patient or caregiver identifiers. Similar to HL7’s assigning authority or FHIR’s identifier.system. A patient or caregiver identifier will be unique within a given recordauthority. The same identifier may exist in multiple recordauthorities and may represent different entities in each recordauthority

Table Schema

Name Type Description
id VARCHAR

Surrogate key. Primary key for the recordauthorities table.

code VARCHAR

Unique code to represent a recordauthority.

name VARCHAR

User friendly name describing the recordauthority.

storesplainpatientidentifier VARCHAR

T/F. T specifies that rows in the patients table that are related to this recordauthority will have the plain text identifier column populated.

site_id VARCHAR

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