Query NDC cardioversion dx vs TISS: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
(18 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=If the [[Cardioversion]] 76335 is coded in '''complications''', 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; Cardioversion (TISS Item); Cardioversion -- excl defibrillation which we are not tracking separately
|DIC_related_concepts=Cardioversion (TISS Item); Acquired Procedure; Cardioversion (EXCLUDE defibrillation-we are not tracking)
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_timing=complete
|DIC_timing=complete
|DIC_status=needs review
|DIC_coding=query ''Query NDC_cardioversion_dx_vs_TISS''
|DIC_LProblem=No
|DIC_implementation_date=2019-01-06
|DIC_status=retired
|DIC_app=Centralized data front end.accdb
|DIC_app=Centralized data front end.accdb
|DIC_backlogged=No
}}
}}


Two tests
Three tests
* if there is a Cardioversion complications then there must be at least one [[TISS28]] T41
* if there is [[Acquired Procedure]] [[Cardioversion (EXCLUDE defibrillation-we are not tracking)]] (a collect first item) then there must be at least one {{TISS w Nr | Cardioversion (TISS Item)}}
* if there is even one [[TISS28]] T41, then there must be a Cardioversion complication
* if there is even one {{TISS w Nr | Cardioversion (TISS Item)}}, then there must be a [[Acquired Procedure]] [[Cardioversion (EXCLUDE defibrillation-we are not tracking)]]


{{DA | Don't think this was ever implemented. CCI Code is [[Cardioversion -- excl defibrillation which we are not tracking separately]]. Should we implement this now? }}
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.


[[Category:TISS28 checks]]
 
== Related articles ==
{{Related Articles}}
 
[[Category:TISS28 check]]
[[Category:CCI Px check‎‎]]
[[Category:CCI Px check‎‎]]

Latest revision as of 15:20, 14 April 2022

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: not entered
Status: retired
Implementation Date: 2019-01-06
Backlogged: No
  • 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.

Log


Related articles

Related articles: