Investigating Chronicles

Question 1

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?

Answer 1

Ctrl + Click

Question 2

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?

Answer 2

Record Viewer

Question 3

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

Answer 3

All but E

Question 4

What information is available on the item information window?

Answer 4

INI and item number, add type, response type and networked INI

Question 5

I IDM 130 is a networked item that is not filled in for this record. What value will be
extracted to Clarity for this item, and other Chronicles items that are not filled out?

Answer 5

Null

Question 6

What value will be extracted to Caboodle for this item, I IDM 130 is a networked item that is not filled in for this record and other networked items that are not filled out in Chronicles?

Answer 6

If the column is a key column, Caboodle will have a ‐1 letting report writers know that this
value was not populated in the source, while still enforcing referential integrity

Question 7

Why do Null values exist?

Answer 7

Not all fields are populated in Chronicles
ETL data cleansing deletes incorrectly formatted data
A column may no longer extract data because it is deprecated

Question 8

What is a category list?

Answer 8

A category list is a list of defined values that can be stored in a Chronicles item.

Question 9

1. 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

Answer 9

B. Multiple Response

C. Networked

Question 9

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

Answer 9

B. Multiple Response
C. Networked
F. Category

Question 10

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? (multi choice)
A. Single Response
B. Multiple Response
C. Networked
D. Overtime
E. No‐Add
F. Category

Answer 10

A. Single Response

D. Overtime

Question 11

T/F Multiple clarity tables might extract data from a single record in chronicles.

Answer 11

true

Question 12

How often are incremental tables typically extracted to clarity?

Answer 12

Daily

Question 13

You open a patient encounter in Record viewer and find item EPT 10115 as pictured. What will be stored for this patient encounter in the clarity column that extract this item?

10115 - ADT: PATIENT STATUS Contact 2 1 3-Discharged

Answer 13

3