Query check CCI TISS Intubation vs Intubated
| Data Integrity Checks | |
| Summary: | Any marked TISS Item in T28 - Planned extubation (TISS Item) or in T29 - Unplanned extubation (TISS Item) must have the T22 - ETT Present (TISS Item) on the same date. But also intubation... |
| Related: | Insertion of ETT (TISS Item), Planned extubation (TISS Item), Unplanned extubation (TISS Item) |
| Firmness: | hard check |
| Timing: | always |
| App: | CCMDB.accdb |
| Coding: | query NDC_TISS_Extubation_only_on_TISS_Intubated_days |
| Uses L Problem table: | not relevant for this app |
| Status: | ready to implement |
| Implementation Date: | |
| Backlogged: | true |
more info
If any of #intubation or extubation is present on a day, then at least one of #ETT or ventilation also need to be marked for that day.
intubation or extubation
T28 - Planned extubation (TISS Item) T29 - Unplanned extubation (TISS Item) T40 - Insertion of ETT (TISS Item)
ETT or ventilation
T22 - ETT Present (TISS Item)
- Invasive Mechanical Ventilation