Query check CCI InExtubation consistent: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (Ttenbergen moved page Check TISS Intubation consistent to Query check CCI InExtubation consistent without leaving a redirect: no longer done in TISS, if we want to do it at all it has to be in CCI and should be in CCMDB.) |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 2: | Line 2: | ||
|DIC_summary=Any marked TISS Item {{TISS w Nr | Insertion of ETT (TISS Item)}} or in {{TISS w Nr | ETT Present (TISS Item)}} must have at least one marked TISS item either in {{TISS w Nr | Planned extubation (TISS Item)}} or in {{TISS w Nr | Unplanned extubation (TISS Item)}} | |DIC_summary=Any marked TISS Item {{TISS w Nr | Insertion of ETT (TISS Item)}} or in {{TISS w Nr | ETT Present (TISS Item)}} must have at least one marked TISS item either in {{TISS w Nr | Planned extubation (TISS Item)}} or in {{TISS w Nr | Unplanned extubation (TISS Item)}} | ||
|DIC_related_concepts=Insertion of ETT (TISS Item); Planned extubation (TISS Item); Unplanned extubation (TISS Item) | |DIC_related_concepts=Insertion of ETT (TISS Item); Planned extubation (TISS Item); Unplanned extubation (TISS Item) | ||
|DIC_firmness= | |DIC_firmness=soft check | ||
|DIC_coding= | |DIC_coding= | ||
|DIC_implementation_date= | |DIC_implementation_date= | ||
|DIC_status=ready to implement | |DIC_status=ready to implement | ||
|DIC_app= | |DIC_app=CCMDB.accdb | ||
}} | }} | ||
{{Todo | {{Todo | ||
| who = Tina | | who = Tina | ||
| todo_added = 2021-07-15 | | todo_added = 2021-07-15 | ||
| todo_action = | | todo_action = 2021-07-22 | ||
| question = | | 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. | ||
}} | }} | ||
== Insertion of ETT and Extubation consistency == | |||
* A = Total the number of days {{TISS w Nr | Insertion of ETT (TISS Item)}} are marked per patient | |||
* B = Total the number of days {{TISS w Nr | Planned extubation (TISS Item)}} and {{TISS w Nr | 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. | |||
Example: | |||
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. | |||
== Related articles == | == Related articles == | ||
{{Related Articles}} | {{Related Articles}} |
Revision as of 14:23, 2021 July 15
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.
Example: 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.
Related articles
Related articles: |