CLR 110 Clarity Data Set UPDATED
ACTUAL Questions and CORRECT
Answers
Steps when receiving a Clarity Request - CORRECT 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﴿ - CORRECT 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 - CORRECT 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) - CORRECT ANSWER - A Contact Serial Number or CSN
will uniquely identify a contact within a master file. 2-9
CTRL + F - CORRECT 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 - CORRECT ANSWER - This will filter the items shown to only include
items that store the value
you searched for. 2-10
Null Values in Clarity - CORRECT 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 - CORRECT ANSWER - The Item Editor shows the definitions of a
Chronicles item. 2-11
Category List - CORRECT 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 - CORRECT 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 - CORRECT 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 - CORRECT 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
ACTUAL Questions and CORRECT
Answers
Steps when receiving a Clarity Request - CORRECT 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﴿ - CORRECT 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 - CORRECT 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) - CORRECT ANSWER - A Contact Serial Number or CSN
will uniquely identify a contact within a master file. 2-9
CTRL + F - CORRECT 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 - CORRECT ANSWER - This will filter the items shown to only include
items that store the value
you searched for. 2-10
Null Values in Clarity - CORRECT 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 - CORRECT ANSWER - The Item Editor shows the definitions of a
Chronicles item. 2-11
Category List - CORRECT 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 - CORRECT 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 - CORRECT 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 - CORRECT 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
