Sending Patients

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

Data Collector Sending Frequency

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

• when working from hospital site: Monday to Friday 07:00-09:30 and 14:00-16:15
• sending should be done every day a collector is working on site
• Sending should only be done when on site and on the network. (no sending from home)
• Only 1 laptop can send at any given time, so sites need to coordinate this amongst themselves
  • SBGH- will be assigned sending between 0700-0900
  • HSC – will be assigned sending between 0900-0930 and 1400-1515
  • GGH – will be assigned sending between 1515-1615

• If there is a special circumstance where you need to send outside of the assigned time, the collector is to email the site that is assigned that time slot to verify no one else is sending or negotiate a time to send.

• Staff should aim to send 2 or more times per week. 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.mdb
• 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)
• if the output checked out OK you can now 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.
• run News and Backup once again to create a backup of the patients files now remaining in your data/ccmdb.mdb.

Paperwork

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

The following forms are sent:

• TISS (Sending TISS forms)
• the previous month's Data collection log forms are sent with the first envelope of the new month

Deleting Sent Patients

see Delete Sent Patients button

Keeping sent patients for reference

If you need to keep sent patients on your laptop for reference, you can do so and will still be able to send new "complete" patients. For PHIA reasons you should not keep excessive patient records, though, we should really only have the current working set on the laptops.

What happens when patients are sent

See the "Sending" module in CCMDB.mdb 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.

• check for previously completed (ie no longer incomplete) records, quit if any found
• send centralized_data.mdb
  • update, then append Log
  • delete then update como, dxs, (if cc: lab, pharm), tmp
  • append new como, dxs, (if cc: lab, pharm), tmp
• send phi xls
• set record_status fields to sent in l_log local
• set record status fields to sent in centralized