Sending Patients: Difference between revisions
Ttenbergen (talk | contribs) m (→Sending Data) |
m (→Sending Data) |
||
| Line 9: | Line 9: | ||
''[[Sending Patients#Historical:Filtering for complete patients | Follow this link to see why you don't need to bother with the '''Edit patient and filter any longer]].'' | ''[[Sending Patients#Historical:Filtering for complete patients | Follow this link to see why you don't need to bother with the '''Edit patient and filter any longer]].'' | ||
To send on [[#Wednesday is the weekly sending day | Send Day]]: | |||
* check that all patients whom you want to send are [[Final Check]]ed in [[Patient List]] | * check that all patients whom you want to send are both complete and [[Final Check]]ed in [[Patient List]] | ||
* click the | * click the Send Records button | ||
* Enter [[batch number]] | * Enter [[batch number]] which is one higher than the last batch sent | ||
**We keep a record of batches sent | * click "OK"and put in your intials. | ||
* Format Column Autofit, click, discharges not sent will come up false, click on G and type reason not sent | |||
*exit and say yes to save all | |||
*We keep a record of batches sent by printing the [[Sent Report]] from ACCESS after sending which lists serial numbers and names of the patients in the sent file. Write at the top of the sheet the batch number and date sent. This sheet gets filed in a folder for future reference. | |||
* check that your output data is on the regional server, i.e. the corresponding folder will open automatically. filenames in the output folder are automatically generated by Access following the [[sent files naming conventions]]; if the file is not there, contact Tina or Trish. | * check that your output data is on the regional server, i.e. the corresponding folder will open automatically. filenames in the output folder are automatically generated by Access following the [[sent files naming conventions]]; if the file is not there, contact Tina or Trish. | ||
* Do not call Pagasa to check for you, if you can see it, it's there | |||
* if the output checked out OK you can [[Delete | * run [[News and Backup]] to have a backup of the complete patients you sent | ||
* if the output checked out OK you can [[Delete Final Checks]] the program tells you how many rows are being deleted. | |||
* run [[News and Backup]] to have a backup of the complete patients you sent | |||
{{Discussion}} | {{Discussion}} | ||
== Paperwork == | == Paperwork == | ||
Revision as of 19:29, 2010 October 13
Sending Patients is the process of using the CCMDB.mdb to export the data collected patients that has been final checked to the format that can be imported into TMSX.
Ongoing preparation during collection
Whenever you complete collection for a patient, Final Check them. 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
Follow this link to see why you don't need to bother with the Edit patient and filter any longer.
To send on Send Day:
- check that all patients whom you want to send are both complete and Final Checked in Patient List
- click the Send Records button
- Enter batch number which is one higher than the last batch sent
- click "OK"and put in your intials.
- Format Column Autofit, click, discharges not sent will come up false, click on G and type reason not sent
- exit and say yes to save all
- We keep a record of batches sent by printing the Sent Report from ACCESS after sending which lists serial numbers and names of the patients in the sent file. Write at the top of the sheet the batch number and date sent. This sheet gets filed in a folder for future reference.
- check that your output data is on the regional server, i.e. the corresponding folder will open automatically. filenames in the output folder are automatically generated by Access following the sent files naming conventions; if the file is not there, contact Tina or Trish.
- Do not call Pagasa to check for you, if you can see it, it's there
- run News and Backup to have a backup of the complete patients you sent
- if the output checked out OK you can Delete Final Checks the program tells you how many rows are being deleted.
- run News and Backup to have a backup of the complete patients you sent
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
Historical:Filtering for complete patients
Historically the following used to be part of the send process:
- Click "Edit Patients"
- Click on the filter button (looks like a funnel/filter/wine glass) to review only profiles marked complete
This was required because data in ccmdb.mdb would get wiped out at each sync, so you would only want to fix those patients you were sending right now. To make it easy to identify these, there was a filter that would show only patients who had the record field set to "complete". This filter used to be triggered using the filter button on the Patient Viewer form. Note that this button does not filter for Final Checked patients, it filters for patients who are set to complete.
Wednesday is the weekly sending day
The day to send data is Wednesday.
If for some reason you cannot send in on a Wednesday, you must call Pagasa Data Processor prior to sending data on any other day of the week.
We are continuously working with these files on the Regional Server. In order not to lose any of the data files, the Data Processor must make sure that we close out of these files before you send in data on any other day of the week.
What happens when patients are sent
The data below may not be up-to-date, check the actual Sending' module in the current CCMDB.mdb for the routines used in sending.
CCMDB.mdb does the following things in this order when sending:
- a check is run to see if the Regional Server is accessible
- ensure that the location and program are consistent, i.e. a CC location must end in "CU"
- Tmp_Checker makes sure that entries in L_TmpV2 are acceptable
- the output file for import into TMSX/MedTMS is generated
- generate Hosp_ward_pending.xls
- data is dumped into PDA_Pending.mdb
- PDA Status.csv is generated, and excel is opened to edit it to explain why discharged patients are not sent
- Output Databases
- open DBs
- data dumped to Greensheets.mdb
- data dumped to TASKS.mdb
- data dumped to TmpV2_1.mdb
- close DBs
- the Sent Report is displayed
- File explorer is opened to Regional Server\Output\<Hosp>_<Ward> to confirm files were sent