Manitoba Centre for Health Policy export

From CCMDB Wiki
Jump to navigation Jump to search

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.
      • Agree to be on separate table.

Template:Discussion

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

details from Change Priorities

  • give them what we have, let them know how it has changed, we will not update to their structure.
  • what is the least work we can send them it in? Basic raw tables and relationships explained. send them CCMDB and CFE and centralized data and TISS when integrated.
  • Tell them to: Ignore rest, just use L_tables and S_tables Tina has it ready, except has to add s_tables. Tina but would have to add s-table relationships. Not done yet.
  • Wiki articles need to updated and data dictionary has to be done first.
  • how to send? As an Access.mdb. They can tie into it with other programs.
  • 2016 - Dr. Manjit asking when we are going to sent next data, only has up to 2012.
  • take suggestion to task Template:Discuss@task

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)

  • 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

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=54814"