CDW110v Caboodle Data Model Fundamentals with Complete Solutions
1. What is the relationship between SlicerDicer is Epic's self-service report-
SlicerDicer and Caboodle? ing tool in Hyperspace that dynamically
queries Caboodle data.
2. Explain the relationship between The Cogito Dictionary reflects the
the dbo and FullAccess schemas. dbo schema. The FullAccess schema
contains almost everything in the
dbo schema (minus a few metada-
ta columns) plus additional columns
in some tables. Since FullAccess has
more data, report writers should use it
when writing queries. However, report
writers should also be familiar with dbo
due to its relationship with the Cogito
Dictionary.
3. True or False: A column can either False. A column can be both a prima-
be a primary key or a surrogate key, ry key (the column(s) used to uniquely
but not both. identify a row) and a surrogate key (a
key created during ETL that does not
exist in the source database). In Ca-
boodle, primary key columns are also
surrogate keys.
4. True or False: Naming conventions True. Naming conventions, such as
are enforced in Caboodle. <name>Fact, are enforced in Caboo-
dle.
5. Identify the Caboodle table and AllergyFact.AllergyKey
column for the following data
point: The Primary Key of Allergy-
Fact
6. Identify the Caboodle table and AllergyFact.Status
column for the following data
point: Allergy Status (LPL 3030)
7. AllergyFact.Severity
, CDW110v Caboodle Data Model Fundamentals with Complete Solutions
Identify the Caboodle table and
column for the following data
point: Allergy Severity (ECT 7150)
8. Identify the Caboodle table and AllergenDim.AllergenEpicId
column for the following data
point: Allergen's Epic ID (ELG .1)
9. Identify the Caboodle table and AllergenDim.Name
column for the following data
point: Allergen's Name (ELG .2)
10. Identify the Caboodle table and AllergyFact.FirstReaction
column for the following data
point: First Reaction (LPL 3008)
11. Identify the Caboodle table for the VisitFact
following SlicerDicer data model:
The Visits Data Model
12. Identify the Caboodle table for the ReceivedClaimFact
following SlicerDicer data model:
The AP Claims Data Model
13. Identify the Caboodle table for the ImagingFact
following SlicerDicer data model:
The Imaging Studies Data Model
14. Identify the Caboodle table for the LogisticsRequestJobFact
following SlicerDicer data model:
The Patient Transports Data Model
15. You are writing a report in Caboo- Search the Cogito Dictionary for "ORC
dle about surgeries. A colleague 50". To limit the search results to ONLY
on the OpTime team tells you that Caboodle, search "CB: ORC 50".
the patient is stored in I ORC 50.
What is the best way to determine
which Caboodle table and column
extracts this data?
1. What is the relationship between SlicerDicer is Epic's self-service report-
SlicerDicer and Caboodle? ing tool in Hyperspace that dynamically
queries Caboodle data.
2. Explain the relationship between The Cogito Dictionary reflects the
the dbo and FullAccess schemas. dbo schema. The FullAccess schema
contains almost everything in the
dbo schema (minus a few metada-
ta columns) plus additional columns
in some tables. Since FullAccess has
more data, report writers should use it
when writing queries. However, report
writers should also be familiar with dbo
due to its relationship with the Cogito
Dictionary.
3. True or False: A column can either False. A column can be both a prima-
be a primary key or a surrogate key, ry key (the column(s) used to uniquely
but not both. identify a row) and a surrogate key (a
key created during ETL that does not
exist in the source database). In Ca-
boodle, primary key columns are also
surrogate keys.
4. True or False: Naming conventions True. Naming conventions, such as
are enforced in Caboodle. <name>Fact, are enforced in Caboo-
dle.
5. Identify the Caboodle table and AllergyFact.AllergyKey
column for the following data
point: The Primary Key of Allergy-
Fact
6. Identify the Caboodle table and AllergyFact.Status
column for the following data
point: Allergy Status (LPL 3030)
7. AllergyFact.Severity
, CDW110v Caboodle Data Model Fundamentals with Complete Solutions
Identify the Caboodle table and
column for the following data
point: Allergy Severity (ECT 7150)
8. Identify the Caboodle table and AllergenDim.AllergenEpicId
column for the following data
point: Allergen's Epic ID (ELG .1)
9. Identify the Caboodle table and AllergenDim.Name
column for the following data
point: Allergen's Name (ELG .2)
10. Identify the Caboodle table and AllergyFact.FirstReaction
column for the following data
point: First Reaction (LPL 3008)
11. Identify the Caboodle table for the VisitFact
following SlicerDicer data model:
The Visits Data Model
12. Identify the Caboodle table for the ReceivedClaimFact
following SlicerDicer data model:
The AP Claims Data Model
13. Identify the Caboodle table for the ImagingFact
following SlicerDicer data model:
The Imaging Studies Data Model
14. Identify the Caboodle table for the LogisticsRequestJobFact
following SlicerDicer data model:
The Patient Transports Data Model
15. You are writing a report in Caboo- Search the Cogito Dictionary for "ORC
dle about surgeries. A colleague 50". To limit the search results to ONLY
on the OpTime team tells you that Caboodle, search "CB: ORC 50".
the patient is stored in I ORC 50.
What is the best way to determine
which Caboodle table and column
extracts this data?
