Are you logged on?
You do not have permission to edit this page, for the following reason:
Free text:
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 ({{TISS w Nr | 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 === *{{TISS w Nr | Planned extubation (TISS Item)}} *{{TISS w Nr | Unplanned extubation (TISS Item)}} *{{TISS w Nr | Insertion of ETT (TISS Item)}} === ETT or ventilation === *{{TISS w Nr | ETT Present (TISS Item)}} *{{TISS w Nr | Invasive Mechanical Ventilation (TISS Item)}} === conditions === * if previous date has no {{TISS w Nr | ETT Present (TISS Item)}} and today date has {{TISS w Nr | ETT Present (TISS Item)}} then {{TISS w Nr |Insertion of ETT (TISS Item)}} should be marked ** Error: No ETT_1, Has ETT_2, No intubation_2 * if previous date has {{TISS w Nr | ETT Present (TISS Item)}} and today date has no {{TISS w Nr | ETT Present (TISS Item)}} then previous date of the {{TISS w Nr |Unplanned extubation (TISS Item)}} or {{TISS w Nr | Planned extubation (TISS Item)}} should be entered ** Error: ETT_2, No ETT_3, no extub_2 * if previous date has {{TISS w Nr | ETT Present (TISS Item)}} and today date has {{TISS w Nr | ETT Present (TISS Item)}} and {{TISS w Nr |Insertion of ETT (TISS Item)}} are marked then today date of {{TISS w Nr |Unplanned extubation (TISS Item)}} or {{TISS w Nr | Planned extubation (TISS Item)}} should be marked ** Error: ETT_2, ETT_3, intub_3, no extub_2, no extub_3 ** Error: ETT_2, ETT_3, extub_2, no intub_2, no intub_3 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 *{{TISS w Nr | Planned extubation (TISS Item)}} or {{TISS w Nr | Unplanned extubation (TISS Item)}} can only be marked when both **1) {{TISS w Nr | Insertion of ETT (TISS Item)}} is marked on same day '''and''' **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. 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}} [[Category:TISS28 check]]
Save page Show preview Show changes Cancel