A D ata W arehouse is a repository of historical data organized for reporting and analysis It facilitates data access by having data from many sources in one place linked together and easily searchable ID: 548219
Download Presentation The PPT/PDF document "Clinical Data Warehouse" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Clinical Data Warehouse
A
D
ata
W
arehouse
is a repository of historical data organized for reporting and analysis. It facilitates data access by having data from many sources in one place, linked together, and easily searchable.
The
Clinical Data Warehouse
is
A database containing clinical data from multiple sources
Data extracted from the databases of BMC’s clinical software packages
A database containing data related to each other with some unique identifier
A database that is only as good as the data enteredSlide2
CDW
Logician
SDK
PICIS
SCM
static
static
static
static
Daily/ Weekly
BMC Clinical Data Warehouse
Tumor Registry
Daily
IBEX
EWS
Weekly
EPIC
DailySlide3
Data currently available in the CDW
SDK – Registration and Visit Data
Logician – Outpatient DataSCM – Inpatient DataIBEX – ER DataPICIS – Surgery DataTumor RegistryIDX/EWS – Appointment SchedulingAnesthesia ManagerEPIC – Inpatient/ED as of May 22, 2014EPIC – Ambulatory as of May 5, 2015ICD-10 as of Oct 1, 2015Slide4
What kind of reports are available?
Recurring reports
One time data setsOnline reportsData countsCross-referenced dataData from a particular set of EPIC encounters, updated weeklySlide5Slide6
One Time Report – a misnomer
Complicated reports may take many iterations to get the complete data set.
The data provided are only as good as the request received.Provide ICD-9 codes when diagnoses are involved a request.Identify the source of the data if there is a known preference.Indicate if the request is a one-time data set or if there will be future request for the same data with different dates.Specify if there are multiple ways to denote a data item of interest.e.g., CIN I/CIN II/CIN III could also be listed as Mild/Moderate/Severe DysplasiaOften it is not until the researcher reviews a set of data that the request (and subsequent new report) can be refined to meet the study’s requirements – understand that the process is iterative.It is the researcher’s responsibility to understand the data.Ask questionsSlide7
Data Quality
Consider these examples:
Smoking historyPregnancy at a particular timeMedications active/inactiveProblem active/inactive