Manitoba Health Crosschecking Sending Data: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m u |
Ttenbergen (talk | contribs) m u |
||
| Line 2: | Line 2: | ||
== Instruction == | == Instruction == | ||
# open [[MB Health Tool.mdb]] | |||
# 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 ''' | |||
# 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) to ... | |||
== fields included == | == fields included == | ||
| Line 10: | Line 20: | ||
*CD's are kept sleeves in this binder with these MHSC send/recieved logs. | *CD's are kept sleeves in this binder with these MHSC send/recieved logs. | ||
== log == | == activity log == | ||
'' newest entry on top, start line with <nowiki> * ~~~~~ </nowiki> then sign as usual | '' newest entry on top, start line with <nowiki> * ~~~~~ </nowiki> then sign as usual | ||
Revision as of 14:58, 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
- open MB Health Tool.mdb
- 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
- 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) to ...
fields included
- PHIN, LN, FN, DOB & Gender are included in a EXCEL file
- A Paper Log Records batch number, date send and date recieved from MHSC.
- One sent/received log form for ICU another for Medicine.
- CD's are kept sleeves in this binder with these MHSC send/recieved logs.
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)