AND ANSWERS GUIDE BOOK.
How to get to Item Information Window?
CTRL click any editable data entry field in Hyperspace
What does the Item Information Window contain?
INI and item number, clarity table and column, help text, additional details that links to
the Item Editor
Limitations of CTRL click
Doesn't work for all data points. Often doesn't work for read only fields
List methods for conducting Chronicles research
Item Information Window, Record Viewer, Item Editor, Category List Maintenance
Record viewer input needs
Master file, record, contact
Record viewer output
INI and item number
How is data displayed different in Chronicles vs Clarity for a category list?
Chronicles has category value and name, Clarity only has category value
How is the data extraction different in Caboodle vs Clarity when there is no value
entered in chronicles?
Caboodle would have -1 or -2, Clarity would just have Null
True or false: primary and foreign keys can be null in Clarity
False. Foreign keys can be null but primary cannot
What is the unique identifier for a record?
Record ID
What is the unique identifier for a line?
Line number
True or false: every master file contains CSNs
False, only some
What level is a CDR unique on?
Record level. So we also need Record ID to uniquely identify the contact
True or false: views and derived tables are results saved at ETL
, False. That is only true for derived tables, views just store the query
Item editor shows
Definitions and properties of a chronicles item. Doesn't show a particular value
Category list in item editor displays how many values?
100
Category list maintenance
Displays all values not just first 100
Release range
Either all customer owned or all categories. For if customer sets category values or if
epic does
No add type
Stores data directly on a record and is true for all contacts on that record
Response each time
Stores values separately on each contact
Look back
Stores values separately but last value is true until a new value is entered
Overtime Add Types
Response each time and look back
List the different response types
Single, multiple, related
Which two tools are used to find Clarity columns?
Clarity compass and cogito data dictionary
Where do you access the clarity compass?
Column Search, Database Object Search
What does the clarity compass do?
Sets definitions for how Chronicles items will translate into Clarity
True or false: the relationship between Chronicles items and Clarity columns is
one to one
False. And item can be extracted to multiple columns and a column can extract data
from multiple items
In what cases would there be no chronicles info in the column search?