Sending Patients: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
(→‎Data Collector Sending Frequency: removed end of shift part which is no longer true w STB sending. Added explanation about not cutting it close with sending.)
 
(176 intermediate revisions by 17 users not shown)
Line 1: Line 1:
'''Sending Patients''' is the process of using the [[CCMDB.mdb]] to export the data collected on the [[PDA]] to the [[sent file format|format]] that can be imported into [[TMSX]].  
Data collectors "send" the data from [[CCMDB.accdb]] to [[Centralized_data.mdb]] and [[PHI.mdb]].


Before you can send, you need to [[Syncing the PDA | sync your PDA]].
== Email Notification to suspend sending ==
At times, there are unexpected issues with the main database.  Main office notifies staff by email to suspend sending operations and will send an updated email when the problem is resolved.  '''It is important that Collectors check their email at the beginning of each shift AND before sending.'''


When you finalize your data and press the "send" button Access automatically exports it to the folder corresponding to that collection's location in the [[Output folder]] on the [[Regional Server]].
==Data Collector Sending Frequency==
If you wish to see your data after you send it, use the Regional Server shortcut on your desktop, navigate to the "Output" folder, then to the folder corresponding to your location. The filenames in the output folder are automatically generated by Access following the [[sent files naming conventions]].
{{:Designated sending times}} <!-- edit at [[Designated sending times]] -->
*'''Do not send outside these hours''' unless requested by main office.
*'''Don't cut it close''' - if you have come really close to the end of the send window and might not '''finish sending''' before the window closes, just don't send and let Pagasa know. If you are still sending while Pagasa [[pull]]s the data we get discrepancies that need to be resolved. It's easier if we just know you didn't get to it and can organize to have you send later if needed.
*At each send, [[Minimal Data Set]] applies.


== How to send completed files ==
== Ongoing preparation during collection ==
These instructions start after you have [[Syncing the PDA | synced]] your PDA.
Whenever you complete collection for a patient, set the [[RecordStatus field]] to "complete". This runs some routines to check the data and marks the patient for export during the next send.  


=== Opening Access ===
At any point during collection you might want to run the [[Pre-send Checker]] to find errors in your data. This will check on some of the data that we send for patients even if they are not final checked. If you run this occasionally during your collections then your chances of running into errors when you are ready to send become less.
* Double-click the '''New Programs''' folder on your desktop
* Double-click the icon for your site/ward
* Enter the tasty password
* "Critical Care and Med Database - (your site)" should be up
* (this step is entirely optional) - Find Orphans; if you have some, see [[Orphans]]
* (this step is entirely optional, the check will run when you send otherwise) - Make sure you have no errors in Pre-Send TmpV2 checker
** (this step is entirely optional) - if you have errors, correct them; if they are '''only on patients you are sending today''', you can correct them in Access directly. If there are also errors on patients you are not sending, you should correct them on the PDA and re-sync
* Click "Edit Patients"
* Click on the filter button (looks like a funnel/filter/wine glass) to review only profiles marked complete


=== Checking ready-to-send patients ===
== Sending Data ==
* For each profile:
To send:  
**Check for accuracy and correct any errors
* run [[News and Backup]] so you have a backup with the most possible information & also the latest [[CCMDB.accdb]]
** if ICU, ensure you have a TISS to send and click the Tiss checkbox
**NOTE: News and backup does not update the master database.  Only the action of ''sending'' does.
*** (Is anyone using this to actually keep track of collecting TISS forms or is this checkbox just a make-work project? The idea was to use it to track that you have the TISS sheet for this. How are people using this? [[User:Ttenbergen|Ttenbergen]] 22:01, 4 May 2009 (CDT))
* check that all patients whom you want to send have the [[RecordStatus field]] set to "complete" in the [[Patient List]]
****I do not use the check box to track TISS.  It's just an empty box that needs to be checked in my case.--[[User:MWaschuk|MWaschuk]] 10:08, 5 May 2009 (CDT)
* click the Send Records button
****Same goes for me. I wouldn't mark a profile complete in my log book until the tiss is done...that is more helpful to me than the check box. [[User:BDeVlaming|BDeVlaming]] 17:43, 6 May 2009 (CDT)
* click "OK" and put in your [[initials]] (see that article on information to default the initials to your own)
* After sending is complete, exit out of [[CCMDB.accdb]] and run [[News and Backup]] once again to create a backup of the patients files now remaining in your [[CCMDB data.mdb]].


