CLR110 Exam Set 2 Questions and Answers with 100%
Correct Answers
Question 1.
True or False: Multiple Clarity tables might ex- tract data from a single record in
Chronicles
Correct Answer: True
Question 2.
How often are incremen- tal tables typically ex- tracted to Clarity.
Correct Answer: Daily
Question 3.
You open a patient en- counter 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. Dis- charged [3]
Correct Answer: 3
Question 4.
You want to include item SER 39: Primary Depart- ment 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
Question 5.
You find an unfamil- iar table called CLARI- TY_ROM in a colleagues report. Which tool
could you use to find out more about this table?
Correct Answer: Database Object Search
Question 6.
Item HNO 1024: Notes Linked to Document has an Add type of No-Add and a Response
type of Multiple. What is the pri- mary key of the table this item is extracted to?
Correct Answer: NOTE_ID and LINE
Question 7.
After receiving a re- port request you con- sult Clarity resources such as Clarity Com-
pass and Clarity Dic- tionary without consult- ing 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
Hyper- space, 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.
,Question 8.
Compared to views, de- rived tables generally take less time to run be- cause the data has
been stored on the database.
Correct Answer: True
Question 9.
True or False Epic SQL Functions must be used in place of Oracle or Mi- crosoft SQL
server func- tions 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.
Question 10.
Which of the following is the best way to de- termine whether a given database object is a
de- rived 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.
Question 11.
Which of the following can be found in the Clar- ity compass
Correct Answer: Whether a column is deprecated. The version when the table was
created.
Question 12.
Which of the follow- ing statements accu- rately 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.
Question 13.
Consider the Raw data field and the item char- acteristics of EPT 110 in Ctrl Click. Based
on the information shown when this data is extract- ed to a column in Clari- ty that column
will most likely:
Correct Answer: Have a data type of datetime.
Question 14.
What value will be ex- tracted to Clarity for Chronicles items that are not filled out
(blanks)?
Correct Answer: NULL
Question 15.
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.
,Question 16.
A Chronicles item can store one or more op- tions form a limited list. Which of the
following could account for this behavior?
Correct Answer: Multiple Response, Networked and Category
Question 17.
A Chronicles item stores a single value, but can store a separate value for each contact
on a record. Which of the fol- lowing could account for this behavior?
Correct Answer: Single Response, Overtime
Question 18.
A lab manager tells you he wants a report on lab specimins and shows you the field where
he can input various infor- mation. What method would you use to find the INI and item
num- bers of the data hes looking for?
Correct Answer: CTRL & Click
Question 19.
A clinical administrator requests a query to in- clude data for a patients registries. Shes
not sure of the INI and item num- ber but she knows the patient is on the Lung Cancer
Screening reg- istry. What tool would you use to find the INI and item number given this
information
Correct Answer: Record Viewer
Question 20.
If you find a table in Clar- ity Compass will it neces- sarily 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.
Question 21.
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
Question 22.
What do you notice about the column that extracts EPT 30? How should this data be dis-
played to a report cus- tomer?
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
, Question 23.
What is the primary key of PAT_ENC
Correct Answer: PAT_ENC_CSN_ID
Question 24.
What column in Clari- ty extracts the patient name?
Correct Answer: PATIENT.PAT_NAME
Question 25.
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
Question 26.
What is the primary key of the PATIENT table?
Correct Answer: PAT_ID
Question 27.
What Chronicles INI and item does it extract?
Correct Answer: 1 EPT .1
Question 28.
Is there a column in PAT_ENC that extracts the same Chronicles item?
Correct Answer: PAT_ENC.PAT_ID
Question 29.
True or False: The Clar- ity Console stores defi- nitions for the database objects that can
be ex- tracted to and stored in the Clarity database.
Correct Answer: FALSE The Clarity Compass stores these definitions.
Question 30.
Which tool would you use to find the table and column that ex- tracts EPT 18864 Attend-
ing Provider?
Correct Answer: Column search to enter the Clarity Compass
Question 31.
What happens when a column is marked Dep- recated?
Correct Answer: No more data will be extracted into that column
Correct Answers
Question 1.
True or False: Multiple Clarity tables might ex- tract data from a single record in
Chronicles
Correct Answer: True
Question 2.
How often are incremen- tal tables typically ex- tracted to Clarity.
Correct Answer: Daily
Question 3.
You open a patient en- counter 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. Dis- charged [3]
Correct Answer: 3
Question 4.
You want to include item SER 39: Primary Depart- ment 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
Question 5.
You find an unfamil- iar table called CLARI- TY_ROM in a colleagues report. Which tool
could you use to find out more about this table?
Correct Answer: Database Object Search
Question 6.
Item HNO 1024: Notes Linked to Document has an Add type of No-Add and a Response
type of Multiple. What is the pri- mary key of the table this item is extracted to?
Correct Answer: NOTE_ID and LINE
Question 7.
After receiving a re- port request you con- sult Clarity resources such as Clarity Com-
pass and Clarity Dic- tionary without consult- ing 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
Hyper- space, 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.
,Question 8.
Compared to views, de- rived tables generally take less time to run be- cause the data has
been stored on the database.
Correct Answer: True
Question 9.
True or False Epic SQL Functions must be used in place of Oracle or Mi- crosoft SQL
server func- tions 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.
Question 10.
Which of the following is the best way to de- termine whether a given database object is a
de- rived 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.
Question 11.
Which of the following can be found in the Clar- ity compass
Correct Answer: Whether a column is deprecated. The version when the table was
created.
Question 12.
Which of the follow- ing statements accu- rately 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.
Question 13.
Consider the Raw data field and the item char- acteristics of EPT 110 in Ctrl Click. Based
on the information shown when this data is extract- ed to a column in Clari- ty that column
will most likely:
Correct Answer: Have a data type of datetime.
Question 14.
What value will be ex- tracted to Clarity for Chronicles items that are not filled out
(blanks)?
Correct Answer: NULL
Question 15.
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.
,Question 16.
A Chronicles item can store one or more op- tions form a limited list. Which of the
following could account for this behavior?
Correct Answer: Multiple Response, Networked and Category
Question 17.
A Chronicles item stores a single value, but can store a separate value for each contact
on a record. Which of the fol- lowing could account for this behavior?
Correct Answer: Single Response, Overtime
Question 18.
A lab manager tells you he wants a report on lab specimins and shows you the field where
he can input various infor- mation. What method would you use to find the INI and item
num- bers of the data hes looking for?
Correct Answer: CTRL & Click
Question 19.
A clinical administrator requests a query to in- clude data for a patients registries. Shes
not sure of the INI and item num- ber but she knows the patient is on the Lung Cancer
Screening reg- istry. What tool would you use to find the INI and item number given this
information
Correct Answer: Record Viewer
Question 20.
If you find a table in Clar- ity Compass will it neces- sarily 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.
Question 21.
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
Question 22.
What do you notice about the column that extracts EPT 30? How should this data be dis-
played to a report cus- tomer?
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
, Question 23.
What is the primary key of PAT_ENC
Correct Answer: PAT_ENC_CSN_ID
Question 24.
What column in Clari- ty extracts the patient name?
Correct Answer: PATIENT.PAT_NAME
Question 25.
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
Question 26.
What is the primary key of the PATIENT table?
Correct Answer: PAT_ID
Question 27.
What Chronicles INI and item does it extract?
Correct Answer: 1 EPT .1
Question 28.
Is there a column in PAT_ENC that extracts the same Chronicles item?
Correct Answer: PAT_ENC.PAT_ID
Question 29.
True or False: The Clar- ity Console stores defi- nitions for the database objects that can
be ex- tracted to and stored in the Clarity database.
Correct Answer: FALSE The Clarity Compass stores these definitions.
Question 30.
Which tool would you use to find the table and column that ex- tracts EPT 18864 Attend-
ing Provider?
Correct Answer: Column search to enter the Clarity Compass
Question 31.
What happens when a column is marked Dep- recated?
Correct Answer: No more data will be extracted into that column
