The person
table is related to the Patient resource that is available via the FHIR API. It has a row for each HIEBus recordgroup that unifies record identity across all data sources. While FHIR employs the provider-centric “Patient” concept, the Bulk Data API uses the more generalized nomenclature “Person” in order to refer to the same entity.
The person
table represents several concepts such as name, identifier, address, etc. that are available from multiple data sources. A prioritization algorithm determines a reconciled value for each of these concepts to describe the person
.
See also:
Source Concepts
- HIEBus recordgroups
- HIEBus recordgroupmembers
- HIEBus patients
- HIEBus demographics
- HIEBus demographicaddresses
- HIEBus demographicidentifiers
Table Schema
Name |
Type
|
Description |
personid |
VARCHAR(38) GUID |
Unique identifier representing a unique person that may include data from several sources that have been linked. This identifier is the person_id of a HIEBus recordgroup.
|
gender |
VARCHAR |
Mapped by Rosetta. Display name.
|
gendercode |
VARCHAR |
Mapped by Rosetta. Coded value.
|
gendertermid |
VARCHAR |
Reference to HIEBus terminology.
|
birthdate |
TIMESTAMP |
Date of birth.
|
identifier |
VARCHAR |
A primary external identifier used to reference to the person. Obtained from a source system. Commonly a MRN, MemberId, etc.
|
givenname |
VARCHAR |
First name.
|
familyname |
VARCHAR |
Last name.
|
middlename |
VARCHAR |
Middle name or initial.
|
deceased |
BOOLEAN |
True if person is deceased.
|
deceaseddate |
TIMESTAMP |
Date of death. NULL if person is living.
|
addressline1 |
VARCHAR |
Address, first line, of the reconciled primary home address determined for the person.
|
addressline2 |
VARCHAR |
Address, second line, of the reconciled primary home address determined for the person.
|
addressline3 |
VARCHAR |
Address, third line, of the reconciled primary home address determined for the person.
|
city |
VARCHAR |
City of the reconciled primary home address determined for the person.
|
postalcode |
VARCHAR |
Zip code of the reconciled primary home address determined for the person.
|
district |
VARCHAR |
County of the reconciled primary home address determined for the person. NULL if not available.
|
state |
VARCHAR |
State of the the reconciled primary home address determined for the person.
|
race |
VARCHAR |
Mapped by Rosetta.
|
racecode |
VARCHAR |
Mapped by Rosetta.
|
racetermid |
VARCHAR |
Reference to HIEBus terminology.
|
lastupdated |
TIMESTAMP |
System generated timestamp indicating the most recent change to this data row. Used for differential operations. Managed in UTC.
|
Back to Tables