Health Services Data: Managing the Data Warehouse: 25 Years of Experience at the Manitoba Centre for Health Policy
The “Data Repository” at the Manitoba Centre for Health Policy (MCHP) is a cornerstone of the organization and one of the three “pillars” on which it stands (the other two being Research Program and Knowledge Translation). For 25 years, MCHP has maintained one of the most extensive collections of government administrative, survey, and clinical data holdings in the world, including everything from hospital and medical claims to child welfare services and educational enrolment and outcomes. Over 70 different government and clinical databases flow into the organization on an annual basis. This chapter outlines how the data are collected, organized, documented, managed, and accessed in a privacy protecting fashion for use by researchers in Canada, North America, and around the world. The research conducted by MCHP, which is located in the Rady Faculty of Health Sciences at the University of Manitoba, in addition to being relevant to policy and government decision makers is regularly published in leading academic journals. The chapter concludes with a discussion of the relative strengths of using a population-based longitudinal registry and some of the challenges faced in organizing and using available data for research purposes.
- Brownell M, Chartier M, Au W, Schultz J. Evaluation of the healthy baby program. 2010. http://mchp-appserv.cpe.umanitoba.ca/reference/MCHP-Healthy_Baby_Full_Report_WEB.pdf. Accessed 29 May 2013.
- Chartier M, Finlayson G, Prior H, McGowan K-L, Chen H, de Rocquigny J, Walld R, Gousseau M. Health and healthcare utilization of francophones in Manitoba. 2012. http://mchp-appserv.cpe.umanitoba.ca/reference/MCHP_franco_report_en_20120513_WEB.pdf. Accessed 29 May 2013.
- Chateau D, Doupe M, Walld R, Soodeen RA, Ouelette C, Rajotte L. Projecting personal care home bed equivalent needs in Manitoba through 2036. 2012. http://mchp-appserv.cpe.umanitoba.ca/reference/MCHP_pch_days_report_WEB.pdf. Accessed 29 May 2013.
- Daas PJH, Arends-Tóth J, Schouten B, Kuijvenhoven L, Statistics Netherlands. Quality framework for the evaluation of administrative data. 2008. http://www.pietdaas.nl/beta/pubs/pubs/21Daas.pdf
- Doupe M, Fransoo R, Chateau D, Dik N, Burchill C, Soodeen R-A, Bozat-Emre S, Guenette W. Population aging and the continuum of older adult care in Manitoba. 2011. http://mchp-appserv.cpe.umanitoba.ca/reference/LOC_Report_WEB.pdf. Accessed 29 May 2013.
- Fransoo R, Martens P, The Need to Know Team, Prior H, Burchill C, Koseva I, Bailly A, Allegro E. The 2013 RHA indicators atlas. 2013. http://mchp-appserv.cpe.umanitoba.ca/reference//RHA_2013_web_version.pdf. Accessed 20 Nov 2013.
- Martens PJ, Bartlett J, Burland E, Prior H, Burchill C, Huq S, Romphf L, Sanguins J, Carter S, Bailly A. Profile of metis health status and healthcare utilization in Manitoba: a population-based study. 2010. http://mchp-appserv.cpe.umanitoba.ca/reference/MCHP-Metis_Health_Status_Full_Report_(WEB)_(update_aug11_2011).pdf. Accessed 29 May 2013.
- Oreopoulos P, Stabile M, Walld R, et al. Short, medium, and long term consequences of poor infant health: an analysis using siblings and twins. J Hum Resour. 2008;43:88–138.Google Scholar
- SAS Institute Inc. SAS data integration studio 3.3: user’s guide. 2006. http://support.sas.com/documentation/onlinedoc/etls/usage33.pdf. Accessed 12 Aug 2014.