CLR110 Clarity Data Model Fundamentals
Exam Practice 2025-2026
1. How to get to Item informa- Ctrl+Click
tion window
2. Where can you look up in- 1. Item information window
formation about the data in 2. Record Viewer
Chronicles? (4) 3. Item Editor
4. Category List Maintenance
3. What is contained in the Item 1. INI and item #
Information window? (3) 2. Clarity table and column
3. Item's help text
4. Where can you find the item's 1. Additional Details link at the bottom of the Item Information
add type and response type? window.
(2) 2. Item Editor
5. What does Record Viewer All items set on a particular contact of a particular record
show you?
6. Where should you go to find Record Viewer
the INI + item number if
Ctrl+Click d/n work or you
don't know the field where a
data point was entered?
7. What can you find in the data Information on a Clarity table like:
dictionary? 1. When it was released
2. Whether columns are deprecated
3. Chronicles INI and item numbers
4. SlicerDicer reporting information
8. Generally, what does the Item The definition of a Chronicles item and info on how it behaves
Editor show? for all values
, CLR110 Clarity Data Model Fundamentals
Exam Practice 2025-2026
9. If a Chronicles item has a data The item is populated by a limited list of options called a
type of 'category,' what does category list
that mean?
10. Can multiple items in Chroni- Yes, so look at 'Where Found' to determine where Chronicles
cles reference the same cate- stores it
gory list?
11. After receiving a report re- 1. Ppl requesting reports only tell you where data is entered in
quest, you consult the data Hyperspace through the end-user workflows, without know-
dictionary without consulting ing where the data is stored in Clarity.
Chronicles resources like item 2. A join needed in your query may not be a documented
editor or record viewer. What foreign key of the Data Dictionary
problems might you run into? 3. Custom category list values are not documented in the Data
Dictionary
4. You cannot look up properties of the source item
12. Which of the following can be A, D
found when viewing a Clarity
table in the Data Dictionary?
A. The version when the table
was created
B. A list of Epic-released Crys-
tal reports that use the Clarity
table
C. The add-type of Chronicles
items extracted to the table
D. Whether a column is depre-
cated
13. What uniquely identifies a con- 1. Contact Serial Number (CSN)
tact within a master file? (2) 2. CDR + record ID
, 14. How is CSN unique? Across all contacts within that master file
15. CDR Contact Date Real - is a date in Epic's internal format, followed
by two decimal places that start at .00 and increment for each
additional contact on the same date
16. Where is the internal identifier .1 item and is referred to as the record ID.
for a Chronicles record stored?
17. What is true of the .1 item on a It is unique across all records in that master file (single re-
record (record ID)? sponse item)
18. Are external identifiers Not necessarily (2 pts might have the same MRN)
unique?
19. What kind of database is Ca- Dimensional
boodle?
20. What kind of database is Hierarchical
Chronicles?
21. What kind of database is Clari- Relational with a normalized data model
ty?
22. On the Item Information card, They are NOT Clarity. This is used for ETL
what does the SQL section rep-
resent?
23. What fields does Ctrl+Click read/write fields
work best on?
24. What do you need to specify in Master file, record, and contact
Record Viewer?
Exam Practice 2025-2026
1. How to get to Item informa- Ctrl+Click
tion window
2. Where can you look up in- 1. Item information window
formation about the data in 2. Record Viewer
Chronicles? (4) 3. Item Editor
4. Category List Maintenance
3. What is contained in the Item 1. INI and item #
Information window? (3) 2. Clarity table and column
3. Item's help text
4. Where can you find the item's 1. Additional Details link at the bottom of the Item Information
add type and response type? window.
(2) 2. Item Editor
5. What does Record Viewer All items set on a particular contact of a particular record
show you?
6. Where should you go to find Record Viewer
the INI + item number if
Ctrl+Click d/n work or you
don't know the field where a
data point was entered?
7. What can you find in the data Information on a Clarity table like:
dictionary? 1. When it was released
2. Whether columns are deprecated
3. Chronicles INI and item numbers
4. SlicerDicer reporting information
8. Generally, what does the Item The definition of a Chronicles item and info on how it behaves
Editor show? for all values
, CLR110 Clarity Data Model Fundamentals
Exam Practice 2025-2026
9. If a Chronicles item has a data The item is populated by a limited list of options called a
type of 'category,' what does category list
that mean?
10. Can multiple items in Chroni- Yes, so look at 'Where Found' to determine where Chronicles
cles reference the same cate- stores it
gory list?
11. After receiving a report re- 1. Ppl requesting reports only tell you where data is entered in
quest, you consult the data Hyperspace through the end-user workflows, without know-
dictionary without consulting ing where the data is stored in Clarity.
Chronicles resources like item 2. A join needed in your query may not be a documented
editor or record viewer. What foreign key of the Data Dictionary
problems might you run into? 3. Custom category list values are not documented in the Data
Dictionary
4. You cannot look up properties of the source item
12. Which of the following can be A, D
found when viewing a Clarity
table in the Data Dictionary?
A. The version when the table
was created
B. A list of Epic-released Crys-
tal reports that use the Clarity
table
C. The add-type of Chronicles
items extracted to the table
D. Whether a column is depre-
cated
13. What uniquely identifies a con- 1. Contact Serial Number (CSN)
tact within a master file? (2) 2. CDR + record ID
, 14. How is CSN unique? Across all contacts within that master file
15. CDR Contact Date Real - is a date in Epic's internal format, followed
by two decimal places that start at .00 and increment for each
additional contact on the same date
16. Where is the internal identifier .1 item and is referred to as the record ID.
for a Chronicles record stored?
17. What is true of the .1 item on a It is unique across all records in that master file (single re-
record (record ID)? sponse item)
18. Are external identifiers Not necessarily (2 pts might have the same MRN)
unique?
19. What kind of database is Ca- Dimensional
boodle?
20. What kind of database is Hierarchical
Chronicles?
21. What kind of database is Clari- Relational with a normalized data model
ty?
22. On the Item Information card, They are NOT Clarity. This is used for ETL
what does the SQL section rep-
resent?
23. What fields does Ctrl+Click read/write fields
work best on?
24. What do you need to specify in Master file, record, and contact
Record Viewer?
