Understanding the Core Data Model
-
Structure Preview: View the normalized representation of FHIR® data via the Silver layer, including table schemas, columns/descriptions, and sample rows.
-
Read-Only Queries: Execute safe SQL queries to explore data for discovery and mart design; no write or update access.
-
Educational Value: Helps users understand the mapping from FHIR® resources to tabular analytics format, empowering efficient mart building and integration. The Hyperion® core data model provides a normalized, relational representation of FHIR® data.
Core Tables & More:
patients - Patient demographics and identifiers
encounters - Healthcare encounters and visits
observations - Clinical observations and measurements
conditions - Diagnoses and medical conditions
procedures - Medical procedures and interventions
medications - Medication administration and prescriptions & 140 more!
Schema Browser within the Core Data Model
Accessing the Schema
-
Navigate to → Core Data Model
-
Select table or view from the navigation tree
-
Review table structure, relationships, and sample data
Table Information Views:
-
Structure: Column names, data types
-
Statistics: Row counts, data distribution
-
Sample Data: Preview of actual table contents