Instructions for exporting data using MCHP Export.accdb

This article contains the instructions to generate data for Manitoba Centre for Health Policy export using MCHP Export.accdb

Instructions

open MCHP Export.accdb
edit the code to set the date range and accommodate any data structure changes that might have occurred since the last export
Click the "Run MCHP Export" button
delete the modules and forms, they contain Passwords

review MCHP_Cleanup to make sure there are no big outstanding questions that will make our data look bad
zip the MCHP Export.accdb and password protected and then copy to a memory stick or CD
- Hand carry the memory stick or CD to Dave Towns, Senior Data Management Analyst, of Manitoba Centre for Health Policy (MCHP), Dept of Community Health Sciences, University of Manitoba and email the password to him (Dave_Twons@cpe.umanitoba.ca.
zip the PHI.mdb and password protected
- send password encrypted PHI.mdb via MHSAL’s secure file transfer system to Jason Berry, A/Director, of Information Management and Governance Unit, Information Management and Analytics, Resources and Performance, Manitoba Health, Healthy Living & Seniors (4041 -300 Carlton Street, Winnipeg MB R3B 3M9) and email the password to him (Jason.Berry@gov.mb.ca); Manitoba Health with de-identify the data and pass it on to MCHP. Julie has an account to MHSAL secure file transfer system.