Manitoba Centre for Health Policy export: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
Ttenbergen (talk | contribs)
CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators
92,599 edits
m →Data: cleanup
m Text replacement - "[[Category: " to "[[Category:"
 
(6 intermediate revisions by the same user not shown)
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.accdb]] that has been processed as per [[Instructions for exporting data using MCHP Export.accdb]].
 
== 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 [[: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 ==
Line 31: Line 7:
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]].
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]].
* [[L_DXs_MCHP table]]  
* [[L_DXs_MCHP table]]  
* [[L_Tasks_MCHP table]].
* [[L_Tasks_MCHP table]]


=== Splitting Multi-use L_TmpV2 ===
=== 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  
Our [[L_TmpV2 table]] contains data from a number of temporary [[Projects]] . We will only send a subset of this data, '''defined by which data has the MCHP field in the [[s_tmp table]] set to "true"''' . The filtered data will be in  
* [[L_TmpV2_MCHP table]]
* [[L_TmpV2_MCHP table]]
It contains a subset of [[:Category:All_Projects]]


[[L_TmpV2 table]] itself will not be sent.
[[L_TmpV2 table]] itself will not be sent.


== Related articles ==
{{Related Articles}}




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

Latest revision as of 11:34, 30 July 2025

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.accdb that has been processed as per Instructions for exporting data using MCHP Export.accdb.

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 this data, defined by which data has the MCHP field in the s_tmp table set to "true" . The filtered data will be in

L_TmpV2 table itself will not be sent.

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