ACING CLR 110 EXAMS WITH THE LATEST A+ QUESTIONS
AND ANSWERS GUIDE BOOK.
True or False: Multiple Clarity tables might extract data from a single record in
Chronicles
True
How often are incremental tables typically extracted to Clarity.
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]
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?
Item Editor
You find an unfamiliar table called CLARITY_ROM in a colleague’s report. Which
tool could you use to find out more about this table?
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?
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?
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.
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.
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?
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 table will also exist for
EPIC SQL Functions and views.
Which of the following can be found in the Clarity compass?
Whether a column is deprecated.
The version when the table was created.
Which of the following statements accurately describes Contact Date Real?
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:
Have a data type of date time?
What value will be extracted to Clarity for Chronicles items that are not filled out
(blanks)?
NULL
What is a Category List?
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?
AND ANSWERS GUIDE BOOK.
True or False: Multiple Clarity tables might extract data from a single record in
Chronicles
True
How often are incremental tables typically extracted to Clarity.
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]
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?
Item Editor
You find an unfamiliar table called CLARITY_ROM in a colleague’s report. Which
tool could you use to find out more about this table?
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?
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?
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.
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.
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?
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 table will also exist for
EPIC SQL Functions and views.
Which of the following can be found in the Clarity compass?
Whether a column is deprecated.
The version when the table was created.
Which of the following statements accurately describes Contact Date Real?
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:
Have a data type of date time?
What value will be extracted to Clarity for Chronicles items that are not filled out
(blanks)?
NULL
What is a Category List?
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?
