Query check CCI InExtubation consistent: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
Ttenbergen (talk | contribs) (superseded by other cross checks in CCMDB.accdn) |
||
| (28 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
|DIC_summary=Any marked 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= | |DIC_related_concepts=Insertion of ETT (TISS Item); Planned extubation (TISS Item); Unplanned extubation (TISS Item) | ||
|DIC_firmness= | |DIC_firmness=soft check | ||
|DIC_status=retired | |||
|DIC_status= | |||
|DIC_app=Centralized data front end.accdb | |DIC_app=Centralized data front end.accdb | ||
|DIC_backlogged=No | |||
}} | }} | ||
== 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. | |||
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 == | ||
{{Related Articles}} | {{Related Articles}} | ||
Latest revision as of 17:06, 2021 December 8
| 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: | Centralized data front end.accdb |
| Coding: | not entered |
| Uses L Problem table: | not entered |
| Status: | retired |
| Implementation Date: | not entered |
| Backlogged: | No |
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: |