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) |
||
| Line 10: | Line 10: | ||
}} | }} | ||
== | == implemented check details == | ||
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. | 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. | ||
| Line 21: | Line 21: | ||
*{{TISS w Nr | ETT Present (TISS Item)}} | *{{TISS w Nr | ETT Present (TISS Item)}} | ||
*{{TISS w Nr | Invasive Mechanical Ventilation (TISS Item)}} | *{{TISS w Nr | Invasive Mechanical Ventilation (TISS Item)}} | ||
== deferred / need discussion details == | |||
Julie had requested the following but there could be false positives; flagging for Task to decide if to defer or how to check. | |||
# if previous date has no {{TISS w Nr | ETT Present (TISS Item)}} and today date has {{TISS w Nr | ETT Present (TISS Item)}} then {{TISS w Nr |Insertion of ETT (TISS Item)}} should be marked | |||
#* not necessarily, could have been done in OR or elsewhere | |||
# if previous date has {{TISS w Nr | ETT Present (TISS Item)}} and today date has no {{TISS w Nr | ETT Present (TISS Item)}} then previous date of the {{TISS w Nr |Unplanned extubation (TISS Item)}} or {{TISS w Nr | Planned extubation (TISS Item)}} should be entered | |||
#* not necessarily, could have been done in OR or elsewhere | |||
# if previous date has {{TISS w Nr | ETT Present (TISS Item)}} and today date has {{TISS w Nr | ETT Present (TISS Item)}} and {{TISS w Nr |Insertion of ETT (TISS Item)}} are marked then today date of {{TISS w Nr |Unplanned extubation (TISS Item)}} or {{TISS w Nr | Planned extubation (TISS Item)}} should be marked | |||
#* not necessarily, could have been done in OR or elsewhere | |||
== Log == | == Log == | ||
Revision as of 11:09, 2021 September 1
| 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) |
| 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 |
implemented check details
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.
intubation or extubation
- T28 - Planned extubation (TISS Item)
- T29 - Unplanned extubation (TISS Item)
- T40 - Insertion of ETT (TISS Item)
ETT or ventilation
deferred / need discussion details
Julie had requested the following but there could be false positives; flagging for Task to decide if to defer or how to check.
- if previous date has no T22 - ETT Present (TISS Item) and today date has T22 - ETT Present (TISS Item) then T40 - Insertion of ETT (TISS Item) should be marked
- not necessarily, could have been done in OR or elsewhere
- if previous date has T22 - ETT Present (TISS Item) and today date has no T22 - ETT Present (TISS Item) then previous date of the T29 - Unplanned extubation (TISS Item) or T28 - Planned extubation (TISS Item) should be entered
- not necessarily, could have been done in OR or elsewhere
- if previous date has T22 - ETT Present (TISS Item) and today date has T22 - ETT Present (TISS Item) and T40 - Insertion of ETT (TISS Item) are marked then today date of T29 - Unplanned extubation (TISS Item) or T28 - Planned extubation (TISS Item) should be marked
- not necessarily, could have been done in OR or elsewhere
Log
- 2021-01-28 - Query implemented