COG170 COGITO FUNDAMENTALS LATEST 2026 EXAM
QUESTIONS AND SOLUTIONS GUARANTEE A+
✔✔Base - ✔✔Used to define the population in your SlicerDicer session. P. 3-14 - 3-15
Ex: Patients data model. Users can narrow down the population to only include patients
with specific relationships to them.
✔✔Criteria - ✔✔Often times the 1st pieces of the population that a user modifies. They
refine the population to only the desired records. P. 3-16
✔✔Measures - ✔✔Determine what function aggregates the data.
Ex: # at the top of the bar in a vertical bar graph. P. 3-18
Any time a user wants to see their data expressed as: A FUNCTION of a FILTER they
can accomplish this by adding a measure.
✔✔Slices - ✔✔Divides up the population into the appropriate buckets so you can view &
compare populations quickly.
Users select slices from the lsit of filters. After selecting a filter to slice on, they can
either:
1) specify what values for the filter should each get their own slice
2) Grab the top 10
3) Grab the bottom 10
4) Grab the top or bottom N records (where N si user specified) p. 3-17
✔✔Exclusive Criteria - ✔✔A population for whom the criterion is false. P. 3-16
✔✔Database - ✔✔An organized collection of data. P. 4-4
AKA: Data sources
The purpose of the database defines its structure.
All of Epic's data is stored in either Chronicles, Clarity, or Caboodle.
✔✔Data Lineage - ✔✔The origin of data as it flows from 1 database to another. Epic
data lineage starts with Chronicles.
1) Epic users enter data into Chronicles through Hyperspace
2) Clarity ETL transfers data from Chronicles to Clarity
, 3) Caboodle ETL transfers data from Clarity to Caboodle the same night as Clarity ETL.
P. 4-4
✔✔Chronicles - ✔✔Designed to be efficient for daily healthcare operations. Tree-like
structure. P. 4-4
✔✔Master File - ✔✔Chronicles is first divided into master files. These contain
information about a broad subject. Ex: the patient master file(INI) contains all patients'
medical records in Epic. P. 4-4
✔✔Record - ✔✔Contain information about individual entities within a master file. P. 4-4
✔✔Contact - ✔✔Contain information about points in time for a record.
Ex: the patient master file uses contacts for patient encounters. P. 4-4
✔✔Item - ✔✔Individual data points within a record or contact. P. 4-5
✔✔Clarity - ✔✔Stores data in the tables that look like 2D grids with rows & columns.
Each row represents an entity in the table, its columns each holds a piece of information
about the row. P. 4-5
Row: Entity
Column: Attribute
✔✔Caboodle - ✔✔A relational database designed to make reporting simpler & more
efficient than it is in Clarity. Caboodle is a data warehouse, meaning that it can hold
data from multiple sources. P. 4-5
Investigate using: Use the Caboodle Dictionary to find Caboodle tables & columns an
item or Clarity column is extracted to. P. 4-6.
✔✔ETL (Extract, Transform, Load) - ✔✔Process of transferring data from multiple
sources. P. 4-5
✔✔SQL - ✔✔A coding language used to generate sets of data from relational
databases such as Clarity.
✔✔Chronicles - ✔✔Stores current data entered by end-users in Hyperspace by storing
an entire patient's medical record in a single location. P.4-4
Divided by:
Master Files-->Records-->Contacts-->Items-->lines
✔✔Master File - ✔✔AKA: INI
QUESTIONS AND SOLUTIONS GUARANTEE A+
✔✔Base - ✔✔Used to define the population in your SlicerDicer session. P. 3-14 - 3-15
Ex: Patients data model. Users can narrow down the population to only include patients
with specific relationships to them.
✔✔Criteria - ✔✔Often times the 1st pieces of the population that a user modifies. They
refine the population to only the desired records. P. 3-16
✔✔Measures - ✔✔Determine what function aggregates the data.
Ex: # at the top of the bar in a vertical bar graph. P. 3-18
Any time a user wants to see their data expressed as: A FUNCTION of a FILTER they
can accomplish this by adding a measure.
✔✔Slices - ✔✔Divides up the population into the appropriate buckets so you can view &
compare populations quickly.
Users select slices from the lsit of filters. After selecting a filter to slice on, they can
either:
1) specify what values for the filter should each get their own slice
2) Grab the top 10
3) Grab the bottom 10
4) Grab the top or bottom N records (where N si user specified) p. 3-17
✔✔Exclusive Criteria - ✔✔A population for whom the criterion is false. P. 3-16
✔✔Database - ✔✔An organized collection of data. P. 4-4
AKA: Data sources
The purpose of the database defines its structure.
All of Epic's data is stored in either Chronicles, Clarity, or Caboodle.
✔✔Data Lineage - ✔✔The origin of data as it flows from 1 database to another. Epic
data lineage starts with Chronicles.
1) Epic users enter data into Chronicles through Hyperspace
2) Clarity ETL transfers data from Chronicles to Clarity
, 3) Caboodle ETL transfers data from Clarity to Caboodle the same night as Clarity ETL.
P. 4-4
✔✔Chronicles - ✔✔Designed to be efficient for daily healthcare operations. Tree-like
structure. P. 4-4
✔✔Master File - ✔✔Chronicles is first divided into master files. These contain
information about a broad subject. Ex: the patient master file(INI) contains all patients'
medical records in Epic. P. 4-4
✔✔Record - ✔✔Contain information about individual entities within a master file. P. 4-4
✔✔Contact - ✔✔Contain information about points in time for a record.
Ex: the patient master file uses contacts for patient encounters. P. 4-4
✔✔Item - ✔✔Individual data points within a record or contact. P. 4-5
✔✔Clarity - ✔✔Stores data in the tables that look like 2D grids with rows & columns.
Each row represents an entity in the table, its columns each holds a piece of information
about the row. P. 4-5
Row: Entity
Column: Attribute
✔✔Caboodle - ✔✔A relational database designed to make reporting simpler & more
efficient than it is in Clarity. Caboodle is a data warehouse, meaning that it can hold
data from multiple sources. P. 4-5
Investigate using: Use the Caboodle Dictionary to find Caboodle tables & columns an
item or Clarity column is extracted to. P. 4-6.
✔✔ETL (Extract, Transform, Load) - ✔✔Process of transferring data from multiple
sources. P. 4-5
✔✔SQL - ✔✔A coding language used to generate sets of data from relational
databases such as Clarity.
✔✔Chronicles - ✔✔Stores current data entered by end-users in Hyperspace by storing
an entire patient's medical record in a single location. P.4-4
Divided by:
Master Files-->Records-->Contacts-->Items-->lines
✔✔Master File - ✔✔AKA: INI
