person

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