Query NDC cardioversion dx vs TISS: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m has question for task that should be addressed before implementing |
Ttenbergen (talk | contribs) m was excluded some time ago, old question |
||
| Line 10: | Line 10: | ||
|DIC_backlogged=No | |DIC_backlogged=No | ||
}} | }} | ||
Three tests | 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 {{TISS w Nr | Cardioversion (TISS Item)}} | * if there is [[Acquired Procedure]] [[Cardioversion (EXCLUDE defibrillation-we are not tracking)]] (a collect first item) then there must be at least one {{TISS w Nr | Cardioversion (TISS Item)}} | ||
Revision as of 14:56, 15 June 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.