CCMDB Wiki

TISS28 Form Scanning: Difference between revisions

← Older editNewer edit →
m m
Line 49: Line 49:
#  It will show up TISS serial number imported and you can check against the TISS forms
#  It will show up TISS serial number imported and you can check against the TISS forms


===Update [[TISS28.mdb]]===
=== fix lowercasing of last letter in HSC ICU names ===
#  Once you finished importing all the tiss
#  Once you finished importing all the tiss
#  Run this query "'''2016-08-22-sameCasing"''' - (limitation of Teleform, cannot use lowercase letter, this query changes lower case letter for HSC ICU a, b, h, d  to uppercase).
#  Run this query "'''2016-08-22-sameCasing"''' - (limitation of Teleform, cannot use lowercase letter, this query changes lower case letter for HSC ICU a, b, h, d  to uppercase).
Line 55: Line 55:


===Scan batch number recording & temporary form stacking===
===Scan batch number recording & temporary form stacking===
*After you import a group of tiss,  put the batch number only on the first form then stack it beside the work station.
* After you import a group of tiss,  put the batch number only on the first form then stack it beside the work station.


===Disposing of the tiss forms===
===Disposing of the tiss forms===
* We keep 3 months of tiss form stack then we confidential waste the oldest tiss group stack.
* We keep 3 months of tiss form stack then we confidential waste the oldest tiss group stack.


===Error Checker Run by [[SAS]]===
*  SAS error checker not using it anymore.
*  We are using Access Error Checker.
**  Access Query Error Checks
    Double Click
  #  Tiss_Errors_DID_inconsistent_w_location.
  #  Tiss_Errors_duplicate_D_IDs_in_patient.
  #  Tiss_Errors_NrTissDays_NE_LOS.
  #  Tiss_Error_orphan_patient_entries.
  #  Tiss_Errors_TISS_date_out_of_admission. 
*Are there special steps how to review the data in each of these excel outputs by the processor? 
*How should this be run and reviewed, weekly or few weeks before quarterly report? 
*What is the process if errors are found?
By running SAS checker, 3 files are outputted in excel format:
*'''TISS28Errors''' (with date run)-report contains the extra TISS days and the missing TISS days
*'''TISS28Pending''' (with date run)- use by Julie, so she can quickly see last date up to which there is complete data in TISS28.data.mdb
*'''Tiss28Reminder''' (with date run)-Started March 2016 - lists record status of all complete and incomplete with missing TISS, 14 days prior to current date.
#  To run this program use the laptop or Julie's computer with SAS program  ({{Discussion}} Pagasa has password - needs to be put on excel main office use only password list located on:  M drive)
#  Double click on the '''SAS 9.3''' a message will pop up click "close"
#  Go to File  then  Open program
#  Go to My Computer, find: X drive
#  On X drive double click on PAGASA's folder
#  Double click on TISS28 folder
#  Double click on "'''chkTiss28CD_ver6'''" and you will see the program
#  You must change the date on "'''version=ddmmmyy'''" to the ''current date''
#  Change also the date on "'''enddate=ddmmmyyyy'''" to the ''currecnt date''
#  Then click run "'''picture of a man walking" .  Takes about 5 minutes to run.
#  Click SAVE
#  Click (X) it will ask you if you want to replace the previous output click "YES"
#  Will ask you if sure to leave SAS click "YES"


===Steps for Processing of TISS errors Error===
===Steps for Processing of TISS errors Error===
Line 101: Line 67:
#  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.
#  If after investigation you cannot reconcile the error that is the only time you ask the collector by email or by phone.
#  If after investigation you cannot reconcile the error that is the only time you ask the collector by email or by phone.
== Cross-checking patient data in EPR ==
{{discussion}} that is not unique to TISS, right? If so we should break it out and link to it as appropriate, also from the other checks where it is relevant. Ttenbergen 17:13, 2017 January 26 (CST)


To navigate in EPR get the chart number or you can search by name also.
To navigate in EPR get the chart number or you can search by name also.
Line 110: Line 79:
*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]].


=== Disposal of TISS forms ===
Data processor keeps scanned forms at workstation.  Approx. 4 months of forms are kept, then oldest is disposed end of 4th month
as confidential waste.


== background info ==
== background info ==
Line 118: Line 84:
'''January 1, 2013'''
'''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.   
*TISS28 data for the '''entire LOS''' is scanned and stored in new repository [[TISS28_Data.mdb]]. This form has 7 days per page.   
[[Category:Data Processing]]
==Filing of TISS28 forms==
Being stored as electronic and paper form.


===Electronic Images===
===Electronic Images===
Retrieved from "https://ccmdb.kuality.ca/index.php?title=TISS28_Form_Scanning"