CCMDB Wiki

Query check CCI InExtubation consistent: Difference between revisions

← Older edit
mNo edit summary
superseded by other cross checks in CCMDB.accdn
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|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=soft check
|DIC_firmness=soft check
|DIC_coding=
|DIC_status=retired
|DIC_implementation_date=
|DIC_app=Centralized data front end.accdb
|DIC_status=ready to implement
|DIC_backlogged=No
|DIC_app=CCMDB.accdb
}}
}}


{{Todo
| who = Tina
| todo_added = 2021-07-15 
| todo_action = 2021-07-22
| 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 ==
== Insertion of ETT and Extubation consistency ==
Line 25: Line 17:
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.  
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:  
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.
* 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}}
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_CCI_InExtubation_consistent"