UAHS Clinical Data Warehouse


The UAHS Center for Biomedical Informatics and Biostatistics (CB2) constructed the Clinical Data Warehouse (CDW) to provide easily accessible data for planning and executing clinical and translational research and for quality of care and process improvement projects.

The CDW currently contains clinical data from the Banner University Medical Center (Tucson) from November 1, 2013 to September 30, 2017.

What is the CDW?

The CDW is the UAHS’s centralized, standardized, integrated repository of data extracted from numerous source systems including HIPAA-compliant electronic health record (EHR) information from the Banner University Medical Center - Tucson. With IRB approval, derivative data sets can be obtained in an identifiable, limited, or anonymized form according to HIPAA definitions.

How long does it take to complete a data request?

Due to subtle nuances in most data requests, once started it can take 4 - 8 weeks to complete a request from start to finish.

Please plan accordingly for data required in support of grants and publications.

What are the data points available in the CDW?

Because the warehouse does contain all the information from EPIC, providing an exhaustive list is not feasible, however the main subject areas include: Demographics, Encounters, Labs, Medications (2013-2017) Diagnoses (ICD-9), Procedures (CPT and ICD-9), problem lists (2013-2017), Allergy Information (2013-2017), and clinical narratives (surgery reports, pathology reports, discharge summaries).

What types of requests can be made?

The data warehouse team will process requests for data that are not considered part of clinical operations and include the following:

Process Improvement

This is not considered research, but if you have an idea that can improve cost / quality of patient care, you can request data to validate your hypothesis / idea.

Preparatory for Research

This type of request is used to assess the feasibility of a proposed study. They frequently take the form of the counts of patients matching certain characteristics to test for statistical significance.

De-Identified

For de-identified requests, all elements of PHI are removed and dates are shifted. The crosswalk between the anonymous identifier and the patient identifier is not maintained, so these are one-time extracts with no potential for future updates.

Coded Data Set

This request type is similar to the de-identified request except that the crosswalk between the anonymous patient identifier and the patient identifier is maintained by the UAHS data warehouse team. The crosswalk is never given to the investigator or anyone outside of the data warehousing team. With this type of request there is the potential to received updated data sets.

Limited Data Set

With this request type, actual dates and zip codes can be received, but no patient identifiers are disclosed. This requires signing a data use agreement with the HIPAA Privacy Office which oversees the disclosure of these data sets

Identified Data Set

IRB approval must be obtained for this type of data set and the investigator must demonstrate a need to have patient identifiers. Also, you may submit an IRB be protocol and obtain informed consent from patients to be able to access their data. This type of request can contain identifying patient information.

What does it cost to get data?

The hourly rate for completion of a data request is $79 for UAHS-affiliated faculty members. After submitting your request, a member of the UAHS Clinical Data Warehouse staff will meet with you to review your request and provide an estimate of the number of hours required to complete your project.

If I have questions about the Data Warehouse, how can I get them answered?

Please send an email to: uahs.datarequest@list.arizona.edu with your questions or to request an appointment with one of the UAHS data warehouse staff. The first hour of consultation is free of charge.