Query Check Renal IncompatibleDxs: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(17 intermediate revisions by the same user not shown)
Line 1: Line 1:
The query '''Check Renal IncompatibleDxs''' implements {{CCMDB Data Integrity Checks}} as per the rules and exclusions in [[Renal_Coding_Considerations#Competing_Diagnoses]]. It is hardcoded in query ''Check_Renal_IncompatibeDXs'' in [[CCMDB.mdb]].
{{LegacyContent
See [[Renal_Coding_Considerations#CCDMB_Data_Integrity_Checks:_Competing_Diagnoses]] for details.
|explanation=retired as part of move to ICD10.
|successor=[[Query check ICD10 ESRD vs ARF]]
|content=


== Start Date ==
{{Data Integrity Check
Sept 2009 (see [[Log]])
| DIC_summary = can't have ARF and CRF in same record
| DIC_related_concepts = Renal Transplant; CRF - Chronic Renal Failure; ARI; Acute Tubular Necrosis; ARF (Diagnosis)
| DIC_firmness = hard check
| DIC_timing =
| DIC_app = CCMDB.accdb
| DIC_coding = query ''Check Renal IncompatibleDxs''
| DIC_status = retired
| DIC_implementation_date = 2009-09-30
}}
 
2014-12-24 retired.
 
See [[Query check ICD10 ESRD vs ARF]] for the ICD10 implementation of this query.
 
See [[Renal Coding Considerations (old)#CCMDB Data Integrity Checks: Competing Diagnoses]] for details.
* If no '''[[Renal Transplant]]''' (80504 or 80505) in either Dxs or Comos then
** If comorbid [[CRF - Chronic Renal Failure|CRF]] (351-00) exists then the following must '''not''' appear in Admit/Acquired codes
*** [[ARI]]  (364-00)
*** [[Acute Tubular Necrosis | ATN]]  (352-00)
*** [[ARF (Diagnosis)]]  (350 **)
 
See also [[ICD10 Guideline for Renal Coding]]


=== Status ===
=== Status ===
* implemented [[CCMDB.mdb_Change_Log_2009#v1.90]]. [[User:Ttenbergen|Ttenbergen]] 15:50, 29 September 2009 (CDT)
* implemented [[CCMDB.mdb Change Log 2009#v1.90]]. [[User:Ttenbergen|Ttenbergen]] 15:50, 29 September 2009 (CDT)
* changed [[CCMDB.mdb_Change_Log_2010#V1.993_Changes]] [[User:Ttenbergen|Ttenbergen]] 17:25, 9 February 2010 (CST)
* changed [[CCMDB.mdb Change Log 2010#V1.993 Changes]] [[User:Ttenbergen|Ttenbergen]] 17:25, 9 February 2010 (CST)
 
}}
 
[[Category:Old dx check]]

Latest revision as of 11:56, 30 July 2025

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy content.

Data Integrity Checks
Summary: can't have ARF and CRF in same record
Related: Renal Transplant, CRF - Chronic Renal Failure, ARI, Acute Tubular Necrosis, ARF (Diagnosis)
Firmness: hard check
Timing:
App: CCMDB.accdb
Coding: query Check Renal IncompatibleDxs
Uses L Problem table: not relevant for this app
Status: retired
Implementation Date: 2009-09-30
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

2014-12-24 retired.

See Query check ICD10 ESRD vs ARF for the ICD10 implementation of this query.

See Renal Coding Considerations (old)#CCMDB Data Integrity Checks: Competing Diagnoses for details.

  • If no Renal Transplant (80504 or 80505) in either Dxs or Comos then
    • If comorbid CRF (351-00) exists then the following must not appear in Admit/Acquired codes

See also ICD10 Guideline for Renal Coding

Status