Chpt 1 Data Source and Reporting tools

Question 1

Definition:The Registry Framework

Answer 1

The Registry Framework exists in Chronicles. Registries are designed for managing populations of patients. Each registry effectively collects information (metrics) about an element of a population ‐ typically a patient.Registries are defined by records in the HFR master file, and the data is stored in the RDT master file.(2.11,pg26)

Question 2

Definition:The Metric Framework

Answer 2

The Metric Framework exists in Chronicles. It collects data from the three Epic databases and brings that information back, compiled and aggregated, at different summary levels and time periods. Metrics are defined in the IDN master file and the data is stored in the CSF master file.(2.11,pg26)

Question 3

What are Cubes?

Answer 3

An OLAP (online analytical processing) cube is a copy of data that has been pre‐aggregated into a specific format for speed.This tool is great for users who want to manipulate the data in Excel; it is very similar to a large pivot table.)(2.11,pg27)

Question 4

What are 3rd Party Data Structures?

Answer 4

Some non‐Epic reporting tools will capture or reference data stored in your Caboodle or Clarity databases and process / store them for further use. Examples of this include SAP Universes and Tableau.(2.11,pg27)

Question 5

Definition:Palette

Answer 5

A product name for tools that allow to visualize data in Hyperspace(2.11, pg28)

Question 6

Definition:Radar Dashboards

Answer 6

Radar is the “front‐door” to Epic’s reporting suite.(2.11, pg28)

Question 7

How does Radar Dashboards present data within Epic and non Epic sources?

Answer 7

1. Real‐time snapshots of business processes
   2.Trending graphs and tables to visualize and compare key statistics
   3.Benchmark values that end users can use to compare to their performance to the Epic community
   4.Enterprise datasets from external systems
2. Alerts which notify end-users that a metric has crossed the threshold
3. Predicted volumes based on historical trends(2.11, pg28)

Question 8

How are dashboards distributed?

Answer 8

via a report group, via user security record, via user type or role, or via redirector.(2.13 pg29)

Question 9

How do you open a Dashboard in a Browser?

Answer 9

1. Log into Hyperspace
2. From any menu Go to the Epic Menu in top upper left corner. Navigate to Help> About Hyperspace.
3. In the window that pops up copy the website URL
4. Paste the URL in the Browser.(2.13,pg29)

Question 10

Definition:Reporting Workbench

Answer 10

Reporting Workbench is the operational reporting tool that analysts and end‐users use to provide real‐ time, actionable reports. Reporting Workbench reports are written from Reporting Workbench templates. Templates are similar to SlicerDicer data models, they define the available data a particular report can search and return(2.13,pg29-30)

Question 11

Sorting Report Descriptions(Select database): Surgical procedures conducted over the past year, by physician

Answer 11

Caboodle; Clarity(pg 36/2.20)

Question 12

Sorting Report Descriptions(Select database):Pending departmental transfers

Answer 12

Chronicles(pg 36/2.20)

Question 13

Sorting Report Descriptions: (Select database). Wait times for patients currently in the ED

Answer 13

Chronicles(pg 36/2.20)

Question 14

Sorting Report Descriptions: (Select database):Top 100 Chief Complaints in the ED

Answer 14

Caboodle ; Clarity(pg 36/2.20)

Question 15

Sorting Report Descriptions: (Select database): Which procedures cost the most to the organization

Answer 15

Caboodle ; Clarity(pg 36/2.20)

Question 16

Sorting Report Descriptions: (Select database): What are the consequences of adjusting to a different payment model

Answer 16

Caboodle ; Clarity(pg 36/2.20)

Question 17

Describe the data lineage of Epic data that ultimately resides in Caboodle?

Answer 17

The data is entered into Chronicles, extracted to Clarity, and then extracted from Clarity to Caboodle.(pg 39/2.23)

Question 18

Is it possible to load external data into Caboodle?

Answer 18

Yes(pg 39/2.23)

Question 19

What is the difference between the reporting capabilities of Chronicles vs. Clarity and Caboodle?

Answer 19

Chronicles captures real‐time data. Clarity and Caboodle allow you to efficiently query large sets of data.(pg 39/2.23)

Question 20

Why should you use Caboodle or Clarity for large scale reporting needs?

Answer 20

SQL reports can be run over very large data sets without slowing down your production server. They also can include complex grouping and mathematics, and can be used to do integrated reporting on Epic and non‐Epic data.(pg 39/2.23)

Question 21

Why don’t Caboodle or Clarity contain real‐time information?

Answer 21

Caboodle and Clarity data needs to be brought across by an ETL process, and is not real‐time.(pg 39/2.23)

Question 22

You have a reporting need, and there is no pre‐built application report to meet it. Do you need to use a report built off of Caboodle or Clarity data to meet this need?

Answer 22

Not necessarily. Reporting Workbench can be used for many non‐standard reporting needs(pg 39/2.23)

Question 23

Definition:Production server.

Answer 23

The Epic system is a client-server architecture. This is the main production server. This machine’s resources provide the computing environment for the application processes and databaseBusiness Continuity Technical Solutions Guide page 51)