What is Epic Clarity

Epic Clarity is Epic’s Enterprise data warehouse build upon either Oracle and Microsoft SQL Server relational database.  Here is a quick overview of different components of Epic application.  When a health care organization decides to implement Epic software, the staff are trained to use the client application called Hyperspace.  Hyperspace provides the end user interface while committing the data to a database known as Cache.  Cache is the hierarchical database used for fast data storage and retrieval.  Unfortunately, hierarchical database is very inefficient for reporting needs such as data aggregation.  Epic’s Clarity database acts as a data warehouse in which analysts can query and answer on specific set of business questions.  The Epic’s Clarity data schema is consist of several thousand tables but not all tables are created equal.

Currently The data model for Epic Clarity is logically divided into:


ADT Prelude
Professional Billing
Tapestry
EpicCare Ambulatory (Outpatient)
OpTime (Surgery)
EpixRx (Medication)
EpicCare Inpatient
Resolute Hospital Billing

Epic currently has a training course for each of the topic above.  The training courses are a great place to start if you are looking for specific area of Clarity you will be working with.

Be Sociable, Share!

If you enjoyed this post, make sure you
Subscribe to my RSS feed!

16 Responses to “What is Epic Clarity”


  1. Nancy Reilly says:

    Please send me info re: how to get Epic Certification.

  2. Rob T says:

    Does anyone know where one could get a list and the base tables and element descriptions?

    • Pat says:

      Hi Rob, if your hospital is currently using Epic you should be able to apply for an Epic UserWeb account. Once you have login to the UserWeb you should be able to find ER models and data dictionaries depending on the software version

  3. Dewitt says:

    The transactional data for Resolute Professional and Hospital are better suite for a true star schema warehouse design. This also allows organizations to join non-Epic data, like expense, payroll, benchmarks, etc. Check out PDS (www.pds-online.com) for services like this.

    • Pat says:

      Hi Dewitt, thanks for visiting my blog. I do agree with you that a true schema warehouse design has its advantages when it comes to building data warehouse and using business intelligence software.

  4. Calvin says:

    Don’t forget TERADATA as the backbone database server too!!

    Ahhh the data dictionary. A great place to start. Can’t tell you how many SLGs I have had submitted to correct the DD!

    • Pat says:

      I am not aware of any Healthcare organization that uses Teradata most of them like SqlServer (my guess is the cost), but Teradata is definitely a great database for building data warehouse.

  5. Stephen Otton says:

    Shands Hospital at the University of Florida uses the Jun Reporting Engine form Jun Consulting. This provides data integration with near real-time data from Epic. Users can develop detailed reports on their own without needing and having to wait for a Clarity report writer.


Trackbacks/Pingbacks

  1. Are You Certified to Handle Data Reporting? | Distance Learning Partners 07 06 12

Leave a Reply

CommentLuv badge

  • Blog Sponsors: