Core Concepts
Master Epic’s data model, naming conventions, and the three-tier architecture.
EHI Living Manual
This is your comprehensive guide to understanding and working with Epic’s Electronic Health Information (EHI) export format.
What You’ll Learn
Section titled “What You’ll Learn”Interactive SQL
Run live SQL queries directly in your browser against a sample dataset.
Real Patterns
Learn practical patterns for joining tables and navigating relationships.
Best Practices
Discover optimization techniques and common pitfalls to avoid.
Quick Start
Section titled “Quick Start”Ready to dive in? Start with Read Me First for essential context, then take the Five Minute Test Drive to see the most important tables in action.
Interactive Learning
Section titled “Interactive Learning”This entire manual is interactive. Every SQL example can be edited and run in your browser:
- ✏️ Edit queries to experiment
- ▶️ Run with Ctrl+Enter
- 🔄 Reset to original
- 💾 Everything runs locally in your browser
About This Manual
Section titled “About This Manual”This guide fills the gaps left by official documentation, providing the context and patterns you need to be productive with Epic EHI data. Whether you’re working with your personal health records or integrating enterprise-scale exports, you’ll find practical guidance here.