Manitoba Health Crosschecking Sending Data: Difference between revisions

← Older edit Newer edit →

@@ Line 9: / Line 9: @@
 # 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)
+#* 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'''
-#* 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
 #** 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
 #* 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)
-#* '''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 ==
 '' 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)
 [[Category:Manitoba Health]]