Epic caboodle how to#
Epic caboodle code#

Matching the records helps with validation/documentation. The new table should have companion records for each record in the original table, but the new table contains different attribute columns. In this scenario, you can create a Dimension table extension or a Fact table extension to go along with the original. If your reporting requires additional fields using the same grain as existing table, then a companion table is a good choice. Create an extended tableД¬reating a companion table is the most common form of extension.

Epic caboodle how to#

EpicвЂ™s documentation has details on how to set this up or your organizationвЂ™s Bluetree Analytics Specialist will be happy to help. This will make it difficult to identify which load added the records but will make linking to the table much simpler. When possible, match your identification scheme with the original loads to the table.

Epic caboodle code#

Is it one row per dispense, per attempted dispense, or per ordered dispense?Д«e careful that your new code doesnвЂ™t pull in records that have been loaded by other ETLs or create a plan for merging two data sources. Make sure you have the same granularity in your new code. Your DispenseMedFactExt was originally for internal dispenses, but now you want to include external pharmacy dispenses. Sometimes a table needs to be repurposed and new records need to be added. Creating a new load for an existing table You will need to work with Epic support if you intend to modify the core Caboodle tables without limiting your ability to implement future Caboodle updates. The most straightforward method of adding additional data to Caboodle is to add new columns to existing tables. Many of these ideas are applicable to any enterprise data warehouse, so even if you arenвЂ™t using Caboodle, read on! Adding columns to an existing table Next, IвЂ™ll discuss common scenarios for extending Caboodle and best practice recommendations. Do you have non-Epic billing software? Export it into Caboodle and report on it there! Is there a data sharing agreement with another organization? Use Caboodle to merge the two data streams into a single combined data repository. Any requests for non-Caboodle data are sent to the Clarity reporting team or requested as additional tables in Caboodle if they are expected to be requested frequently.Д¬aboodle can also accept external data sources.

One organization IвЂ™ve worked with has an entire research-focused department working out of Caboodle instead of Clarity. If your organization has decided, through a data governance process, that surgical cases start at вЂwheels across the thresholdвЂ™ or at вЂanesthesia start,вЂ™ that definition can be integrated in a custom вЂSurgeryStartвЂ™ column to ensure the policy is represented in reporting. Also, healthcare organizations can extend Caboodle to add tables or columns. ThereвЂ™s less confusion over which datetime field to use because there are fewer fields overall. Caboodle and extensionsД¬ompared to Clarity, Caboodle is simpler.

This breadth of data createsВ endlessВ possibilities for analysis,В butВ its data modelsВ lack prioritization based on relative importance or frequency of use.Д¬aboodleВ has a curated data model, designed to surface data elements most commonly needed for reporting.В Reports such as patient counts, procedure volumes, and medication totalsВ usuallyВ requireВ less time forВ analysis and use fewer tables than an identical report built in Clarity. Every field, button click, datetime, editвЂ¦ itвЂ™s available for storing and reporting. For many who work in Epic-focused analytics,В CaboodleВ has become a go-to source for analyzing large volumes of data.Д¬aboodleВ wasВ designed by Epic to work well with data visualization tools such as Tableau or Power BI.В As such, itвЂ™s aВ dimensionally modeled versionВ of Clarity that can be used toВ speed upВ report design andВ produce reusableВ development for similar requests.Д¬larity containsВ the dataВ recorded in your EMR, extracted and transformed from a hierarchical representation to a relational data model.