Query check CCI TISS discontinuous ETT
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 |
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.
|
The check
intubation or extubation
- T28 - Planned extubation (TISS Item)
- T29 - Unplanned extubation (TISS Item)
- T40 - Insertion of ETT (TISS Item)
ETT or ventilation
conditions
- if previous date has no T22 - ETT Present (TISS Item) and today date has T22 - ETT Present (TISS Item) then T40 - Insertion of ETT (TISS Item) should be marked
- Error: No ETT_1, Has ETT_2, No intubation_2
- if previous date has T22 - ETT Present (TISS Item) and today date has no T22 - ETT Present (TISS Item) then previous date of the T29 - Unplanned extubation (TISS Item) or T28 - Planned extubation (TISS Item) should be entered
- Error: ETT_2, No ETT_3, no extub_2
- if previous date has T22 - ETT Present (TISS Item) and today date has T22 - ETT Present (TISS Item) and T40 - Insertion of ETT (TISS Item) are marked then today date of T29 - Unplanned extubation (TISS Item) or T28 - Planned extubation (TISS Item) should be marked
- Error: ETT_2, ETT_3, intub_3, no extub_2, no extub_3
- Error: ETT_2, ETT_3, extub_2, no intub_2, no intub_3
remaining questions
- 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.
- the sequence is being intub yesterday and the next day extub then new insertion on same 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.
- the sequence is today new insertion then extub and tomorrow has no tube.
Log
- 2021-11-10 - implemented query but not calling it from code yet, want Lisa or someone to check on this