Questions
In Clarity, which of the following columns COULD contain a NULL
value? Correct Answer - A. A foreign key column that would
store the patient's primary care provider
B. A date column that would store the discharge date for an
encounter
C. A string column that stores a patient's email address
D. A numeric column that stores the patient's age in years 2-21
How to access Clarity Compass Correct Answer - Clarity
Compass which is accessed with two activities in Hyperspace:
Column Search
Database Object Search 3-5
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