Query TISS Errors ETT consistent

Data Integrity Checks
Summary:	Checks that ETTs are only removed if previously present and only added when not present.
Related:	CAM positive (TISS Item), Delirium, not due to drugs or alcohol, Delusional disorder, Psychosis/psychotic disorder, NOS, acute or chronic
Firmness:	hard check
Timing:	always
App:	Centralized data front end.accdb
Coding:	Query TISS_Errors_ETT_consistent
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:
Backlogged:	true

• Cargo

• SMW

• Categories: 

Julie requested

extubate only when tube present

T28 - Planned extubation (TISS Item)(T28) or T29 - Unplanned extubation (TISS Item)(T29) can only be marked when T22 - ETT Present (TISS Item)(T22) is marked in same day.

extubate only when new tube inserted

T28 - Planned extubation (TISS Item)(T28) or T29 - Unplanned extubation (TISS Item)(T29) can only be marked when both 1) T40 - Insertion of ETT (TISS Item)(T40) is marked on same day and 2) T22 - ETT Present (TISS Item)(T22) is marked in previous day.

T28 - Planned extubation (TISS Item)(T28) or T29 - Unplanned extubation (TISS Item)(T29) can only be marked when both 1) T40 - Insertion of ETT (TISS Item)(T40) is marked on same day and 2) T22 - ETT Present (TISS Item)(T22) is not marked the next day.

A patient might arrive intubated, so there would be no intubation. Does this check really make sense? Ttenbergen 23:23, 2019 March 25 (CDT) I have revised the conditions, pls check if they now make sense.--JMojica 16:38, 2019 July 9 (CDT)

• SMW

• Cargo

• Categories

new tube inserted

When T40 - Insertion of ETT (TISS Item)(T40) is marked, the T22 - ETT Present (TISS Item)(T22) must also be marked in same day.