Query NDC cardioversion dx vs TISS

From CCMDB Wiki
Jump to navigationJump to search
Data Integrity Checks
Summary: If pt has Acquired Procedure Cardioversion (EXCLUDE defibrillation-we are not tracking), then the TISS28 item T41 - 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


  • Cargo


  • SMW


  • Categories: 
Discuss@task.png
  • SMW


  • Cargo


  • Categories

Three tests

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.

Related articles

Related articles: