Query check CCI TISS Intubation vs Intubated: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 2: | Line 2: | ||
|DIC_summary= | |DIC_summary= | ||
Any marked TISS Item in {{TISS w Nr | Planned extubation (TISS Item)}} or in {{TISS w Nr | Unplanned extubation (TISS Item)}} must have the {{TISS w Nr | ETT Present (TISS Item)}} on the same date. | Any marked TISS Item in {{TISS w Nr | Planned extubation (TISS Item)}} or in {{TISS w Nr | Unplanned extubation (TISS Item)}} must have the {{TISS w Nr | ETT Present (TISS Item)}} on the same date. | ||
|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); ETT Present (TISS Item) | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_coding=query ''check_CCI_TISS_Intubation_vs_Intubated'' | |DIC_coding=query ''check_CCI_TISS_Intubation_vs_Intubated'' | ||
Latest revision as of 16:10, 2021 December 8
| Data Integrity Checks | |
| Summary: | Any marked TISS Item in T28 - Planned extubation (TISS Item) or in T29 - Unplanned extubation (TISS Item) must have the T22 - ETT Present (TISS Item) on the same date. |
| Related: | Insertion of ETT (TISS Item), Planned extubation (TISS Item), Unplanned extubation (TISS Item), ETT Present (TISS Item) |
| Firmness: | hard check |
| Timing: | always |
| App: | CCMDB.accdb |
| Coding: | query check_CCI_TISS_Intubation_vs_Intubated |
| Uses L Problem table: | not relevant for this app |
| Status: | implemented |
| Implementation Date: | 2021-01-28 |
| Backlogged: | true |
If any of #intubation or extubation is present on a day, then at least one of #ETT or ventilation also need to be marked for that day.
See query check_CCI_TISS_discontinuous_ETT for a related cross check.
intubation or extubation
- T28 - Planned extubation (TISS Item)
- T29 - Unplanned extubation (TISS Item)
- T40 - Insertion of ETT (TISS Item)
ETT or ventilation
Log
- 2021-01-28 - Query implemented