Compared to views, derived tables generally take less time to run because the data has been stored on
the DB
True, views are saved queries, their use can affect performance. Derived tables are stored procedures and
thus perform better
After receiving a report request, you consult Clarity resources such as Clarity Compass and the Clarity
Dictionary without consulting Chroncile resources such as Item Editor and record viewer. What problems
may you run into?
Analytics catalog
Database object search
Column search
Clarity Dictionary on the
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?
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?
Null
What value will be extracted to Caboodle for this item, and other networked items that are not filled out in
Chronicles?
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
True, even foreign key may be null.
Why do null values exist in Clarity
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
Item Editor
Shows the definition of chronicle items.
Shows information about how the item behaves for all values
Hot Keys
Opening Chart Search - Ctrl + Space
What is a category list?
a list of defined values that can be stored in a Chronicles item
Benefits and limitations of using category as a filter
1. more efficient
2. cannot only see first 100 values in item editor - must use category list maintenance to see complete list
, add types
no add
response each time
lookback
what is an add type
describes how long a piece of data is valid
no add
considered true for all cases.
if changed then old value is replaced
example: SSN, birthday
response each time
data stored separate on each contact record
if blank then it is considered unknown
example: weight, blood pressure
the DB
True, views are saved queries, their use can affect performance. Derived tables are stored procedures and
thus perform better
After receiving a report request, you consult Clarity resources such as Clarity Compass and the Clarity
Dictionary without consulting Chroncile resources such as Item Editor and record viewer. What problems
may you run into?
Analytics catalog
Database object search
Column search
Clarity Dictionary on the
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?
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?
Null
What value will be extracted to Caboodle for this item, and other networked items that are not filled out in
Chronicles?
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
True, even foreign key may be null.
Why do null values exist in Clarity
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
Item Editor
Shows the definition of chronicle items.
Shows information about how the item behaves for all values
Hot Keys
Opening Chart Search - Ctrl + Space
What is a category list?
a list of defined values that can be stored in a Chronicles item
Benefits and limitations of using category as a filter
1. more efficient
2. cannot only see first 100 values in item editor - must use category list maintenance to see complete list
, add types
no add
response each time
lookback
what is an add type
describes how long a piece of data is valid
no add
considered true for all cases.
if changed then old value is replaced
example: SSN, birthday
response each time
data stored separate on each contact record
if blank then it is considered unknown
example: weight, blood pressure
