CCMDB Wiki

TISS28 Form Scanning: Difference between revisions

← Older editNewer edit →
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
mNo edit summary
Line 126: Line 126:


* 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 [[TISS28 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 [[TISS28 Data.mdb]].
== background info ==
===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. 
===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===
===Backups of the Forms===
Line 200: Line 177:
**You have a text box stating that your about to record one record.  Click Yes.
**You have a text box stating that your about to record one record.  Click Yes.
* Close out of the L_TISS_Item table.
* Close out of the L_TISS_Item table.
   
 
== background info ==
===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.  
 
===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.


==Other things to resolve with data processing==
==Other things to resolve with data processing==
Retrieved from "https://ccmdb.kuality.ca/index.php?title=TISS28_Form_Scanning"