Epic Crystal Reporting/Clarity/SQL
CERTIFICATION TEST STUDY GUIDE 2025/2026
QUESTIONS BANK AND VERIFIED CORRECT SOLUTIONS
WITH RATIONALES || 100% GUARANTEED PASS
<RECENT VERSION>
1. What is a relational database? - ANSWER ✓ A relational database contains
related tables, and these tables can be linked together based on the
relationship between the fields in two or more tables
2. Each table in a relational database contains _______ _______ and contains a
_______ of intersecting rows and columns of data - ANSWER ✓ one
concept; series
3. SAP BusinessObject has created _______________ to report with relational
databases. - ANSWER ✓ Crystal
4. ___________ is a relational database used to store and report on your
organization's Epic data. - ANSWER ✓ Clarity
5. We use _________ to report off of _________ - ANSWER ✓ Crystal;
Clarity
6. What is another name for a row? - ANSWER ✓ Record
7. What is Clarity's primary purpose? - ANSWER ✓ To store an organization's
Epic data purely for reporting purposes
8. Does EPIC offer its own tools for creating reports off of Clarity? -
ANSWER ✓ No. That's why we use Crystal Reports
9. A department in CLARITY_DEP is represented as one ____________. -
ANSWER ✓ Row
,10.True/False: In the PATIENT table, different pieces of information pertaining
to one patient are stored in different columns - ANSWER ✓ True
11.Describe a "row" and a synonym for it - ANSWER ✓ A row contains a
complete unit of related information, and they are often called "records"
12.Describe a database - ANSWER ✓ A container of data that provides
information for a report and can also be called data sources
13.What are the three different methods for creating a new report within Crystal
Reporting? - ANSWER ✓ 1. Report Wizard
2. Blank Report Option
3. Base a report off of a pre-exsiting report (My Recent Reports)
14.What is the first step when creating a new report? - ANSWER ✓ To specify
the data source
15.We access the Clarity Database through an ______ layer - ANSWER ✓
ODBC
16.What does ODBC stand for? - ANSWER ✓ Open Database Connectivity
17.What is an ODBC? - ANSWER ✓ An interface that allows Crystal the
ability to retrieve data in database management systems
18.Do views hold data? - ANSWER ✓ No. Views are created simply to
simplify reporting on certain types of information. They don't hold data, but
run queries against other Clarity tables and present the results in a form that
can be used as a table
19.In Crystal Reports, the term "field" is used to refer to what? - ANSWER ✓
Refers to anything you can drag onto your report. This includes database
columns, formulas, text, as well as special functions
20.What area will you spend most of your time in when creating a Crystal
Report? - ANSWER ✓ The Design Tab
,21.This section only shows up on the top of the first page of a report -
ANSWER ✓ Report Header (RH)
22.This section with show up on the top of every single page - ANSWER ✓
Page Header (PH)
23.What are the three databases where Epic data is stored? - ANSWER ✓
Chronicles, Clarity, and Caboodle.
24.What does data lineage refer to in the context of Epic data? - ANSWER ✓
The origin of a piece of data and how and when it has moved or changed
since being created.
25.Which database do Epic users primarily enter data into? - ANSWER ✓
Chronicles.
26.What process transfers data from Chronicles to Clarity? - ANSWER ✓
Clarity ETL (Extract, Transform, and Load) transfers data every night.
27.What does Caboodle ETL do? - ANSWER ✓ Transfers data from Clarity to
Caboodle on the same night as Clarity ETL.
28.What programming language does Chronicles run on? - ANSWER ✓ M, a
language designed for managing non-relational databases.
29.How does Chronicles structure data for healthcare operations? - ANSWER
✓ It uses a tree-like structure to efficiently retrieve data.
30.Two Main components of patient data - ANSWER ✓ 1. Patient
Demographics
2. Clinical Encounters
31.What is the difference between patient demographics stored in
HSP_Account table and Patient table - ANSWER ✓ HSP_Account
demographics are current at the time of discharge.
Patient table demographics are the most up to date, even after discharge.
, 32.What does each row in the Pat_Enc_HSP table represent? - ANSWER ✓ A
hospital encounter
33.Guarantor - ANSWER ✓ Individual who is responsible for paying the
balance not paid by the insurer. All hospital accounts have exactly one
guarantor
34.Guarantor owed balance - ANSWER ✓ Sum the HB_SelfPay_Balance and
Patient_Balance columns from the ACCOUNT table.
35.Life cycle of a hospital account - ANSWER ✓ Created as soon or before a
patient arrives for an encounter and stays active until every charge on the
account has been paid, written off or otherwise accounted for
36.Open account - ANSWER ✓ Patient is in house. Charges will accumulate,
but won't be sent anywhere.
37.DNB - Coding status - ANSWER ✓ After discharge, account changes to
DNB for a few days to give the hospital time to verify charges and complete
coding.
38.Billed - Send Claims/Statements - ANSWER ✓ After claim hold is
complete, the status is changed to billed and payments begin to try to be
collected.
39.Closed - all follow-ups complete - ANSWER ✓ Specific number of days
after account reaches a zero balance
40.Account Class - ANSWER ✓ Custom category list used to group hospital
accounts by the type of visit they pertain to. Ex. Emergency, Outpatient,
Inpatient, observation, specimen collection.
41.Account base class - ANSWER ✓ Epic-relased list of only three values:
outpatient, inpatient, emergency. All account classes have to map to account
base class, although this field is rarely seen by the users.
CERTIFICATION TEST STUDY GUIDE 2025/2026
QUESTIONS BANK AND VERIFIED CORRECT SOLUTIONS
WITH RATIONALES || 100% GUARANTEED PASS
<RECENT VERSION>
1. What is a relational database? - ANSWER ✓ A relational database contains
related tables, and these tables can be linked together based on the
relationship between the fields in two or more tables
2. Each table in a relational database contains _______ _______ and contains a
_______ of intersecting rows and columns of data - ANSWER ✓ one
concept; series
3. SAP BusinessObject has created _______________ to report with relational
databases. - ANSWER ✓ Crystal
4. ___________ is a relational database used to store and report on your
organization's Epic data. - ANSWER ✓ Clarity
5. We use _________ to report off of _________ - ANSWER ✓ Crystal;
Clarity
6. What is another name for a row? - ANSWER ✓ Record
7. What is Clarity's primary purpose? - ANSWER ✓ To store an organization's
Epic data purely for reporting purposes
8. Does EPIC offer its own tools for creating reports off of Clarity? -
ANSWER ✓ No. That's why we use Crystal Reports
9. A department in CLARITY_DEP is represented as one ____________. -
ANSWER ✓ Row
,10.True/False: In the PATIENT table, different pieces of information pertaining
to one patient are stored in different columns - ANSWER ✓ True
11.Describe a "row" and a synonym for it - ANSWER ✓ A row contains a
complete unit of related information, and they are often called "records"
12.Describe a database - ANSWER ✓ A container of data that provides
information for a report and can also be called data sources
13.What are the three different methods for creating a new report within Crystal
Reporting? - ANSWER ✓ 1. Report Wizard
2. Blank Report Option
3. Base a report off of a pre-exsiting report (My Recent Reports)
14.What is the first step when creating a new report? - ANSWER ✓ To specify
the data source
15.We access the Clarity Database through an ______ layer - ANSWER ✓
ODBC
16.What does ODBC stand for? - ANSWER ✓ Open Database Connectivity
17.What is an ODBC? - ANSWER ✓ An interface that allows Crystal the
ability to retrieve data in database management systems
18.Do views hold data? - ANSWER ✓ No. Views are created simply to
simplify reporting on certain types of information. They don't hold data, but
run queries against other Clarity tables and present the results in a form that
can be used as a table
19.In Crystal Reports, the term "field" is used to refer to what? - ANSWER ✓
Refers to anything you can drag onto your report. This includes database
columns, formulas, text, as well as special functions
20.What area will you spend most of your time in when creating a Crystal
Report? - ANSWER ✓ The Design Tab
,21.This section only shows up on the top of the first page of a report -
ANSWER ✓ Report Header (RH)
22.This section with show up on the top of every single page - ANSWER ✓
Page Header (PH)
23.What are the three databases where Epic data is stored? - ANSWER ✓
Chronicles, Clarity, and Caboodle.
24.What does data lineage refer to in the context of Epic data? - ANSWER ✓
The origin of a piece of data and how and when it has moved or changed
since being created.
25.Which database do Epic users primarily enter data into? - ANSWER ✓
Chronicles.
26.What process transfers data from Chronicles to Clarity? - ANSWER ✓
Clarity ETL (Extract, Transform, and Load) transfers data every night.
27.What does Caboodle ETL do? - ANSWER ✓ Transfers data from Clarity to
Caboodle on the same night as Clarity ETL.
28.What programming language does Chronicles run on? - ANSWER ✓ M, a
language designed for managing non-relational databases.
29.How does Chronicles structure data for healthcare operations? - ANSWER
✓ It uses a tree-like structure to efficiently retrieve data.
30.Two Main components of patient data - ANSWER ✓ 1. Patient
Demographics
2. Clinical Encounters
31.What is the difference between patient demographics stored in
HSP_Account table and Patient table - ANSWER ✓ HSP_Account
demographics are current at the time of discharge.
Patient table demographics are the most up to date, even after discharge.
, 32.What does each row in the Pat_Enc_HSP table represent? - ANSWER ✓ A
hospital encounter
33.Guarantor - ANSWER ✓ Individual who is responsible for paying the
balance not paid by the insurer. All hospital accounts have exactly one
guarantor
34.Guarantor owed balance - ANSWER ✓ Sum the HB_SelfPay_Balance and
Patient_Balance columns from the ACCOUNT table.
35.Life cycle of a hospital account - ANSWER ✓ Created as soon or before a
patient arrives for an encounter and stays active until every charge on the
account has been paid, written off or otherwise accounted for
36.Open account - ANSWER ✓ Patient is in house. Charges will accumulate,
but won't be sent anywhere.
37.DNB - Coding status - ANSWER ✓ After discharge, account changes to
DNB for a few days to give the hospital time to verify charges and complete
coding.
38.Billed - Send Claims/Statements - ANSWER ✓ After claim hold is
complete, the status is changed to billed and payments begin to try to be
collected.
39.Closed - all follow-ups complete - ANSWER ✓ Specific number of days
after account reaches a zero balance
40.Account Class - ANSWER ✓ Custom category list used to group hospital
accounts by the type of visit they pertain to. Ex. Emergency, Outpatient,
Inpatient, observation, specimen collection.
41.Account base class - ANSWER ✓ Epic-relased list of only three values:
outpatient, inpatient, emergency. All account classes have to map to account
base class, although this field is rarely seen by the users.
