CLR110 Clarity Data Model EXAM
QUESTIONS WITH CORRECT
SOLUTIONS||100% GUARANTEED
PASS||UPDATED 2026/2027
SYLLABUS||ALREADY GRADED
A+||<<NEWEST VERSION>>
How do you Determine foreign keys between Clarity tables that extract from the
same master file? - ANSWER ✓ See the many-to-one diagram under "Linking
diagrams"
How do you Use Epic tools to identify networked items? - ANSWER ✓ Each
networked item will store the ID of a Chronicles record or contact. the (.1 or
CSN/CDR)
How do you Use Chronicles networked items to determine Clarity foreign keys -
ANSWER ✓ Use the Clarity Compass (column search) to look up the
corresponding tables and columns in Clarity.
The relationship between Chronicles master files and extracted tables in Clarity -
ANSWER ✓ Join the primary key to the networked item
When to use an INNER JOIN vs a LEFT OUTER JOIN in Clarity - ANSWER ✓
The reporting need, load type and frequency will determine whether two tables
should be joined using a left outer join or an inner join.
Why is research started in Chronicles? - ANSWER ✓ - Understanding how the
data is structured in Chronicles will allow you to better understand the structure of
Clarity
- Researching the record in the Record viewer will allow you to validate the data in
the source and explore link between data points
- You cannot trust the naming conventions in Clarity
, Why doesn't one Chronicles master file translate into one Clarity table? -
ANSWER ✓ Clarity was built to easily store and retrieve small amounts of
information across many topics at once.
two main principles for constructing tables in the Clarity database: - ANSWER ✓
Minimize redundant data
Maintain consistent granularity
What Chronicles item characteristics allow multiple values to be stored for a
single record? - ANSWER ✓ Add type and response type
Add Type - ANSWER ✓ Indicates if data is stored on a record or on a contact in
the record.
Categorized as either No-Add or Overtime (Response Each Time or Lookback)
No-Add: stored on the record. Always considered "current".
Overtime: stored on the contact.
Response Type - ANSWER ✓ Indicates how many lines of data an item can hold
Categorized as either Single or Multiple (Multiple response, Related group)
Single: holds only one line of data
Multiple: holds multiple lines of data
two possible identifiers for contacts in Epic - ANSWER ✓ Contact Serial Number
(CSN) and Contact Date Real (CDR)
What do you need to find a second contact on the record? - ANSWER ✓ Just the
CSN, or Record ID and CDR
Fundamental concepts about contacts within a master file: - ANSWER ✓ - The
meaning of a contact differs between master files.
- Some master files contain contacts that change meaning within the master file,
depending on the type of record the contact is stored in.
- Some master files only ever use one contact per record.
Static Master Files - ANSWER ✓ Static master files typically contain build
records, such as departments, medications, and providers. Such records can be
created before documenting care for a patient. In general, the meaning of a contact
within a static master file is an update.
, Dynamic Master Files - ANSWER ✓ Dynamic master files are generally created
as part of a workflow
How doe multiple and related groups affect the primary key? - ANSWER ✓ Line
column is added to uniquely identify each row in the table
All data in a single extracted table in Clarity typically come from the same
Chronicles ________________ - ANSWER ✓ Master File
All data in a single extracted table in Clarity typically come from items with the
same ________________________ - ANSWER ✓ Add Type & Response Type
Multiple response Chronicles items typically extract to __________Clarity tables,
unless they are part of the same related group. - ANSWER ✓ Separate
What are the three steps to constructing a Clarity QUERY - ANSWER ✓ 1. Find
the INI + Item number of the data point to use on the report.
2. Use the INI + Item number to find the appropriate Clarity table and column.
3. Join the Clarity tables together using the correct foreign key.
Is it better to write reports tom down or bottom up? - ANSWER ✓ it is usually
better to write reports from the most granular level and to move back up. This is
due to the cardinality of the joins.
What are advantages of Many to One Joins? - ANSWER ✓ Such joins preserve
the granularity of the starting table on the left. They also have the advantage of
allowing inner joins without losing rows.
Networked Items - ANSWER ✓ define relationships between an item in one
master file and a record or contact. Each networked item will store the ID of a
Chronicles record or contact.
How does a networked item compare to a category item? - ANSWER ✓ Both
networked items and category items store a value from a list. A networked item
points to an ID or contact within a master file. This record or contact can store a
wide variety of information depending on the master file. By contrast, a category
item points to a value in a category list.
QUESTIONS WITH CORRECT
SOLUTIONS||100% GUARANTEED
PASS||UPDATED 2026/2027
SYLLABUS||ALREADY GRADED
A+||<<NEWEST VERSION>>
How do you Determine foreign keys between Clarity tables that extract from the
same master file? - ANSWER ✓ See the many-to-one diagram under "Linking
diagrams"
How do you Use Epic tools to identify networked items? - ANSWER ✓ Each
networked item will store the ID of a Chronicles record or contact. the (.1 or
CSN/CDR)
How do you Use Chronicles networked items to determine Clarity foreign keys -
ANSWER ✓ Use the Clarity Compass (column search) to look up the
corresponding tables and columns in Clarity.
The relationship between Chronicles master files and extracted tables in Clarity -
ANSWER ✓ Join the primary key to the networked item
When to use an INNER JOIN vs a LEFT OUTER JOIN in Clarity - ANSWER ✓
The reporting need, load type and frequency will determine whether two tables
should be joined using a left outer join or an inner join.
Why is research started in Chronicles? - ANSWER ✓ - Understanding how the
data is structured in Chronicles will allow you to better understand the structure of
Clarity
- Researching the record in the Record viewer will allow you to validate the data in
the source and explore link between data points
- You cannot trust the naming conventions in Clarity
, Why doesn't one Chronicles master file translate into one Clarity table? -
ANSWER ✓ Clarity was built to easily store and retrieve small amounts of
information across many topics at once.
two main principles for constructing tables in the Clarity database: - ANSWER ✓
Minimize redundant data
Maintain consistent granularity
What Chronicles item characteristics allow multiple values to be stored for a
single record? - ANSWER ✓ Add type and response type
Add Type - ANSWER ✓ Indicates if data is stored on a record or on a contact in
the record.
Categorized as either No-Add or Overtime (Response Each Time or Lookback)
No-Add: stored on the record. Always considered "current".
Overtime: stored on the contact.
Response Type - ANSWER ✓ Indicates how many lines of data an item can hold
Categorized as either Single or Multiple (Multiple response, Related group)
Single: holds only one line of data
Multiple: holds multiple lines of data
two possible identifiers for contacts in Epic - ANSWER ✓ Contact Serial Number
(CSN) and Contact Date Real (CDR)
What do you need to find a second contact on the record? - ANSWER ✓ Just the
CSN, or Record ID and CDR
Fundamental concepts about contacts within a master file: - ANSWER ✓ - The
meaning of a contact differs between master files.
- Some master files contain contacts that change meaning within the master file,
depending on the type of record the contact is stored in.
- Some master files only ever use one contact per record.
Static Master Files - ANSWER ✓ Static master files typically contain build
records, such as departments, medications, and providers. Such records can be
created before documenting care for a patient. In general, the meaning of a contact
within a static master file is an update.
, Dynamic Master Files - ANSWER ✓ Dynamic master files are generally created
as part of a workflow
How doe multiple and related groups affect the primary key? - ANSWER ✓ Line
column is added to uniquely identify each row in the table
All data in a single extracted table in Clarity typically come from the same
Chronicles ________________ - ANSWER ✓ Master File
All data in a single extracted table in Clarity typically come from items with the
same ________________________ - ANSWER ✓ Add Type & Response Type
Multiple response Chronicles items typically extract to __________Clarity tables,
unless they are part of the same related group. - ANSWER ✓ Separate
What are the three steps to constructing a Clarity QUERY - ANSWER ✓ 1. Find
the INI + Item number of the data point to use on the report.
2. Use the INI + Item number to find the appropriate Clarity table and column.
3. Join the Clarity tables together using the correct foreign key.
Is it better to write reports tom down or bottom up? - ANSWER ✓ it is usually
better to write reports from the most granular level and to move back up. This is
due to the cardinality of the joins.
What are advantages of Many to One Joins? - ANSWER ✓ Such joins preserve
the granularity of the starting table on the left. They also have the advantage of
allowing inner joins without losing rows.
Networked Items - ANSWER ✓ define relationships between an item in one
master file and a record or contact. Each networked item will store the ID of a
Chronicles record or contact.
How does a networked item compare to a category item? - ANSWER ✓ Both
networked items and category items store a value from a list. A networked item
points to an ID or contact within a master file. This record or contact can store a
wide variety of information depending on the master file. By contrast, a category
item points to a value in a category list.
