TISS28 Form Scanning: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "[["Copying" Centralized_data.accdb]]" to ""Copying" Centralized_data.accdb " |
|||
| (22 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
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]]. | 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]]. | ||
| Line 9: | Line 10: | ||
== Preparation == | == Preparation == | ||
=== Get files to PC === | === Get files to PC === | ||
* Follow the process in [["Copying" | *a. Follow the process in [["Copying" Centralized_data.accdb]] | ||
* click the "'''Reconnect .MDBs'''" button <!-- this is NOT [[Reconnect CFE and initial error checks]], the cross | 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 check]]s 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 === | === forms === | ||
''' There used to be preparation of forms, but there no longer is.''' I.e leave the page numbers alone, or use 001. | ''' There used to be preparation of forms, but there no longer is.''' I.e leave the page numbers alone, or use 001. | ||
== Scanning forms == | == Scanning forms == | ||
| Line 40: | Line 46: | ||
Info only: | Info only: | ||
* When you click commit the batch sits in | * When you click commit the batch sits in {{S:\MED\MED_CCMED}}TISS28\ExportData | ||
* See [[TISS28 form images]] for how these images are dealt with after processing | * See [[TISS28 form images]] for how these images are dealt with after processing | ||
==Importing batch into [[TISS28. | ==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 | # click "Re-connect.MDBs" button one time only at the beginning | ||
# Click "Import TISS Data", click "OK" for success message (takes <1 minute) | # 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) | #* when done, program says "Successfully imported data from <THE NUMBER> TISS forms." (this number is pretty much never wrong) | ||
| Line 51: | Line 57: | ||
# A table will show up - "qryConfirmImport" | # A table will show up - "qryConfirmImport" | ||
# Verify that you have a line with correct D_ID for each form | # Verify that you have a line with correct D_ID for each form | ||
# Close the '''[[TISS28. | # Close the '''[[TISS28.accdb]]''' when you have completed all the forms | ||
===Scan batch number recording & temporary form stacking=== | ===Scan batch number recording & temporary form stacking=== | ||
| Line 67: | Line 73: | ||
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. | 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 | * 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: | * If query is empty, run next; else: | ||
<!-- see [[Template:Data Integrity Check]] for how to get things on this list. --> | <!-- see [[Template:Data Integrity Check]] for how to get things on this list. --> | ||
{{#ask: [[DICApp::TISS28. | {{#ask: [[DICApp::TISS28.accdb]] | ||
|?DICStatus = Status | |?DICStatus = Status | ||
|?Modification date | |?Modification date | ||
| Line 86: | Line 90: | ||
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]]. | 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. | *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 == | == background info == | ||
| Line 97: | Line 96: | ||
'''2013-Jan-01''' | '''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. | *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 == | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category:Legacy Data Processing]] | |||
[[Category:TISS28 Scanning Process | *]] | [[Category:TISS28 Scanning Process | *]] | ||
[[Category: Teleform]] | [[Category:Teleform]] | ||
[[Category: Data Processing]] | [[Category:Data Processing]] | ||
[[Category: TISS Scanning]] | [[Category:TISS Scanning]] | ||
[[Category: TISS28]] | [[Category:TISS28.accdb]] | ||