Instructions for exporting data using MCHP Export.accdb

From CCMDB Wiki

Revision as of 22:47, 2017 June 11 by Ttenbergen (talk | contribs) (changed to .accdb)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

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.

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Instructions_for_exporting_data_using_MCHP_Export.accdb&oldid=56374"

MCHP