Difference between revisions of "Query TISS Errors ETT consistent"
From CCMDB Wiki
Jump to navigationJump to searchTtenbergen (talk | contribs) m (Text replacement - "Insertion of ETT (TISS Item)" to "{{TISS w Nr | Insertion of ETT (TISS Item)}}") |
(→Julie requested) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 11: | Line 11: | ||
==Julie requested== | ==Julie requested== | ||
| − | === extubate only | + | === extubate only when tube present === |
| − | {{TISS w Nr | Planned extubation (TISS Item)}}(T28) or {{TISS w Nr | Unplanned extubation (TISS Item)}}(T29) can only be marked when {{TISS w Nr | ETT Present (TISS Item)}}(T22) is marked in same or previous day. | + | {{TISS w Nr | Planned extubation (TISS Item)}}(T28) or {{TISS w Nr | Unplanned extubation (TISS Item)}}(T29) can only be marked when {{TISS w Nr | ETT Present (TISS Item)}}(T22) is marked in same day. |
| + | |||
| + | === extubate only when new tube inserted === | ||
| + | {{TISS w Nr | Planned extubation (TISS Item)}}(T28) or {{TISS w Nr | Unplanned extubation (TISS Item)}}(T29) can only be marked when both 1) {{TISS w Nr | Insertion of ETT (TISS Item)}}(T40) is marked on same day '''and''' 2) {{TISS w Nr | ETT Present (TISS Item)}}(T22) is marked in previous day. | ||
| + | |||
| + | {{TISS w Nr | Planned extubation (TISS Item)}}(T28) or {{TISS w Nr | Unplanned extubation (TISS Item)}}(T29) can only be marked when both 1) {{TISS w Nr | Insertion of ETT (TISS Item)}}(T40) is marked on same day '''and''' 2) {{TISS w Nr | ETT Present (TISS Item)}}(T22) is not marked the next day. | ||
| − | |||
| − | |||
{{Discuss | who = Julie | question = | {{Discuss | who = Julie | question = | ||
| − | * A patient might arrive intubated, so there would be no intubation. Does this check really make sense? Ttenbergen 23:23, 2019 March 25 (CDT) }} | + | * A patient might arrive intubated, so there would be no intubation. Does this check really make sense? Ttenbergen 23:23, 2019 March 25 (CDT) |
| + | ** I have revised the conditions, pls check if they now make sense.--[[User:JMojica|JMojica]] 16:38, 2019 July 9 (CDT) }} | ||
| + | === new tube inserted === | ||
| + | When {{TISS w Nr | Insertion of ETT (TISS Item)}}(T40) is marked, the {{TISS w Nr | ETT Present (TISS Item)}}(T22) must also be marked in same day. | ||
== Related articles == | == Related articles == | ||
Revision as of 16:46, 2019 July 9
| Data Integrity Checks | |
| Summary: | Checks that ETTs are only removed if previously present and only added when not present. |
| Related: | CAM positive (TISS Item), Delirium, not due to drugs or alcohol, Delusional disorder, Psychosis/psychotic disorder, NOS, acute or chronic |
| Firmness: | hard check |
| Timing: | always |
| App: | Centralized data front end.accdb |
| Coding: | Query TISS_Errors_ETT_consistent |
| Uses L Problem table: | not relevant for this app |
| Status: | needs review |
| Implementation Date: | |
| Backlogged: | true |
Contents
Julie requested
extubate only when tube present
T28 - Planned extubation (TISS Item)(T28) or T29 - Unplanned extubation (TISS Item)(T29) can only be marked when T22 - ETT Present (TISS Item)(T22) is marked in same day.
extubate only when new tube inserted
T28 - Planned extubation (TISS Item)(T28) or T29 - Unplanned extubation (TISS Item)(T29) can only be marked when both 1) T40 - Insertion of ETT (TISS Item)(T40) is marked on same day and 2) T22 - ETT Present (TISS Item)(T22) is marked in previous day.
T28 - Planned extubation (TISS Item)(T28) or T29 - Unplanned extubation (TISS Item)(T29) can only be marked when both 1) T40 - Insertion of ETT (TISS Item)(T40) is marked on same day and 2) T22 - ETT Present (TISS Item)(T22) is not marked the next day.
|
|
new tube inserted
When T40 - Insertion of ETT (TISS Item)(T40) is marked, the T22 - ETT Present (TISS Item)(T22) must also be marked in same day.
