CCMDB Wiki

Query check CCI TISS discontinuous ETT: Difference between revisions

← Older edit
 
(7 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:
*{{TISS w Nr | Planned extubation (TISS Item)}} or {{TISS w Nr | Unplanned extubation (TISS Item)}} can only be marked when both
*yesterday I have ETT
** 1) {{TISS w Nr | Insertion of ETT (TISS Item)}} is marked on same day '''and'''
*today you t40 new insertion marked,
** 2) {{TISS w Nr | ETT Present (TISS Item)}} is marked in previous day.
*but there is no extubation either yesterday or today
* the sequence is being intub yesterday and the next day extub then new insertion on same day.
 
{{DJ |
Another scenario: 
* 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?
*ett2 not null
}}
*intub3 not null
*extub2 null
*extub3 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 49: 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.  
{{DJ |
 
* I don't even understand when this check would ever make sense... what do you mean with this one? 
Another scenario
}}
*new insertion today
*tomorrow there is no ETT present
*there needs to be an extub present today


== 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-10 - updated to work right with param parameter
* 2022-01-10 - updated to work right with param parameter
* 2022-01-06 - activated as soft check
* 2022-01-06 - activated as soft check
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_CCI_TISS_discontinuous_ETT"