COG170: Cogito Fundamentals Exam
(Latest Update ) 100% Correct
Questions & Answer
Define: Record - Correct answer Recorders contain information about individual
entities within a master file.
Example:
A record in the patient master file contains information about a single patient. For
instances, a record in the orders master file contains information about a single order.
Records contain many contacts
Define: Contact - Correct answer Contacts are time-based
They contain information about points in time for a record.
Example
The patient master file uses contacts for patient encounters.
,Individual data within a record or contact are stored in items.
Define: Item - Correct answer Individual data within a record or contact are stored in
items.
They are data points (discrete data points)
Examples of items in a patient master file include social security number and
admission date.
Define: Lines - Correct answer Items that store multiple pieces of information at a
time have multiple lines.
Example
There is an item for diagnoses that has one line for each diagnosis entered.
,Define: Clarity - Correct answer A relational database designed to be efficient and
flexible for reporting on large amounts of data over long periods of time. It is
normalized and compact (small and efficient).
Data is stored in tables with two dimensional grids, rows and columns.
Each column holds a piece of information, similar to an item in Chronicles. Each row
represents an entity that the data in the columns are about.
Example: a table has one row for every patient encounter, and each column has
information about that patient encounter.
Clarity data is accessed using SQL or tools that use SQL.
Data for Clarity is extracted nightly thus, it does not contain today's data.
Define: Caboodle - Correct answer Similar to Clarity, relational database with tables of
rows and columns accessed via SQL
, Designed to make reporting simpler and efficient than Clarity.
As a data warehourse, it contains both Epic and non-Epic data
Clarity holds more data/information than Caboodle.
Similar to Clarity, Caboodle is not real-time information, it does not contain today's
data
Not all reports can be written in Caboodle.
Define: ETL - Correct answer ETL (Extract, Transform and Load)
Every night the Clairty ETL process transfers data from Chronicles to Clarity
Caboodle ETL Transfers data from Clarity to Caboodle the same night as the Clarity
ETL
(Latest Update ) 100% Correct
Questions & Answer
Define: Record - Correct answer Recorders contain information about individual
entities within a master file.
Example:
A record in the patient master file contains information about a single patient. For
instances, a record in the orders master file contains information about a single order.
Records contain many contacts
Define: Contact - Correct answer Contacts are time-based
They contain information about points in time for a record.
Example
The patient master file uses contacts for patient encounters.
,Individual data within a record or contact are stored in items.
Define: Item - Correct answer Individual data within a record or contact are stored in
items.
They are data points (discrete data points)
Examples of items in a patient master file include social security number and
admission date.
Define: Lines - Correct answer Items that store multiple pieces of information at a
time have multiple lines.
Example
There is an item for diagnoses that has one line for each diagnosis entered.
,Define: Clarity - Correct answer A relational database designed to be efficient and
flexible for reporting on large amounts of data over long periods of time. It is
normalized and compact (small and efficient).
Data is stored in tables with two dimensional grids, rows and columns.
Each column holds a piece of information, similar to an item in Chronicles. Each row
represents an entity that the data in the columns are about.
Example: a table has one row for every patient encounter, and each column has
information about that patient encounter.
Clarity data is accessed using SQL or tools that use SQL.
Data for Clarity is extracted nightly thus, it does not contain today's data.
Define: Caboodle - Correct answer Similar to Clarity, relational database with tables of
rows and columns accessed via SQL
, Designed to make reporting simpler and efficient than Clarity.
As a data warehourse, it contains both Epic and non-Epic data
Clarity holds more data/information than Caboodle.
Similar to Clarity, Caboodle is not real-time information, it does not contain today's
data
Not all reports can be written in Caboodle.
Define: ETL - Correct answer ETL (Extract, Transform and Load)
Every night the Clairty ETL process transfers data from Chronicles to Clarity
Caboodle ETL Transfers data from Clarity to Caboodle the same night as the Clarity
ETL
