ACING CLR 110 EXAMS WITH THE LATEST A+ QUESTIONS
AND ANSWERS GUIDE BOOK.
Upon receiving a report request you will typically
1. Identify the data elements you will need for the report
2. Find the INI and Item numbers of the data points to use on the report
3. Use the INI and item numbers to find the appropriate Clarity tables and columns
4. Join the Clarity tables together using the correct foreign key information
The INI and item number is the Chronicles address for a piece of data.
It is with this Chronicles address that you can map the data point to the appropriate
table and column in Clarity.
Chronicles Research
Activities to look up Chronicles data information:
Item Information window CTRL Click
Record Viewer
Item Editor
Category List Maintenance
Item Information Window CTRL Click
When you are provided instructions to get to a workflow in Hyperspace. Use the Ctrl
Click method to retrieve information.
Ctrl Left Click on the data entry field in Hyperspace, Item Information Window appears.
Ctrl Click Item Information Window
This window shows the INI and item number in which the data is stored, along with
other information about the item as a whole. Click more for item details such as add
type, response type, and networked INI if the item is networked.
Item Information Window - SQL
SQL column title and SQL description fields do NOT refer to Clarity or Caboodle
columns. These fields refer to the KB_SQL columns use in the the Clarity ETL process
Ctrl Click Web Based Information
When working with web based information windows the values listed under Table and
Column are Clarity tables and columns. When you click additional details you will open
the item editor activity to find our information such as add type and response type.
,Once you know the INI, Record ID and Contact for a piece of data you can use
__________ to find the INI and item number
Record Viewer
Record Viewer
is an activity in Hyperspace that provides a read only view of raw data in Chronicles
record. Shows all items on a particular contact of a particular record.
In order to view data you must specify the Masterfile, Record and Contact for the data
you want to see.
Record Viewer is the most convenient place to find _______ for a piece of data
INI and Item number
Record Viewer Information
Items that are part of a related group are displayed next to each other in a table.
Category items display both the value and name of the category they hold.
Networked Items display bothe the ID and the name of the record they network to.
Formatted data in Record Viewer
Data formatted in Record Viewer doesnt necessaritly translate to Clarity. The raw data
stored in Chronicles is only what is included inside the brackets. The value of the item
would be the number inside the brackets.
Null Values in Clarity
Clarity columns that are not primary keys can contain null values. Even foreign keys can
be null.
Null Values in Clarity 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.
Item Editor
The item editor shows the definitions of a Chronicles item. It doesnt show a particular
value stored in the item it shows information about how the item behaves for ALL
values.
Category List Maintenance
, 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 see a category list
Category values may be displayed in the item editor in the Category section. only the
first 100 values in the list.
To see the complete list use Category List Maintenance in Hyperspace.
Item Editor : Category List
Item editor can only show a limited selection of possible options.
Release Range
describes which category values are released by EPIC and cannot be changed.
Category List Maintenance
Provides a more complete look at the category list
Add Type
Describes how long a piece of data is valid. Determines whether an items value is
stored on each contact or directly to the record
No - Add
Stored directly on a record. Value should be considered as true for all contacts on the
record. If a No Add item does get changed the value is replaced.
Example: Patient Date of Birth
Response Each Time
Stores the value separately on each of the record contacts.
Example: Blood pressure collected on each visit. If not collected value will return blank
Lookback
stores item values separately on each contact but assumes the last value is true until a
new value is entered.
Example: Patients age, only updates if there is a change from the last time the patient
was seen.
Overtime Add types
Since both response each time and lookback items store data on the contact these add
types may be collectively referred to as over time add types.
Investigate Clarity
AND ANSWERS GUIDE BOOK.
Upon receiving a report request you will typically
1. Identify the data elements you will need for the report
2. Find the INI and Item numbers of the data points to use on the report
3. Use the INI and item numbers to find the appropriate Clarity tables and columns
4. Join the Clarity tables together using the correct foreign key information
The INI and item number is the Chronicles address for a piece of data.
It is with this Chronicles address that you can map the data point to the appropriate
table and column in Clarity.
Chronicles Research
Activities to look up Chronicles data information:
Item Information window CTRL Click
Record Viewer
Item Editor
Category List Maintenance
Item Information Window CTRL Click
When you are provided instructions to get to a workflow in Hyperspace. Use the Ctrl
Click method to retrieve information.
Ctrl Left Click on the data entry field in Hyperspace, Item Information Window appears.
Ctrl Click Item Information Window
This window shows the INI and item number in which the data is stored, along with
other information about the item as a whole. Click more for item details such as add
type, response type, and networked INI if the item is networked.
Item Information Window - SQL
SQL column title and SQL description fields do NOT refer to Clarity or Caboodle
columns. These fields refer to the KB_SQL columns use in the the Clarity ETL process
Ctrl Click Web Based Information
When working with web based information windows the values listed under Table and
Column are Clarity tables and columns. When you click additional details you will open
the item editor activity to find our information such as add type and response type.
,Once you know the INI, Record ID and Contact for a piece of data you can use
__________ to find the INI and item number
Record Viewer
Record Viewer
is an activity in Hyperspace that provides a read only view of raw data in Chronicles
record. Shows all items on a particular contact of a particular record.
In order to view data you must specify the Masterfile, Record and Contact for the data
you want to see.
Record Viewer is the most convenient place to find _______ for a piece of data
INI and Item number
Record Viewer Information
Items that are part of a related group are displayed next to each other in a table.
Category items display both the value and name of the category they hold.
Networked Items display bothe the ID and the name of the record they network to.
Formatted data in Record Viewer
Data formatted in Record Viewer doesnt necessaritly translate to Clarity. The raw data
stored in Chronicles is only what is included inside the brackets. The value of the item
would be the number inside the brackets.
Null Values in Clarity
Clarity columns that are not primary keys can contain null values. Even foreign keys can
be null.
Null Values in Clarity 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.
Item Editor
The item editor shows the definitions of a Chronicles item. It doesnt show a particular
value stored in the item it shows information about how the item behaves for ALL
values.
Category List Maintenance
, 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 see a category list
Category values may be displayed in the item editor in the Category section. only the
first 100 values in the list.
To see the complete list use Category List Maintenance in Hyperspace.
Item Editor : Category List
Item editor can only show a limited selection of possible options.
Release Range
describes which category values are released by EPIC and cannot be changed.
Category List Maintenance
Provides a more complete look at the category list
Add Type
Describes how long a piece of data is valid. Determines whether an items value is
stored on each contact or directly to the record
No - Add
Stored directly on a record. Value should be considered as true for all contacts on the
record. If a No Add item does get changed the value is replaced.
Example: Patient Date of Birth
Response Each Time
Stores the value separately on each of the record contacts.
Example: Blood pressure collected on each visit. If not collected value will return blank
Lookback
stores item values separately on each contact but assumes the last value is true until a
new value is entered.
Example: Patients age, only updates if there is a change from the last time the patient
was seen.
Overtime Add types
Since both response each time and lookback items store data on the contact these add
types may be collectively referred to as over time add types.
Investigate Clarity
