TISS28 Form Scanning: Difference between revisions

Line 66:

When all forms/batches for "this round" have been scanned, run each of the TISS_Error_* queries

* If query is empty, run next;

* If query is empty, run next; else:

* if query has records, that might be OK as well, especially for TISS_Errors_NrTissDays, some are just not here yet

=== TISS_Errors_duplicate_Items ===

If any records are listed,

# delete in L_TISS_Form

# ndelete in L_TIIS_Item

# re-scan

Could fix these one by one, but usually it's quickest to just re-scan.

=== TISS_Errors_missing_days ===

If any records are listed:

* compare the Arrive and Dispo dates to dates covered;

** consider if the record is currently relevant, if not, could ignore

*** between reports, only do HSC ICUs because of CRRT

*** we may only looking until e.g. end of last month

** look up the patient in EPR to confirm adm and dis date, correct in [[CFE]] if different than EPR

** otherwise, TISS is wrong (usually missing or extra day); usually it's the first or last day that is missing, sometimes one in middle

*** get [[copy of info for pt]] from CFE

*** scan TISS form and blank out the addressograph

*** email collector with the question

*** no log of these questions is kept

* when collector provides info for missing day, add data in L_TISS_Item table

=== TISS_Errors_NrTISSDays_NE_LOS ===

* If query has records, that might be OK as well, especially for TISS_Errors_NrTissDays, some are just not here yet

(info only: TISS_Errors_NrTissDays usually has errors...)

=== additional thoughts... ===

{{discussion}} Tina needs to integrate this into documentation somewhere: The reason the checks are done in TISS rather than CFE, even though CFE is used to look up and email, is to reduce push-pull cycles. Also because always in the morning during send window. Need to think about this further. Ttenbergen 11:33, 2017 June 20 (CDT)

@@ Line 66: / Line 66: @@
 When all forms/batches for "this round" have been scanned, run each of the TISS_Error_* queries
-* If query is empty, run next;
+* If query is empty, run next; else:
-* if query has records, that might be OK as well, especially for TISS_Errors_NrTissDays, some are just not here yet
+=== TISS_Errors_duplicate_Items ===
+If any records are listed,
+# delete in L_TISS_Form
+# ndelete in L_TIIS_Item
+# re-scan
+Could fix these one by one, but usually it's quickest to just re-scan.
+=== TISS_Errors_missing_days ===
+If any records are listed:
+* compare the Arrive and Dispo dates to dates covered;
+** consider if the record is currently relevant, if not, could ignore
+*** between reports, only do HSC ICUs because of CRRT
+*** we may only looking until e.g. end of last month
+** look up the patient in EPR to confirm adm and dis date, correct in [[CFE]] if different than EPR
+** otherwise, TISS is wrong (usually missing or extra day); usually it's the first or last day that is missing, sometimes one in middle
+*** get [[copy of info for pt]] from CFE
+*** scan TISS form and blank out the addressograph
+*** email collector with the question
+*** no log of these questions is kept
+* when collector provides info for missing day, add data in L_TISS_Item table
+=== TISS_Errors_NrTISSDays_NE_LOS ===
+* If query has records, that might be OK as well, especially for TISS_Errors_NrTissDays, some are just not here yet
 (info only: TISS_Errors_NrTissDays usually has errors...)
+=== additional thoughts... ===
 {{discussion}} Tina needs to integrate this into documentation somewhere: The reason the checks are done in TISS rather than CFE, even though CFE is used to look up and email, is to reduce push-pull cycles. Also because always in the morning during send window. Need to think about this further. Ttenbergen 11:33, 2017 June 20 (CDT)