Query check CCI InExtubation consistent: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 12: Line 12:
  | who = Tina  
  | who = Tina  
  | todo_added = 2021-07-15   
  | todo_added = 2021-07-15   
  | todo_action = 2021-07-22
  | todo_action = 2021-07-27
  | question = _Dev_CCMDB
  | question = _Dev_CCMDB
* This could be done in CCMDB instead now that we collect TISS there. Confirming with Lisa if she thinks this would be problematic.  
* This could be done in CCMDB instead now that we collect TISS there. Confirming with Lisa if she thinks this would be problematic.  
** Lisa couldn't think of problems with it either, so will implement like this to start and we can tweak if there are problems. [[User:Ttenbergen|Ttenbergen]] 09:52, 2021 July 27 (CDT)
}}
}}



Revision as of 09:52, 2021 July 27

Data Integrity Checks
Summary: Any marked TISS Item T40 - Insertion of ETT (TISS Item) or in T22 - ETT Present (TISS Item) must have at least one marked TISS item either in T28 - Planned extubation (TISS Item) or in 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:
Uses L Problem table: not relevant for this app
Status: ready to implement
Implementation Date:
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

_Dev_CCMDB

  • This could be done in CCMDB instead now that we collect TISS there. Confirming with Lisa if she thinks this would be problematic.
    • Lisa couldn't think of problems with it either, so will implement like this to start and we can tweak if there are problems. Ttenbergen 09:52, 2021 July 27 (CDT)
  • added: 2021-07-15
  • action: 2021-07-27
  • Cargo


  • Categories

Insertion of ETT and Extubation consistency

Soft check

This will be implemented as a soft check because, due to the fact we only allow one entry per day for the CCIs, there are scenarios in which the difference would be more than 1.

Examples:

  • Pt arrives intubated. On day 1, they are extubated. On day 2 they are intubated, extubated and then intubated again on the same day, which will look on TISS as one insertion on that day and one removal. If you then had a removal the next day you will have an error because you have a count of 3 extubations with only 1 intubation.
  • We don’t always extubate for those that are ill and have cardiac arrest and die, we often leave the ETT in

Related articles

Related articles: