CCMDB Wiki

Query check CCI TISS discontinuous ETT: Difference between revisions

← Older editNewer edit →
mNo edit summary
Line 36: Line 36:
** Error: ETT_2, ETT_3, extub_2, no intub_2, no intub_3
** Error: ETT_2, ETT_3, extub_2, no intub_2, no intub_3


== remaining questions ==
Another scenario:
*yesterday I have ETT
*today you t40 new insertion marked,
*but there is no extubation either yesterday or today


If patient has {{TISS w Nr | Planned extubation (TISS Item)}} or {{TISS w Nr | Unplanned extubation (TISS Item)}} they have to have to also be intubated that day
Another scenario:  
 
*ett2 not null
*{{TISS w Nr | Planned extubation (TISS Item)}} or {{TISS w Nr | Unplanned extubation (TISS Item)}} can only be marked when both
*intub3 not null
** 1) {{TISS w Nr | Insertion of ETT (TISS Item)}} is marked on same day '''and'''
*extub2 null
** 2) {{TISS w Nr | ETT Present (TISS Item)}} is marked in previous day.
*extub3 null  
* the sequence is being intub yesterday and the next day extub then new insertion on same day.
{{DT |
* Most intubated patients eventually get extubated without getting intubated again; this check would flag every one of them! Is that actually what you want, or am I misunderstanding this one?
** Julie explained:
***yesterday I have ETT
***today you t40 new insertion marked,
***but there is no extubation either yesterday or today
 
ie.
ett2 not null
intub3 not null
extub2 null
extub3 null  
 
Meaning I could simply broaden my third criteria line by not also requiring ett3 to be not null
 
}}


*{{TISS w Nr | Planned extubation (TISS Item)}} or {{TISS w Nr | Unplanned extubation (TISS Item)}} can only be marked when both  
*{{TISS w Nr | Planned extubation (TISS Item)}} or {{TISS w Nr | Unplanned extubation (TISS Item)}} can only be marked when both  
Line 65: Line 51:
**2) {{TISS w Nr | ETT Present (TISS Item)}} is not marked the next day.  
**2) {{TISS w Nr | ETT Present (TISS Item)}} is not marked the next day.  
* the sequence is today new insertion then extub and tomorrow has no tube.  
* the sequence is today new insertion then extub and tomorrow has no tube.  
{{DT |
* I don't even understand when this check would ever make sense... what do you mean with this one? 
**new insertion today
**tomorrow there is no ETT present
**there needs to be an extub present today


* added as criteria 5
Another scenario
}}
*new insertion today
*tomorrow there is no ETT present
*there needs to be an extub present today


== Log ==
== Log ==
* 2022-02-09 - updated to broaden criteria 3 to not require ett3 to be any specific value
* 2022-02-09 - updated to broaden criteria 3 to not require ett3 to be any specific value; added criteria 5
* 2022-01-11 - updated to link days by Pat_ID properly
* 2022-01-11 - updated to link days by Pat_ID properly
* 2022-01-10 - updated to work right with param parameter
* 2022-01-10 - updated to work right with param parameter
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_CCI_TISS_discontinuous_ETT"