Mapping Chronicles Relationships in Clarity

Question 1

What Chronicles item characteristics allow multiple values to be stored for a single record?

Answer 1

Add type and response type

Question 2

What is the add type and Response Type of Patient ID EPT .1?

Answer 2

No-Add, Single

Question 3

What is the add type and Response Type of Patient ID EPT .2?

Answer 3

No-add Single

Question 4

What is the add type and Response Type of Patient Registries EPT 23400

Answer 4

No-Add Multiple

Question 5

What is the add type and Response Type of Patient Class EPT 10110

Answer 5

Overtime Single

Question 6

What is the add type and Response Type of Hospital Admission Date EPT 18850?

Answer 6

Overtime Single

Question 7

What is the add type and Response Type of Attending Providers EPT 18864?

Answer 7

Overtime Multiple

Question 8

All data in a single extracted table in Clarity typically come from the same Chronicles \_\_\_\_\_\_\_\_\_\_\_\_
A. Add Type
B. Response Type
C. Master File
D. Separate

Answer 8

C. Master file

Question 9

Define the cardinality of a relationship

Answer 9

It describes the numerical relationship between entities in two tables

Question 10

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

Answer 10

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

Question 11

What value is stored in a networked item?

a. The .2 of a Chronicles record the name
b. The .1 of a Chronicles record or the CSN of a contact on a Chronicles record
c. the address of the pointer for the value

Answer 11

b. The .1 of a Chronicles record or the CSN of a contact on a Chronicles record

Question 12

You have a patient query and would like to display the name of the patients’ providers : 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?

Answer 12

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

Question 13

T or F Would it be possible to have more than one copy of the same table in one report?
Why or why not?

Answer 13

True; Because Chronicles master files can reference each other multiple times, there are multiple
ways to link Clarity tables together

Question 14

If an item's response type is multiple, what element will be present in the primary key of the table
that extracts the item?
A. Record ID
B. CSN
C LINE
D CDR

Answer 14

C . Line

Question 15

Why is it good practice to conduct research in Chronicles?

Answer 15

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