Manitoba Centre for Health Policy export: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 25: Line 25:
* 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.


== structure ==
== Data ==
=== 1Main ===
Structure is same as CCMDB except:
* contents of
** L_Log
** L_PHI (all of it, MB Health can decide what to strip/obfuscate)
** Created_variables_CC and Created_variables_common, those which are not already in L_Log
 
=== Como ===
* contents of L_Como
 
=== Dxs ===
* admit and acquired diagnoses with priorities and primary designation.
 
=== Labs ===
* separate table because only in CC and there is a lot there
* [[Query L Labs total‎]] which summarizes L_Labs_Flowsheet into one line per pt
* Labs from [[Legacy TMS Data.mdb]]
* some of the above were previously combined in which case we kept the value from L Labs total‎
 
=== Pharmacy_new ===
* separate table because only in CC and there is a lot there
* [[Query L_Pharm_total]] which summarizes L_Pharm_Flowsheet into one line per pt
* pharm_* fields from [[L_Log]]
* Pharmacy from [[Legacy TMS Data.mdb]]
 
=== Pharmacy_old ===
* separate table because only in CC and there is a lot there
* Pharmacy from [[Legacy TMS Data.mdb]]
* separate table because combined there were more than the 256 columns access can handle
 
=== Tasks ===
Tasks (since it's only for Medicine)
 
 
=== ADL_scores ===
ADL_scores (since it's only for Medicine)


===Things to consider still ===
{{discussion}}
* Tasks... (its in DXs and that's confusing)
** Could write code to stick it into its own table and delete it from dxs.
{{discussion}}
* ADL_scores (since it's only for Medicine)
** can we leave those as are?


=== Tmp ===
=== Tmp ===
A subset of [[:Category:All_Projects]]
A subset of [[:Category:All_Projects]]
* ERWait  - Med only and it should be clearly specified as DATE_TIME LEFT ED to go to the WARD.
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)
* ABO_TEE -  STB CICU is using the MCHP and this data has been requested by CICU
** ABO TEE blood type
** ABO TEE function
** ABO TEE LV fraction
** A_T blood type
** A_T function
** A_T LV fraction
* VAP/CLI DATES  -  there are cases of more than one VAP Date (multi record)
** QAInf
 
=== TISS28 ===
* new TISS, one entry per item per day
 
=== TISS76 ===
* from [[Legacy TMS Data.mdb]], own table since one line for all items per day


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




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

Revision as of 16:21, 2017 April 13

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:

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 except:

Things to consider still

Template:Discussion

  • Tasks... (its in DXs and that's confusing)
    • Could write code to stick it into its own table and delete it from dxs.

Template:Discussion

  • ADL_scores (since it's only for Medicine)
    • can we leave those as are?

Tmp

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? Template:Discussion Ttenbergen 16:21, 2017 April 13 (CDT)

Old Data

Template:Discussion Need to decide what to do with

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