CLR110 Clarity Data Model Fundamentals questions
with accurate answers
_C Column Ans✓✓✓ ○ naming convention for columns that extract
category values
○ each row stores a number value that correlates to a name in the
prefixed ZC_ table
!A key question to ask when writing a report is "what is the meaning of
one row in my results?" When constructing your query, take note of how
cardinality of a join or presence of a filter may modify your report's
granularity Ans✓✓✓
!Appendix E: Record Viewer Tip Sheet contains more information on
the filtering options available in the record viewer Ans✓✓✓
!Be sure to look up category list tables in the Columns section of the
dictionary and not rely on the naming convention. There is no enforced
naming convention in Clarity like you see in Caboodle. Ans✓✓✓
!better to write reports from the most granular level and to move back
up. Ans✓✓✓
!If both the ACCESS_LOG_TYPE_C and METRIC_WRKF_TYP_C
columns are populated, Ans✓✓✓ then the event definition is tracked
using both types of event logging, so one event populates both
ACCESS_LOG and ACCESS_WRKF. Keep this in mind, particularly if
you are creating a report that counts rows in each of these tables.
,!Most networked items point to records. However, some networked
items point directly to a contact within a record.
‣ Identify whether a networked item links to a record or a contact by
looking at the Network section within the Item Editor.
‣ If the first field within that section reads Record pointer? then
the link is to a record.
‣ If instead, the first field reads Contact pointer? then the link is to a
contact.
I ORD 226: Patient CSN is an example of a networked item that points
to a contact. Ans✓✓✓
!Since both multiple response and related group items store more than
one type of data, these response types may collectively be referred to as
multiple response types.
Single data stores one line of data, while Multiple data stores multiple
lines of data. Ans✓✓✓
!Since both respond each time and lookback items store data on the
contact, these add types are referred to as overtime add types.
No‐Add data is stored at the record level Overtime data is stored at the
contact level. Ans✓✓✓
,!The Foreign Key section of the Clarity dictionary on the UserWeb does
NOT include a full list of every possible join between tables in Clarity.
It should primarily be used to identify category list tables. Ans✓✓✓
.Why doesn't one Chronicles master file translate into one Clarity
table? Ans✓✓✓ designed to
○ Minimize redundant data
○ Maintain consistent granularity
A Chronicles item can store one or more options from a limited list.
Which of the following could
account for this behavior? ﴾Choose all that apply﴿
A. Single Response
B. Multiple Response
C. Networked
D. Overtime
E. No‐Add
F. Category Ans✓✓✓ B, C and F. If a Chronicles item can store one or
more options it is a multiple response item.
If the options come from a limited list, that item may be a category item,
where the category list is the list
of options, or
, networked, where the records or contacts in the destination master file is
the list of
options
A Chronicles item stores a single value, but can store a separate value
for each contact on a record. Which of the following could account for
this behavior? ﴾Choose all that apply﴿
A. Single Response
B. Multiple Response
C. Networked
D. Overtime
E. No‐Add
F. Category Ans✓✓✓ A and D. If a Chronicles item can store only one
value it is a single response item.
If a separate value is stored on each contact the add type is Overtime.
A clinical administrator requests a query to include data for a patient's
registries. She's not sure of the INI and Item number, but she knows
patient is on the Lung Cancer Screening registry. What
tool would you use to find the INI and item number given this
information? Ans✓✓✓ record viewer
A lab manager tells you he wants a report on lab specimens, and shows
you the field where he can input various information. What method
would you use to find the INI + Item numbers of the data
with accurate answers
_C Column Ans✓✓✓ ○ naming convention for columns that extract
category values
○ each row stores a number value that correlates to a name in the
prefixed ZC_ table
!A key question to ask when writing a report is "what is the meaning of
one row in my results?" When constructing your query, take note of how
cardinality of a join or presence of a filter may modify your report's
granularity Ans✓✓✓
!Appendix E: Record Viewer Tip Sheet contains more information on
the filtering options available in the record viewer Ans✓✓✓
!Be sure to look up category list tables in the Columns section of the
dictionary and not rely on the naming convention. There is no enforced
naming convention in Clarity like you see in Caboodle. Ans✓✓✓
!better to write reports from the most granular level and to move back
up. Ans✓✓✓
!If both the ACCESS_LOG_TYPE_C and METRIC_WRKF_TYP_C
columns are populated, Ans✓✓✓ then the event definition is tracked
using both types of event logging, so one event populates both
ACCESS_LOG and ACCESS_WRKF. Keep this in mind, particularly if
you are creating a report that counts rows in each of these tables.
,!Most networked items point to records. However, some networked
items point directly to a contact within a record.
‣ Identify whether a networked item links to a record or a contact by
looking at the Network section within the Item Editor.
‣ If the first field within that section reads Record pointer? then
the link is to a record.
‣ If instead, the first field reads Contact pointer? then the link is to a
contact.
I ORD 226: Patient CSN is an example of a networked item that points
to a contact. Ans✓✓✓
!Since both multiple response and related group items store more than
one type of data, these response types may collectively be referred to as
multiple response types.
Single data stores one line of data, while Multiple data stores multiple
lines of data. Ans✓✓✓
!Since both respond each time and lookback items store data on the
contact, these add types are referred to as overtime add types.
No‐Add data is stored at the record level Overtime data is stored at the
contact level. Ans✓✓✓
,!The Foreign Key section of the Clarity dictionary on the UserWeb does
NOT include a full list of every possible join between tables in Clarity.
It should primarily be used to identify category list tables. Ans✓✓✓
.Why doesn't one Chronicles master file translate into one Clarity
table? Ans✓✓✓ designed to
○ Minimize redundant data
○ Maintain consistent granularity
A Chronicles item can store one or more options from a limited list.
Which of the following could
account for this behavior? ﴾Choose all that apply﴿
A. Single Response
B. Multiple Response
C. Networked
D. Overtime
E. No‐Add
F. Category Ans✓✓✓ B, C and F. If a Chronicles item can store one or
more options it is a multiple response item.
If the options come from a limited list, that item may be a category item,
where the category list is the list
of options, or
, networked, where the records or contacts in the destination master file is
the list of
options
A Chronicles item stores a single value, but can store a separate value
for each contact on a record. Which of the following could account for
this behavior? ﴾Choose all that apply﴿
A. Single Response
B. Multiple Response
C. Networked
D. Overtime
E. No‐Add
F. Category Ans✓✓✓ A and D. If a Chronicles item can store only one
value it is a single response item.
If a separate value is stored on each contact the add type is Overtime.
A clinical administrator requests a query to include data for a patient's
registries. She's not sure of the INI and Item number, but she knows
patient is on the Lung Cancer Screening registry. What
tool would you use to find the INI and item number given this
information? Ans✓✓✓ record viewer
A lab manager tells you he wants a report on lab specimens, and shows
you the field where he can input various information. What method
would you use to find the INI + Item numbers of the data
