Query NDC cardioversion dx vs TISS: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
mNo edit summary
 
(25 intermediate revisions by 3 users not shown)
Line 1: Line 1:
*If the 763-35 is code in '''COMPLICATIONS''', then the [[TISS28]] item 41 '''must be''' marked.[[User:TOstryzniuk|Trish Ostryzniuk]] 17:49, 2014 April 30 (CDT)
{{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
}}


Three tests
* 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)]]


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.


*If the 763-35 is code in '''COMPLICATIONS''', then the [[:Category: TISS76 | TISS76]] item 18 '''must be''' marked.  
== Log ==
* 2021-10-07 - deleted query from [[CFE]]
* 2020-10-01  - collectoin of [[Cardioversion (TISS Item)]] stopped so this query became irrelevant.  


*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. 
**what if it was required again? Ttenbergen 17:19, 2012 November 5 (EST){{discussion}}
***only codes onces, not counting number of times it was done.[[User:TOstryzniuk|Trish Ostryzniuk]] 17:49, 2014 April 30 (CDT)
Don't think this was ever implemented. Will need to be set up for TISS28:41.


[[Category:Cleaner.mdb Data Integrity Checks]]
== Related articles ==
[[Category:TISS76 Checks]]
{{Related Articles}}
[[Category:TISS28 Checks]]
 
[[Category:TISS28 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: