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:
|
CCMDB.accdb
|
Coding:
|
query TISS_Errors_NrTISSDays_NE_LOS
|
Uses L Problem table:
|
not relevant for this app
|
Status:
|
deferred
|
Implementation Date:
|
2016-07-11
|
Backlogged:
|
true
|
"deferred" is not in the list (needs review, ready to implement, implemented, not entered, not feasible, declined, retired) of allowed values for the "DICStatus" property.
.
See Query check CCI TISS NrDays LT LOS and Query check CCI TISS NrDays GT LOS instead.
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 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
Related articles