Query TISS Errors NrTISSDays NE LOS

Data Integrity Checks
Summary:	Length of stay (LOS) for all ICU patients must be consistent with their number of TISS days, incl no TISS days at all (ie missing forms).
Related:	LOS, TISS, Arrive DtTm field, Dispo DtTm field
Firmness:	hard check
Timing:	always
App:	TISS28.mdb
Coding:	query TISS_Errors_NrTISSDays_NE_LOS
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2016-07-11
Backlogged:	true

• Cargo

• SMW

"TISS28.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. 

• Categories:  

• form:

Causes and solutions

• if LOS lower than TISS_Day_Count, there likely is a missing TISS form, likely; this would probably have shown up and been questioned for Query TISS Errors missing days.

If it generally shows up there, then should THIS query really only look for TISS_Days > LOS? No sense showing those twice...

• SMW

• Cargo

• Categories

• if LOS higher than TISS_Day_Count
  • the problem might be
    • form may not have arrived and been scanned yet (e.g. consider if collector is away, forms may just not be here yet)
    • form may have been scanned with wrong serial or unit (either form wrong, or not wrong in verifier)
  • review images of TISS forms
    • copy D_ID
    • open "lookup image" form and paste into and click image button
  • review dates in EPR, possibly

Log

• 2019-02-11 - changed to only look at discharges within the last 90 days, instead of all since 2013