Manitoba Centre for Health Policy export: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (clean-up)
Line 1: Line 1:
The export process for [[MCHP]] uses the file [[MCHP Export.mdb]] to generate a date-named file which is then sent to Manitoba Health, where it is de-identified before they send it on to MCHP.
This article functions as a portal for the people at [[MCHP]] who import data into their repositories from our [[Manitoba Centre for Health Policy export]]. We provide them a copy of the [[MCHP Export.mdb]] that has been processed as per [[Instructions for exporting data using MCHP Export.mdb]].
 
== checklist ==
* how about the ALERT score (MOST), this was not given before but we can add now, what do you think?
* itiss?
* data dictionary
 
== Instructions ==
=== Preparations ===
Copy the following files all to one folder:
* a [[centralized_data_front_end.mdb]] 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()
 
=== sending ===
* copy [[MCHP Export.mdb]] to a memory stick or CD
* '''delete the modules and forms, they contain [[:Category:Password | Passwords]]'''
* 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.


== Data ==
== Data ==

Revision as of 17:47, 2017 May 3

This article functions as a portal for the people at MCHP who import data into their repositories from our Manitoba Centre for Health Policy export. We provide them a copy of the MCHP Export.mdb that has been processed as per Instructions for exporting data using MCHP Export.mdb.

Data

Structure is same as CCMDB Data Structure except for the following.

Splitting dual use L_Dxs

For legacy reasons we store different kinds of data in L_Dxs table. For ease of use by MCHP we split the data into the following two tables and won't send the actual L_Dxs table.

Splitting Multi-use L_TmpV2

Our L_TmpV2 table contains data from a number of temporary projects. We will only send a subset of longer-term data. The filtered data will be in

It contains a subset of Category:All_Projects

L_TmpV2 table itself will not be sent.

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Manitoba_Centre_for_Health_Policy_export&oldid=55191"