Query NDC cardioversion dx vs TISS: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "*If the 763-35 is code in '''COMPLICATIONS''', then the TISS item 18 '''must be''' marked. *If the DX code is '''763-35''' in '''ADMIT''' this could mean cardioversion was d..."
 
mNo edit summary
 
(26 intermediate revisions by 3 users not shown)
Line 1: Line 1:
*If the 763-35 is code in '''COMPLICATIONS''', then the TISS item 18 '''must be''' marked.  
{{Data Integrity Check
|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_firmness=hard check
|DIC_timing=complete
|DIC_coding=query ''Query NDC_cardioversion_dx_vs_TISS''
|DIC_implementation_date=2019-01-06
|DIC_status=retired
|DIC_app=Centralized data front end.accdb
|DIC_backlogged=No
}}


*If the DX code is '''763-35''' in '''ADMIT''' this could mean cardioversion was done in the ER or in another location '''prior to''' arrival in the unit therefore,  TISS item 18 for cardioversion should '''NOT''' be marked. 
Three tests
**what if it was required again? Ttenbergen 17:19, 2012 November 5 (EST){{discussion}}
* 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 {{TISS w Nr | Cardioversion (TISS Item)}}, then there must be a [[Acquired Procedure]] [[Cardioversion (EXCLUDE defibrillation-we are not tracking)]]


Don't think this was ever implemented. Will need to be set up for TISS28:41.
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.


[[Category:Cleaner.mdb Data Integrity Checks]]
== Log ==
[[Category:TISS76 Checks]]
* 2021-10-07 - deleted query from [[CFE]]
[[Category:TISS28 Checks]]
* 2020-10-01  - collectoin of [[Cardioversion (TISS Item)]] stopped so this query became irrelevant.
 
 
== Related articles ==
{{Related Articles}}
 
[[Category:TISS28 check]]
[[Category:CCI Px check‎‎]]

Latest revision as of 16: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: