CLR110 - Clarity Data Model Fundamentals:
Questions With Correct Solutions
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
he's looking for? Correct Answer - Ctrl + Click
I IDM 130 is a networked item that is not filled in for this record.
What value will be extracted to Clarity for this item, and other
Chronicles items that are not filled out? Correct Answer - Null
What value will be extracted to Caboodle for this item, and other
networked items that are not filled out in Chronicles? Correct
Answer - if the column is a key column, Caboodle will have a ‐1
letting report writers know that this value was not populated in the
source, while still enforcing referential integrity.
T/F columns that are non primary keys contain null values
Correct Answer - True, even foreign key may be null.
Why do null values exist in Clarity Correct Answer - Not all
fields are populated in Chronicles
ETL data cleansing deletes incorrectly formatted data
Data is deprecated y no longer extracted
!Appendix E: Record Viewer Tip Sheet contains more information on
the filtering options available in the record viewer Correct Answer
-
Item Editor Correct Answer - Shows the definition of chronicle
items.
Shows information about how the item behaves for all values
,Hot Keys Correct Answer - Opening Chart Search - Ctrl + Space
What is a category list? Correct Answer - a list of defined
values that can be stored in a Chronicles item
Benefits and limitations of using category as a filter Correct
Answer - 1. more efficient
2. cannot only see first 100 values in item editor - must use category
list maintenance to see complete list
add types Correct Answer - no add
response each time
lookback
what is an add type Correct Answer - describes how long a
piece of data is valid
no add Correct Answer - considered true for all cases.
if changed then old value is replaced
example: SSN, birthday
response each time Correct Answer - data stored separate on
each contact record
if blank then it is considered unknown
example: weight, blood pressure
lookback Correct Answer - store each item separately but if
blank considers last value to be true
Example: age, address
No‐Add Correct Answer - add type
stored on record, not contact.
considered true for all contacts
, !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. Correct Answer -
Response Each Time Correct Answer - Response type
stored separately on each of the records contacts
if blank, should be considered unknown
Lookback Correct Answer - add type
stored separately on each contact
assume that last value entered remains true
Response Type Correct Answer - determines how many lines
an item can hold at one time
- Single Response
- Multiple Response
- Related Group
!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. Correct Answer -
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? Correct Answer - record viewer
Questions With Correct Solutions
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
he's looking for? Correct Answer - Ctrl + Click
I IDM 130 is a networked item that is not filled in for this record.
What value will be extracted to Clarity for this item, and other
Chronicles items that are not filled out? Correct Answer - Null
What value will be extracted to Caboodle for this item, and other
networked items that are not filled out in Chronicles? Correct
Answer - if the column is a key column, Caboodle will have a ‐1
letting report writers know that this value was not populated in the
source, while still enforcing referential integrity.
T/F columns that are non primary keys contain null values
Correct Answer - True, even foreign key may be null.
Why do null values exist in Clarity Correct Answer - Not all
fields are populated in Chronicles
ETL data cleansing deletes incorrectly formatted data
Data is deprecated y no longer extracted
!Appendix E: Record Viewer Tip Sheet contains more information on
the filtering options available in the record viewer Correct Answer
-
Item Editor Correct Answer - Shows the definition of chronicle
items.
Shows information about how the item behaves for all values
,Hot Keys Correct Answer - Opening Chart Search - Ctrl + Space
What is a category list? Correct Answer - a list of defined
values that can be stored in a Chronicles item
Benefits and limitations of using category as a filter Correct
Answer - 1. more efficient
2. cannot only see first 100 values in item editor - must use category
list maintenance to see complete list
add types Correct Answer - no add
response each time
lookback
what is an add type Correct Answer - describes how long a
piece of data is valid
no add Correct Answer - considered true for all cases.
if changed then old value is replaced
example: SSN, birthday
response each time Correct Answer - data stored separate on
each contact record
if blank then it is considered unknown
example: weight, blood pressure
lookback Correct Answer - store each item separately but if
blank considers last value to be true
Example: age, address
No‐Add Correct Answer - add type
stored on record, not contact.
considered true for all contacts
, !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. Correct Answer -
Response Each Time Correct Answer - Response type
stored separately on each of the records contacts
if blank, should be considered unknown
Lookback Correct Answer - add type
stored separately on each contact
assume that last value entered remains true
Response Type Correct Answer - determines how many lines
an item can hold at one time
- Single Response
- Multiple Response
- Related Group
!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. Correct Answer -
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? Correct Answer - record viewer