** click the Final check box in the upper right hand corner
== Deleting Sent Patients ==
====Yellow fields and error messages====
* profiles should be deleted the next shift that the collector works, you can delete sent patients (who now have "sent" in their [[Record field]]) by pressing the '''[["Delete Sent Patients" button]]'''. The program tells you how many rows are being deleted.
* Yellow fields indicate missing, erroneous or internally inconsistent data; see the error field in the bottom of the screen for explanations
* For PHIA reasons you should not keep "sent" patient records on your laptop.
* correct the error and try to check the box for the tab again to re-check
** to delete a diagnosis/drug/lab/etc click on the box to the left of the line. An arrow will appear. Click the "delete" key on your keyboard (or right-click, delete) to delete the line.


=== Sending Patients ===
== What happens when patients are sent ==
* Click the "Send Records" button
See the "Sending" module in [[CCMDB.accdb]] itself for info on what happens when data is sent.
* Enter [[batch number]] and click "OK" (where do you get which number to enter [[User:Ttenbergen|Ttenbergen]] 22:01, 4 May 2009 (CDT)) {{discussion}}
As of 17:18, 2015 April 30 (CDT) the order of steps inside the process is as follows. Listed here to help in troubleshooting.
**We keep a record of batches sent.  Some record batches sent on a "batch log" sheet.  Some print a sheet from ACCESS after sending which lists serial numbers and names of the pts in the sent file.  You then write at the top of the sheet the batch number and date sent. This sheet gets filed in a folder.--[[User:MWaschuk|MWaschuk]] 10:13, 5 May 2009 (CDT)
* check for previously completed (ie no longer incomplete) records, quit if any found
*** Are the batch log sheets ever used to look something up again? [[User:Ttenbergen|Ttenbergen]] 13:17, 6 May 2009 (CDT)
* send [[centralized_data.mdb]]
****I use it as a guide for deleting profiles from the pda, and after that I never look at them again.  It is proof of when and if a profile has been sent. If I want to look something up I usually use my log book.[[User:BDeVlaming|BDeVlaming]] 17:47, 6 May 2009 (CDT)
** update, then append
** delete then update the other [[L-tables]]
** append new [[L-tables]]
* send phi xls
* set [[RecordStatus field]] to sent in local [[L_Log table]]
* set [[RecordStatus field]] to sent in [[Centralized data.mdb]]


* Check the initials and click "OK"
== Error messages during sending ==
* edit [[PDA_Status.csv]]
Occasionally you will get an error during sending and Access will start an email message for you to send to the office.  
* '''''how much of the following is related to the status.csv, and how much to getting out of Access... could it be pulled apart?'''''
* FORMAT COLUMN AUTOFIT click dates appear discharges not sent will come up false click on G and type reason not sent
* File print record exit save all yes
* Go to: Sent Files to Batch '''print'''. What are you printing from here?[[User:TOstryzniuk|TOstryzniuk]] 19:27, 11 March 2009 (CDT)
* Exit


{{Discussion}}
'''Short version''': when an error generates an email, please do send us these emails, even if it seems like sending went through. '''You don't need to delay going home after you send that email, further communication about this can happen at the next shift.'''
* Several prints are mentioned here. What is done with these print-outs, where are they filed, what are they used for?[[User:Ttenbergen|Ttenbergen]] 13:22, 11 February 2009 (CST)
 
* Again - Could someone please comment on what is being printed, and what is done with the print-outs? Thanks, [[User:Ttenbergen|Ttenbergen]] 22:01, 4 May 2009 (CDT)
'''Long version''': We have suspected for some time that there are occasional glitches during sending that are not evident from looking at the data. The send process still completes, and the records are still set to "sent", but not everything is getting to the centralized repository as it should. So, we changed our program to trap more errors and to make it as easy as possible to pass them on to us. We need those emails to understand the patterns of these problems, even if all the data is sent, to find out how common these problems are and whether we need to change the program and/or our processes further to prevent the underlying problem. Most of the time Pagasa will check and let you know that all was sent correctly and you can delete the data.
**The print out records the serial number and names of the pt in the sent file. This sheet is then filed in a folder. The batch number and date sent is written at the top of the sheet.--[[User:MWaschuk|MWaschuk]] 10:15, 5 May 2009 (CDT)
You do not necessarily need to wait around after you send the email, just don't delete the batch of data you sent. If something went wrong with it, next day re-send will usually be quick enough. So, really, sending this email should not add to your time spent, so there is no reason not to send it.
*** Are the print-outs ever used to look something up again? [[User:Ttenbergen|Ttenbergen]] 13:17, 6 May 2009 (CDT)
 
****I use it as a guide for deleting profiles from the pda, and after that I never look at them again.[[User:BDeVlaming|BDeVlaming]] 17:51, 6 May 2009 (CDT)
== Checks hat people are sending inside the [[Designated sending times]] ==
[[CFE]] query ''Sending_at_wrong_time'' will show who sends out of the [[Designated sending times]].
 
