CLR110 EXAM QUESTIONS AND
ANSWERS 100% CORRECT
True or False: Multiple Clarity tables might extract data from a single record in
Chronicles. - ANSWER-True
For example, one patient (EPT) record in Chronicles can have data extracted to
PATIENT, PAT_ENC, HSP_ATND_PROV, and OTHER_COMMUNCTN.
How often are incremental tables typically extracted to Clarity? - ANSWER-Daily
Incremental tables are typically extracted to Clarity every night during the ETL process.
You open a patient encounter in the Record Viewer and find item EPT 10115. What will
be stored for this patient encounter in the Clarity column that extracts this item?
10115-ADT: PATIENT STATUS Discharged [3] - ANSWER-3
When looking at the record viewer, the raw value inside the brackets is typically
extracted to Clarity.
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?
a) Column Search
b) Database Object Search
c) Item Editor
d) Record Viewer
e) Category List Maintenance - ANSWER-a
When you know the INI and the item number, the best tool to use to find a Clarity table
and column will be the Column 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?
- ANSWER-NOTE_ID and LINE
True or False: Compared to views, derived tables generally take less time to run
because the data has been stored on the database. - ANSWER-True
Since views are saved queries, their use can affect performance.
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. - ANSWER-False
Epic SQL functions are not required. You may use Oracle or Microsoft SQL Server
functions.
You find an unfamiliar table CLARITY_ROM in a colleague's report. Which tool could
you use to find out more about this table?
ANSWERS 100% CORRECT
True or False: Multiple Clarity tables might extract data from a single record in
Chronicles. - ANSWER-True
For example, one patient (EPT) record in Chronicles can have data extracted to
PATIENT, PAT_ENC, HSP_ATND_PROV, and OTHER_COMMUNCTN.
How often are incremental tables typically extracted to Clarity? - ANSWER-Daily
Incremental tables are typically extracted to Clarity every night during the ETL process.
You open a patient encounter in the Record Viewer and find item EPT 10115. What will
be stored for this patient encounter in the Clarity column that extracts this item?
10115-ADT: PATIENT STATUS Discharged [3] - ANSWER-3
When looking at the record viewer, the raw value inside the brackets is typically
extracted to Clarity.
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?
a) Column Search
b) Database Object Search
c) Item Editor
d) Record Viewer
e) Category List Maintenance - ANSWER-a
When you know the INI and the item number, the best tool to use to find a Clarity table
and column will be the Column 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?
- ANSWER-NOTE_ID and LINE
True or False: Compared to views, derived tables generally take less time to run
because the data has been stored on the database. - ANSWER-True
Since views are saved queries, their use can affect performance.
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. - ANSWER-False
Epic SQL functions are not required. You may use Oracle or Microsoft SQL Server
functions.
You find an unfamiliar table CLARITY_ROM in a colleague's report. Which tool could
you use to find out more about this table?
