Clarity Test Flashcards
A Chronicles item can store one or more options from a limited list. Which of the following could
account for this behavior? ﴾Choose all that apply﴿
A. Single Response
B. Multiple Response
C. Networked
D. Overtime
E. No‐Add
F. Category
B, C and F. If a Chronicles item can store one or more options it is a multiple response item. If
the options come from a limited list, that item may be a category item, where the category list is the
list of options, or networked, where the records or contacts in the destination master file is the list of
options
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? ﴾Choose all that apply﴿
A. Single Response
B. Multiple Response
C. Networked
D. Overtime
E. No‐Add
F. Category
A and D. If a Chronicles item can store only one value it is a single response item. If a separate
value is stored on each contact the add type is Overtime
A lab manager tells you he wants a report on lab specimens, and shows you the field where he can
input various information. What method would you use to find the INI + Item numbers of the data
he’s looking for?
Ctrl + Click
A clinical administrator requests a query to include data for a patient’s registries. She’s not sure of the INI and Item number, but she knows patient is on the Lung Cancer Screening registry. What tool would you use to find the INI and item number given this information?
Record Viewer
In Clarity, which of the following columns COULD contain a NULL value?
A. A foreign key column that would store the patient’s primary care provider
B. A date column that would store the discharge date for an encounter
C. A string column that stores a patient’s email address
D. A numeric column that stores the patient’s age in years
E. A column that is the primary key of a table
All but E. In Clarity the only column that CANNOT be NULL is a column in the primary key of a
table
True or False: The Clarity Console stores definitions for the database objects that can be extracted to and stored in the Clarity database.
False. The Clarity Compass stores these definitions.
Which tool would you use to find the table and column that extracts EPT 18864: Attending Provider?
Column Search, to enter the Clarity Compass
In which of the following scenarios would it be appropriate, and even necessary, to reach out to your Clarity ETL administrator?
A. You need to use CLARITY_DEP_CUST_FIELDS in a report. You found the table in the Clarity Compass, but cannot query the table on your database.
B. 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 administrator can enable this for you
If an item’s add type is no add and response type is single, what element will be present in the primary key of the table that extracts the item?
A. Record ID
B. A Contact Identifier such as CSN
C. Line
A. If an item’s add type is no add and response type is single then the primary key of the table will include the Record ID
What value is stored in a networked item?
The .1 of a Chronicles record or the CSN of a contact on a Chronicles record
You have a patient query and would like to display the name of the patients’ providers. Item EPT18867: Admitting Provider is a networked item that points to the SER master file. How can you use Column Search help display the name of the admitting provider?
Use Column Search on I EPT 18867 to find the foreign key column in the starting table. You can also use Column Search on I SER .2 to find the table that stores provider names. Use the foreign key of the starting table to join to the primary key of the destination table
True or False: Would it be possible to have more than one copy of the same table in one report? Why or why not?
True; Because Chronicles master files can reference each other multiple times, there are multiple ways to link Clarity tables together
If an item’s response type is multiple, what element will be present in the primary key of the table that extracts the item?
Line
Why is it good practice to conduct research in Chronicles?
Report requesters may only be able to provide a workflow or a field in Hyperspace. In Chronicles you can open the Record Viewer and validate the data in the source and explore links between the data points. The most reliable way to find the Clarity column that reflects the data point is to use the information stored in the Clarity Compass. Understanding how the data is structured in Chronicles will allow you to better understand the structure of Clarity.
Which part of the join does the Chronicles networked item map to?
The foreign key of the source table.
