CDW110v
Caboodle
Data
Model
Fundamentals
Caboodle
Dictionary
-
ANS
Basic
metadata
for
tables.
Find
Descriptions
of
tables
and
columns
available
in
the
data
model.
Identify
tables
that
can
be
linked
together.
Caboodle
Dictionary
Editor
-
ANS
In
depth
view
of
Caboodle
ETL
packages
and
data
lineage.
Shows
Clarity
tables
data
that
is
extracted
from
when
populating
tables,
which
ETL
packages
are
used
by
Caboodle
tables
and
dependencies
amongst
the
tables
in
Caboodle.
Caboodle
Executions
-
ANS
Where
Caboodle
administrators
can
create,
edit,
run
and
monitor
executions.
Can
be
used
to
schedule
recurring
executions.
Caboodle
Work
Queues
-
ANS
Logs
the
different
types
of
issues
that
can
occur
during
the
ETL
process
that
require
manual
intervention
to
resolve.
Caboodle
configurations
-
ANS
modify
settings,
perform
customizations
such
as
adding
attributes
to
the
data
model
and
view
reports
related
to
Caboodle
configuration
and
operation.
Caboodle
BI
Developers
-
ANS
write
Caboodle
reports
and
should
have
access
to
the
Caboodle
Dictionary
on
the
Console.
Dictionary
provides
table
descriptions,
data
lineage
for
tables
and
columns
and
foreign
key
information.
BI
Developers
should
be
familiar
with
Caboodles
dimensional
data
model
and
at
least
one
area
of
healthcare
reportings
such
as
revenue
or
clinical
reporting.
Caboodle
Administrators
-
ANS
have
access
to
all
activities
on
the
Caboodle
Console.
Administrators
monitor
executions,
troubleshoot
work
queue
errors
and
establish
system
level
configurations.
Caboodle
ETL
Developers
-
ANS
create
custom
EPIC
and
n
on
Epic
content
for
extraction
into
the
data
warehouse,
document
their
work
in
the
dictionary
editor
and
test
their
work
using
the
ETL
tools
available
in
the
console.
Custom
development
notes
and
documentation
relevant
to
report
writers
will
be
visible
in
the
dictionary.
Why
use
Caboodle
-
ANS
Accessibility,
Efficiency
and
fewer
tables
and
simpler
joins.
SSIS
package
-
ANS
SQL
Server
Integration
packages
:
Data
is
extracted
from
source
systems
(Clarity)
transformed
in
the
staging
database
and
presented
for
users
in
the
reporting
database.
DMCs
-
ANS
Data
Model
Components Data
Model
Components
-
ANS
collection
of
metadata
tables
that
support
the
ETL
process
and
reporting
views
stored
in
the
FullAccess
schema.
DMC
type
and
suffixes
-
ANS
Each
DMC
gets
a
type
and
suffix.
Dim
for
dimensions,
Fact
for
facts,
Bridge
for
bridges,
Data
Mart
for
data
marts,
AttributeValueDim
for
EAV
tables,
X
for
custom
tables
Caboodle
Star
Schema
-
ANS
where
one
central
fact
table
will
join
to
many
associated
lookup
or
dimension
tables.
Dimensional
Data
Model
-
ANS
This
structure
intentionally
makes
some
compromises
to
the
normalized
data
model
used
by
Clarity
in
order
to
facilitate
report
writing.
The
trade
off
is
that
it
requires
a
more
complicated
ETL
process
to
maintain.
Caboodle
consists
of
a
reporting
database
and
a
staging
database
-
ANS
dbo
-
ANS
Staging
database:
import
tables
and
mapping
tables
live
here.
Used
by
administrators
for
moving
data
into
Caboodle.
Reporting
Database:
dbo
schema
stores
reporting
data
and
acts
as
the
data
source
for
SlicerDicer.
Caboodle
Dictionary
reflects
the
contents
of
the
dbo
schema
EPIC
-
ANS
Staging
Database:
Epic
schema
on
the
staging
database
contains
the
_IdLookup
tables,
which
map
source
IDs
to
system-generated
Caboodle
primary
keys
in
the
reporting
database.
Reporting
Database:
Prior
to
Epic
2018
this
schema
stored
the
tables
used
by
the
SlicerDicer
patients
data
model.
FullAccess
-
ANS
Staging
Database:
The
FullAccess
schema
does
not
exist
on
the
staging
database
Reporting
Database:
The
FullAccess
schema
houses
views
that
simplify
reporting.
FullAccess
should
be
your
default
schema
when
reporting.
DMC
-
ANS
Data
Model
Components
Business
Key
-
ANS
Identifier:
combination
of
columns
that
identify
records
Data
Lineage
-
ANS
A
precise
technical
explanation
of
where
data
in
a
package
is
extracted
from
in
a
source
database.
Durable
Key
-
ANS
An
identifier
for
a
record
in
Caboodle
shared
across
rows
for
the
same
record.
Example
a
single
patient
record
might
have
multiple
rows
associated
with
it
in
Patient
Dim.
Each
row
has
the
same
durable
key
to
make
it
easy
to
find
all
rows
associated.
Foreign
Key
-
ANS
the
primary
key
for
a
row
in
a
different
table
in
Caboodle,
used
to
link
two
tables
together.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller LECTDERRICK. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £9.41. You're not tied to anything after your purchase.
