Using a Health System Corporate Data Warehouse for Research – Lessons from the VHA
Methods: This work describes the content and scope of the VHA CDW. The population represented in the data, temporal range and size of the database, various topical themes found in the data, sources of data documentation, diversity of potential units of analyses and strengths and limitations associated with the data are summarized. Illustrative examples of how these data are used in research and information about how to apply for access to these data are also included.
Results: These data can be used to inform studies ranging from the success of a new therapy to the wait times for a specific surgery to the average cost of care provided in outpatient clinics. Furthermore, the sheer volume of data (e.g., 8.49 million Veterans enrolled in the VHA and 86.4 million outpatient visits in fiscal year 2013) available in the CDW offers increased ability to focus on special populations, such as female Veterans or patients undergoing chemotherapy, within the VA. Studies can choose to focus on many varied units of analyses ranging a specific medication to mobile health care units to the patient.
Conclusion: The robustness of the CDW data affords researchers a sophisticated view of clinical, administrative and financial data associated with health care provided in hospitals, clinics and pharmacies across the nation. In the VHA, investment in an enterprise-wide data warehouse has already facilitated research on a number of topics and is creating an environment conducive to comparing health services use trends across systems with other health systems’ electronic medical record data.
Learning Areas:Communication and informatics
Describe the content of the newest and largest data source in the VA. Identify sources of additional instruction about the data warehouse. Evaluate whether or not this database is likely to be useful for a specific research project.
Keyword(s): Veterans' Health, Research
Qualified on the content I am responsible for because: I am the VIReC Center Director responsible for providing information to researchers about the utility of these data for research. I have also been a Principal investigator with extensive experience using these data in health services research.
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.