Clinical Research Data Warehouse (CRDW)

Clinical Research Data Warehouse (CRDW)

The i2b2 Cohort Discovery Tool provides an easy-to-use, self-service method for MCW researchers to query the CTSI’s Clinical Research Data Warehouse (CRDW) to answer the question “Does the CRDW contain a cohort of patients with certain characteristics?”. Search criteria can include patient demographics, ICD-9 coded diagnoses, CPT and HCPCS coded procedures, laboratory test results, medication orders by class or ingredient, clinical encounter metadata and MCW Tissue Bank biospecimen variables.

i2b2 queries return an approximate number of distinct patients matching the search criteria.  No patient identifiers are revealed.  All i2b2 users create their own library of queries which can be re-run as the data warehouse expands or re-used as components within new queries.

The Froedtert Health System (FH) and Children’s Hospital of Wisconsin (CHW) have separate data warehouses and toolsets.  Generally, the FH system contains ~10% children and CHW contains ~10% adults.

All completed i2b2 queries transmit to the CTSI’s Honest Broker data extraction tools which are also separate for FH and CHW.  These toolsets enables research teams to generate pre-defined data tables in de-identifed form to facilitate cohort feasibility or retrospective data analysis.  Research teams with an approved MCW or CHW IRB protocol are allowed to request identified data tables from their respective IRB for a variety of projects.

Hypotheses and Feasibility vs. Data Content

Until very recently, EMR systems like Epic have been primarily designed to improve patient safety, clinical workflow management and billing compliance. Using this data for research purposes can be challenging. We strongly encourage researchers to meet with us in the early stages of a project to gauge the feasibility of clinical queries and to help identify any nuances in the clinical data that could affect their interpretation of the data.

Examples of Clinical Data Types Available

0
2017 Fact Count
Patients
0
FH
0
CHW
Patient Encounters
0
FH
0
CHW
Diagnosis ICD9
0
FH
0
CHW
Allergies
0
FH
0
CHW
Family History
0
FH
0
CHW
Immunizations
0
FH
0
CHW
Medications
0
FH
0
CHW
Laboratory Results
0
FH
0
CHW
Lifestyle *
0
FH
0
CHW
Providers
0
FH
0
CHW
Procedures
0
FH
0
CHW
Flowsheets
0
FH
0
CHW

* Lifestyle (tobacco, alcohol, drugs, and contraceptives)

NIH Funding Acknowledgment: Important Reminder – Please acknowledge the NIH when publishing papers, patents, projects, and presentations resulting from the use of CTSI resources by including the NIH Funding Acknowledgement.

PARTNERS

Zablocki VA Medical CenterMedical College of WisconsinMSOE