MODEL FUNDAMENTALS
ANSWER ALL QUESTIONS IN THIS SECTION
QUESTION 1
True or False
After you upgrade Epic to August 2018, your Epic and Caboodle versions must
always match. - ANSWERS-True
QUESTION 2
Why must you upgrade Caboodle at the same time as the rest of the Epic software?
- ANSWERS-because quarterly Caboodle releases target the Clarity data model
from the same quarterly Epic release.
QUESTION 3
What is "Dim" table naming convention? - ANSWERS-dimensions (e.g.
PatientDim)
QUESTION 4
What is "Fact" table naming convention? - ANSWERS-facts (e.g. EncounterFact)
END OF
PAGE 1
, CDW 110V CABOODLE DATA 2025
MODEL FUNDAMENTALS
QUESTION 5
What is "ProfileDim" table naming convention? - ANSWERS-profile dimensions
(e.g. VisitProfileDim)
QUESTION 6
What is "Bridge" table naming convention? - ANSWERS-bridges (e.g.
DiagnosisBridge)
QUESTION 7
What is "X" table naming convention? - ANSWERS-custom tables (e.g.
CustomFactX)
QUESTION 8
What is "Info" table naming convention? - ANSWERS-informational tables (e.g.
IdentityInfo)
END OF
PAGE 2
, CDW 110V CABOODLE DATA 2025
MODEL FUNDAMENTALS
QUESTION 9
What is "DataMart" table naming convention? - ANSWERS-data marts (e.g.
HospitalReadmissionDataMart)
QUESTION 10
what is DMC? - ANSWERS-Data Model Component
QUESTION 11
Define Data Model Component - ANSWERS-No table in Caboodle "stands alone".
They are surrounded and supported by a collection of various metadata tables.
QUESTION 12
How are the words "DMC" and "table" often used? - ANSWERS-they are often
used interchangeably when casually discussing Caboodle.
END OF
PAGE 3