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

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
m changed to .accdb
mNo edit summary
Line 3: Line 3:
== Instructions ==
== Instructions ==
=== Preparations ===
=== Preparations ===
Copy the following files all to one folder:
# [[Pull]] down the data to the usual location
* a [[centralized_data_front_end.accdb]] with up-to-date created_variables
# copy [[MCHP Export.mdb]] to the same location
* [[Centralized_data.mdb]]
* [[PHI.mdb]]
* CCMDB.mdb
* [[Legacy TMS Data.mdb]]
* TISS28_Data.mdb


=== generating the export file ===
=== generating the export file ===
* open
* open [[MCHP Export.mdb]]
* run the Function Process_MCHP()
* Click the "Run MCHP Export" button
 
{{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.
}}
* '''delete the modules and forms, they contain [[:Category:Password | Passwords]]'''
* '''delete the modules and forms, they contain [[:Category:Password | Passwords]]'''


=== sending ===
=== sending ===
* 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
* 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.
* 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.
== Related articles ==
{{Related Articles}}


[[Category: MCHP]]
[[Category: MCHP]]

Revision as of 15:41, 2019 August 14

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

Instructions

Preparations

  1. Pull down the data to the usual location
  2. copy MCHP Export.mdb to the same location

generating the export file

  • 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.
  • SMW


  • Cargo


  • Categories
  • delete the modules and forms, they contain Passwords

sending

  • 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.

Related articles

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