Caboodle
caboodle - ANS Data warehouse, data source for slicer dicer, dimensional data model
Slicer Dicer - ANS Can be based on fact or dimension tables
Chronicles Database - ANS Hierarchical and real time
Clarity Database - ANS Relational, normalized data model
Caboodle Database - ANS Dimensional for ease of reporting and data exploration.
How does data get in to caboodle? - ANS Clarity and non- epic data go to Caboodle staging via
SSIS packages, then to caboodle reporting
dbo schema - ANS Caboodle dictionary, Slicer Dicer
Full Access Schema - ANS SQL reports
Primary Key - ANS Columns that uniquely ID a row
Examples: BirthFact.PrimaryKey, PatientDim.PatientKey
Durable Key - ANS Retains the same value across multiple rows in the same entity.
Example: PatientDim.DurableKey
Foreign Key - ANS Value that uniquely identifies a row in another table.
Example: BirthFact.MotherPatientKey
Durable Key Lookup - ANS BirthFact.MotherPatientDurableKey
Caboodle Dictionary - ANS Part of the caboodle console. Entries include properties, sources,
columns, and ER diagrams.
Contains basic table metadata. Used by BIDs.
Caboodle Console - ANS Contains dictionary editor, executions, the work queue, and
configuration. Used by caboodle admins for creating/managing executions and caboodle
developers for creating new data models.
Fact Tables - ANS Represent the occurrence of a specific measurable event.
MedicationOrderFact
caboodle - ANS Data warehouse, data source for slicer dicer, dimensional data model
Slicer Dicer - ANS Can be based on fact or dimension tables
Chronicles Database - ANS Hierarchical and real time
Clarity Database - ANS Relational, normalized data model
Caboodle Database - ANS Dimensional for ease of reporting and data exploration.
How does data get in to caboodle? - ANS Clarity and non- epic data go to Caboodle staging via
SSIS packages, then to caboodle reporting
dbo schema - ANS Caboodle dictionary, Slicer Dicer
Full Access Schema - ANS SQL reports
Primary Key - ANS Columns that uniquely ID a row
Examples: BirthFact.PrimaryKey, PatientDim.PatientKey
Durable Key - ANS Retains the same value across multiple rows in the same entity.
Example: PatientDim.DurableKey
Foreign Key - ANS Value that uniquely identifies a row in another table.
Example: BirthFact.MotherPatientKey
Durable Key Lookup - ANS BirthFact.MotherPatientDurableKey
Caboodle Dictionary - ANS Part of the caboodle console. Entries include properties, sources,
columns, and ER diagrams.
Contains basic table metadata. Used by BIDs.
Caboodle Console - ANS Contains dictionary editor, executions, the work queue, and
configuration. Used by caboodle admins for creating/managing executions and caboodle
developers for creating new data models.
Fact Tables - ANS Represent the occurrence of a specific measurable event.
MedicationOrderFact
