CLR110 Review Questions With Appropriate
Solutions
True or False: Multiple Clarity tables might extract data from a
single record in Chronicles Correct Answer - True
How often are incremental tables typically extracted to Clarity.
Correct Answer - 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] Correct Answer - 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? Correct Answer - 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?
Correct Answer - 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? Correct Answer - 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? Correct Answer - People
requesting reports may only tell you where data goes in Hyperspace,
without knowing where the data is stored in Clarity.
,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. Correct Answer
- 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.
Correct Answer - 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? Correct Answer - 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
Correct Answer - Whether a column is deprecated.
The version when the table was created.
Which of the following statements accurately describes Contact Date
Real? Correct Answer - 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:
Correct Answer - Have a data type of datetime.
What value will be extracted to Clarity for Chronicles items that are
not filled out (blanks)? Correct Answer - NULL
What is a Category List? Correct Answer - 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? Correct
Answer - 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? Correct Answer - 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? Correct Answer - 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 Correct Answer - Record Viewer
If you find a table in Clarity Compass will it necessarily be in your
Clarity database? Correct Answer - 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? Correct Answer - 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
What do you notice about the column that extracts EPT 30? How
should this data be displayed to a report customer? Correct
Answer - 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 Correct Answer -
PAT_ENC_CSN_ID
What column in Clarity extracts the patient name? Correct Answer
- PATIENT.PAT_NAME
What column in Clarity extracts the patient sex EPT130? Correct
Answer - 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? Correct Answer -
PAT_ID
What Chronicles INI and item does it extract? Correct Answer -
1 EPT .1
Solutions
True or False: Multiple Clarity tables might extract data from a
single record in Chronicles Correct Answer - True
How often are incremental tables typically extracted to Clarity.
Correct Answer - 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] Correct Answer - 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? Correct Answer - 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?
Correct Answer - 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? Correct Answer - 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? Correct Answer - People
requesting reports may only tell you where data goes in Hyperspace,
without knowing where the data is stored in Clarity.
,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. Correct Answer
- 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.
Correct Answer - 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? Correct Answer - 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
Correct Answer - Whether a column is deprecated.
The version when the table was created.
Which of the following statements accurately describes Contact Date
Real? Correct Answer - 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:
Correct Answer - Have a data type of datetime.
What value will be extracted to Clarity for Chronicles items that are
not filled out (blanks)? Correct Answer - NULL
What is a Category List? Correct Answer - 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? Correct
Answer - 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? Correct Answer - 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? Correct Answer - 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 Correct Answer - Record Viewer
If you find a table in Clarity Compass will it necessarily be in your
Clarity database? Correct Answer - 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? Correct Answer - 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
What do you notice about the column that extracts EPT 30? How
should this data be displayed to a report customer? Correct
Answer - 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 Correct Answer -
PAT_ENC_CSN_ID
What column in Clarity extracts the patient name? Correct Answer
- PATIENT.PAT_NAME
What column in Clarity extracts the patient sex EPT130? Correct
Answer - 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? Correct Answer -
PAT_ID
What Chronicles INI and item does it extract? Correct Answer -
1 EPT .1
