About the Core 5.2 Data Model

The Data Model Interface Guide describes the name, purpose, recommended use, and schema of data tables that may be present in data marts that are available when you make a connection to the Bulk Data API.

Depending on the intended use case, a specific data mart may not include all tables that are available in the model. Additionally, a specific data mart may have additional tables that are not described here. The data model behind the Bulk Data API is highly extensible and many data marts will have supplemental tables and columns. The core tables that form the foundation of the API are documented in this guide.

Tables in the core data model can be grouped into categories:

Contents

Unified Model

These tables 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.

Topics

Data Tables

Annotations are computed and provided as columns in order to simplify access to commonly used value set references (i.e. the HCC and CCSR condition category for diagnoses, RxNorm drug class for medications, etc.) and key derived concepts (i.e. normalized care setting computed for encounters, claims, conditions, procedures, etc.).