Query check CCI TISS discontinuous ETT

From CCMDB Wiki
Revision as of 23:50, 2021 November 10 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search
Data Integrity Checks
Summary: T22 - ETT Present (TISS Item) should start with an T40 - Insertion of ETT (TISS Item) and end with an T28 - Planned extubation (TISS Item) or T29 - Unplanned extubation (TISS Item).
Related: Insertion of ETT (TISS Item), Planned extubation (TISS Item), Unplanned extubation (TISS Item)
Firmness: soft check
Timing: always
App: CCMDB.accdb
Coding: query check_CCI_TISS_discontinuous_ETT
Uses L Problem table: not relevant for this app
Status: ready to implement
Implementation Date: 2021-11-10
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

This query checks for some scenarios around intubation that are possible, but are entered erroneously often enough to make it worth warning about them. It is implemented as a soft check, so collectors can click past it.

  • Should we include a request to add a comment in notes when clicking past this to preempt future follow-up? Ttenbergen 13:36, 2021 November 10 (CST)
  • SMW


  • Cargo


  • Categories

The check

intubation or extubation

ETT or ventilation

conditions

remaining questions

  • Most intubated patients eventually get extubated without getting intubated again; this check would flag every one of them! Is that actually what you want, or am I misunderstanding this one?
  • SMW


  • Cargo


  • Categories
  • I don't even understand when this check would ever make sense... what do you mean with this one?
  • SMW


  • Cargo


  • Categories

Log

  • 2021-11-10 - implemented query but not calling it from code yet, want Lisa or someone to check on this

Related articles

Related articles: