Manitoba Health Crosschecking Sending Data: Difference between revisions

(30 intermediate revisions by 3 users not shown)

Line 1:

{{LegacyContent

|explanation=MB Health stopped providing data.

|content=

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

#* restrict fields ''Study'' and/or (''SentDtTm'' and ''RecordStatus'') and '''document settings used for a given exchange in [[#activity log]] below'''

# change to datasheet view to confirm the data is correct, then '''save'''

# right-click on the new query and click '''export'''

#* export the file as xlsx

#** 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]]

# 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. [[User:PTorres|PTorres]] 13:17, 2014 August 26 (CDT)

#** It is on my C:\MB_Health_Records_Cleaning\MEMO. [[User:PTorres|PTorres]] 15:45, 2014 August 26 (CDT)

#*** I think all supporting files should be stored on a file share so that they are backed up and anyone covering for Pagasa without her password could do this. Can we move the files to {{M:$1}} where the .mdb lives? Ttenbergen 11:32, 2014 September 8 (CDT)

#**** Did you move the files over as well yesterday when you did the other clean-up of this process? Thanks... Ttenbergen 08:20, 2014 September 9 (CDT)

# send the CD and letter to Manitoba Health via InterOffice mail (pick-up daily, no stamp needed)

#* see [[MB_Health_Crosscheck_Contact#MB Health Contact]] for address

#* labels are pre-printed in the [[#MB Health binder]]

# update the [[#activity log]], e.g. with "data exported and couriered" and the end points (e.g. up to study 123 or vetted records with [[sendDtTm]] < 1 jan 1900)

== MB Health Binder ==

The MB Health binder contains mailing labels for our [[MB Health Crosscheck Contact]]. The binder can be found on the shelf next to the TISS scanning computer in the data processor cubicle in the main office.

It also contains other historical paperwork related to the process.

* For the two binder we will just keep the label of our contact person and history of the old process of MB Health. [[User:PTorres|PTorres]] 12:06, 2014 September 8 (CDT)

** Are you saying there is a second binder? Ttenbergen 08:25, 2014 September 9 (CDT)

== activity log ==

'' newest entry on top, start line with <nowiki> * ~~~~~ </nowiki> then sign as usual

* MH_2014-09-05-First sent to the new MHO program [[User:PTorres|PTorres]] 12:03, 2014 September 8 (CDT)

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

*what is activity log for, the sending of data to MHSC for crosschecking?=--[[User:TOstryzniuk|Trish Ostryzniuk]] 16:47, 2015 July 7 (CDT)

**we last sent data to MHSC on May 14.15. Julie Mojica to follow up. No data back as of July 7.15.

[[Category:Manitoba Health]]

}}

@@ Line 1: / Line 1: @@
+{{LegacyContent
+|explanation=MB Health stopped providing data.
+|content=
 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
+#* restrict fields ''Study'' and/or (''SentDtTm'' and ''RecordStatus'') and '''document settings used for a given exchange in [[#activity log]] below'''
+# change to datasheet view to confirm the data is correct, then '''save'''
+# right-click on the new query and click '''export'''
+#* export the file as xlsx
+#** 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]]
+# 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. [[User:PTorres|PTorres]] 13:17, 2014 August 26 (CDT)
+#** It is on my C:\MB_Health_Records_Cleaning\MEMO. [[User:PTorres|PTorres]] 15:45, 2014 August 26 (CDT)
+#*** I think all supporting files should be stored on a file share so that they are backed up and anyone covering for Pagasa without her password could do this. Can we move the files to {{M:$1}} where the .mdb lives? Ttenbergen 11:32, 2014 September 8 (CDT)
+#**** Did you move the files over as well yesterday when you did the other clean-up of this process? Thanks... Ttenbergen 08:20, 2014 September 9 (CDT)
+# send the CD and letter to Manitoba Health via InterOffice mail (pick-up daily, no stamp needed)
+#* see [[MB_Health_Crosscheck_Contact#MB Health Contact]] for address
+#* labels are pre-printed in the [[#MB Health binder]]
+# update the [[#activity log]], e.g. with "data exported and couriered" and the end points (e.g. up to study 123 or vetted records with [[sendDtTm]] < 1 jan 1900)
+== MB Health Binder ==
+The MB Health binder contains mailing labels for our [[MB Health Crosscheck Contact]]. The binder can be found on the shelf next to the TISS scanning computer in the data processor cubicle in the main office.
+It also contains other historical paperwork related to the process.
+* For the two binder we will just keep the label of our contact person and history of the old process of MB Health. [[User:PTorres|PTorres]] 12:06, 2014 September 8 (CDT)
+** Are you saying there is a second binder? Ttenbergen 08:25, 2014 September 9 (CDT)
+== activity log ==
+'' newest entry on top, start line with <nowiki> * ~~~~~ </nowiki> then sign as usual
+* MH_2014-09-05-First sent to the new MHO program [[User:PTorres|PTorres]] 12:03, 2014 September 8 (CDT)
+* 15:46, 2014 August 25 (CDT) started development Ttenbergen 15:46, 2014 August 25 (CDT)
+*what is activity log for, the sending of data to MHSC for crosschecking?=--[[User:TOstryzniuk|Trish Ostryzniuk]] 16:47, 2015 July 7 (CDT)
+**we last sent data to MHSC on May 14.15.  Julie Mojica to follow up.  No data back as of July 7.15.
 [[Category:Manitoba Health]]
+}}