Manitoba Health Crosschecking Sending Data

This article explains how to use MB Health Tool.mdb to send data to Manitoba Health as part of Crosschecking data with Manitoba Health.

Instruction

1. follow instructions at MB_Health_Tool.mdb#Starting_the_program to open the tool
2. open query 1_new_export
3. save as new query, using name yyyy-mm-dd-<C> export
   • C is optional, can be used for Comment if needed
   • examples would be 2014-08-20 or 2014-08-20-Resend
4. right-click and design view the query
5. edit the criteria to restrict the data
   • need to document what data one would restrict to, likely referring to the #activity log below Ttenbergen 16:03, 2014 August 25 (CDT)
     • I added the study field on the Design view so I know the cut point of the file that I am sending for now still combination of study numbers and Date sent. PTorres 11:14, 2014 August 26 (CDT)
       • So which fields did you constrain, and to what? Ttenbergen 15:27, 2014 August 26 (CDT) Template:Discussion

So I added the study number field so I know which study number I started up to the present sent date. PTorres 15:05, 2014 September 5 (CDT)

1. change to list view to confirm the data is correct, then save
2. right-click on the new query and click export
   • export the file as a .csv (text)

Tina I did not save as csv but xlsx PTorres 15:05, 2014 September 5 (CDT)

1. • • save in M:\MB_Health_Records_Cleaning\exports
     • file name MH_yyyy-mm-dd.csv, e.g. MH_2014-08-20.csv
   • close program and push Ttenbergen 17:01, 2014 August 25 (CDT)
2. prepare accompanying documentation
   • We have a cover letter prepared already all I need to do is change the file name and number of records that I am going to send. PTorres 13:17, 2014 August 26 (CDT)
     • where would one find this letter? pretend Sheila is trying to do this while you are away...Template:Discussion

It is on myC:\MB_Health_Records_Cleaning\MEMO.

PTorres 15:45, 2014 August 26 (CDT)

1. send the CD and letter to Manitoba Health via InterOffice mail (pick-up daily)
   • address? any further instructions? Ttenbergen 16:03, 2014 August 25 (CDT) Template:Discussion

For Marc Silva address I do have printed label which was file on the MB HEALTH binder. To send it just mail it regular envelop and put InterOffice mail no stamp needed. PTorres 15:51, 2014 August 26 (CDT)

1. • update the #activity log, e.g. with "data exported and couriered"

development of this solution

• Julie has contacted MB Health to confirm
  • that it would be OK to send single file from now on
  • that it would be OK to replace the current study number (numerical) with the D_ID (15 character string)
    • answers? Template:Discussion

activity log

newest entry on top, start line with * ~~~~~ then sign as usual

• 15:46, 2014 August 25 (CDT) started development Ttenbergen 15:46, 2014 August 25 (CDT)