220182 Building a Shared Data Warehouse for FQHC

Wednesday, November 10, 2010 : 8:45 AM - 9:00 AM

Lisa Schilling, MD, MSPH , Division of General Internal Medicine, University of Colorado School of Medicine, Aurora, CO
Arthur Davidson, MD, MSPH , Denver Public Health, Denver Health, Denver, CO
Dan Tuteur, MHSA , Executive Director, Colorado Community Managed Care Network, Denver, CO
Jason Greer , CACHIE, Program Director, Colorado Community Managed Care Network, Denver, CO
The Colorado Associated Community Health Information Exchange (CACHIE) is a HIT entity initiated to provide federally qualified health centers (FQHC) in Colorado with a clinical data warehouse (CDW) and the reporting tools to support reporting for mandated needs, quality improvement and benchmarking, clinical registries, and ad hoc end-user reporting.

The design of the CDW began with an exploration of end-user challenges and needs utilizing business process analysis methods at several FQHCs. Topics included (1) mandated and other reporting needs, (2) current reporting methods and tools, and (3) challenges and barriers. Interviewed FQHC partners desired a CDW that supported efficient and user-friendly reporting for identification of quality gaps, quality improvement initiative assessment, quality benchmarking across FQHCs, creation of clinical registries, mandated UDS reporting, and reporting to support policy, advocacy and funding proposals. Barriers and challenges varied by EHR vendor but included difficulty identifying and retrieving required data from EHR databases, limitations with retrospective queries, lack of uniform quality metric definitions among FQHCs, and costs. User and technical requirements were specified. Using diabetes and tobacco cessation reporting as the initial use cases, Phase1 included CDW design and extraction-transfer-load of required data for tobacco and diabetes, including identification of the required data types, standardized vocabularies, and query requirements, e.g., being able to aggregate data by provider, clinic site, or clinic. Beginning with a single EHR vendor employed at two FQHCs data profiling identified data location and data quality issues. A data mart was created to support rapid uniform queries of the data.

Learning Areas:
Clinical medicine applied in public health
Communication and informatics

Learning Objectives:
1. Describe the purpose of the data warehouse 2. Discuss the design and architecture 3. Describe the options for data exposure to end users Discuss design and data challenges

Keywords: Health Information Systems, Health Care Quality

Presenting author's disclosure statement:

Qualified on the content I am responsible for because: I have been participated in every step of this project
Any relevant financial relationships? No

I agree to comply with the American Public Health Association Conflict of Interest and Commercial Support Guidelines, and to disclose to the participants any off-label or experimental uses of a commercial product or service discussed in my presentation.