CLR110
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
Is there a column in PAT_ENC that extracts the same Chronicles item? -
CORRECT ANSWER-PAT_ENC.PAT_ID
True or False: The Clarity Console stores definitions for the database objects that
can be extracted to and stored in the Clarity database. - CORRECT
ANSWER-FALSE The Clarity Compass stores these definitions.
Which tool would you use to find the table and column that extracts EPT 18864
Attending Provider? - CORRECT ANSWER-Column search to enter the Clarity
Compass
What happens when a column is marked Deprecated? - CORRECT
ANSWER-No more data will be extracted into that column
In which of the following scenarios would it be appropriate and even necessary to
reach out to your Clarity ETL Administrator? - CORRECT ANSWER-You need to
use CLARITY_DEP_CUST_FIELDS in a report. You found a table in Clarity
Compass but cannot query the table on your database.
You found a view that looks useful in your reports.
You query the view, get data returned but you want to know how this view fits in
with your reports.
A CLARITY_DEP_CUST_FIELDS likely has not been extracted to the Clarity
database. Your ETL can enable this for you.
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
Is there a column in PAT_ENC that extracts the same Chronicles item? -
CORRECT ANSWER-PAT_ENC.PAT_ID
True or False: The Clarity Console stores definitions for the database objects that
can be extracted to and stored in the Clarity database. - CORRECT
ANSWER-FALSE The Clarity Compass stores these definitions.
Which tool would you use to find the table and column that extracts EPT 18864
Attending Provider? - CORRECT ANSWER-Column search to enter the Clarity
Compass
What happens when a column is marked Deprecated? - CORRECT
ANSWER-No more data will be extracted into that column
In which of the following scenarios would it be appropriate and even necessary to
reach out to your Clarity ETL Administrator? - CORRECT ANSWER-You need to
use CLARITY_DEP_CUST_FIELDS in a report. You found a table in Clarity
Compass but cannot query the table on your database.
You found a view that looks useful in your reports.
You query the view, get data returned but you want to know how this view fits in
with your reports.
A CLARITY_DEP_CUST_FIELDS likely has not been extracted to the Clarity
database. Your ETL can enable this for you.
