CCMDB Wiki

Query check CCI TISS discontinuous ETT: Difference between revisions

← Older edit
 
(4 intermediate revisions by the same user not shown)
Line 6: Line 6:
|DIC_coding=query ''check_CCI_TISS_discontinuous_ETT''
|DIC_coding=query ''check_CCI_TISS_discontinuous_ETT''
|DIC_implementation_date=2021-11-10
|DIC_implementation_date=2021-11-10
|DIC_status=ready to implement
|DIC_status=implemented
|DIC_app=CCMDB.accdb
|DIC_app=CCMDB.accdb
|DIC_backlogged=No
|DIC_backlogged=No
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? 
Another scenario
**new insertion today
*new insertion today
**tomorrow there is no ETT present
*tomorrow there is no ETT present
**there needs to be an extub present today
*there needs to be an extub present today
This may already be covered if the status change is cross checked.
}}


== Log ==
== Log ==
* 2022-08-11 - tweaked the query to only run 1000 days back and to not include future dates (for a long-LOS pt the query was giving error "The query cannot be completed. Either the size of the query result is larger than the maximum size of a database (2GB), or there is not enough temporary storage space on the disk to store the query result.")
* 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"