Manitoba Health Crosschecking Sending Data: Difference between revisions
Jump to navigation
Jump to search
m Added a study field on the Design View |
Ttenbergen (talk | contribs) m u |
||
| Line 9: | Line 9: | ||
# right-click and design view the query | # right-click and design view the query | ||
# edit the criteria to restrict the data | # 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) | #* ''' 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. | #**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. [[User:PTorres|PTorres]] 11:14, 2014 August 26 (CDT) | ||
[[User:PTorres|PTorres]] 11:14, 2014 August 26 (CDT) | #*** So which fields did you constrain, and to what? Ttenbergen 15:27, 2014 August 26 (CDT) {{discussion}} | ||
# change to list view to confirm the data is correct, then '''save''' | # change to list view to confirm the data is correct, then '''save''' | ||
# right-click on the new query and click '''export''' | # right-click on the new query and click '''export''' | ||
| Line 19: | Line 19: | ||
#* close program and [[push]] Ttenbergen 17:01, 2014 August 25 (CDT) | #* close program and [[push]] Ttenbergen 17:01, 2014 August 25 (CDT) | ||
# prepare accompanying documentation | # 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. | #* 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. [[User:PTorres|PTorres]] 13:17, 2014 August 26 (CDT) | ||
[[User:PTorres|PTorres]] 13:17, 2014 August 26 (CDT) | #** where would one find this letter? pretend Sheila is trying to do this while you are away...{{discussion}} | ||
#* | # 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) {{discussion}} | #* '''address? any further instructions? ''' Ttenbergen 16:03, 2014 August 25 (CDT) {{discussion}} | ||
#* update the [[#activity log]], e.g. with "data exported and couriered" | #* update the [[#activity log]], e.g. with "data exported and couriered" | ||
Revision as of 14:27, 2014 August 26
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
- follow instructions at MB_Health_Tool.mdb#Starting_the_program to open the tool
- open query 1_new_export
- 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
- right-click and design view the query
- 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
- 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)
- need to document what data one would restrict to, likely referring to the #activity log below Ttenbergen 16:03, 2014 August 25 (CDT)
- change to list view to confirm the data is correct, then save
- right-click on the new query and click export
- export the file as a .csv (text)
- 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)
- export the file as a .csv (text)
- 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
- 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)
- 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
- 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)