Query check CCI InExtubation consistent: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 12: | Line 12: | ||
| who = Tina | | who = Tina | ||
| todo_added = 2021-07-15 | | todo_added = 2021-07-15 | ||
| todo_action = 2021-07- | | todo_action = 2021-07-27 | ||
| question = _Dev_CCMDB | | question = _Dev_CCMDB | ||
* This could be done in CCMDB instead now that we collect TISS there. Confirming with Lisa if she thinks this would be problematic. | * This could be done in CCMDB instead now that we collect TISS there. Confirming with Lisa if she thinks this would be problematic. | ||
** Lisa couldn't think of problems with it either, so will implement like this to start and we can tweak if there are problems. [[User:Ttenbergen|Ttenbergen]] 09:52, 2021 July 27 (CDT) | |||
}} | }} | ||
Revision as of 09:52, 2021 July 27
Data Integrity Checks | |
Summary: | Any marked TISS Item T40 - Insertion of ETT (TISS Item) or in T22 - ETT Present (TISS Item) must have at least one marked TISS item either in T28 - Planned extubation (TISS Item) or in T29 - Unplanned extubation (TISS Item) |
Related: | Insertion of ETT (TISS Item), Planned extubation (TISS Item), Unplanned extubation (TISS Item) |
Firmness: | soft check |
Timing: | always |
App: | CCMDB.accdb |
Coding: | |
Uses L Problem table: | not relevant for this app |
Status: | ready to implement |
Implementation Date: | |
Backlogged: | true |
_Dev_CCMDB
|
|
Insertion of ETT and Extubation consistency
- A = Total the number of days T40 - Insertion of ETT (TISS Item) are marked per patient
- B = Total the number of days T28 - Planned extubation (TISS Item) and T29 - Unplanned extubation (TISS Item) are marked per patient
- The difference between A and B can be -1, 0, 1. Other values will be questionable.
Soft check
This will be implemented as a soft check because, due to the fact we only allow one entry per day for the CCIs, there are scenarios in which the difference would be more than 1.
Examples:
- Pt arrives intubated. On day 1, they are extubated. On day 2 they are intubated, extubated and then intubated again on the same day, which will look on TISS as one insertion on that day and one removal. If you then had a removal the next day you will have an error because you have a count of 3 extubations with only 1 intubation.
- We don’t always extubate for those that are ill and have cardiac arrest and die, we often leave the ETT in
Related articles
Related articles: |