CDW 110V CABOODLE DATA MODEL
FUNDAMENTALS
True or False: A caboodle report may contain at most 1 conformed dimension? -
Answer -False. A Caboodle report can contain multiple conformed dimensions.
Which of the following can be populated by more than one package? - Answer -A
single table and a single row in a table.
When would a foreign key column in Caboodle contain a -1? - Answer -When the
foreign key in the source data was null and a value was expected.
Which tool(s) in the Caboodle console would be used most often by Caboodle report
writers? - Answer -Dictionary and the Dictionary editor.
True or False: Caboodle and Clarity can be used interchangeably? - Answer -False.
Caboodle and Clarity cannot be used interchangeably.
Which of the following types of columns would you find in a type 1 table? - Answer -
Surrogate key, foreign key, and a combo key.
Where does Epic data in Caboodle come from? - Answer -From Clarity, which gets its
data from Chronicles.
True or false: Only Epic can define SSIS packages to move data from Clarity to
Caboodle? - Answer -False. Caboodle developers can also SSIS packages to move
data from Clarity to Caboodle.
Caboodle is designed to... - Answer -Store Epic data, store non-Epic data, make
reporting easy, interoperate with SlicerDicer.
Caboodle is considered a normalized database. - Answer -False
Name three documentation resources for Caboodle resources. - Answer -Caboodle
dictionary, Reporting with Caboodle document, Caboodle ER diagram.
When writing reports, why is it better to use your organization's Caboodle console rather
than the console used in training? - Answer -Because the console can be highly
customized for your organization.
What is the surrogate key for MedicationOrderFact? - Answer -MedicationOrderKey
How are foreign keys documented in the Dictionary? - Answer -Table that link to or
from a given table are listed under properties, and hyperlinks to the destination table are
provided next to foreign key column descriptions.
, True or False: A maximum of one foreign key can exist between two tables in Caboodle.
- Answer -False. Multiple foreign keys can exist between two tables in Caboodle.
How can MedicationOrderFact join to PatientDim? - Answer -
MedicationOrderFact.PatientKey = PatientDim.PatientKey or
MedicationOrderFact.PatientDurableKey = PatientDim.PatientDurableKey
In Caboodle, can Fact tables be joined to other fact tables? - Answer -Yes, example
MedicationOrderFact can join to EncounterFact.
Which of the following would you expect to be stored in a dimension table? - Answer -
Users and Diagnosis Definitions
Which of the following are possible to do in Caboodle? - Answer -Joining a fact table to
another fact table, Fact table to dimension table, dimension table to dimension table, 2
different EAV dim table to an attribute dim table
True or False: Any change to Patient data in Clarity will generate a new row in
PatientDim after the next extract. - Answer -False, only changes in type 2 data would
result in a new row being generated.
True of false: The _Current view tables in the FullAccess schema contains a subset of
the rows contained in their corresponding type 2 tables. - Answer -True. _Current view
tables in the Fullaccess schema contain a subset of the rows contained in their
corresponding type 2 tables.
What is a durable key? - Answer -Type 2 tables have a durable key column which
stores the same value for all rows that correspond to the same entity. This allows for
grouping or summarizing data by the entity.
If a patient has a PCP assigned, but that providers' data hasn't been extracted to
ProviderDim, what value would appear in ProviderDim.name for this patient? - Answer -
*unknown (an inferred row)
A foreign key column in Caboodle contains the value -3. What could this mean? -
Answer -Either the data that once populated this row was deleted from the source, or
this is the -3 row, for which all foreign key columns are also -3.
If a foreign key is null in Clarity, what will appear in the corresponding column in
Caboodle? - Answer -If the foreign key was expected to have data, then a -1 will
appear in Caboodle to represent an unspecified value. If the foreign key was not
expected to contain data, then a -2 will appear in the row to represent a value that is not
applicable.
FUNDAMENTALS
True or False: A caboodle report may contain at most 1 conformed dimension? -
Answer -False. A Caboodle report can contain multiple conformed dimensions.
Which of the following can be populated by more than one package? - Answer -A
single table and a single row in a table.
When would a foreign key column in Caboodle contain a -1? - Answer -When the
foreign key in the source data was null and a value was expected.
Which tool(s) in the Caboodle console would be used most often by Caboodle report
writers? - Answer -Dictionary and the Dictionary editor.
True or False: Caboodle and Clarity can be used interchangeably? - Answer -False.
Caboodle and Clarity cannot be used interchangeably.
Which of the following types of columns would you find in a type 1 table? - Answer -
Surrogate key, foreign key, and a combo key.
Where does Epic data in Caboodle come from? - Answer -From Clarity, which gets its
data from Chronicles.
True or false: Only Epic can define SSIS packages to move data from Clarity to
Caboodle? - Answer -False. Caboodle developers can also SSIS packages to move
data from Clarity to Caboodle.
Caboodle is designed to... - Answer -Store Epic data, store non-Epic data, make
reporting easy, interoperate with SlicerDicer.
Caboodle is considered a normalized database. - Answer -False
Name three documentation resources for Caboodle resources. - Answer -Caboodle
dictionary, Reporting with Caboodle document, Caboodle ER diagram.
When writing reports, why is it better to use your organization's Caboodle console rather
than the console used in training? - Answer -Because the console can be highly
customized for your organization.
What is the surrogate key for MedicationOrderFact? - Answer -MedicationOrderKey
How are foreign keys documented in the Dictionary? - Answer -Table that link to or
from a given table are listed under properties, and hyperlinks to the destination table are
provided next to foreign key column descriptions.
, True or False: A maximum of one foreign key can exist between two tables in Caboodle.
- Answer -False. Multiple foreign keys can exist between two tables in Caboodle.
How can MedicationOrderFact join to PatientDim? - Answer -
MedicationOrderFact.PatientKey = PatientDim.PatientKey or
MedicationOrderFact.PatientDurableKey = PatientDim.PatientDurableKey
In Caboodle, can Fact tables be joined to other fact tables? - Answer -Yes, example
MedicationOrderFact can join to EncounterFact.
Which of the following would you expect to be stored in a dimension table? - Answer -
Users and Diagnosis Definitions
Which of the following are possible to do in Caboodle? - Answer -Joining a fact table to
another fact table, Fact table to dimension table, dimension table to dimension table, 2
different EAV dim table to an attribute dim table
True or False: Any change to Patient data in Clarity will generate a new row in
PatientDim after the next extract. - Answer -False, only changes in type 2 data would
result in a new row being generated.
True of false: The _Current view tables in the FullAccess schema contains a subset of
the rows contained in their corresponding type 2 tables. - Answer -True. _Current view
tables in the Fullaccess schema contain a subset of the rows contained in their
corresponding type 2 tables.
What is a durable key? - Answer -Type 2 tables have a durable key column which
stores the same value for all rows that correspond to the same entity. This allows for
grouping or summarizing data by the entity.
If a patient has a PCP assigned, but that providers' data hasn't been extracted to
ProviderDim, what value would appear in ProviderDim.name for this patient? - Answer -
*unknown (an inferred row)
A foreign key column in Caboodle contains the value -3. What could this mean? -
Answer -Either the data that once populated this row was deleted from the source, or
this is the -3 row, for which all foreign key columns are also -3.
If a foreign key is null in Clarity, what will appear in the corresponding column in
Caboodle? - Answer -If the foreign key was expected to have data, then a -1 will
appear in Caboodle to represent an unspecified value. If the foreign key was not
expected to contain data, then a -2 will appear in the row to represent a value that is not
applicable.
