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