Query TISS Errors NrTISSDays NE LOS: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
PTorres (talk | contribs)
CCMDB_legit, approved
1,617 edits
PTorres (talk | contribs)
CCMDB_legit, approved
1,617 edits
Line 10: Line 10:


== Causes and solutions ==
== 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 '''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]].<!-- but this is not duplication, because missing days actually lists the individual missing days -->
{{Discuss | who=Pagasa | question =
* If it generally shows up there, then should THIS query really only look for TISS_Days > LOS? No sense showing those twice... }}
 
* if LOS '''higher than''' TISS_Day_Count
* if LOS '''higher than''' TISS_Day_Count
** the problem might be  
** the problem might be  

Revision as of 15:36, 11 February 2019

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: TISS28.mdb
Coding: query TISS_Errors_NrTISSDays_NE_LOS
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2016-07-11
Backlogged: true
  • Cargo


  • SMW
"TISS28.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property.
  • Categories:  
  • form:

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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_TISS_Errors_NrTISSDays_NE_LOS&oldid=135173"