Sending Patients
Sending Patients is the process of using the CCMDB.mdb to export the data that has had the RecordStatus field set to "complete" to the format that can be imported into TMSX.
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
The day to send data is Wednesday or Thursday up to 13:00 hrs.
You cannot send on Monday, Tuesday or Friday because the main office is processing and doing QA checks and edits etc on the master database which is pulled off the Regional Server on these days.
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)
- reformat and notes for PDA_Status.csv
- click Format, Column, Autofit, click,
- discharges not sent will come up false
- click on G and type reason not sent
- This is important information is for the Statistician. She uses it to determine if she can release stats for regular reports and special projects. By knowing what is still out there and why not sent in yet, she can make these type of decisions and also advise those requesting, exactly what the status of the files are. Decisions are made about analysis based on this important piece of data that we require each week and also Pagasa does not need to call and follow up.
- exit and say yes to save all
- if the output checked out OK you can 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.
- Tina, the program used to tell us how many rows were being deleted but that has not been the case for a long time. It would be nice to know the actual because it provides us with a quick & easy check to verify number of files deleted and it is an easy cross reference at the same time.--CMarks 08:05, 29 August 2011 (CDT)
- added to Requested CCMDB changes for the next version Ttenbergen 08:53, 29 August 2011 (CDT)
- Tina, the program used to tell us how many rows were being deleted but that has not been the case for a long time. It would be nice to know the actual because it provides us with a quick & easy check to verify number of files deleted and it is an easy cross reference at the same time.--CMarks 08:05, 29 August 2011 (CDT)
- 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 arrive with 1 to 2 days after electronically sending in the CSV files to the Regional Server.
The following forms are sent:
- TISS
- the previous months Data collection log forms are sent with the first envelope of the new month
Sending TISS sheets for patients still in the ICU
For patients who are in your ICU for more than 14 days,
- complete and check TISS forms from more than one week ago and send them in even before the patient is complete. You can keep the current sheet and the sheet just previous to that one.
- please keep track of this in the Notes field on the laptop.
Rationale:
- Since the change to the new TISS 28, we are now doing a 2300 hrs snapshot of central lines, trachs, ventilators and bipap (#46-49 on sheet) for important projects.
- Template:Discussion This is about the Critical Care Vital Sign Monitor) project, right?
- The reason for this is so that Pagasa can scan these forms and keep up to date with reporting these 2300 counts.
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.