View source for TISS28 Form Scanning

 Legacy process 2020-Dec-7  (a few forms still coming and scanned Feb 2021 in from Dec 2020 backlog)
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_Data.mdb | 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]]

== Preparation ==
=== Get files to PC ===
*a. Follow the process in [["Copying" Centralized data.mdb]] to copy files used by this process into the [[Frozen]] folder on the [[Data Processor]]s desktop
*b. Open [[TISS28.accdb]] (use shortcut on processors desktop) 
**click the "'''Reconnect .MDBs'''" button <!-- this is NOT [[Reconnect CFE and initial error checks]], the cross checks involved with that don't apply here. -->

=== Teleform scan station prep ===
On scanner PC:
*a. Double-click on the '''Teleform Reader''' shortcut on the desktop (eyeglasses icon)
*b. double click to open '''Teleform Verifier'''

'''Ready to scan forms'''

=== forms ===
''' There used to be preparation of forms, but there no longer is.''' I.e leave the page numbers alone, or use 001.

== Scanning forms ==
For general scanning instructions including for TISS28, see [[Scanning_to_network#Instructions]].

''We have had repeated problems with the scanner, see [[Main office scanning problems]].''

== Verifying ==
=== Correcting forms ===
* wait for the last line to say "ready for correction" (starts as "evaluating") <!-- it always gets to this "OK" -->
* last line may be highlighted; double click on the last line
* will show error , how to correct
* can see error where highlited blue
* check each line that is "xed" out. click on the data point in the form and enter the correct value below
* click OK when asked "Saved corrections to results file?"
* when you are done correcting all lines, the program returns you to the Teleform Verifier

=== Finishing off / Committing a batch ===
* check if column Scan column and eval column have the same number in them
** '''only if different''', right-click line, discard, and start that batch over. 
* Right-click the batch and click "Commit"; say "Yes".

Info only: 
* When you click commit the batch sits in [[X:\]]TISS28\ExportData
* See [[TISS28 form images]] for how these images are dealt with after processing

==Importing batch into [[TISS28.accdb]]==
# if you have not done so before you started toscan started, open the '''[[TISS28.accdb]]''' (Access icon), Enter password  (a list of main office passwords are stored in an Excel file on "M")
# click "Re-connect.MDBs" button one time only at the beginning
# Click "Import TISS Data", click "OK" for success message (takes <1 minute)
#* when done, program says "Successfully imported data from <THE NUMBER> TISS forms." (this number is pretty much never wrong)
#* There might be an error titled "Form already exists" with content "a scanned form has a D_ID and first date that already exists in L_TISS Form.  Click OK to see query. You might be able to edit the TISS_export table to resolve the issue(e.g. delete the offending line).  Click OK to re-check or cancel and stop import."; if so see [[Deleting a duplicate record from the TISS pre-import file]]
# A table will show up - "qryConfirmImport" 
# Verify that you have a line with correct D_ID for each form
# Close the '''[[TISS28.accdb]]''' when you have completed all the forms

===Scan batch number recording & temporary form stacking===
* After you import a group of TISS forms,  put the batch number only on the first form then stack it on top of the left-most pile, rotating it 90 degrees from the previous batch
** make a new pile if the pile gets too high, >~2in

====Disposing of the TISS forms====
* We keep about 3 months / 3 stacks of TISS forms 
* [[Confidential waste disposal#HSC]] the oldest (right-most) pile when ready

== Error checking ==
The [[Data processor]] usually scans all forms that are currently waiting for scanning before processing the error checking queries because it is faster that way. However, this may require keeping track of progress between scanning sessions, so for anyone covering it might be better to process the queries before the end of each shift. 

See [[TISS28 Data Integrity Checks]] for a list of the scans and how to deal with them... 

When all forms/batches for "this round" have been scanned (possibly less often, we'll catch in the end), run each of the TISS_Error_* queries.  

* In the following, if there is data for an extra TISS day that is identical to previous, just delete it; if the "offending" TISS day is different from surrounding, then confirm with collector 
* If query is empty, run next; else:
<!-- see [[Template:Data Integrity Check]] for how to get things on this list. -->
{{#ask: [[DICApp::TISS28.accdb]]
 |?DICStatus = Status
 |?Modification date
 |limit=10000
 |format=broadtable
 |link=all
 |class=sortable wikitable smwtable
 |default= '''No {{PAGENAME}} found'''
}}

==== Why are these checks not done in CFE where the data would be easy to edit?  ====
The reason the checks are done in TISS rather than CFE, even though a frozen version of CFE is used to look up and email, is to reduce push-pull cycles. Could not pull current version of CFE to make changes because TISS Scanning is always done while collectors are [[Sending Patients]].
*Cannot scan tiss if CFE is in pull. I do scanning when CFE is in push and do the checking at the same time.

== background info ==

===Start Date===
'''2013-Jan-01'''
*TISS28 data for the '''entire LOS''' is scanned and stored in new repository [[TISS28_Data.mdb]]. This form has 7 days per page.
===Stop Date===
'''2020-Dec-7'''  
*See: [[Change to collect TISS data in CCI Picklist]]

== Related articles ==
{{Related Articles}}

[[Category:Legacy Data Processing]]
[[Category:TISS28 Scanning Process | *]]
[[Category:Teleform]]
[[Category:Data Processing]]
[[Category:TISS Scanning]]
[[Category:TISS28.accdb]]