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. 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
Syncing
- Make sure Regional Server is on prior to syncing
- Place PDA in Sync Box
- When Sync is completed check to make sure you have no errors
- Follow instructions in Copying files from PDA to regional server
Checking patients
- 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
- For each profile:
- Check for accuracy and correct any errors
- if ICU, ensure you have a TISS to send and click the Tiss checkbox
- (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))
- click the Final check box in the upper right hand corner
- Once all patient records are checked, click the "little door" on the top right to close the form
- 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
- 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)
Other Things to do at send time
- what paperwork is sent to the main office, and how? Ttenbergen 13:24, 11 February 2009 (CST)