Instructions for exporting data using MCHP Export.accdb: Difference between revisions

Revision as of 14:59, 2019 August 15

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

	Do we want the exporting of PHI for MB Health to be a separate thing or a step in here? I don't want to generate it as a table in here and risk it being passed along to MCHP unencrypted. But if I generate it as an export to e.g. .csv I would need to know what format we need. Also, do we have the process for getting that encoded written on here somewhere else already? If not we should add it. Is the process only used for MCHP? If more general it should probably go on its own page and be linked. as far as I remember, I just simply zipped the PHI.mdb and encrypted, saved in CD and sent to MB Health via dept mail. Similarly, I zipped the MCHP_Export.mdb and encrypted, saved in CD and hand carried it to Dave Towns at MCHP. Can we not do the same? no need to have another separate export for PHI into another format (i.e. CSV or other).

review MCHP_Cleanup to make sure there are no big outstanding questions that will make our data look bad
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.

@@ Line 12: / Line 12: @@
 {{Discuss | who=Julie |question=
 * Do we want the exporting of PHI for MB Health to be a separate thing or a step in here? I don't want to generate it as a table in here and risk it being passed along to MCHP unencrypted. But if I generate it as an export to e.g. .csv I would need to know what format we need. Also, do we have the process for getting that encoded written on here somewhere else already? If not we should add it. Is the process only used for MCHP? If more general it should probably go on its own page and be linked.
+**as far as I remember, I just simply zipped the PHI.mdb  and encrypted, saved in CD and sent to MB Health via dept mail. Similarly, I zipped the MCHP_Export.mdb and encrypted, saved in CD and hand carried it to Dave Towns at MCHP.  Can we not do the same? no need to have another separate export for PHI into another format (i.e. CSV or other).
 }}
 * '''delete the modules and forms, they contain [[:Category:Password | Passwords]]'''