Manitoba Health Crosschecking Sending Data: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
PTorres (talk | contribs)
CCMDB_legit, approved
1,548 edits
m I did not save as csv but xlsx
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)
#* restrict fields ''Study'' and/or (''SentDtTm'' and ''RecordStatus'') and '''document settings used for a given exchange in [[#activity log]] below'''
#**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)
# change to datasheet view to confirm the data is correct, then '''save'''
#*** So which fields did you constrain, and to what? Ttenbergen 15:27, 2014 August 26 (CDT) {{discussion}}
So I added the study number field so I know which study number I started up to the present sent date.
[[User:PTorres|PTorres]] 15:05, 2014 September 5 (CDT)
# 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'''
#* export the file as a .csv (text)
#* export the file as xlsx
Tina I did not save as csv but xlsx
[[User:PTorres|PTorres]] 15:05, 2014 September 5 (CDT)
#** 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)
#* close program and [[push]]  
# 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. [[User:PTorres|PTorres]] 13:17, 2014 August 26 (CDT)
#* 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)
#** where would one find this letter? pretend Sheila is trying to do this while you are away...{{discussion}}
#** It is on my C:\MB_Health_Records_Cleaning\MEMO. [[User:PTorres|PTorres]] 15:45, 2014 August 26 (CDT)
It is on myC:\MB_Health_Records_Cleaning\MEMO.
#*** 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:\MB_Health_Records_Cleaning where the .mdb lives? Ttenbergen 11:32, 2014 September 8 (CDT){{discussion}}
[[User:PTorres|PTorres]] 15:45, 2014 August 26 (CDT)
# send the CD and letter to Manitoba Health via InterOffice mail (pick-up daily)
# 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}}
#* see [[MB_Health_Crosscheck_Contact#MB Health Contact]] for address '''pls update address there'''{{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.
# 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)
[[User:PTorres|PTorres]] 15:51, 2014 August 26 (CDT)
#* update the [[#activity log]], e.g. with "data exported and couriered"


== development of this solution ==
== MB Health Binder? ==
*Julie has contacted MB Health to confirm
* 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.[[User:PTorres|PTorres]] 15:51, 2014 August 26 (CDT)
** that it would be OK to send single file from now on
* Where is this MB Health Binder and what else do we do with it? Ttenbergen 11:32, 2014 September 8 (CDT) {{discussion}}
** that it would be OK to replace the current study number (numerical) with the D_ID (15 character string)
*** answers? {{Discussion}}


== activity 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


* {{discussion}} Pagasa, please log here what data you sent to MB Health Ttenbergen 11:32, 2014 September 8 (CDT)
* 15:46, 2014 August 25 (CDT) started development Ttenbergen 15:46, 2014 August 25 (CDT)
* 15:46, 2014 August 25 (CDT) started development Ttenbergen 15:46, 2014 August 25 (CDT)




[[Category:Manitoba Health]]
[[Category:Manitoba Health]]

Revision as of 10:32, 8 September 2014

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
    • restrict fields Study and/or (SentDtTm and RecordStatus) and document settings used for a given exchange in #activity log below
  6. change to datasheet view to confirm the data is correct, then save
  7. 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
  8. 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)
      • It is on my C:\MB_Health_Records_Cleaning\MEMO. 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:\MB_Health_Records_Cleaning where the .mdb lives? Ttenbergen 11:32, 2014 September 8 (CDT)Template:Discussion
  9. send the CD and letter to Manitoba Health via InterOffice mail (pick-up daily)
  10. 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?

  • 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)
  • Where is this MB Health Binder and what else do we do with it? Ttenbergen 11:32, 2014 September 8 (CDT) Template:Discussion

activity log

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

  • Template:Discussion Pagasa, please log here what data you sent to MB Health Ttenbergen 11:32, 2014 September 8 (CDT)
  • 15:46, 2014 August 25 (CDT) started development Ttenbergen 15:46, 2014 August 25 (CDT)
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Manitoba_Health_Crosschecking_Sending_Data&oldid=40385"