Query NDC cardioversion dx vs TISS

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:	CFE
Coding:	query Query NDC_cardioversion_dx_vs_TISS
Uses L Problem table:	not relevant for this app
Status:	retired
Implementation Date:	2019-01-06
Backlogged:	No

• Cargo

• SMW

"CFE" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. 

• Categories:  

• form:

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.

Log

• 2021-10-07 - deleted query from CFE
• 2020-10-01 - collectoin of Cardioversion (TISS Item) stopped so this query became irrelevant.