Epic Caboodle Chapter Review
questions for match5
You need to filter on the date represented by a DateKey column to dates in the past decade.
What
is the recommended way to do this? - ANSWERS-Filter directly on the DateKey column
What is the purpose of surrogate key columns in Caboodle? - ANSWERS-To store Caboodle‐
specific identifiers
How are ProcedureDim.ProcedureKey and ProcedureDim.DurableKey different? - ANSWERS-
ProcedureKey is the primary key, and DurableKey identifies each procedure
Which ProcedureOrderFact column stores the Chronicles ID of each procedure order? -
ANSWERS-ProcedureOrderEpicId
What condition do you always apply when joining to tables that have a DurableKey column? -
ANSWERS-IsCurrent = 1
How can you identify a lookup column? - ANSWERS-It lists a table in the Links To field of the
Columns section in the Cogito Data Dictionary
In which database does all Epic data begin? - ANSWERS-Chronicles
Why can't a Caboodle report return a diagnosis made this morning? - ANSWERS-Caboodle
extracts data nightly
, A Caboodle table exists with the name of WoundAssessmentDataMart. What does each row
most
likely represent? - ANSWERS-A wound assessment
Assume your organization collects pharmacy data and hospital admission data through Epic and
collects hospital employee data using a non‐Epic system. Which of the following report requests
could be met with Caboodle but not with Clarity? - ANSWERS-Which hospital employees
worked the most hours during peak occupancy times
Suppose you're creating a report using EncounterFact and ProviderDim that displays the name
of
each provider for each encounter. If an encounter's data loads into EncounterFact, but that
provider's data hasn't been extracted to ProviderDim, what value would appear in
ProviderDim.Name for this encounter? - ANSWERS-*Unknown
A query filters PatientInfectionFact to only rows where InfectionStatus = N'Active'. Can this
query
return PatientInfectionFact rows that are inferred rows or PatientInfectionFact rows whose
source
data has been deleted? - ANSWERS-No
Suppose the department ID for an encounter was expected but was not present in the source
data.
After extracting the data to Caboodle, what value would appear in
DepartmentDim.DepartmentName when joining from EncounterFact.DepartmentKey to
DepartmentDim.DepartmentKey? - ANSWERS-*Unspecified
questions for match5
You need to filter on the date represented by a DateKey column to dates in the past decade.
What
is the recommended way to do this? - ANSWERS-Filter directly on the DateKey column
What is the purpose of surrogate key columns in Caboodle? - ANSWERS-To store Caboodle‐
specific identifiers
How are ProcedureDim.ProcedureKey and ProcedureDim.DurableKey different? - ANSWERS-
ProcedureKey is the primary key, and DurableKey identifies each procedure
Which ProcedureOrderFact column stores the Chronicles ID of each procedure order? -
ANSWERS-ProcedureOrderEpicId
What condition do you always apply when joining to tables that have a DurableKey column? -
ANSWERS-IsCurrent = 1
How can you identify a lookup column? - ANSWERS-It lists a table in the Links To field of the
Columns section in the Cogito Data Dictionary
In which database does all Epic data begin? - ANSWERS-Chronicles
Why can't a Caboodle report return a diagnosis made this morning? - ANSWERS-Caboodle
extracts data nightly
, A Caboodle table exists with the name of WoundAssessmentDataMart. What does each row
most
likely represent? - ANSWERS-A wound assessment
Assume your organization collects pharmacy data and hospital admission data through Epic and
collects hospital employee data using a non‐Epic system. Which of the following report requests
could be met with Caboodle but not with Clarity? - ANSWERS-Which hospital employees
worked the most hours during peak occupancy times
Suppose you're creating a report using EncounterFact and ProviderDim that displays the name
of
each provider for each encounter. If an encounter's data loads into EncounterFact, but that
provider's data hasn't been extracted to ProviderDim, what value would appear in
ProviderDim.Name for this encounter? - ANSWERS-*Unknown
A query filters PatientInfectionFact to only rows where InfectionStatus = N'Active'. Can this
query
return PatientInfectionFact rows that are inferred rows or PatientInfectionFact rows whose
source
data has been deleted? - ANSWERS-No
Suppose the department ID for an encounter was expected but was not present in the source
data.
After extracting the data to Caboodle, what value would appear in
DepartmentDim.DepartmentName when joining from EncounterFact.DepartmentKey to
DepartmentDim.DepartmentKey? - ANSWERS-*Unspecified
