Query check CCI InExtubation consistent: Difference between revisions

(24 intermediate revisions by 2 users not shown)

Line 1:

{{Data Integrity Check

|DIC_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)]]

|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_firmness=~~hard~~ check

|DIC_firmness=soft check

~~|DIC_coding={{Discuss | who = all | question = Pagasa, please put the names of the queries}}~~

|DIC_status=retired

~~|DIC_implementation_date=2018-10-25~~

|DIC_status=~~needs review~~

|DIC_app=Centralized data front end.accdb

|DIC_backlogged=No

}}

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

== Insertion of ETT and Extubation consistency ==

* B = Total the number of days [[Planned extubation (TISS Item)]] and [[Unplanned extubation (TISS Item)]] are marked per patient

* 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.

== ~~Query2 - ETT present and Extubation consistency~~ ==

=== Soft check ===

~~Any marked TISS Item~~ in ~~[[Planned extubation (TISS Item)]] or in [[Unplanned extubation (TISS Item)]] must have~~ the ~~[[ETT Present (TISS Item)]] on the same date~~.

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 ==

@@ Line 1: / Line 1: @@
 {{Data Integrity Check
-|DIC_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)]]
+|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=hard check
+|DIC_firmness=soft check
-|DIC_coding={{Discuss | who = all | question =  Pagasa, please put the names of the queries}}
+|DIC_status=retired
-|DIC_implementation_date=2018-10-25
-|DIC_status=needs review
 |DIC_app=Centralized data front end.accdb
+|DIC_backlogged=No
 }}
-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
+== Insertion of ETT and Extubation consistency ==
-* B = Total the number of days  [[Planned extubation (TISS Item)]] and [[Unplanned extubation (TISS Item)]] are marked per patient
+* 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.
-== Query2  - ETT present and Extubation consistency ==
+=== Soft check ===
-Any marked TISS Item in [[Planned extubation (TISS Item)]] or in [[Unplanned extubation (TISS Item)]] must have the [[ETT Present (TISS Item)]] on the same date.
+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}}