CDW110V CABOODLE DATA MODEL
FUNDAMENTALS COMPREHENSIVE EXAM 2026
FULL QUESTIONS AND CORRECT ANSWERS
ALREADY PASSED
◉ True or False: The ER Diagram contains information that cannot
be found anywhere else in the Cogito Dictionary?
Answer: False. The ER Diagram is a visual representation of
information that can be found in the dictionary
◉ 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
◉ 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
◉ Identify the Caboodle table and column for the following data
point: Medications that are considered opioids
Answer: MedicationDim.Opioid
◉ True or False: Any change to patient data in Clarity will generate a
new row in PatientDim after the next extract.
FUNDAMENTALS COMPREHENSIVE EXAM 2026
FULL QUESTIONS AND CORRECT ANSWERS
ALREADY PASSED
◉ True or False: The ER Diagram contains information that cannot
be found anywhere else in the Cogito Dictionary?
Answer: False. The ER Diagram is a visual representation of
information that can be found in the dictionary
◉ 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
◉ 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
◉ Identify the Caboodle table and column for the following data
point: Medications that are considered opioids
Answer: MedicationDim.Opioid
◉ True or False: Any change to patient data in Clarity will generate a
new row in PatientDim after the next extract.
