Query check CCI TISS discontinuous ETT: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
(9 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-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



Latest revision as of 09:15, 11 August 2022

Data Integrity Checks
Summary: T22 - ETT Present (TISS Item) should start with an T40 - Insertion of ETT (TISS Item) and end with an T28 - Planned extubation (TISS Item) or T29 - Unplanned extubation (TISS Item).
Related: Insertion of ETT (TISS Item), Planned extubation (TISS Item), Unplanned extubation (TISS Item)
Firmness: soft check
Timing: complete
App: CCMDB.accdb
Coding: query check_CCI_TISS_discontinuous_ETT
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2021-11-10
Backlogged: No
  • Cargo


  • SMW


  • Categories:  
  • form:

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.

Could happen in case of Tracheostomy creation in procedure suite

There might be no extubation if pt has a trach (T23 - Trach Tube Present (TISS Item)) created (Tracheostomy creation), since that would be done in OR and part of it would be the extubation. Since this would be a soft check, the collector could just OK past it if this is the case.

The check

intubation or extubation

ETT or ventilation

conditions

Another scenario:

  • yesterday I have ETT
  • today you t40 new insertion marked,
  • but there is no extubation either yesterday or today

Another scenario:

  • ett2 not null
  • intub3 not null
  • extub2 null
  • extub3 null

Another scenario

  • new insertion today
  • tomorrow there is no ETT present
  • there needs to be an extub present today

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

Related articles

Related articles: