Query NDC cardioversion dx vs TISS

From CCMDB Wiki
Revision as of 20:59, 2020 December 2 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search
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
  • Cargo


  • SMW


  • Categories: 
  • form:
  • 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: