Query check CCI InExtubation consistent

From CCMDB Wiki
Revision as of 14:23, 2021 July 15 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search
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.
  • added: 2021-07-15
  • action: 2021-07-22
  • 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.

Example: 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.

Related articles

Related articles: