Clarity CLR 110: Glossary
Extract File - CORRECT ANSWER-An extract file is a tab-delimited, flat text file (.EXT)
that collects specified data from the Epic production system and makes it available to be
loaded into the Clarity DBMS. These files are usually generated by KB_SQL queries on
the production side, which are then FTPed over to the Clarity server and loaded into the
reporting database.
Extracted Table - CORRECT ANSWER-Extracted tables are tables populated by the
standard Clarity ETL process.
Foreign Key - CORRECT ANSWER-Foreign keys are used to join tables together. The
columns used as foreign keys will define the relationship between the Clarity tables in
your report.
Full Outer Join - CORRECT ANSWER-This is the least restrictive join type and will
include everything you would get with a left outer join and a right outer join. You get one
record for each pair of records that match, plus one record for each record in each table
that do not match.
Inner Join - CORRECT ANSWER-his is the most restrictive and efficient type of linking.
You will only get rows from the left table that have one or more matching rows in the
right table.
Item - CORRECT ANSWER-A piece of data in Chronicles. It can be stored at the record
level or at the contact level. It is the fourth and last level of the Chronicles hierarchy.
Join Type - CORRECT ANSWER-When you want to report on entities whose
information is contained in multiple tables, you must join all the tables into one data set
that has columns from all the tables. When joining two tables there are four types of
joins that will determine which rows will get into the resulting data
set: inner join, left outer join, right outer join, and full outer join.
KB_SQL - CORRECT ANSWER-KB_SQL is a third-party product from Knowledge
Based (KB) Systems, Inc., that allows you to retrieve, analyze, and report on
information in Caché databases using SQL syntax.
Left Outer Join - CORRECT ANSWER-This join type is less restrictive than an inner join
and will include everything you would get with an inner join. You will also get all records
from the left table that do not match records in the right table.
