1|Page
CDW110V CABOODLE DATA MODEL
FUNDAMENTALS EXAM NEWEST 2026 ACTUAL
EXAM TEST BANK| COMPLETE 300 REAL EXAM
QUESTIONS AND CORRECT VERIFIED ANSWERS/
ALREADY GRADED A+ (BRAND NEW!!)
Identify the Caboodle table and column for the following data point:
Encounter's Epic CSN - ANSWER - EncounterFact.EncounterEpicCsn
Identify the Caboodle table and column for the following data point:
Type - ANSWER - EncounterFact.Type
Identify the Caboodle table and column for the following data point:
Patient's name - ANSWER - PatientDim.Name
Identify the Caboodle table and column for the following data point: The
patient's age in years - ANSWER - DurationDim.YearsDisplayString
Identify the Caboodle table and column for the following data point:
Provider's name (SER .2) - ANSWER - ProviderDim.Name
Identify the Caboodle table and column for the following data point:
Provider's primary specialty - ANSWER -
ProviderDim.PrimarySpecialty
pg. 1
,2|Page
Identify the Caboodle table and column for the following data point: The
department's name (DEP .2) - ANSWER - DepartmentDim.Name
Identify the Caboodle table and column for the following data point: The
patient's name - ANSWER - PatientDim.Name
Identify the Caboodle table and column for the following data point: The
date of the Encounter - ANSWER - EncounterFact.Date
Identify the Caboodle table and column for the following data point:
Column used to find Office Visits (I EPT 30) - ANSWER -
EncounterFact.Type = 'Office Visit'
Identify the Caboodle table and column for the following data point:
Column used to identify office visits that have been completed (I EPT
87318) - ANSWER - EncounterFact.DerivedEncounterStatus =
'Complete'
Identify the Caboodle table and column for the following data point: The
patient's MRN - ANSWER - PatientDim.PrimaryMrn
Identify the Caboodle table and column for the following data point: The
patient's name - ANSWER - PatientDim.Name
pg. 2
,3|Page
Identify the Caboodle table and column for the following data point:
Medications that are considered opioids - ANSWER -
MedicationDim.Opioid
What is the difference between a MappingFact table and a Bridge table?
- ANSWER - Both are used to map many-to-many relationships,
however, Bridge table always link to a Dimension table while
MappingFact tables link to Fact tables.
What two columns do all Bridge tables have? - ANSWER - Every
Bridge table has a Combo key to which other tables join, and a foreign
key to join to its associated Dim table.
What Chronicles Data structure underlies many of the EAV tables in
Caboodle? - ANSWER - SmartData Element data stored in the HLV
master file in Chronicles.
What is the granularity of MedicationOrderFact? - ANSWER - An order.
What Clarity table acts as the primary source for data in EpisodeFact? -
ANSWER - Episode.
What is the granularity of DepartmentDim? - ANSWER - Granularity: A
bed, room, room group, care area, submitter, department, location,
service area, or business segment
pg. 3
, 4|Page
Identify the Caboodle table and column for the following data point: The
Epic ID for the medication order - ANSWER -
MedicationOrderFact.MedicationOrderEpicId
Identify the Caboodle table and column for the following data point: The
date the order was placed - ANSWER - DateDim.DisplayString
Identify the Caboodle table and column for the following data point: The
name of the department - ANSWER - DepartmentDim.Name
Identify the Caboodle table and column for the following data point: The
PatientKey for the inferred rows - ANSWER - PatientDim.PatientKey
Identify the Caboodle table and column for the following data point: The
medication's generic name - ANSWER - MedicationDim.GenericName
Identify the Caboodle table and column for the following data point: The
medication's Epic ID - ANSWER - MedicationDim.MedicationEpicID
Identify the Caboodle table and column for the following data point:
Column to identify inferred patients - ANSWER -
PatientDim._IsInferred
pg. 4
CDW110V CABOODLE DATA MODEL
FUNDAMENTALS EXAM NEWEST 2026 ACTUAL
EXAM TEST BANK| COMPLETE 300 REAL EXAM
QUESTIONS AND CORRECT VERIFIED ANSWERS/
ALREADY GRADED A+ (BRAND NEW!!)
Identify the Caboodle table and column for the following data point:
Encounter's Epic CSN - ANSWER - EncounterFact.EncounterEpicCsn
Identify the Caboodle table and column for the following data point:
Type - ANSWER - EncounterFact.Type
Identify the Caboodle table and column for the following data point:
Patient's name - ANSWER - PatientDim.Name
Identify the Caboodle table and column for the following data point: The
patient's age in years - ANSWER - DurationDim.YearsDisplayString
Identify the Caboodle table and column for the following data point:
Provider's name (SER .2) - ANSWER - ProviderDim.Name
Identify the Caboodle table and column for the following data point:
Provider's primary specialty - ANSWER -
ProviderDim.PrimarySpecialty
pg. 1
,2|Page
Identify the Caboodle table and column for the following data point: The
department's name (DEP .2) - ANSWER - DepartmentDim.Name
Identify the Caboodle table and column for the following data point: The
patient's name - ANSWER - PatientDim.Name
Identify the Caboodle table and column for the following data point: The
date of the Encounter - ANSWER - EncounterFact.Date
Identify the Caboodle table and column for the following data point:
Column used to find Office Visits (I EPT 30) - ANSWER -
EncounterFact.Type = 'Office Visit'
Identify the Caboodle table and column for the following data point:
Column used to identify office visits that have been completed (I EPT
87318) - ANSWER - EncounterFact.DerivedEncounterStatus =
'Complete'
Identify the Caboodle table and column for the following data point: The
patient's MRN - ANSWER - PatientDim.PrimaryMrn
Identify the Caboodle table and column for the following data point: The
patient's name - ANSWER - PatientDim.Name
pg. 2
,3|Page
Identify the Caboodle table and column for the following data point:
Medications that are considered opioids - ANSWER -
MedicationDim.Opioid
What is the difference between a MappingFact table and a Bridge table?
- ANSWER - Both are used to map many-to-many relationships,
however, Bridge table always link to a Dimension table while
MappingFact tables link to Fact tables.
What two columns do all Bridge tables have? - ANSWER - Every
Bridge table has a Combo key to which other tables join, and a foreign
key to join to its associated Dim table.
What Chronicles Data structure underlies many of the EAV tables in
Caboodle? - ANSWER - SmartData Element data stored in the HLV
master file in Chronicles.
What is the granularity of MedicationOrderFact? - ANSWER - An order.
What Clarity table acts as the primary source for data in EpisodeFact? -
ANSWER - Episode.
What is the granularity of DepartmentDim? - ANSWER - Granularity: A
bed, room, room group, care area, submitter, department, location,
service area, or business segment
pg. 3
, 4|Page
Identify the Caboodle table and column for the following data point: The
Epic ID for the medication order - ANSWER -
MedicationOrderFact.MedicationOrderEpicId
Identify the Caboodle table and column for the following data point: The
date the order was placed - ANSWER - DateDim.DisplayString
Identify the Caboodle table and column for the following data point: The
name of the department - ANSWER - DepartmentDim.Name
Identify the Caboodle table and column for the following data point: The
PatientKey for the inferred rows - ANSWER - PatientDim.PatientKey
Identify the Caboodle table and column for the following data point: The
medication's generic name - ANSWER - MedicationDim.GenericName
Identify the Caboodle table and column for the following data point: The
medication's Epic ID - ANSWER - MedicationDim.MedicationEpicID
Identify the Caboodle table and column for the following data point:
Column to identify inferred patients - ANSWER -
PatientDim._IsInferred
pg. 4
