CLR 110 Clarity Data Set questions with accurate
answers
"internal format" Ans✓✓✓ number of days since 12/31/1840 or number
of seconds since midnight 3-9
2 Tools Used in Clarity ETL Process Ans✓✓✓ Clarity Compass, Clarity
Console 3-17
A manager needs to know who has made changes to patient
demographics in the last six months.
Will Caboodle likely be able to meet this report request? Ans✓✓✓ No.
snapshot change tracking does not track who made a change. 6-14
ACCESS_LOG and ACCESS_WRKF Ans✓✓✓ Tables used to see what
a specific user is doing in the system, or has accessed certain patient's
data. 6-12
Add Type Ans✓✓✓ An item's Add Type describes how long a piece of
data is valid. It determines whether an item's value is
stored on each contact, or directly to the record. 2-17
Add Type Ans✓✓✓ Indicates if data is stored on a record or
on a contact in the record. Categorized as either No‐Add or
Overtime ﴾Response Each Time or
Lookback﴿
,No‐Add: stored on the record.
Always considered "current".
Overtime: stored on the contact. 4-6
Add Type: No-Add, Response Type: Multiple/Related Ans✓✓✓
RECORD_ID, LINE 4-12
Add Type: No-Add, Response Type: Single Ans✓✓✓ RECORD_ID 4-
12
Add Type: Overtime, Response Type: Multiple/Related Ans✓✓✓ CSN,
LINE or RECORD_ID, CDR, LINE 4-12
Add Type: Overtime, Response Type: Single Ans✓✓✓ CSN or
RECORD_ID, CDR 4-12
All data in a single extracted table in Clarity typically come from items
with the same _________ and ___________ Ans✓✓✓ Add type,
Response type 4-12
All data in a single extracted table in Clarity typically come from the
same Chronicles: ______________ Ans✓✓✓ Master file 4-12
Audit Item Tables Ans✓✓✓ The set of tables that begin with
AUDIT_ITM, that are designed to audit any item in chronicles for which
auditing is turned on. 6-11
, Caboodle Packages Ans✓✓✓ Clarity is the source of Epic data for
Caboodle, and you are able to
see the SQL query that populates the load package for Epic data going
into Caboodle. 5-8
Categories are extracted as an ______________________ or
________________________ Ans✓✓✓ INTEGER, VARCHAR 3-9
Category List Ans✓✓✓ 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
find name to display for a
particular value, you need to see the category list. 2-12
Chronicles Info relationship between items: Ans✓✓✓ The relationship
between items and columns is not one‐to‐one: a single Chronicles item
can extract to
multiple columns in Clarity. 3-7
Clarity Compass Ans✓✓✓ Defines what Chronicles/production data will
be extracted
into which Clarity tables and columns. Defines the structure
of your Clarity tables, including primary keys. 3-17
answers
"internal format" Ans✓✓✓ number of days since 12/31/1840 or number
of seconds since midnight 3-9
2 Tools Used in Clarity ETL Process Ans✓✓✓ Clarity Compass, Clarity
Console 3-17
A manager needs to know who has made changes to patient
demographics in the last six months.
Will Caboodle likely be able to meet this report request? Ans✓✓✓ No.
snapshot change tracking does not track who made a change. 6-14
ACCESS_LOG and ACCESS_WRKF Ans✓✓✓ Tables used to see what
a specific user is doing in the system, or has accessed certain patient's
data. 6-12
Add Type Ans✓✓✓ An item's Add Type describes how long a piece of
data is valid. It determines whether an item's value is
stored on each contact, or directly to the record. 2-17
Add Type Ans✓✓✓ Indicates if data is stored on a record or
on a contact in the record. Categorized as either No‐Add or
Overtime ﴾Response Each Time or
Lookback﴿
,No‐Add: stored on the record.
Always considered "current".
Overtime: stored on the contact. 4-6
Add Type: No-Add, Response Type: Multiple/Related Ans✓✓✓
RECORD_ID, LINE 4-12
Add Type: No-Add, Response Type: Single Ans✓✓✓ RECORD_ID 4-
12
Add Type: Overtime, Response Type: Multiple/Related Ans✓✓✓ CSN,
LINE or RECORD_ID, CDR, LINE 4-12
Add Type: Overtime, Response Type: Single Ans✓✓✓ CSN or
RECORD_ID, CDR 4-12
All data in a single extracted table in Clarity typically come from items
with the same _________ and ___________ Ans✓✓✓ Add type,
Response type 4-12
All data in a single extracted table in Clarity typically come from the
same Chronicles: ______________ Ans✓✓✓ Master file 4-12
Audit Item Tables Ans✓✓✓ The set of tables that begin with
AUDIT_ITM, that are designed to audit any item in chronicles for which
auditing is turned on. 6-11
, Caboodle Packages Ans✓✓✓ Clarity is the source of Epic data for
Caboodle, and you are able to
see the SQL query that populates the load package for Epic data going
into Caboodle. 5-8
Categories are extracted as an ______________________ or
________________________ Ans✓✓✓ INTEGER, VARCHAR 3-9
Category List Ans✓✓✓ 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
find name to display for a
particular value, you need to see the category list. 2-12
Chronicles Info relationship between items: Ans✓✓✓ The relationship
between items and columns is not one‐to‐one: a single Chronicles item
can extract to
multiple columns in Clarity. 3-7
Clarity Compass Ans✓✓✓ Defines what Chronicles/production data will
be extracted
into which Clarity tables and columns. Defines the structure
of your Clarity tables, including primary keys. 3-17
