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,607 edits
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,851 edits
m Text replacement - "[[Category: " to "[[Category:"
 
(11 intermediate revisions by 2 users 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 ==
== Data ==
* how about the ALERT score (MOST), this was not given before but we can add now, what do you think?
Structure is same as [[CCMDB Data Structure]] except for the following.
* itiss?
* data dictionary


== Instructions ==
=== Splitting dual use L_Dxs ===
=== Preparations ===
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]].
Copy the following files all to one folder:
* [[L_DXs_MCHP table]]  
* a [[centralized_data_front_end.mdb]] with up-to-date created_variables
* [[L_Tasks_MCHP table]]
* [[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 ==
Structure is same as CCMDB except:


===Things to consider still ===
=== Splitting Multi-use L_TmpV2 ===
{{discussion}}
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
* Tasks... (its in DXs and that's confusing)
* [[L_TmpV2_MCHP table]]
** Could write code to stick it into its own table and delete it from dxs.
***Agree to be on separate table.
{{discussion}}
* ADL_scores (since it's only for Medicine)
** can we leave those as are? 
***Yes


=== Tmp ===
[[L_TmpV2 table]] itself will not be sent.
A subset of [[:Category:All_Projects]]
Query L_TmpV2_MCHP limits that list to only those that have MCHP field true; alternative would be to delete from L_TmpV2 all where MCHP field not true. Preference? {{discussion}} Ttenbergen 16:21, 2017 April 13 (CDT)
*if first, will you still include L_TMPV2?  if second, will it be the same table name - what is the chance that the original L_TMPV2 will not be overwritten?  Maybe the first is safer, we just tell MCHP to ignore L_TmpV2 if you intend to include it.


=== Old Data ===
== Related articles ==  
{{discussion}}
{{Related Articles}}
Need to decide what to do with
* old pharmacy ([[Legacy TMS Data.mdb]])
* TISS76 ([[Legacy TMS Data.mdb]])




[[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"