CLR 110 CLARITY DATA SET WITH
COMPLETE SOLUTIONS
Steps when receiving a Clarity Request - ANSWER-0. Identify the data elements you
will need for the report.
1. Find the INI + Item numbers of the data points to use on the report.
2. Use the INI + Item numbers to find the appropriate Clarity tables and columns.
3. Join the Clarity tables together using the correct foreign key information. 2-4
Item Information Window ﴾Ctrl + Click Method﴿ - ANSWER-The window can be
accessed when
a Hyperspace user knows the exact field within a workflow that stores the data they
want on a report. When you control‐left click on a data entry field in Hyperspace, the
Item Information window appears.
This window shows the INI and item number in which this data is stored, along with
other information
about the item as a whole. 2-6
Record Viewer - ANSWER-The Record Viewer is an activity in Hyperspace that
provides a read‐only view of raw data in Chronicles
record. 2-8
Contact Serial Number (CSN) - ANSWER-A Contact Serial Number or CSN will
uniquely identify a contact within a master file. 2-9
CTRL + F - ANSWER-This will bring up a search bar. The search bar will search
through item
names as well as values stored.2-10
Further Item Filtering >
Text Search - ANSWER-This will filter the items shown to only include items that store
the value
you searched for. 2-10
Null Values in Clarity - ANSWER-Any Clarity columns that is not a primary key can
contain null values. Even foreign keys may be null. Null values exist for several reasons:
Not all fields are populated in Chronicles ETL data cleansing deletes incorrectly
formatted data A column may no longer extract data because it is deprecated. 2-11
Item Editor - ANSWER-The Item Editor shows the definitions of a Chronicles item. 2-11
Category List - ANSWER-When using a category list value as a filter, the query can run
more efficiently when filtering on the
, category value itself rather than the name in the category list table. To find name to
display for a
particular value, you need to see the category list. 2-12
Add Type - ANSWER-An item's Add Type describes how long a piece of data is valid. It
determines whether an item's value is
stored on each contact, or directly to the record. 2-17
No-Add - ANSWER-No‐Add items store data directly on a record, not a specific contact.
The
value of a no‐add item should be considered true for all contacts on that
record. 2-18
Response Each Time - ANSWER-Response each time items store values separately on
each of a record's contacts. If a response each time item is blank for a certain contact, it
should be considered unknown. 2-18
Columns Tab-Useful Columns - ANSWER-Column Name, Chronicles info, Data type,
Deprecated?, Replacement columns, Column Description, Column Notes 3-7
Chronicles Info relationship between items: - ANSWER-The relationship between items
and columns is not one‐to‐one: a single Chronicles item can extract to
multiple columns in Clarity. 3-7
Where are Clarity column data types documented? - ANSWER-Clarity column data
types are documented in the Clarity Compass. 3-9
What 6 data types are used by Chronicles? - ANSWER-The data types used by
Chronicles are: 1)String, 2)Number, 3)Date, 4)Time, 5)Instant, and 6)Category. 3-9
Lookback - ANSWER-Lookback items store values separately on each contact, but
assume that the last value entered remains true until a new value is entered. 2-18
Response Type - ANSWER-An item's Response Type determines how many lines of
data an item can hold. 2-18
Single Response - ANSWER-Only one line of data can be stored per contact. 2-19
Multiple Response - ANSWER-Multiple lines of data can be stored per contact.
These lines might be discrete pieces of data, such as multiple symptoms, or they might
be multiple lines of a block of text, such as an address. 2-19
Related Group - ANSWER-Multiple lines of data can be stored per contact, and each
one of these lines is related to a line in another item. These lines might refer to a list of
relatives' names and their phone
numbers. 2-19
COMPLETE SOLUTIONS
Steps when receiving a Clarity Request - ANSWER-0. Identify the data elements you
will need for the report.
1. Find the INI + Item numbers of the data points to use on the report.
2. Use the INI + Item numbers to find the appropriate Clarity tables and columns.
3. Join the Clarity tables together using the correct foreign key information. 2-4
Item Information Window ﴾Ctrl + Click Method﴿ - ANSWER-The window can be
accessed when
a Hyperspace user knows the exact field within a workflow that stores the data they
want on a report. When you control‐left click on a data entry field in Hyperspace, the
Item Information window appears.
This window shows the INI and item number in which this data is stored, along with
other information
about the item as a whole. 2-6
Record Viewer - ANSWER-The Record Viewer is an activity in Hyperspace that
provides a read‐only view of raw data in Chronicles
record. 2-8
Contact Serial Number (CSN) - ANSWER-A Contact Serial Number or CSN will
uniquely identify a contact within a master file. 2-9
CTRL + F - ANSWER-This will bring up a search bar. The search bar will search
through item
names as well as values stored.2-10
Further Item Filtering >
Text Search - ANSWER-This will filter the items shown to only include items that store
the value
you searched for. 2-10
Null Values in Clarity - ANSWER-Any Clarity columns that is not a primary key can
contain null values. Even foreign keys may be null. Null values exist for several reasons:
Not all fields are populated in Chronicles ETL data cleansing deletes incorrectly
formatted data A column may no longer extract data because it is deprecated. 2-11
Item Editor - ANSWER-The Item Editor shows the definitions of a Chronicles item. 2-11
Category List - ANSWER-When using a category list value as a filter, the query can run
more efficiently when filtering on the
, category value itself rather than the name in the category list table. To find name to
display for a
particular value, you need to see the category list. 2-12
Add Type - ANSWER-An item's Add Type describes how long a piece of data is valid. It
determines whether an item's value is
stored on each contact, or directly to the record. 2-17
No-Add - ANSWER-No‐Add items store data directly on a record, not a specific contact.
The
value of a no‐add item should be considered true for all contacts on that
record. 2-18
Response Each Time - ANSWER-Response each time items store values separately on
each of a record's contacts. If a response each time item is blank for a certain contact, it
should be considered unknown. 2-18
Columns Tab-Useful Columns - ANSWER-Column Name, Chronicles info, Data type,
Deprecated?, Replacement columns, Column Description, Column Notes 3-7
Chronicles Info relationship between items: - ANSWER-The relationship between items
and columns is not one‐to‐one: a single Chronicles item can extract to
multiple columns in Clarity. 3-7
Where are Clarity column data types documented? - ANSWER-Clarity column data
types are documented in the Clarity Compass. 3-9
What 6 data types are used by Chronicles? - ANSWER-The data types used by
Chronicles are: 1)String, 2)Number, 3)Date, 4)Time, 5)Instant, and 6)Category. 3-9
Lookback - ANSWER-Lookback items store values separately on each contact, but
assume that the last value entered remains true until a new value is entered. 2-18
Response Type - ANSWER-An item's Response Type determines how many lines of
data an item can hold. 2-18
Single Response - ANSWER-Only one line of data can be stored per contact. 2-19
Multiple Response - ANSWER-Multiple lines of data can be stored per contact.
These lines might be discrete pieces of data, such as multiple symptoms, or they might
be multiple lines of a block of text, such as an address. 2-19
Related Group - ANSWER-Multiple lines of data can be stored per contact, and each
one of these lines is related to a line in another item. These lines might refer to a list of
relatives' names and their phone
numbers. 2-19
