Query check CCI TISS Intubation vs Intubated: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 6: Line 6:
|DIC_coding=query ''NDC_TISS_Extubation_only_on_TISS_Intubated_days''
|DIC_coding=query ''NDC_TISS_Extubation_only_on_TISS_Intubated_days''
|DIC_implementation_date=
|DIC_implementation_date=
|DIC_status=retired
|DIC_status=ready to implement
|DIC_app=Centralized data front end.accdb
|DIC_app=CCMDB.accdb
}}
}}


== more info ==
== more info ==
if extubated unplanned (#28) or planned (#29) and reintubated (#40) are marked on the same day, then ETT present (#22) or vent anytime (#18) should be marked
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 ===
{{TISS w Nr | Planned extubation (TISS Item)}} 
{{TISS w Nr | Unplanned extubation (TISS Item)}} 
{{TISS w Nr | Insertion of ETT (TISS Item)}}
 
=== ETT or ventilation ===
{{TISS w Nr | ETT Present (TISS Item)}}
{{TISS w Nr | Invasive Mechanical Ventilation}}


== Related articles ==
== Related articles ==

Revision as of 18:28, 2020 December 2

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
  • Cargo


  • SMW


  • Categories: 
  • form:

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 

Related articles

Related articles: