Query TISS Errors NrTISSDays NE LOS: Difference between revisions

Latest revision as of 15:32, 14 April 2022

This page contains Legacy Content.

Click Expand to show legacy content.

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, 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:	declined
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

2021-10-07 - deleted as part of Change to collect TISS data in CCI Picklist
2019-02-11 - changed to only look at discharges within the last 90 days, instead of all since 2013

@@ Line 5: / Line 5: @@
 {{Data Integrity Check
 |DIC_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).
-|DIC_related_concepts=LOS; TISS; Arrive DtTm field; Dispo DtTm field
+|DIC_related_concepts=LOS; TISS; Dispo DtTm field
 |DIC_firmness=hard check
 |DIC_coding=query ''TISS_Errors_NrTISSDays_NE_LOS''
@@ Line 12: / Line 12: @@
 |DIC_app=CCMDB.accdb
 }}
-.
 See [[Query check CCI TISS NrDays LT LOS]] and [[Query check CCI TISS NrDays GT LOS]] instead.