CLR110 EXAM 2025 QUESTIONS AND
ANSWERS
True or False: Multiple Clarity tables might extract data from a single record in Chronicles -
ANS True
How often are incremental tables typically extracted to Clarity. - ANS Daily
You open a patient encounter in the Record Viewer and find item EPT 10115 as pictured. What
will be stored for this patient encounter in the Clarity column that extracts this item.
Discharged [3] - ANS 3
You want to include item SER 39: Primary Department in a query. Which is the best tool to use
to find the Clarity table and column that extracts this item? - ANS Item Editor
You find an unfamiliar table called CLARITY_ROM in a colleagues report. Which tool could you
use to find out more about this table? - ANS Database Object Search
Item HNO 1024: Notes Linked to Document has an Add type of No-Add and a Response type of
Multiple. What is the primary key of the table this item is extracted to? - ANS NOTE_ID and
LINE
After receiving a report request you consult Clarity resources such as Clarity Compass and
Clarity Dictionary without consulting Chronicles resources such as Item Editor and the Record
Viewer. What problems may you run into? - ANS People requesting reports may only tell you
where data goes in Hyperspace, without knowing where the data is stored in Clarity.
1 COPYRIGHT © 2025 SIRJOEL ALL RIGHTS RESERVED
,A join needed in your query may not be a documented foreign key of the Clarity Dictionary.
Custom category list values are not documented in the Clarity Compass or Clarity Dictionary.
You cannot look up properties about the source item.
Compared to views, derived tables generally take less time to run because the data has been
stored on the database. - ANS True
True or False Epic SQL Functions must be used in place of Oracle or Microsoft SQL server
functions in order to return data from Clarity. - ANS False, Epic SQL Functions are not
required. You may use Oracle or Microsoft SQL Server functions.
Which of the following is the best way to determine whether a given database object is a
derived table? - ANS NONE of the above
In the Clarity Compass, look in the summary tab and check the Type field. Derived tables can
begin with the letters other than D_ and the scripts tabe will also exist for EPIC SQL Functions
and views.
Which of the following can be found in the Clarity compass - ANS Whether a column is
deprecated.
The version when the table was created.
Which of the following statements accurately describes Contact Date Real? - ANS Different
records can have contacts with the same Contact Date Real.
It represents the number of days since 12/31/1840 followed by a two digit decimal.
Consider the Raw data field and the item characteristics of EPT 110 in Ctrl Click. Based on the
information shown when this data is extracted to a column in Clarity that column will most
likely: - ANS Have a data type of datetime.
2 COPYRIGHT © 2025 SIRJOEL ALL RIGHTS RESERVED
,What value will be extracted to Clarity for Chronicles items that are not filled out (blanks)? -
ANS NULL
What is a Category List? - ANS Category list is a system (Epic) list, it is uneditable. When using
a filter use the value itself rather than the name.
A Chronicles item can store one or more options form a limited list. Which of the following
could account for this behavior? - ANS Multiple Response, Networked and Category
A Chronicles item stores a single value, but can store a separate value for each contact on a
record. Which of the following could account for this behavior? - ANS Single Response,
Overtime
A lab manager tells you he wants a report on lab specimins and shows you the field where he
can input various information. What method would you use to find the INI and item numbers of
the data hes looking for? - ANS CTRL & Click
A clinical administrator requests a query to include data for a patients registries. Shes not sure
of the INI and item number but she knows the patient is on the Lung Cancer Screening registry.
What tool would you use to find the INI and item number given this information -
ANS Record Viewer
If you find a table in Clarity Compass will it necessarily be in your Clarity database? - ANS Not
always the case. The Clarity Compass will show all of the tables that are possible but at your
organization you might not have every table extracted.
How can you find out if it is? - ANS Query in SQL, look for C records in Clarity Compass check
to see if there are executions listed on the summary form.
Open SQL Management Studio
Write a query to show data from PAT_ENC
Include the primary key, the patient ID and the column that extracts EPT 30
3 COPYRIGHT © 2025 SIRJOEL ALL RIGHTS RESERVED
, What do you notice about the column that extracts EPT 30? How should this data be displayed
to a report customer? - ANS It is a category value, you should display the name to your
report customer.
Modify your query to display the name of the encounter type.
Hint: check the foreign key information sections of PAT_ENC in the Clarity Dictionary
What is the primary key of PAT_ENC - ANS PAT_ENC_CSN_ID
What column in Clarity extracts the patient name? - ANS PATIENT.PAT_NAME
What column in Clarity extracts the patient sex EPT130? - ANS PATIENT.SEX_C, Modify your
query to display the patient name and patient sex. You will need to join your tables to do so
What is the primary key of the PATIENT table? - ANS PAT_ID
What Chronicles INI and item does it extract? - ANS 1 EPT .1
Is there a column in PAT_ENC that extracts the same Chronicles item? -
ANS PAT_ENC.PAT_ID
True or False: The Clarity Console stores definitions for the database objects that can be
extracted to and stored in the Clarity database. - ANS FALSE The Clarity Compass stores
these definitions.
Which tool would you use to find the table and column that extracts EPT 18864 Attending
Provider? - ANS Column search to enter the Clarity Compass
4 COPYRIGHT © 2025 SIRJOEL ALL RIGHTS RESERVED
ANSWERS
True or False: Multiple Clarity tables might extract data from a single record in Chronicles -
ANS True
How often are incremental tables typically extracted to Clarity. - ANS Daily
You open a patient encounter in the Record Viewer and find item EPT 10115 as pictured. What
will be stored for this patient encounter in the Clarity column that extracts this item.
Discharged [3] - ANS 3
You want to include item SER 39: Primary Department in a query. Which is the best tool to use
to find the Clarity table and column that extracts this item? - ANS Item Editor
You find an unfamiliar table called CLARITY_ROM in a colleagues report. Which tool could you
use to find out more about this table? - ANS Database Object Search
Item HNO 1024: Notes Linked to Document has an Add type of No-Add and a Response type of
Multiple. What is the primary key of the table this item is extracted to? - ANS NOTE_ID and
LINE
After receiving a report request you consult Clarity resources such as Clarity Compass and
Clarity Dictionary without consulting Chronicles resources such as Item Editor and the Record
Viewer. What problems may you run into? - ANS People requesting reports may only tell you
where data goes in Hyperspace, without knowing where the data is stored in Clarity.
1 COPYRIGHT © 2025 SIRJOEL ALL RIGHTS RESERVED
,A join needed in your query may not be a documented foreign key of the Clarity Dictionary.
Custom category list values are not documented in the Clarity Compass or Clarity Dictionary.
You cannot look up properties about the source item.
Compared to views, derived tables generally take less time to run because the data has been
stored on the database. - ANS True
True or False Epic SQL Functions must be used in place of Oracle or Microsoft SQL server
functions in order to return data from Clarity. - ANS False, Epic SQL Functions are not
required. You may use Oracle or Microsoft SQL Server functions.
Which of the following is the best way to determine whether a given database object is a
derived table? - ANS NONE of the above
In the Clarity Compass, look in the summary tab and check the Type field. Derived tables can
begin with the letters other than D_ and the scripts tabe will also exist for EPIC SQL Functions
and views.
Which of the following can be found in the Clarity compass - ANS Whether a column is
deprecated.
The version when the table was created.
Which of the following statements accurately describes Contact Date Real? - ANS Different
records can have contacts with the same Contact Date Real.
It represents the number of days since 12/31/1840 followed by a two digit decimal.
Consider the Raw data field and the item characteristics of EPT 110 in Ctrl Click. Based on the
information shown when this data is extracted to a column in Clarity that column will most
likely: - ANS Have a data type of datetime.
2 COPYRIGHT © 2025 SIRJOEL ALL RIGHTS RESERVED
,What value will be extracted to Clarity for Chronicles items that are not filled out (blanks)? -
ANS NULL
What is a Category List? - ANS Category list is a system (Epic) list, it is uneditable. When using
a filter use the value itself rather than the name.
A Chronicles item can store one or more options form a limited list. Which of the following
could account for this behavior? - ANS Multiple Response, Networked and Category
A Chronicles item stores a single value, but can store a separate value for each contact on a
record. Which of the following could account for this behavior? - ANS Single Response,
Overtime
A lab manager tells you he wants a report on lab specimins and shows you the field where he
can input various information. What method would you use to find the INI and item numbers of
the data hes looking for? - ANS CTRL & Click
A clinical administrator requests a query to include data for a patients registries. Shes not sure
of the INI and item number but she knows the patient is on the Lung Cancer Screening registry.
What tool would you use to find the INI and item number given this information -
ANS Record Viewer
If you find a table in Clarity Compass will it necessarily be in your Clarity database? - ANS Not
always the case. The Clarity Compass will show all of the tables that are possible but at your
organization you might not have every table extracted.
How can you find out if it is? - ANS Query in SQL, look for C records in Clarity Compass check
to see if there are executions listed on the summary form.
Open SQL Management Studio
Write a query to show data from PAT_ENC
Include the primary key, the patient ID and the column that extracts EPT 30
3 COPYRIGHT © 2025 SIRJOEL ALL RIGHTS RESERVED
, What do you notice about the column that extracts EPT 30? How should this data be displayed
to a report customer? - ANS It is a category value, you should display the name to your
report customer.
Modify your query to display the name of the encounter type.
Hint: check the foreign key information sections of PAT_ENC in the Clarity Dictionary
What is the primary key of PAT_ENC - ANS PAT_ENC_CSN_ID
What column in Clarity extracts the patient name? - ANS PATIENT.PAT_NAME
What column in Clarity extracts the patient sex EPT130? - ANS PATIENT.SEX_C, Modify your
query to display the patient name and patient sex. You will need to join your tables to do so
What is the primary key of the PATIENT table? - ANS PAT_ID
What Chronicles INI and item does it extract? - ANS 1 EPT .1
Is there a column in PAT_ENC that extracts the same Chronicles item? -
ANS PAT_ENC.PAT_ID
True or False: The Clarity Console stores definitions for the database objects that can be
extracted to and stored in the Clarity database. - ANS FALSE The Clarity Compass stores
these definitions.
Which tool would you use to find the table and column that extracts EPT 18864 Attending
Provider? - ANS Column search to enter the Clarity Compass
4 COPYRIGHT © 2025 SIRJOEL ALL RIGHTS RESERVED
