Sending Patients

Sending Patients is the process of using the CCMDB.mdb to export the data collected on the PDA to the format that can be imported into TMSX.

Before you can send, you need to sync your PDA.

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. 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.

How to send completed files

These instructions start after you have synced your PDA.

Opening Access

• 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

• For each profile:
  • Check for accuracy and correct any errors
  • if ICU, ensure you have a TISS to send and click the Tiss checkbox
  • click the Final check box in the upper right hand corner

Discussion

• 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? Ttenbergen 22:01, 4 May 2009 (CDT)
  • I do not use the check box to track TISS. It's just an empty box that needs to be checked in my case.--MWaschuk 10:08, 5 May 2009 (CDT)
  • 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. BDeVlaming 17:43, 6 May 2009 (CDT)

Yellow fields and error messages

• Yellow fields indicate missing, erroneous or internally inconsistent data; see the error field in the bottom of the screen for explanations
• 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

• Click the "Send Records" button
• Enter batch number and click "OK" (where do you get which number to enter Ttenbergen 22:01, 4 May 2009 (CDT)) Template:Discussion
  • 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.--MWaschuk 10:13, 5 May 2009 (CDT)
    • Are the batch log sheets ever used to look something up again? 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. 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.BDeVlaming 17:47, 6 May 2009 (CDT)

• Check the initials and click "OK"
• edit PDA_Status.csv
• 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?TOstryzniuk 19:27, 11 March 2009 (CDT)
• Exit

• Several prints are mentioned here. What is done with these print-outs, where are they filed, what are they used for?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, Ttenbergen 22:01, 4 May 2009 (CDT)
  • 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.--MWaschuk 10:15, 5 May 2009 (CDT)
    • Are the print-outs ever used to look something up again? 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.BDeVlaming 17:51, 6 May 2009 (CDT)
        • Can I assume this is all about the Sent Report? If so, let's move this discussion there. Ttenbergen 10:54, 24 September 2009 (CDT)

Paperwork

Paperwork is sent through the interhospital mail (MCL) and arrive with 1 to 2 days after electronically sending in the CSV files

The following forms are sent:

• TISS
• Green Sheets
• the previous months log sheets are sent with the first envelope of the new month
• Manually collected data forms
  • What are these other forms? If there are more, list them, otherwise please take out this last point about manually collected data forms Template:Discussion

What day do we send on?

Template:Discussion Appanretly the send day has changed from Wednesday/Thursday... what is the official send day now?

• 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? gogogirl 11:14, 2 June 2009 (CDT)
  • Now that the summer is over and everyone is back from redeployment and vacation, reminder to all collectors that the file sending date is every Wednesday. If you need to send on any other day of the week it is mandatory that you call Pagasa first before you send in your files. If you cannot send in files for a week, you must also call her and let her know. We are working with these files on these other days and don't want files to get lost and have to get you to redo them. Any concerns about this let me know. Trish Ostryzniuk, Manager'
    • I am still confused, so we are only to send now on Wednesday?gogogirl 14:22, 8 October 2009 (CDT)

Test Data

see Test data

What happens when patients are sent

CCMDB.mdb does the following things in this order when sending:

1. a check is run to see if the Regional Server is accessible
2. ensure that the location and program are consistent, i.e. a CC location must end in "CU"
3. Tmp_Checker makes sure that entries in L_TmpV2 are acceptable
4. the Output for TMSX output file for import into TMSX is generated
5. generate Hosp_ward_pending.xls
6. data is dumped into PDA_Pending.mdb
7. PDA Status.csv is generated, and excel is opened to edit it to explain why discharged patients are not sent
8. Output Databases
   1. open DBs
   2. data dumped to Greensheets.mdb
   3. data dumped to TASKS.mdb
   4. data dumped to TmpV2_1.mdb
   5. close DBs
9. the Sent Report is displayed
10. File explorer is opened to Regional Server\Output\<Hosp>_<Ward> to confirm files were sent