CLR110 CLARITY DATA MODEL CERTIFICATION
TEST PAPER 2026 QUESTIONS WITH ANSWERS
GUARANTEED TO PASS
◉ What is the significance of identifying Clarity tables and columns?
Answer: To understand the data structure and how to query effectively.
◉ What is the main focus of the exercise on misleading results? Answer:
To analyze how incorrect joins can lead to inaccurate data
interpretations.
◉ What are the two main principles for constructing tables in the Clarity
database? Answer: Minimize redundant data and maintain consistent
granularity.
◉ What is stored in the EPT master file in Clarity? Answer: Patient data,
where each record represents a patient and each contact represents a
different encounter.
◉ What problem arises when capturing multiple phone numbers in a
single Clarity table? Answer: It requires an upper limit on the number of
phone numbers and complicates storage of other items with many
values.
,◉ How does Clarity minimize data redundancy while maintaining
granularity? Answer: By mapping a single Chronicles master file to
multiple Clarity tables based on item granularity.
◉ What are the two key characteristics of Chronicles items important for
Clarity queries? Answer: Add type and response type.
◉ What does the add type indicate in Chronicles? Answer: It indicates if
data is stored on a record or on a contact in the record.
◉ What are the two categories of add type in Chronicles? Answer:
Single and Multiple.
◉ What does the response type indicate in Chronicles? Answer: It
indicates how many lines of data an item can hold.
◉ What are the two categories of response type in Chronicles? Answer:
No-Add and Overtime.
◉ What does a Single add type hold? Answer: Only one line of data.
◉ What does a No-Add response type signify? Answer: Data is stored
on the record and the value is always current.
, ◉ What does an Overtime response type signify? Answer: Data is stored
on the contact.
◉ What is the internal identifier in Chronicles records? Answer: A
unique record ID stored in the .1 item on the record.
◉ What is the difference between internal and external identifiers in
Chronicles? Answer: Internal identifiers are unique across all records,
while external identifiers may not be unique.
◉ What is an example of an external identifier in patient records?
Answer: Medical Record Number (MRN).
◉ What is the Contact Serial Number (CSN) in Clarity? Answer: A
unique serial number for all contacts within a master file.
◉ What is the Contact Date Real (CDR) in Clarity? Answer: A date in
Epic's internal format, followed by two decimal places that increment
for each additional contact on the same date.
◉ How does a single patient record handle multiple MRNs? Answer: A
single patient record can store more than one MRN but can only have
one unique EPT .1.
TEST PAPER 2026 QUESTIONS WITH ANSWERS
GUARANTEED TO PASS
◉ What is the significance of identifying Clarity tables and columns?
Answer: To understand the data structure and how to query effectively.
◉ What is the main focus of the exercise on misleading results? Answer:
To analyze how incorrect joins can lead to inaccurate data
interpretations.
◉ What are the two main principles for constructing tables in the Clarity
database? Answer: Minimize redundant data and maintain consistent
granularity.
◉ What is stored in the EPT master file in Clarity? Answer: Patient data,
where each record represents a patient and each contact represents a
different encounter.
◉ What problem arises when capturing multiple phone numbers in a
single Clarity table? Answer: It requires an upper limit on the number of
phone numbers and complicates storage of other items with many
values.
,◉ How does Clarity minimize data redundancy while maintaining
granularity? Answer: By mapping a single Chronicles master file to
multiple Clarity tables based on item granularity.
◉ What are the two key characteristics of Chronicles items important for
Clarity queries? Answer: Add type and response type.
◉ What does the add type indicate in Chronicles? Answer: It indicates if
data is stored on a record or on a contact in the record.
◉ What are the two categories of add type in Chronicles? Answer:
Single and Multiple.
◉ What does the response type indicate in Chronicles? Answer: It
indicates how many lines of data an item can hold.
◉ What are the two categories of response type in Chronicles? Answer:
No-Add and Overtime.
◉ What does a Single add type hold? Answer: Only one line of data.
◉ What does a No-Add response type signify? Answer: Data is stored
on the record and the value is always current.
, ◉ What does an Overtime response type signify? Answer: Data is stored
on the contact.
◉ What is the internal identifier in Chronicles records? Answer: A
unique record ID stored in the .1 item on the record.
◉ What is the difference between internal and external identifiers in
Chronicles? Answer: Internal identifiers are unique across all records,
while external identifiers may not be unique.
◉ What is an example of an external identifier in patient records?
Answer: Medical Record Number (MRN).
◉ What is the Contact Serial Number (CSN) in Clarity? Answer: A
unique serial number for all contacts within a master file.
◉ What is the Contact Date Real (CDR) in Clarity? Answer: A date in
Epic's internal format, followed by two decimal places that increment
for each additional contact on the same date.
◉ How does a single patient record handle multiple MRNs? Answer: A
single patient record can store more than one MRN but can only have
one unique EPT .1.
