TISS28 form images: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 42: Line 42:
[[Category:TISS28.mdb]]
[[Category:TISS28.mdb]]
[[Category:Data Processing]]
[[Category:Data Processing]]
[[Category:TISS28 Scanning Process]]

Revision as of 13:58, 11 February 2019

TISS28 Form Scanning produces electronic images of the TISS28 forms. We keep these permanently and dispose of the actual paper forms as described in TISS28 Form Scanning.


needs cleaning up, just dumping here for now

  • SMW


  • Cargo


  • Categories

Backups of the Forms

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


Electronic Images

The scanned images are stored on the following network share:

  • \\hsc1msfp0001\med_ccmed\TISS28\ExportData\Images (X)

This share has a sub-folder for each batch that has been processed. Currently there are two types of batch numbers:

  • a) e.g. 00002421_old (numeric with txt)
  • b) e.g. 00001222 (numeric)
    • Any folders with the suffix: "_old" is pre-Windows7. The Windows 7 upgrade involved upgrading Teleform. The Teleform upgrade caused a reset of 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 only numeric.

finding images

If you cannot link to scannned tiss image via tiss28.mdb then you will need to find image manually. in TISS28.mdb go to L_TISS_FORM to find the batch number of the D_ID.

  • 2018-Dec-5: Computer was changed and new computer now Windows 10. Teleform migrated to new computer and caused a "reset" of the sequence of batch numbers to one.
      • Jan 17, 2019 onward, able to link from tiss28.mbd to the scanned image folder on X . (batch 173 onward)
      • Dec 5, 2018 to Jan 16, 2019: not able to link from tiss28.mdb to scanned image folder. Must go to manually to the image folder on X. (Batch 1-172).
      • Apr 13, 2017 to Dec 4, 2018: able to link from tiss28.mdb to scanned image folder on X. (batch 2999-5891).
      • ? to Apr 11, 2017" not able to link from tiss28.mbd to the scanned image folder on X. (batch 200-2998)
      • 2013-2015: not able to link form tiss28.mbd to the scanned image folder on X. (not details for dates because some of the 2015 scanned files somehow are mixed into the 2019 scanned batches)

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

Related articles

Related articles: