CCMDB Wiki

Manitoba Health Crosschecking Sending Data: Difference between revisions

← Older edit
PTorres (talk | contribs)
CCMDB_legit, approved
1,621 edits
m I did not save as csv but xlsx
m Text replacement - "M:\\([A-Za-z0-9._-]+)(?=\s|$)" to "{{M:\$1}}"
 
(14 intermediate revisions by 3 users not shown)
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]].
This article explains how to use [[MB Health Tool.mdb]] to send data to Manitoba Health as part of [[Crosschecking data with Manitoba Health]].


Line 9: Line 13:
# 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:$1}} where the .mdb lives? Ttenbergen 11:32, 2014 September 8 (CDT)
[[User:PTorres|PTorres]] 15:45, 2014 August 26 (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)
# send the CD and letter to Manitoba Health via InterOffice mail (pick-up daily, no stamp needed)
#* '''address? any further instructions? ''' Ttenbergen 16:03, 2014 August 25 (CDT) {{discussion}}
#* see [[MB_Health_Crosscheck_Contact#MB Health Contact]] for address
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.
#* labels are pre-printed in the [[#MB Health binder]]
[[User:PTorres|PTorres]] 15:51, 2014 August 26 (CDT)
# 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)
#* 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
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.
** 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)
It also contains other historical paperwork related to the process.
*** answers? {{Discussion}}
 
* 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 ==
== 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


* 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)
* 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]]
[[Category:Manitoba Health]]
}}
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Manitoba_Health_Crosschecking_Sending_Data"