Manitoba Centre for Health Policy export
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.
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
- click the "Generate output" button
sending
- copy MCHP Export.mdb to a memory stick or CD
- delete the modules and forms, they contain 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
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.