Query check CCI InExtubation consistent: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
Ttenbergen (talk | contribs) m →top: substance cleanup |
||
| Line 1: | Line 1: | ||
{{Data Integrity Check | {{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 [[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_related_concepts= | |DIC_related_concepts=Insertion of ETT (TISS Item); Planned extubation (TISS Item); Unplanned extubation (TISS Item) | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_coding={{ | |DIC_coding={{Discuss | who = all | question = Pagasa, please put the names of the queries}} | ||
|DIC_implementation_date=2018-10-25 | |DIC_implementation_date=2018-10-25 | ||
|DIC_status=needs review | |DIC_status=needs review | ||
Revision as of 00:11, 27 October 2018
| Data Integrity Checks | |||
| 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) | ||
| Related: | Insertion of ETT (TISS Item), Planned extubation (TISS Item), Unplanned extubation (TISS Item) | ||
| Firmness: | hard check | ||
| Timing: | always | ||
| App: | Centralized data front end.accdb | ||
| Coding: |
| ||
| Uses L Problem table: | not entered | ||
| Status: | needs review | ||
| Implementation Date: | 2018-10-25 | ||
| Backlogged: | true | ||
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
- B = Total the number of days Planned extubation (TISS Item) and 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
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.
Related articles
| Related articles: |