TISS28 Form Scanning: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
PTorres (talk | contribs)
PTorres (talk | contribs)
Line 76: Line 76:
TISS Error Output from SAS is located in\\Hsc1msfp0001\med_ccmed\PAGASA\TISS28
TISS Error Output from SAS is located in\\Hsc1msfp0001\med_ccmed\PAGASA\TISS28
#  Open the Tiss28Errors_01Oct2015_b_rtf, to see the output error.
#  Open the Tiss28Errors_01Oct2015_b_rtf, to see the output error.
#  Copy the list in excell so you manipulate the filter.
#  Copy the list in excell so you can manipulate the filter.
#  Error on Date,Location,Missing day or Extra day checked the "EPR" to see patient visit info.
#  Error on Date,Location,Missing day or Extra day checked the "EPR" to see patient visit info.
  ** To navigate in EPR get the chart number **
  To navigate in EPR get the chart number or you can search by name also.
     *Click File then Find Patient then enter the chart number on the ID  and the site location on the IDlocation then Search.
     *Click File then Find Patient then enter the chart number on the ID  and the site location on the IDlocation then Search.
    *Note for Stb you have to add "0" then the chart number then Search,
    *Note for Stb you have to add "0" then the chart number then Search,
       for other sites you dont need to do that.   
       for other sites you dont need to do that.   
    *Once you get patient name highlighted it then click Shows visits.
    *Once you get patient name highlighted it then click Shows visits.
    *Click the date you want to see the admission.
    *Click the date you want to see the admission then click "OK".
{{Discussion}}
    *Then click to Registration then Visit Location then Location History will pop up the admission of the patient.
How are the errors processed between processor and data collector? Need steps documented here so someone can follow process.
#  If after investigation you cannot reconcile the error that is the only time you ask the collector by email or by phone.
 
*It appear that: Sometimes TISS form is printed out other times not.  Sometimes a for is filled out for missing day and scanned in, other times not and extra day manually added to tiss.data.mdb.
*It appear that: Sometimes TISS form is printed out other times not.  Sometimes a for is filled out for missing day and scanned in, other times not and extra day manually added to tiss.data.mdb.



Revision as of 10:31, 2 October 2015

The purpose of this article is to outline the process of scanning TISS28 paper forms, verifying the data in Teleform and committing the data to the TISS28 MS Access database.

These instructions are applicable to the following:

  • Teleform version 10.9 installed in a PC running Windows 7
  • Scanning to a network share from a multifunction printer/scanner

For additional information see this article: Teleform

Start Date

January 1, 2013

  • TISS28 data for the entire LOS is scanned and stored in new repository TISS28_Data.mdb. This form has 7 days per page.

Prior to starting scanning

  • Review each TISS and black blob those that you can tell verifier will not pick up well.
  • page numbers don't fuss, does not matter what page number is the form. Use 001 for
    • tissdata.mdb stores TISS by groups and date order.
      • Template:Discussion there is an issue that for some TISS, they are not being grouped in TISS.mdb. Not sure why. Sheila Rusnak has pointed this out several times. When searching for tiss.data.mdb to find what is already scanned you may have to find NEXT, one page is not being grouped as it should be with other site serial Location.
        • please book a time to demonstrate, ideally when Pagasa is back, so she can also explain if this is maybe something she knows and has a work-around for Ttenbergen 12:59, 2015 July 6 (CDT)

Steps required to Navigating through Teleform Programs.

Scanning forms

On the scanner:

  1. put forms into scanner
  2. on scanner interface, click "Scan to Network"
  3. click "Scan to Network" a second time
  4. click "change..."
    • under "sides(duplex)" choose "2 sided"
    • under "Scan As" choose TIFF
  5. click "Scan it" button

Teleform ScanStation

On the Scanner PC:

  1. Double-click on the Teleform ScanStation shortcut on the desktop
  2. Select File, New Batch
  3. Click Start buttom in bottom left
  4. Click Accept
  • leave Teleform Scan Station open

Verifying

  1. Double-click on the Teleform Verifier shortcut on the desktop
  2. click on the line with the latest batch number, status column should say "Ready for Correction"
  3. click the "Process" button on the right
  4. click the "AB12" button in the button bar to change view to form view
  5. correct all entries the program presents
  6. when dialog box asks "save corrections to results file" click OK
  7. right-click the batch and click "Commit"; say "OK" to "Commit batch data?"

Importing Tiss

  1. Open the Tiss 28 Database
  2. Click Importing tiss data
  3. A message will come out telling the numbers of tiss forms imported successfully
  4. It will show up tiss serial number imported and you can check against the tiss forms

Update tiss 28 mdb

  1. Once you finished importing all the tiss
  2. Open the Tiss 28 Database
  3. Click Prepared Report
  4. Click the Data by Patient and Date View and then click "Run" it takes 3 minutes to run
  5. After running the Data by Patient and Data View Click Count of Tiss items

