Instructions for exporting data using MCHP Export.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m |
Ttenbergen (talk | contribs) m changed to .accdb |
||
| Line 4: | Line 4: | ||
=== Preparations === | === Preparations === | ||
Copy the following files all to one folder: | Copy the following files all to one folder: | ||
* a [[centralized_data_front_end. | * a [[centralized_data_front_end.accdb]] with up-to-date created_variables | ||
* [[Centralized_data.mdb]] | * [[Centralized_data.mdb]] | ||
* [[PHI.mdb]] | * [[PHI.mdb]] | ||
Revision as of 22:47, 2017 June 11
This article contains the instructions to generate data for Manitoba Centre for Health Policy export using MCHP Export.mdb
Instructions
Preparations
Copy the following files all to one folder:
- a centralized_data_front_end.accdb with up-to-date created_variables
- Centralized_data.mdb
- PHI.mdb
- CCMDB.mdb
- Legacy TMS Data.mdb
- TISS28_Data.mdb
generating the export file
- open
- run the Function Process_MCHP()
- delete the modules and forms, they contain Passwords
sending
- copy MCHP Export.mdb to a memory stick or CD
- send the memory stick or CD to Jason Berry, Privacy Policy Analyst, of Information Management and Analytics, Manitoba Health, Healthy Living & Seniors (4040D -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.