Query TISS Errors NrTISSDays NE LOS: Difference between revisions

Revision as of 10:01, 2021 September 2

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

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

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

@@ Line 5: / Line 5: @@
 |DIC_coding=query ''TISS_Errors_NrTISSDays_NE_LOS''
 |DIC_implementation_date=2016-07-11
-|DIC_status=needs review
+|DIC_status=deferred
 |DIC_app=CCMDB.accdb
 }}
+.
-{{Discuss|
+See [[Query check CCI TISS NrDays LT LOS]] and [[Query check CCI TISS NrDays GT LOS]] instead.
-Is this check actually needed?
-* [[Query check CCI Date]] already checks to make sure the entries are all within the admission.
-* There might be more than one TISS entry per day (also see [[Query check CCI Picklist duplicates]])
-* We need to accommodate a second TISS entry on days for which there is a ?[[Boarding Loc]] entry, and that second entry must have a time (see [[Change to collect TISS data in CCI Picklist]]).
-* [[Query TISS Errors missing days]] does something closely related
-}}
 == Causes and solutions ==
@@ Line 34: / Line 28: @@
 {{Related Articles}}
-[[Category:TISS28 checks]]
+[[Category:Legacy TISS28 checks]]
-[[Category:Data Processing]]
-[[Category:Length of stay]]
-[[Category:Registry checks]]
-[[Category:TISS28 Scanning Process]]