CLR110 CLARITY DATA MODEL EXAM QUESTIONS WITH MULTIPLE CHOICES AND RATIONALES
| LATEST UPDATE 2025\2026
Question 1 A Chronicles item can store one or more options from a limited list. Which of the
following attributes could account for this behavior?
A) Single Response and No-Add
B) Multiple Response and Category
C) Single Response and Overtime
D) No-Add and String
E) Response Each Time and Number
Correct Answer: B) Multiple Response and Category
Rationale: If a Chronicles item can store more than one value, its Response Type must be
Multiple Response. If those values are chosen from a pre-defined limited list, it is a
Category item. Alternatively, it could be a Networked item if the "list" is actually records
in another master file.
Question 2 What are the primary steps to writing a Clarity report request, in the correct order?
A) Join tables, find columns, find INIs, identify data.
B) Identify data, find INI/Item, find Clarity tables/columns, join tables.
C) Identify data, join tables, find INI/Item, find Clarity tables.
D) Find Clarity tables, identify data, join tables, find INI/Item.
E) Identify data, find Clarity tables, join tables, find INI/Item.
Correct Answer: B) Identify data, find INI/Item, find Clarity tables/columns, join tables.
Rationale: The workflow begins with understanding the business need, moving into
Chronicles to find the technical address (INI/Item), mapping that to the Clarity schema via
the Compass, and finally writing the SQL join logic.
Question 3 Which activity in Chronicles provides a read-only view of raw data for a specific
record to help find INI and Item numbers?
A) Item Editor
B) Category List Maintenance
C) Record Viewer
D) Clarity Compass
E) Analytics Catalog
Correct Answer: C) Record Viewer
Rationale: Record Viewer allows you to see the raw data stored in Chronicles for a specific
record. It is especially useful when Ctrl+Click does not work or when you need to see how
data is formatted before extraction.
Question 4 When attempting to find the INI and Item number for a field in Hyperspace, what is
the most efficient first step?
A) Open the Clarity Dictionary on the UserWeb.
B) Use the "Database Object Search" in Hyperspace.
, 2
C) Perform a "Ctrl + Left Click" on the field.
D) Run a SQL query on the Clarity database.
E) Open the Item Editor and search by field name.
Correct Answer: C) Perform a "Ctrl + Left Click" on the field.
Rationale: Ctrl + Left Click opens the Item Information Window, which directly displays
the INI and Item number for the field, provided the field is not read-only or incompatible.
Question 5 If a field in Hyperspace is read-only and "Ctrl + Left Click" does not work, which
tool should be used next to find the Item number if you know the specific record?
A) Item Editor
B) Record Viewer
C) Category List Maintenance
D) Analytics Catalog
E) Report Repository
Correct Answer: B) Record Viewer
Rationale: Record Viewer is the alternative for finding item numbers when the Item
Information Window is unavailable, as it shows all items populated for a specific record.
Question 6 If a value is stored as '101-Inpatient' in the Chronicles Record Viewer, what value is
actually extracted and stored in the corresponding Clarity column?
A) Inpatient
B) 101-Inpatient
C) 101
D) NULL
E) -1
Correct Answer: C) 101
Rationale: Clarity typically extracts the internal ID (the category value) of a category entry,
not the display name/title. The title is usually found in a related "ZC_" table.
Question 7 An item IDM 130 is a networked item that is not filled in for a particular record.
What value will be extracted to Clarity for this item?
A) 0
B) -1
C) NULL
D) Empty String
E) An error code
Correct Answer: C) NULL
Rationale: In the Clarity data model, when a Chronicles item is not populated, the resulting
value in the Clarity table is NULL. This applies to most data types including networked
items.
, 3
Question 8 In Caboodle, if a networked item is not populated in Chronicles, what value is
typically stored in the key column?
A) NULL
B) 0
C) -1
D) 999
E) Empty String
Correct Answer: C) -1
Rationale: Unlike Clarity, which uses NULL, Caboodle uses -1 for unpopulated foreign keys
to maintain referential integrity while signaling that the data was not available in the
source.
Question 9 Which tool allows you to see the definitions and behavior of a Chronicles item (such
as its Add Type and Response Type) without looking at a specific record's data?
A) Record Viewer
B) Item Editor
C) Category List Maintenance
D) Clarity Console
E) SQL Server Management Studio
Correct Answer: B) Item Editor
Rationale: The Item Editor shows the structural definitions of an item—how it behaves for
all records—whereas the Record Viewer shows data for one specific record.
Question 10 Which of the following defines a "Category List" in Chronicles?
A) A list of every record in a master file.
B) A list of defined values that can be stored in a Chronicles item.
C) A list of all Clarity tables.
D) A list of all contacts for a specific patient.
E) A list of all INIs in the system.
Correct Answer: B) A list of defined values that can be stored in a Chronicles item.
Rationale: Category lists provide standardized options (e.g., Marital Status, Race) to ensure
data consistency across the application.
Question 11 What does the "Release Range" in a Category List indicate?
A) The dates during which the data was collected.
B) Category values released by Epic that cannot be modified by the organization.
C) The specific Clarity tables where the data is stored.
D) The number of records that use a specific category value.
E) The maximum number of characters allowed in a string.
Correct Answer: B) Category values released by Epic that cannot be modified by the
organization.
, 4
Rationale: Epic-released values are protected to ensure system stability and standard
reporting functionality; values outside this range are typically customer-defined.
Question 12 A Chronicles item stores only one value at a time, but it can store a separate, unique
value for every contact on a record. What are its Response and Add types?
A) Multiple Response; No-Add
B) Single Response; Overtime
C) Single Response; No-Add
D) Multiple Response; Overtime
E) Related Group; Overtime
Correct Answer: B) Single Response; Overtime
Rationale: "Single Response" means only one value is stored per entry. "Overtime" (which
includes Response Each Time and Lookback) means the data is stored at the contact level
rather than the record level.
Question 13 Which Add Type indicates that data is stored directly on the record and is
considered true for all contacts on that record?
A) Overtime
B) Response Each Time
C) Lookback
D) No-Add
E) Multiple Response
Correct Answer: D) No-Add
Rationale: No-Add items (like a Date of Birth) do not change over time and are stored at the
record level, meaning they apply to every contact associated with that record.
Question 14 If a "Response Each Time" item is blank for a specific contact, how should it be
interpreted for a report?
A) The previous contact's value remains true.
B) The value is unknown for that specific contact.
C) The value is the same as the No-Add value.
D) The record is corrupt.
E) The value is 0.
Correct Answer: B) The value is unknown for that specific contact.
Rationale: Unlike "Lookback" items, "Response Each Time" items are only valid for the
specific contact they are recorded on. If blank, no data exists for that specific instance.
Question 15 What is the main difference between "Overtime" and "No-Add" items in
Chronicles?
A) No-Add items are strings; Overtime items are numbers.
B) No-Add data is stored at the record level; Overtime data is stored at the contact level.
| LATEST UPDATE 2025\2026
Question 1 A Chronicles item can store one or more options from a limited list. Which of the
following attributes could account for this behavior?
A) Single Response and No-Add
B) Multiple Response and Category
C) Single Response and Overtime
D) No-Add and String
E) Response Each Time and Number
Correct Answer: B) Multiple Response and Category
Rationale: If a Chronicles item can store more than one value, its Response Type must be
Multiple Response. If those values are chosen from a pre-defined limited list, it is a
Category item. Alternatively, it could be a Networked item if the "list" is actually records
in another master file.
Question 2 What are the primary steps to writing a Clarity report request, in the correct order?
A) Join tables, find columns, find INIs, identify data.
B) Identify data, find INI/Item, find Clarity tables/columns, join tables.
C) Identify data, join tables, find INI/Item, find Clarity tables.
D) Find Clarity tables, identify data, join tables, find INI/Item.
E) Identify data, find Clarity tables, join tables, find INI/Item.
Correct Answer: B) Identify data, find INI/Item, find Clarity tables/columns, join tables.
Rationale: The workflow begins with understanding the business need, moving into
Chronicles to find the technical address (INI/Item), mapping that to the Clarity schema via
the Compass, and finally writing the SQL join logic.
Question 3 Which activity in Chronicles provides a read-only view of raw data for a specific
record to help find INI and Item numbers?
A) Item Editor
B) Category List Maintenance
C) Record Viewer
D) Clarity Compass
E) Analytics Catalog
Correct Answer: C) Record Viewer
Rationale: Record Viewer allows you to see the raw data stored in Chronicles for a specific
record. It is especially useful when Ctrl+Click does not work or when you need to see how
data is formatted before extraction.
Question 4 When attempting to find the INI and Item number for a field in Hyperspace, what is
the most efficient first step?
A) Open the Clarity Dictionary on the UserWeb.
B) Use the "Database Object Search" in Hyperspace.
, 2
C) Perform a "Ctrl + Left Click" on the field.
D) Run a SQL query on the Clarity database.
E) Open the Item Editor and search by field name.
Correct Answer: C) Perform a "Ctrl + Left Click" on the field.
Rationale: Ctrl + Left Click opens the Item Information Window, which directly displays
the INI and Item number for the field, provided the field is not read-only or incompatible.
Question 5 If a field in Hyperspace is read-only and "Ctrl + Left Click" does not work, which
tool should be used next to find the Item number if you know the specific record?
A) Item Editor
B) Record Viewer
C) Category List Maintenance
D) Analytics Catalog
E) Report Repository
Correct Answer: B) Record Viewer
Rationale: Record Viewer is the alternative for finding item numbers when the Item
Information Window is unavailable, as it shows all items populated for a specific record.
Question 6 If a value is stored as '101-Inpatient' in the Chronicles Record Viewer, what value is
actually extracted and stored in the corresponding Clarity column?
A) Inpatient
B) 101-Inpatient
C) 101
D) NULL
E) -1
Correct Answer: C) 101
Rationale: Clarity typically extracts the internal ID (the category value) of a category entry,
not the display name/title. The title is usually found in a related "ZC_" table.
Question 7 An item IDM 130 is a networked item that is not filled in for a particular record.
What value will be extracted to Clarity for this item?
A) 0
B) -1
C) NULL
D) Empty String
E) An error code
Correct Answer: C) NULL
Rationale: In the Clarity data model, when a Chronicles item is not populated, the resulting
value in the Clarity table is NULL. This applies to most data types including networked
items.
, 3
Question 8 In Caboodle, if a networked item is not populated in Chronicles, what value is
typically stored in the key column?
A) NULL
B) 0
C) -1
D) 999
E) Empty String
Correct Answer: C) -1
Rationale: Unlike Clarity, which uses NULL, Caboodle uses -1 for unpopulated foreign keys
to maintain referential integrity while signaling that the data was not available in the
source.
Question 9 Which tool allows you to see the definitions and behavior of a Chronicles item (such
as its Add Type and Response Type) without looking at a specific record's data?
A) Record Viewer
B) Item Editor
C) Category List Maintenance
D) Clarity Console
E) SQL Server Management Studio
Correct Answer: B) Item Editor
Rationale: The Item Editor shows the structural definitions of an item—how it behaves for
all records—whereas the Record Viewer shows data for one specific record.
Question 10 Which of the following defines a "Category List" in Chronicles?
A) A list of every record in a master file.
B) A list of defined values that can be stored in a Chronicles item.
C) A list of all Clarity tables.
D) A list of all contacts for a specific patient.
E) A list of all INIs in the system.
Correct Answer: B) A list of defined values that can be stored in a Chronicles item.
Rationale: Category lists provide standardized options (e.g., Marital Status, Race) to ensure
data consistency across the application.
Question 11 What does the "Release Range" in a Category List indicate?
A) The dates during which the data was collected.
B) Category values released by Epic that cannot be modified by the organization.
C) The specific Clarity tables where the data is stored.
D) The number of records that use a specific category value.
E) The maximum number of characters allowed in a string.
Correct Answer: B) Category values released by Epic that cannot be modified by the
organization.
, 4
Rationale: Epic-released values are protected to ensure system stability and standard
reporting functionality; values outside this range are typically customer-defined.
Question 12 A Chronicles item stores only one value at a time, but it can store a separate, unique
value for every contact on a record. What are its Response and Add types?
A) Multiple Response; No-Add
B) Single Response; Overtime
C) Single Response; No-Add
D) Multiple Response; Overtime
E) Related Group; Overtime
Correct Answer: B) Single Response; Overtime
Rationale: "Single Response" means only one value is stored per entry. "Overtime" (which
includes Response Each Time and Lookback) means the data is stored at the contact level
rather than the record level.
Question 13 Which Add Type indicates that data is stored directly on the record and is
considered true for all contacts on that record?
A) Overtime
B) Response Each Time
C) Lookback
D) No-Add
E) Multiple Response
Correct Answer: D) No-Add
Rationale: No-Add items (like a Date of Birth) do not change over time and are stored at the
record level, meaning they apply to every contact associated with that record.
Question 14 If a "Response Each Time" item is blank for a specific contact, how should it be
interpreted for a report?
A) The previous contact's value remains true.
B) The value is unknown for that specific contact.
C) The value is the same as the No-Add value.
D) The record is corrupt.
E) The value is 0.
Correct Answer: B) The value is unknown for that specific contact.
Rationale: Unlike "Lookback" items, "Response Each Time" items are only valid for the
specific contact they are recorded on. If blank, no data exists for that specific instance.
Question 15 What is the main difference between "Overtime" and "No-Add" items in
Chronicles?
A) No-Add items are strings; Overtime items are numbers.
B) No-Add data is stored at the record level; Overtime data is stored at the contact level.