Error Checker Run by SAS

  1. To run this program use the laptop or Julie's computer with SAS program
  2. Double click on the SAS 9.3 a message will pop up click "close"
  3. Go to File then Open program
  4. Go to My Computer to look for the X drive
  5. On X drive double click on PAGASA's folder
  6. Double click on Tiss 28 folder
  7. Double click on "chkTiss28CD_ver6" and you will see the program
  8. You have to change the date on "version=ddmmmyy" to the current date
  9. Change also the date on "enddate=ddmmmyyyy" to the currecnt date
  10. Then click run "picture of a man walking" about 5 minutes to run
  11. Click Save
  12. Click (X) it will ask you if you want to replace the previous output click "Yes"
  13. Will ask you if sure to leave SAS click "Yes"

Steps for Processing of TISS errors Error

TISS Error Output from SAS is located in\\Hsc1msfp0001\med_ccmed\PAGASA\TISS28

  1. Open the Tiss28Errors_01Oct2015_b_rtf, to see the output error.
  2. Copy the list in excell so you can manipulate the filter.
  3. Error on Date,Location,Missing day or Extra day checked the "EPR" to see patient visit info.
  To navigate in EPR get the chart number or you can search by name also.
   *Click File then Find Patient then enter the chart number on the ID  and the site location on the IDlocation then Search.
   *Note for Stb you have to add "0" then the chart number then Search,
     for other sites you dont need to do that.  
   *Once you get patient name highlighted it then click Shows visits.
   *Click the date you want to see the admission then click "OK".
   *Then click to Registration then Visit Location then Location History will pop up the admission of the patient.
  1. If after investigation you cannot reconcile the error that is the only time you ask the collector by email or by phone.
  • It appear that: Sometimes TISS form is printed out other times not. Sometimes a for is filled out for missing day and scanned in, other times not and extra day manually added to tiss.data.mdb.

Disposal of TISS forms

After error correction is completed for a batch the forms will be disposed as confidential waste.

transitional

We will test that disposal is OK for 4 weeks. During this time Pagasa will keep the forms for every error correction episode in a pile (no further processing or sorting). If, by 2015-May-15, we are comfortable that we have not had to refer back to the forms we will start to dispose of them right away as per above. At that point this paragraph can be deleted.

Filing of TISS28 forms

Being stored as electronic and paper form.

Electronic Images

The scanned images are stored on the following network share:

  • \\hsc1msfp0001\med_ccmed\TISS28\ExportData\Images

This share has a sub-folder for each batch that has been processed. Currently there are two types of batch numbers. Any folder in this directory with the suffix: "_old" is pre-Windows7. The Windows 7 upgrade involved upgrading Teleform. The Teleform upgrade caused a reset to the sequence of batch numbers. All code in the TISS28 DB has been updated and is fully operational for this change. All batches going forward are simply numeric.

Locating Images

There are two methods that can be used to locate an image. Simply by serial number - this is the serial number entered on the form at the hospital. There are duplicate serial numbers and this method will return all potential matches but will show the following information:

  • Site
  • Unit
  • Serial
  • Batch No
  • First Date
  • Image File - with the option to open and view the file (click the button next to this field on the form)

An alternate method is to search based on a combination of: Site + Unit + Serial

This method reports the same data outlined above.

Backups of the Forms

The forms are backed up from the scanner PC to X:\TISS28\ExportData\Images


Supplementary Information

Other things to resolve with data processing

  • site STB ICMS & STB ICCS - will want a PROGRAM & not a data collector to correct the location name on form for STB
  • if STB_ICMS convert to STB_MICU
  • if STB_ICCS convert to STB_CICU

Is this an outstanding problem? If so, please add to Change Priorities. Ttenbergen 19:32, 2014 April 30 (CDT)Trish Ostryzniuk 18:33, 2015 March 13 (CDT)Template:Potential Change

Trouble shooting of the tiss 28 forms

  • If encountered problem like this message "the instruction at 0X3894ffo"
  • Go to X:\Tiss28
  • Then open the ExportData with 2 folders 1) Images 2)Archives.
  • Archive is the csv data of the batch you scanned and verified after you commited the batch in the Teleform it goes to the Archive folder.
  • Sometimes the error messages shows up when commitng so I dont import the batch and check what is the problem.
  • Some of the common error are if the Location or the Site is incorrect it just give you this error message"the instruction at 0X3894ffo
  • Go To Access database into the Edit Tiss data click find and enter the serial number.

Original transition from TISS76 to TISS28

  • Example: If patient has one page already completed in December and a NEW TISS form is started Jan 1, is this page number 2?
    • as addressed in email over holidays, doesn't matter what number is used since the field is not imported. Ttenbergen 11:10, 2013 January 7 (EST)

January 1, 2013 - New TISS28 forms; we will scan all pages for entire patients LOS in ICU. New form will have 7 days per form. TISS28 data will NOT be uploaded to master TMSX (Critical Care) database. See TISS28_data_specifications#Location_of_data about where thsi will be stored.