Query NDC cardioversion dx vs TISS: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m was excluded some time ago, old question |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 6: | Line 6: | ||
|DIC_coding=query ''Query NDC_cardioversion_dx_vs_TISS'' | |DIC_coding=query ''Query NDC_cardioversion_dx_vs_TISS'' | ||
|DIC_implementation_date=2019-01-06 | |DIC_implementation_date=2019-01-06 | ||
|DIC_status= | |DIC_status=ready to implement | ||
|DIC_app=CCMDB.accdb | |DIC_app=CCMDB.accdb | ||
|DIC_backlogged=No | |DIC_backlogged=No | ||
Revision as of 11:54, 2 September 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: | ready to implement |
| 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.