CLR110 UPDATED ACTUAL Questions and CORRECT Answers
True or False: Multiple Clarity tables might True
extract data from a single record in
Chronicles
How often are incremental tables typically Daily
extracted to Clarity.
You open a patient encounter in the 3
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]
You want to include item SER 39: Primary Item Editor
Department in a query. Which is the best
tool to use to find the Clarity table and
column that extracts this item?
You find an unfamiliar table called Database Object Search
CLARITY_ROM in a colleagues report.
Which tool could you use to find out more
about this table?
Item HNO 1024: Notes Linked to Document NOTE_ID and LINE
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?
, People requesting reports may only tell you where data goes in Hyperspace,
After receiving a report request you
without knowing where the data is stored in Clarity.
consult Clarity resources such as Clarity
A join needed in your query may not be a documented foreign key of the Clarity
Compass and Clarity Dictionary without
Dictionary.
consulting Chronicles resources such as
Custom category list values are not documented in the Clarity Compass or Clarity
Item Editor and the Record Viewer. What
Dictionary.
problems may you run into?
You cannot look up properties about the source item.
Compared to views, derived tables True
generally take less time to run because the
data has been stored on the database.
True or False Epic SQL Functions must be False, Epic SQL Functions are not required. You may use Oracle or Microsoft SQL
used in place of Oracle or Microsoft SQL Server functions.
server functions in order to return data
from Clarity.
NONE of the above
Which of the following is the best way to
In the Clarity Compass, look in the summary tab and check the Type field. Derived
determine whether a given database object
tables can begin with the letters other than D_ and the scripts tabe will also exist for
is a derived table?
EPIC SQL Functions and views.
Which of the following can be found in the Whether a column is deprecated.
Clarity compass The version when the table was created.
Which of the following statements Different records can have contacts with the same Contact Date Real.
accurately describes 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 Have a data type of datetime.
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:
What value will be extracted to Clarity for NULL
Chronicles items that are not filled out
(blanks)?
Category list is a system (Epic) list, it is uneditable. When using a filter use the value
What is a Category List?
itself rather than the name.
A Chronicles item can store one or more Multiple Response, Networked and Category
options form a limited list. Which of the
following could account for this behavior?
A Chronicles item stores a single value, but Single Response, Overtime
can store a separate value for each contact
on a record. Which of the following could
account for this behavior?
A lab manager tells you he wants a report CTRL & Click
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?
True or False: Multiple Clarity tables might True
extract data from a single record in
Chronicles
How often are incremental tables typically Daily
extracted to Clarity.
You open a patient encounter in the 3
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]
You want to include item SER 39: Primary Item Editor
Department in a query. Which is the best
tool to use to find the Clarity table and
column that extracts this item?
You find an unfamiliar table called Database Object Search
CLARITY_ROM in a colleagues report.
Which tool could you use to find out more
about this table?
Item HNO 1024: Notes Linked to Document NOTE_ID and LINE
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?
, People requesting reports may only tell you where data goes in Hyperspace,
After receiving a report request you
without knowing where the data is stored in Clarity.
consult Clarity resources such as Clarity
A join needed in your query may not be a documented foreign key of the Clarity
Compass and Clarity Dictionary without
Dictionary.
consulting Chronicles resources such as
Custom category list values are not documented in the Clarity Compass or Clarity
Item Editor and the Record Viewer. What
Dictionary.
problems may you run into?
You cannot look up properties about the source item.
Compared to views, derived tables True
generally take less time to run because the
data has been stored on the database.
True or False Epic SQL Functions must be False, Epic SQL Functions are not required. You may use Oracle or Microsoft SQL
used in place of Oracle or Microsoft SQL Server functions.
server functions in order to return data
from Clarity.
NONE of the above
Which of the following is the best way to
In the Clarity Compass, look in the summary tab and check the Type field. Derived
determine whether a given database object
tables can begin with the letters other than D_ and the scripts tabe will also exist for
is a derived table?
EPIC SQL Functions and views.
Which of the following can be found in the Whether a column is deprecated.
Clarity compass The version when the table was created.
Which of the following statements Different records can have contacts with the same Contact Date Real.
accurately describes 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 Have a data type of datetime.
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:
What value will be extracted to Clarity for NULL
Chronicles items that are not filled out
(blanks)?
Category list is a system (Epic) list, it is uneditable. When using a filter use the value
What is a Category List?
itself rather than the name.
A Chronicles item can store one or more Multiple Response, Networked and Category
options form a limited list. Which of the
following could account for this behavior?
A Chronicles item stores a single value, but Single Response, Overtime
can store a separate value for each contact
on a record. Which of the following could
account for this behavior?
A lab manager tells you he wants a report CTRL & Click
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?
