Unified Model

The tables in the Unified Model represent a transformation of the HIEBus model that unifies claim-sourced and EHR-sourced data and denormalizes the HIEBus transactional model to make data more readily accessible for analytics use cases via simpler queries. All data tables reference a master HIEBus personid (recordgroup) that links records across data sources into a unified person. Terminology concepts are represented with mapped primary terms in reference terminologies. These table concepts roughly align with FHIR resources that are available via the FHIR API.

Most of the concepts represented by the Unified Model (careteam, condition, coverage, medicationdispense, medicationrequest, observation, procedure, and servicerequest) have three key relationships:

• These concepts describe a person and are related to the person table via the personid column.
• Optionally, these concepts may relate to a claim (via the claimid column) or an encounter (via the encounterid column).
• These concepts have several terminology concepts that are denormalized for common use cases but can relate to value sets or other mappings in the terminology model. See Using Terminology Concepts Mapped By Rosetta for columns represented with Rosetta-mapped terms.