CDW110v Caboodle Data Model Fundamentals
Study online at https://quizlet.com/_hgwy12
1. What is the relationship between SlicerDicer is Epic's self-service reporting tool in Hyper-
SlicerDicer and Caboodle? space that dynamically queries Caboodle data.
2. Explain the relationship between The Cogito Dictionary reflects the dbo schema. The Ful-
the dbo and FullAccess schemas. lAccess schema contains almost everything in the dbo
schema (minus a few metadata columns) plus addition-
al 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 primary key (the col-
be a primary key or a surrogate key, umn(s) used to uniquely identify a row) and a surrogate
but not both. key (a key created during ETL that does not exist in the
source database). In Caboodle, primary key columns
are also surrogate keys.
4. True or False: Naming conventions True. Naming conventions, such as <name>Fact, are
are enforced in Caboodle. enforced in Caboodle.
5. Identify the Caboodle table and col- AllergyFact.AllergyKey
umn for the following data point:
The Primary Key of AllergyFact
6. Identify the Caboodle table and col- AllergyFact.Status
umn for the following data point:
Allergy Status (LPL 3030)
7. Identify the Caboodle table and col- AllergyFact.Severity
umn for the following data point:
Allergy Severity (ECT 7150)
8. AllergenDim.AllergenEpicId
, CDW110v Caboodle Data Model Fundamentals
Study online at https://quizlet.com/_hgwy12
Identify the Caboodle table and col-
umn for the following data point:
Allergen's Epic ID (ELG .1)
9. Identify the Caboodle table and col- AllergenDim.Name
umn for the following data point:
Allergen's Name (ELG .2)
10. Identify the Caboodle table and col- AllergyFact.FirstReaction
umn 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 50". To limit the
dle about surgeries. A colleague search results to ONLY Caboodle, search "CB: ORC 50".
on the OpTime team tells you that
the patient is stored in I ORC 50.
What is the best way to determine
Study online at https://quizlet.com/_hgwy12
1. What is the relationship between SlicerDicer is Epic's self-service reporting tool in Hyper-
SlicerDicer and Caboodle? space that dynamically queries Caboodle data.
2. Explain the relationship between The Cogito Dictionary reflects the dbo schema. The Ful-
the dbo and FullAccess schemas. lAccess schema contains almost everything in the dbo
schema (minus a few metadata columns) plus addition-
al 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 primary key (the col-
be a primary key or a surrogate key, umn(s) used to uniquely identify a row) and a surrogate
but not both. key (a key created during ETL that does not exist in the
source database). In Caboodle, primary key columns
are also surrogate keys.
4. True or False: Naming conventions True. Naming conventions, such as <name>Fact, are
are enforced in Caboodle. enforced in Caboodle.
5. Identify the Caboodle table and col- AllergyFact.AllergyKey
umn for the following data point:
The Primary Key of AllergyFact
6. Identify the Caboodle table and col- AllergyFact.Status
umn for the following data point:
Allergy Status (LPL 3030)
7. Identify the Caboodle table and col- AllergyFact.Severity
umn for the following data point:
Allergy Severity (ECT 7150)
8. AllergenDim.AllergenEpicId
, CDW110v Caboodle Data Model Fundamentals
Study online at https://quizlet.com/_hgwy12
Identify the Caboodle table and col-
umn for the following data point:
Allergen's Epic ID (ELG .1)
9. Identify the Caboodle table and col- AllergenDim.Name
umn for the following data point:
Allergen's Name (ELG .2)
10. Identify the Caboodle table and col- AllergyFact.FirstReaction
umn 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 50". To limit the
dle about surgeries. A colleague search results to ONLY Caboodle, search "CB: ORC 50".
on the OpTime team tells you that
the patient is stored in I ORC 50.
What is the best way to determine
