Query check CCI InExtubation consistent

Data Integrity Checks
Summary:	Any marked TISS Item Insertion of ETT (TISS Item) or in ETT Present (TISS Item) must have at least one marked TISS item either in Planned extubation (TISS Item) or in Unplanned extubation (TISS Item)
Related:	Insertion of ETT (TISS Item), Planned extubation (TISS Item), Unplanned extubation (TISS Item)
Firmness:	hard check
Timing:	always
App:	Centralized data front end.accdb
Coding:
Uses L Problem table:	not entered
Status:	needs review
Implementation Date:	2018-10-25
Backlogged:	true

• Cargo

• SMW

• Categories: 

• form:

Any marked TISS Item Insertion of ETT (TISS Item) or in ETT Present (TISS Item) must have at least one marked TISS item either in Planned extubation (TISS Item) or in Unplanned extubation (TISS Item)

Query1 - Insertion of ETT and Extubation consistency

• A = Total the number of days Insertion of ETT (TISS Item) are marked per patient
• B = Total the number of days Planned extubation (TISS Item) and Unplanned extubation (TISS Item) are marked per patient
• The difference between A and B can be -1, 0, 1. Other values will be questionable.

this cross check would not know the difference between (on one day, intubated, extubated, and reintubated) vs (intubated and then extubated); while this hopefully not too common of a thing, would it cause false positives for Pagasa to run after? Ttenbergen 11:33, 2018 October 29 (CDT) yes that is correct because both have a difference of zero. Using the cut off GTE Abs(2) will get true negatives and not false positives. This query considers only the counts and not the dates which will have numerous scenarios and too complicated to define. For those having a difference of -1,0,1 , there are also the possibility for incorrect sequence of dates of intubation or extubation - this is not captured in the query. If you have other suggestions, let us know.--JMojica 12:19, 2018 October 29 (CDT) What I was trying to say is that I am worried this would be a false positive, which will then create work load for Pagasa and/or Collectors to confirm. Do we really want cross checks that bring up potential errors? We have talked about this before, but never really come up with a general answer. Should we take it to task meeting? Ttenbergen 23:45, 2018 October 29 (CDT) Are you saying I should use "difference between A and B can be -2, -1, 0, 1, 2. Other values will be questionable? The basic scenarios are 1. no new insert and no extubation (0-0=0) , 2. no new insert and then extubated - this assumes currently with tube and then extubated (0-1=-1), 3. insert new tube and no extubation(1-0=1), 4) insert new tube and then extubated (1-1=0). When there are 2 insertions, the valid number of extubations =1,2,3 even if occurring at same or different days as insertion day, the difference will either be -1,0,1. Same holds true with 3 insertions or 4 insertions. there will be definite errors if the difference is >= 2 or <= -2. Having 1 insertion and 3 extubations or 3 insertions and 1 extubation are not possible and are errors.

• SMW

• Cargo

• Categories