Query NDC cardioversion dx vs TISS: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Text replacement - "NDC_cardioversion_dx_vs_TISS" to "Query NDC_cardioversion_dx_vs_TISS"
m Text replacement - "Cardioversion (TISS Item)" to "{{TISS w Nr | Cardioversion (TISS Item)}}"
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=If pt has [[Acquired Procedure]] [[Cardioversion (EXCLUDE defibrillation-we are not tracking)]], then the [[TISS28]] item [[Cardioversion (TISS Item)]] (T41) must be marked.
|DIC_summary=If pt has [[Acquired Procedure]] [[Cardioversion (EXCLUDE defibrillation-we are not tracking)]], then the [[TISS28]] item {{TISS w Nr | Cardioversion (TISS Item)}} (T41) must be marked.
|DIC_related_concepts=Cardioversion (TISS Item); Acquired Procedure; Cardioversion (EXCLUDE defibrillation-we are not tracking)
|DIC_related_concepts=Cardioversion (TISS Item); Acquired Procedure; Cardioversion (EXCLUDE defibrillation-we are not tracking)
|DIC_firmness=hard check
|DIC_firmness=hard check
Line 11: Line 11:
}}
}}
Three tests
Three tests
* if there is [[Acquired Procedure]] [[Cardioversion (EXCLUDE defibrillation-we are not tracking)]] then there must be at least one [[Cardioversion (TISS Item)]](T41)
* 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)}}(T41)
* if there is even one [[Cardioversion (TISS Item)]](T41), then there must be a [[Acquired Procedure]] [[Cardioversion (EXCLUDE defibrillation-we are not tracking)]]
* if there is even one {{TISS w Nr | Cardioversion (TISS Item)}}(T41), 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 20:59, 28 April 2019

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: Centralized data front end.accdb
Coding: query Query NDC_cardioversion_dx_vs_TISS
Uses L Problem table: Yes
Status: implemented
Implementation Date: 2019/01/06
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

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.