Query TISS Errors NrTISSDays NE LOS: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "Legacy TISS28 checks" to "Legacy TISS28 check")
mNo edit summary
(One intermediate revision by the same user not shown)
Line 1: Line 1:
{{LegacyContent
|explanation=deleted as part of [[Change to collect TISS data in CCI Picklist]]
|content= 
{{Data Integrity Check
{{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_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).
Line 5: Line 9:
|DIC_coding=query ''TISS_Errors_NrTISSDays_NE_LOS''
|DIC_coding=query ''TISS_Errors_NrTISSDays_NE_LOS''
|DIC_implementation_date=2016-07-11
|DIC_implementation_date=2016-07-11
|DIC_status=deferred
|DIC_status=declined
|DIC_app=CCMDB.accdb
|DIC_app=CCMDB.accdb
}}
}}
Line 23: Line 27:


== Log ==
== Log ==
* 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
* 2019-02-11 - changed to only look at discharges within the last 90 days, instead of all since 2013


Line 29: Line 34:


[[Category:Legacy TISS28 check]]
[[Category:Legacy TISS28 check]]
}}

Revision as of 16:06, 2021 October 7

Legacy Content

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, 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: declined
Implementation Date: 2016-07-11
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

. 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

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_TISS_Errors_NrTISSDays_NE_LOS&oldid=152327"