Query check CCI TISS Intubation vs Intubated

From CCMDB Wiki
Revision as of 18:06, 2020 December 2 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search
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: Centralized data front end.accdb
Coding: query NDC_TISS_Extubation_only_on_TISS_Intubated_days
Uses L Problem table: not entered
Status: retired
Implementation Date:
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

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

Related articles

Related articles: