Query TISS Errors ETT consistent

From CCMDB Wiki
Jump to navigationJump to search
Data Integrity Checks
Summary: Checks that ETTs are only removed if previously present and only added when not present.
Related: Planned extubation (TISS Item), Unplanned extubation (TISS Item), ETT Present (TISS Item), Insertion of ETT (TISS Item)
Firmness: hard check
Timing: always
App: CCMDB.accdb
Coding: Query TISS_Errors_ETT_consistent
Uses L Problem table: not relevant for this app
Status: needs review
Implementation Date:
Backlogged: true


  • Cargo


  • SMW


  • Categories: 

Julie requested

extubate only when tube present

T28 - Planned extubation (TISS Item) or T29 - Unplanned extubation (TISS Item) can only be marked when T22 - ETT Present (TISS Item) is marked in same day.

extubate only when new tube inserted

T28 - Planned extubation (TISS Item) or T29 - Unplanned extubation (TISS Item) can only be marked when both 1) T40 - Insertion of ETT (TISS Item) is marked on same day and 2) T22 - ETT Present (TISS Item) is marked in previous day.

T28 - Planned extubation (TISS Item) or T29 - Unplanned extubation (TISS Item) can only be marked when both 1) T40 - Insertion of ETT (TISS Item) is marked on same day and 2) T22 - ETT Present (TISS Item) is not marked the next day.

StatsLogo.svg
  • A patient might arrive intubated, so there would be no intubation. Does this check really make sense? Ttenbergen 23:23, 2019 March 25 (CDT)
    • I have revised the conditions, pls check if they now make sense.--JMojica 16:38, 2019 July 9 (CDT)
      • Actually, no: Someone can arrive intubated from another ICU and then be extubated their first day here. I don't see how Insertion can be included in these two. Ttenbergen 20:13, 2020 December 2 (CST)
  • SMW


  • Cargo


  • Categories

new tube inserted

When T40 - Insertion of ETT (TISS Item)(T40) is marked, the T22 - ETT Present (TISS Item)(T22) must also be marked in same day.

Related articles

Related articles: