Core 5.2 Model | Unified | personidentifier

personidentifier

The personidentifier table provides a crosswalk that maps all person-level identifiers from all data sources to a personid. A personid represents a unique HIEBus recordgroup. A HIEBus recordgroup represents a unified identity across all data sources.
Most of the identifiers in this table are sent to HIEBus from external data sources. Additionally, all of the internal HIEBus patientids (a GUID; the id column in the HIEBus patients table) that compose the HIEBus recordgroup are also included. Internal HIEBus patientids will have type = HIEBus patientid.

Additional References:

Overview of the Unified Model
Using Terminology Concepts Mapped By Rosetta for columns represented with Rosetta-mapped terms.
Galileo Encounter Reconciliation for computed columns related to primary care setting.

Table Schema

Name	Type	Description
personid	VARCHAR	GUID. An internal 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.
type	VARCHAR	Type of identifier.
typecode	VARCHAR	Coded value. Type of identifier.
typetermid	INTEGER	Reference to the HIEBus terminology id.
identifier	VARCHAR	An identifier used to reference the `person`. For example, an MRN, MemberId, etc.
datasource	VARCHAR	The data source that sent this identifier.
lastupdated	TIMESTAMP	System generated timestamp indicating the most recent change to this data row. Used for differential operations. Managed in UTC.

Back to Tables