== Related articles ==
{{Related Articles}}


== Other Things to do at send time ==
* what paperwork is sent to the main office, and how? [[User:Ttenbergen|Ttenbergen]] 13:24, 11 February 2009 (CST)


** The green sheets for medicine/ICU and TISS for ICU are bundled together in an envelope and sent through the interhospital mail (MCL).  Also, the previous months log sheets are sent with the first envelope of the new month.--[[User:MWaschuk|MWaschuk]] 10:19, 5 May 2009 (CDT)
{{stub}}
[[Category: IT Instructions]]
[[Category: IT Instructions]]
[[Category: Data Collection Guide]]
[[Category: Data Collection Guide]]
[[Category: Questions]]
[[Category: Sending]]
[[Category: Question for Data Collectors]]
[[Category:Laptop identifier]]
[[When did send day change from Wednesday/Thursday?]]
 
*At the Vic, it is difficult to have files completed to send
Tuesday, Wednesday, as we only work Tuesday-Wednesday-Thursday here, due to the new master rotation, so is it ok our files will be behind a week?
[[User:WGobert|gogogirl]] 11:14, 2 June 2009 (CDT)

Latest revision as of 10:22, 2022 June 3

Data collectors "send" the data from CCMDB.accdb to Centralized_data.mdb and PHI.mdb.

Email Notification to suspend sending

At times, there are unexpected issues with the main database. Main office notifies staff by email to suspend sending operations and will send an updated email when the problem is resolved. It is important that Collectors check their email at the beginning of each shift AND before sending.

Data Collector Sending Frequency

Because the Data Processor needs dedicated access to Centralized_data.mdb the time during which collectors are able to send is limited as follows:

  • when working from hospital site: Monday to Friday 14:30-18:00
  • when working from home: Monday to Friday 07:00-09:00
  • Do not send outside these hours unless requested by main office.
  • Don't cut it close - if you have come really close to the end of the send window and might not finish sending before the window closes, just don't send and let Pagasa know. If you are still sending while Pagasa pulls the data we get discrepancies that need to be resolved. It's easier if we just know you didn't get to it and can organize to have you send later if needed.
  • At each send, Minimal Data Set applies.

Ongoing preparation during collection

Whenever you complete collection for a patient, set the RecordStatus field to "complete". This runs some routines to check the data and marks the patient for export during the next send.

At any point during collection you might want to run the Pre-send Checker to find errors in your data. This will check on some of the data that we send for patients even if they are not final checked. If you run this occasionally during your collections then your chances of running into errors when you are ready to send become less.

Sending Data

To send:

  • run News and Backup so you have a backup with the most possible information & also the latest CCMDB.accdb
    • NOTE: News and backup does not update the master database. Only the action of sending does.
  • check that all patients whom you want to send have the RecordStatus field set to "complete" in the Patient List
  • click the Send Records button
  • click "OK" and put in your initials (see that article on information to default the initials to your own)
  • After sending is complete, exit out of CCMDB.accdb and run News and Backup once again to create a backup of the patients files now remaining in your CCMDB data.mdb.

Deleting Sent Patients

  • profiles should be deleted the next shift that the collector works, you can delete sent patients (who now have "sent" in their Record field) by pressing the "Delete Sent Patients" button. The program tells you how many rows are being deleted.
  • For PHIA reasons you should not keep "sent" patient records on your laptop.

What happens when patients are sent

See the "Sending" module in CCMDB.accdb itself for info on what happens when data is sent. As of 17:18, 2015 April 30 (CDT) the order of steps inside the process is as follows. Listed here to help in troubleshooting.

Error messages during sending

Occasionally you will get an error during sending and Access will start an email message for you to send to the office.

Short version: when an error generates an email, please do send us these emails, even if it seems like sending went through. You don't need to delay going home after you send that email, further communication about this can happen at the next shift.

Long version: We have suspected for some time that there are occasional glitches during sending that are not evident from looking at the data. The send process still completes, and the records are still set to "sent", but not everything is getting to the centralized repository as it should. So, we changed our program to trap more errors and to make it as easy as possible to pass them on to us. We need those emails to understand the patterns of these problems, even if all the data is sent, to find out how common these problems are and whether we need to change the program and/or our processes further to prevent the underlying problem. Most of the time Pagasa will check and let you know that all was sent correctly and you can delete the data. You do not necessarily need to wait around after you send the email, just don't delete the batch of data you sent. If something went wrong with it, next day re-send will usually be quick enough. So, really, sending this email should not add to your time spent, so there is no reason not to send it.

Checks hat people are sending inside the Designated sending times

CFE query Sending_at_wrong_time will show who sends out of the Designated sending times.

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Sending_Patients&oldid=156358"