CLR110 COMPREHENSIVE EXAM QUESTIONS AND
ANSWERS GRADED A+
✔✔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 - ✔✔Three steps:
1. Find the INI and item number of the data point to use on the report.
2. Use the INI and item number to find the appropriate Clarity table and column.
3. Join the Clarity tables together using the correct foreign key
✔✔Clarity Tools - ✔✔Clarity Compass, Clarity Dictionary
✔✔Clarity Compass - ✔✔Used to set definitions for how Chronicles items will translate
into Clarity. Used by ETL admin to define the structure of Clarity tables. Useful to BI
developers to view mapping. Provides organization specific information about the Clarity
Database.
✔✔Clarity Column data types - ✔✔Documented in Clarity Compass:
Relational Format:
Strings become VARCHARS
Numbers become NUMERICS
Categories will be INTEGER or VARCHAR
Dates, times and instants will be DATETIME format. Extracted to a single column or
modified to include the default date and time.
Dates are extracted as midnight on the date.
Times are extracted as the time on 01/1/1900
✔✔Clarity Compass accessed by Column Search - ✔✔Search by Chronicles INI and
item number or Clarity Column Name
✔✔Columns tab (Clarity Compass) - ✔✔Column Name : Name of the column
Chronicles info: INI and item number that extracts data to the column
Data Type: The SQL data type of the column
, Deprecated? When a column is deprecated data is no longer extracted to it
Replacement Columns: Only appear for columns that are deprecated
Column Description: The Epic released notes on the column
Column Notes: the column notes documented by ETL administrator at your org.
Chronicles Info: relationship is not one to one. A single item can extract to multiple
columns.
✔✔Chronicles Info - ✔✔relationship is not one to one: a single Chronicles item can
extract to multiple columns
✔✔Clarity Columns can extract - ✔✔Data from a single Chronicles item
Data from multiple Chronicles item
Data not stored in a Chronicles item
Calculated data
✔✔When you see an empty grid - ✔✔The column extracts data not stored in Chronicles
item or the column extracts calculated data.
✔✔Database Object Search - ✔✔Search by table name or the name of another
database object.
Brings you to the summary tab in Clarity Compass
✔✔Table Summary Tab : Database Object Search - ✔✔within the table workspace
shows the Clarity Compass information that is relevant to the entire table
✔✔Overview Section- Database Object Search - ✔✔Top section of the summary form.
Displays the name of the table as well as Chronicles master file that table data is
extracted from.
✔✔Type of Database Object - ✔✔Type of table: Extracted, Derived Table, View and
Function
✔✔Load Frequency (Database Object Search) - ✔✔Refers to how often data gets
loaded into a specific Clarity table. The most common load frequencies are
INCREMENTAL, WEEKLY_ FULL and MONTHLY
✔✔Grouped Tables (Database Object Search) - ✔✔Grouped tables are extension
tables created when an original table has enough columns to warrant splitting it into
different tables.
Grouped tables have the same primary key and generally have the same table name
with a suffix of _2 _3
✔✔Description (Database Object Search) - ✔✔An Epic released description of the table
ANSWERS GRADED A+
✔✔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 - ✔✔Three steps:
1. Find the INI and item number of the data point to use on the report.
2. Use the INI and item number to find the appropriate Clarity table and column.
3. Join the Clarity tables together using the correct foreign key
✔✔Clarity Tools - ✔✔Clarity Compass, Clarity Dictionary
✔✔Clarity Compass - ✔✔Used to set definitions for how Chronicles items will translate
into Clarity. Used by ETL admin to define the structure of Clarity tables. Useful to BI
developers to view mapping. Provides organization specific information about the Clarity
Database.
✔✔Clarity Column data types - ✔✔Documented in Clarity Compass:
Relational Format:
Strings become VARCHARS
Numbers become NUMERICS
Categories will be INTEGER or VARCHAR
Dates, times and instants will be DATETIME format. Extracted to a single column or
modified to include the default date and time.
Dates are extracted as midnight on the date.
Times are extracted as the time on 01/1/1900
✔✔Clarity Compass accessed by Column Search - ✔✔Search by Chronicles INI and
item number or Clarity Column Name
✔✔Columns tab (Clarity Compass) - ✔✔Column Name : Name of the column
Chronicles info: INI and item number that extracts data to the column
Data Type: The SQL data type of the column
, Deprecated? When a column is deprecated data is no longer extracted to it
Replacement Columns: Only appear for columns that are deprecated
Column Description: The Epic released notes on the column
Column Notes: the column notes documented by ETL administrator at your org.
Chronicles Info: relationship is not one to one. A single item can extract to multiple
columns.
✔✔Chronicles Info - ✔✔relationship is not one to one: a single Chronicles item can
extract to multiple columns
✔✔Clarity Columns can extract - ✔✔Data from a single Chronicles item
Data from multiple Chronicles item
Data not stored in a Chronicles item
Calculated data
✔✔When you see an empty grid - ✔✔The column extracts data not stored in Chronicles
item or the column extracts calculated data.
✔✔Database Object Search - ✔✔Search by table name or the name of another
database object.
Brings you to the summary tab in Clarity Compass
✔✔Table Summary Tab : Database Object Search - ✔✔within the table workspace
shows the Clarity Compass information that is relevant to the entire table
✔✔Overview Section- Database Object Search - ✔✔Top section of the summary form.
Displays the name of the table as well as Chronicles master file that table data is
extracted from.
✔✔Type of Database Object - ✔✔Type of table: Extracted, Derived Table, View and
Function
✔✔Load Frequency (Database Object Search) - ✔✔Refers to how often data gets
loaded into a specific Clarity table. The most common load frequencies are
INCREMENTAL, WEEKLY_ FULL and MONTHLY
✔✔Grouped Tables (Database Object Search) - ✔✔Grouped tables are extension
tables created when an original table has enough columns to warrant splitting it into
different tables.
Grouped tables have the same primary key and generally have the same table name
with a suffix of _2 _3
✔✔Description (Database Object Search) - ✔✔An Epic released description of the table
