Query NDC Pacemaker acquired vs TISS: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
JMojica (talk | contribs)
No edit summary
mNo edit summary
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{LegacyContent
|explanation= see [[#log]]
|content=
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=Records with [[Acquired Diagnosis]] of ([[Pacemaker insertion, permanent]] or [[Pacemaker insertion, temporary]]) but who don't have [[Pacemaker insertion (TISS Item)|Pacemaker insertion]]
|DIC_summary=Records with [[Acquired Procedure]] of [[Pacemaker insertion, temporary]] that  don't have date-matching [[Pacemaker insertion (TISS Item)|Pacemaker insertion]] or vice versa.
|DIC_related_concepts=Pacemaker insertion, permanent; Pacemaker insertion, temporary; Permanent Pacemaker Insertion; Pacemaker insertion (TISS Item)
|DIC_related_concepts=Pacemaker insertion, permanent; Pacemaker insertion, temporary; Permanent Pacemaker Insertion; Pacemaker insertion (TISS Item)
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_timing=complete
|DIC_timing=complete
|DIC_coding=query ''NDC Pacemaker TISS wo acquired''
|DIC_coding=query ''NDC_Pacemaker_TISS_vs_acquired''
|DIC_status=needs review
|DIC_implementation_date=2019/01/06
|DIC_status=retired
|DIC_LProblem=Yes
|DIC_LProblem=Yes
|DIC_app=Centralized data front end.accdb
|DIC_app=Centralized data front end.accdb
}}
}}
{{Discuss | who = Julie | question = * will this check still make sense and still be wanted in CCI/ICD10? If so, what is the check?
 
*If acquired CCI has 1.HZ.53.GR-NN [[Pacemaker insertion, temporary]], then  TISS28 item #42 (temporary pacemaker) must be marked. This query is needed. Delete [[Pacemaker insertion, permanent]].  --[[User:JMojica|JMojica]] 11:31, 2018 November 20 (CST)
This query includes incomplete patients; the [[Data Processor]] only checks into incompletes during reporting time.
}}
 
== Log ==
* 2021-10-07 - query deleted
* 2020-10-01 - collection of [[Pacemaker insertion (TISS Item)]] stopped as part of [[Change to collect TISS data in CCI Picklist]], so the check would have no longer worked
 


== Related articles ==
== Related articles ==
{{Related Articles}}
{{Related Articles}}
}}

Latest revision as of 13:42, 2021 October 7

Legacy Content

This page contains Legacy Content.
  • Explanation: see #log
  • Successor: No successor was entered

Click Expand to show legacy content.

Data Integrity Checks
Summary: Records with Acquired Procedure of Pacemaker insertion, temporary that don't have date-matching Pacemaker insertion or vice versa.
Related: Pacemaker insertion, permanent, Pacemaker insertion, temporary, Permanent Pacemaker Insertion, Pacemaker insertion (TISS Item)
Firmness: hard check
Timing: complete
App: Centralized data front end.accdb
Coding: query NDC_Pacemaker_TISS_vs_acquired
Uses L Problem table: Yes
Status: retired
Implementation Date: 2019/01/06
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

This query includes incomplete patients; the Data Processor only checks into incompletes during reporting time.

Log


Related articles

Related articles: