personrecord

The personrecord view manages all unique human individuals with data stored in HIEBus and identifies each “person” (a unique human individual) with a unique person_id. The “person” is constructed by grouping together one or more rows in the patients table; each row in the patients table represents a unique patient within a single data source. The personrecord view will have a row for each patient row (and patient_id) that is linked together into the group that composes a unique “person” across all data sources.

Table Schema

Name Type Description
person_id VARCHAR

HIEBus assigned unique identifier (GUID) representing a unique human individual (also referred to as “person” or “recordgroup”).

patient_id VARCHAR

HIEBus assigned unique identifier (GUID) representing a unique patient within a single data source. Join to patients.id. All patient related data tables have a patient_id column that references this surrogate key.

recordauthority_code VARCHAR

The code of the recordauthority source for the patient_id. (JOIN patients.recordauthority_id TO recordauthorities.id)

recordauthority_name VARCHAR

The name of the recordauthority source for the patient_id. (JOIN patients.recordauthority_id TO recordauthorities.id)


Back to Tables