Query NDC Pacemaker acquired vs TISS

Data Integrity Checks
Summary:	Records with Acquired Diagnosis of Pacemaker insertion, temporary) but who don't have Pacemaker insertion or vice versa
Related:	Pacemaker insertion, permanent, Pacemaker insertion, temporary, Permanent Pacemaker Insertion, Pacemaker insertion (TISS Item)
Firmness:	hard check
Timing:	complete
App:	Centralized data front end.accdb
Coding:	query NDC Pacemaker TISS wo acquired
Uses L Problem table:	Yes
Status:	ready to implement
Implementation Date:	not entered
Backlogged:	true

• Cargo

• SMW

• Categories:  

• form:

• If acquired CCI has 1.HZ.53.GR-NN Pacemaker insertion, temporary, then TISS28 item #42 (temporary pacemaker) must be marked. This query is needed. Delete Pacemaker insertion, permanent.