Investigating Clarity (2 of 2)

Question 1

What’s the difference between a Category List Table and a ZC Table?

Answer 1

There is no difference. Both names are referring to the same thing.

(Aug. 2021, 3.14)

Question 2

Where can you go to easily identify the correct category list table (ZC_ table)?

Answer 2

Look for header Category Lookup in the Columns section of the Summary tab in the Clarity Dictionary.

(Aug. 2021, 3.15)

Question 3

Where can you access the Clarity Dictionary if you don’t have access to Hyperspace?

Answer 3

The Clarity Dictionary can be found on the UserWeb through the Data Handbook.

(Aug. 2021, 3.15)

Question 4

If you don’t have access to Hyperspace, where would you go to identify category list tables?

Answer 4

The Clarity Dictionary on the UserWeb in the Foreign Key section.

(Aug. 2021, 3.16)

Question 5

What are the two main tools used in the Clarity ETL process?

Answer 5

1. Clarity Compass
   • Maps Chronicles items to Clarity tables and columns.
   • Stores table definitions
2. Clarity Console
   • Schedules the extract of defined tables from Chronicles to Clarity.

(Aug. 2021, 3.17)

Question 6

What does the load frequency of a table determine?

Answer 6

The load frequency of a table determines how often the data in the table is extracted from Chronicles to Clarity.

(Aug. 2021, 3.17)

Question 7

What is the most common load frequency?

Answer 7

INCREMENTAL. The INCREMENTAL load takes place nightly, so the data contained in most Clarity tables is updated every 24 hours.

(Aug. 2021, 3.17)

Question 8

List three load frequencies.

Answer 8

1. INCREMENTAL
2. WEEKLY
3. MONTHLY

(Aug. 2021, 3.17)

Question 9

Why is it important to know the extract frequencies of the tables that you’re using?

Answer 9

Different tables can have different load frequencies meaning some tables can be more up-to-date than others.

(Aug. 2021, 3.18)

Question 10

What type of join should you use if your joining two tables with different frequencies?

Answer 10

A left outer join may be needed to make sure the report returns the necessary data.

(Aug. 2021, 3.18)

Question 11

Why is the Report Repository considered a resource for Clarity research?

Answer 11

The Report Repository contains reference information for Epic-released and custom-written reports.

It is also a useful resource to investigate Clarity tables used in a similar report request.

(Aug. 2021, 3.16)

Question 12

What does it mean when a column is deprecated?

Answer 12

Data will no longer be extracted to it.

Aug. 2021, 3.19

Question 13

What causes a table or column be deprecated?

Answer 13

A deprecated column is a result of an Epic software update. Old items are retired and replaced with new items that behave more efficiently or in a more desired manner.

(Aug. 2021, 3.19)

Question 14

Does a deprecated table or column continue to exist in the Clarity database?

Answer 14

Yes. No new data will be extracted to it but it will still exist in the Clarity database.

(Aug. 2021, 3.19)

Question 15

What are two ways the Clarity Compass identifies deprecated columns?

Answer 15

1. By adding a Deprecated chip to the column Name
2. It is stated in the column Description

(Aug. 2021, 3.20)

Question 16

Who should you check with to determine what, if any, changes to Clarity may affect your reports after an upgrade?

Answer 16

The Clarity ETL Administrator.

Aug. 2021, 3.20

Question 17

What is the Compass Comparison for?

Answer 17

Prior to upgrade, your ETL administrator upgrades Clarity Compass E records in a separate environment. These new E records are then compared to existing C records using a tool called the Compass Comparison, which returns a list of new and changed tables and columns.

(Aug. 2021, 3.21)

Question 18

What does the Data Model Change Analyzer (DMCA) return?

Answer 18

The DMCA returns a list of reports that will be affected by these changes.

(Aug. 2021, 3.21)

Question 19

What stores a list of all possible database objects that can be extracted to the Clarity database?

Answer 19

The Clarity Compass.

Aug. 2021, 3.21

Question 20

Where does the Cogito Dictionary live?

Answer 20

In the Analytics Catalog.

Aug. 2021, 3.23

Question 21

When searching the Cogito Dictionary how do you specify which database you want to search?

Answer 21

To find Clarity and Caboodle tables in the Analytics Catalog, filter the catalog for a specific database using:
• CL:
• CB:

(Aug. 2021, 3.23)

Question 22

Does every Epic application have a set of core Clarity tables?

Answer 22

Yes

Aug. 2021, 3.27

Question 23

What do core Clarity tables contain?

Answer 23

The majority of reportable data points populated by workflows for that application.

(Aug. 2021, 3.27)

Question 24

True or False:

Every Clarity table has a list of the applications for which it is considered “core”.

Answer 24

True

Aug. 2021, 3.27

Question 25

Why wouldn’t you have access to every table in the Clarity database?

Answer 25

You will only have access to the tables that are core to the Epic applications you have licenses for.

(Aug. 2021, 3.27)

Question 26

How would you quickly determine whether a given table will be available in your clarity database?

Answer 26

Check the Custom field located in the Clarity Compass header section. If it says “Yes”, then the table has been configured for extraction to the Clarity database.

(Aug. 2021, 3.27)

Question 27

What is KB_SQL used to translate?

Answer 27

KB_SQL translates the data stored in Chronicles from M Script to the relational tables and columns of Clarity.

(Aug. 2021, 3.28)