Query NDC cardioversion dx vs TISS: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m has question for task that should be addressed before implementing |
||
| Line 5: | Line 5: | ||
|DIC_timing=complete | |DIC_timing=complete | ||
|DIC_coding=query ''Query NDC_cardioversion_dx_vs_TISS'' | |DIC_coding=query ''Query NDC_cardioversion_dx_vs_TISS'' | ||
|DIC_implementation_date=2019 | |DIC_implementation_date=2019-01-06 | ||
|DIC_status= | |DIC_status=needs review | ||
|DIC_app=CCMDB.accdb | |DIC_app=CCMDB.accdb | ||
|DIC_backlogged=No | |||
}} | }} | ||
{{DiscussTask | | {{DiscussTask | | ||
* [[Cardioversion (EXCLUDE defibrillation-we are not tracking)]] and {{TISS w Nr | Cardioversion (TISS Item)}} are very similar, should we continue to collect both? [[User:Ttenbergen|Ttenbergen]] 19:59, 2020 December 2 (CST) | * [[Cardioversion (EXCLUDE defibrillation-we are not tracking)]] and {{TISS w Nr | Cardioversion (TISS Item)}} are very similar, should we continue to collect both? [[User:Ttenbergen|Ttenbergen]] 19:59, 2020 December 2 (CST) | ||
Revision as of 16:14, 7 April 2021
| Data Integrity Checks | |
| Summary: | If pt has Acquired Procedure Cardioversion (EXCLUDE defibrillation-we are not tracking), then the TISS28 item T26 & 27 - Cardioversion (TISS Item) (T41) must be marked. |
| Related: | Cardioversion (TISS Item), Acquired Procedure, Cardioversion (EXCLUDE defibrillation-we are not tracking) |
| Firmness: | hard check |
| Timing: | complete |
| App: | CCMDB.accdb |
| Coding: | query Query NDC_cardioversion_dx_vs_TISS |
| Uses L Problem table: | not relevant for this app |
| Status: | needs review |
| Implementation Date: | 2019-01-06 |
| Backlogged: | No |
|
|
Three tests
- if there is Acquired Procedure Cardioversion (EXCLUDE defibrillation-we are not tracking) (a collect first item) then there must be at least one T26 & 27 - Cardioversion (TISS Item)
- if there is even one T26 & 27 - Cardioversion (TISS Item), then there must be a Acquired Procedure Cardioversion (EXCLUDE defibrillation-we are not tracking)
Excluded because it would cause false positives:
- if both are present dates should be the same; since there could be more than one, matching multiple would require a different query to specifically match dates and only for existing ones; if we decide this is required we can revisit.