Query NDC cardioversion dx vs TISS: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (Text replacement - "Cardioversion (TISS Item)" to "{{TISS w Nr | Cardioversion (TISS Item)}}") |
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_LProblem=Yes | |DIC_LProblem=Yes | ||
|DIC_app= | |DIC_app=CCMDB.accdb | ||
}} | }} | ||
Three tests | Three tests | ||
* if there is [[Acquired Procedure]] [[Cardioversion (EXCLUDE defibrillation-we are not tracking)]] 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)]] then there must be at least one {{TISS w Nr | Cardioversion (TISS Item)}} | ||
* if there is even one {{TISS w Nr | Cardioversion (TISS Item)}} | * if there is even one {{TISS w Nr | Cardioversion (TISS Item)}}, then there must be a [[Acquired Procedure]] [[Cardioversion (EXCLUDE defibrillation-we are not tracking)]] | ||
Excluded because it would cause false positives: | Excluded because it would cause false positives: | ||
Revision as of 19:00, 2020 December 2
| 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: | true |
Three tests
- if there is Acquired Procedure Cardioversion (EXCLUDE defibrillation-we are not tracking) 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.