Manitoba Health Crosschecking Sending Data: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →Instruction: u |
Ttenbergen (talk | contribs) m u |
||
| Line 2: | Line 2: | ||
== Instruction == | == Instruction == | ||
# | # follow instructions at [[MB_Health_Tool.mdb#Starting_the_program]] to open the tool | ||
# open query ''1_new_export'' | # open query ''1_new_export'' | ||
# save as new query, using name yyyy-mm-dd-<C> export | # save as new query, using name yyyy-mm-dd-<C> export | ||
| Line 15: | Line 15: | ||
#** save in M:\MB_Health_Records_Cleaning\exports | #** save in M:\MB_Health_Records_Cleaning\exports | ||
#** file name MH_yyyy-mm-dd.csv, e.g. MH_2014-08-20.csv | #** 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) | |||
# prepare accompanying documentation | # prepare accompanying documentation | ||
#* '''what if any?''' Ttenbergen 16:03, 2014 August 25 (CDT){{discussion}} | #* '''what if any?''' Ttenbergen 16:03, 2014 August 25 (CDT){{discussion}} | ||
Revision as of 16:01, 2014 August 25
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)Template:Discussion
- 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
- what if any? Ttenbergen 16:03, 2014 August 25 (CDT)Template:Discussion
- courier the data to Manitoba Health
- address? any further instructions? Ttenbergen 16:03, 2014 August 25 (CDT) Template:Discussion
- update the #activity log, e.g. with "data exported and couriered"
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)