Query check CCI InExtubation consistent: Difference between revisions

m Text replacement - "Unplanned extubation (TISS Item)" to "{{TISS w Nr | Unplanned extubation (TISS Item)}}"
m Text replacement - "Insertion of ETT (TISS Item)" to "{{TISS w Nr | Insertion of ETT (TISS Item)}}"
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=Any marked TISS Item [[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=hard check
|DIC_firmness=hard check
Line 8: Line 8:
|DIC_app=Centralized data front end.accdb
|DIC_app=Centralized data front end.accdb
}}
}}
Any marked TISS Item [[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)}}
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)}}


== Query1  - Insertion of ETT and Extubation consistency ==
== Query1  - Insertion of ETT and Extubation consistency ==
* A = Total the number of days  [[Insertion of ETT (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
* 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.
* The difference between A and B can be -1, 0, 1.  Other values will be questionable.