Query TISS Errors NrTISSDays NE LOS

From CCMDB Wiki
Jump to navigation Jump to search

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