CCMDB Wiki

Query check CCI TISS discontinuous ETT: Difference between revisions

← Older edit
No edit summary
 
(10 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
}}
}}
This query checks for some scenarios around intubation that are possible, but are entered erroneously often enough to make it worth warning about them. It is implemented as a soft check, so collectors can click past it.  
This query checks for some scenarios around intubation that are possible, but are entered erroneously often enough to make it worth warning about them. It is implemented as a soft check, so collectors can click past it.
 
{{Discuss |
* Should we include a request to add a comment in notes when clicking past this to preempt future follow-up? [[User:Ttenbergen|Ttenbergen]] 13:36, 2021 November 10 (CST)
}}


=== Could happen in case of Tracheostomy creation in procedure suite ===
=== Could happen in case of Tracheostomy creation in procedure suite ===
Line 40: 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 53: 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-06 - activated as soft check
* 2021-11-10 - implemented query but not calling it from code yet, want Lisa or someone to check on this
* 2021-11-10 - implemented query but not calling it from code yet, want Lisa or someone to check on this


Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_CCI_TISS_discontinuous_ETT"