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 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=
|DIC_summary=
Any marked TISS Item in {{TISS w Nr | Planned extubation (TISS Item)}} or in {{TISS w Nr | Unplanned extubation (TISS Item)}} must have the {{TISS w Nr | ETT Present (TISS Item)}} on the same date. But also intubation...  
Any marked TISS Item in {{TISS w Nr | Planned extubation (TISS Item)}} or in {{TISS w Nr | Unplanned extubation (TISS Item)}} must have the {{TISS w Nr | ETT Present (TISS Item)}} on the same date.
|DIC_related_concepts=Insertion of ETT (TISS Item);  Planned extubation (TISS Item); Unplanned extubation (TISS Item)
|DIC_related_concepts=Insertion of ETT (TISS Item);  Planned extubation (TISS Item); Unplanned extubation (TISS Item)
|DIC_firmness=hard check
|DIC_firmness=hard check

Revision as of 10:57, 2021 September 1

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.
Related: Insertion of ETT (TISS Item), Planned extubation (TISS Item), Unplanned extubation (TISS Item)
Firmness: hard check
Timing: always
App: CCMDB.accdb
Coding: query check_CCI_TISS_Intubation_vs_Intubated
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2021-01-28
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

ETT or ventilation

Log

  • 2021-01-28 - Query implemented

Related articles

Related articles: