Query TISS Errors NrTISSDays NE LOS: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 10: Line 10:


{{Discuss|
{{Discuss|
Is this check actually needed?
* [[Query check CCI Date]] already checks to make sure the entries are all within the admission.  
* [[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]])
* 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]]).
* 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
}}
}}


Line 33: Line 34:
{{Related Articles}}
{{Related Articles}}


[[Category: TISS28 checks]]
[[Category:TISS28 checks]]
[[Category: Data Processing]]
[[Category:Data Processing]]
[[Category: Length of stay]]
[[Category:Length of stay]]
[[Category:Registry checks]]
[[Category:Registry checks]]
[[Category:TISS28 Scanning Process]]
[[Category:TISS28 Scanning Process]]

Revision as of 22:31, 2020 December 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: needs review
Implementation Date: 2016-07-11
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

Is this check actually needed?

  • SMW


  • Cargo


  • Categories

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

Related articles: