Query Check Renal IncompatibleDxs: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
m Text replacement - "[[Category: " to "[[Category:"
 
(27 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Comorbid [[CRF]] can not be coded with the following diagnoses for the same patient:
{{LegacyContent
* [[ARF]] 350 -(as instructed by coding guideline)
|explanation=retired as part of move to ICD10.
* [[ARI]] 364 -(as instructed by coding guideline)
|successor=[[Query check ICD10 ESRD vs ARF]]
==Discussion==
|content=
{{Discussion}}
* [[ATN]] 352 - must be included here also.  This is missing from integrity check for ccmdb. [http://ltc.umanitoba.ca/wikis/ccmdb/index.php/Renal_Coding_Considerations#Competing_Diagnoses  see rule here].--[[User:TOstryzniuk|TOstryzniuk]] 21:08, 21 January 2010 (CST)


==Integrity Rule that includes renal Transplant (805)==
{{Data Integrity Check
*here is what we want as an integrity check rule that also includes kidney transplant:
| DIC_summary = can't have ARF and CRF in same record
*'''IF''' Comorbid DX (any slot) is 351 '''AND''' Complication/Acquired DX (any slot) is 805 '''AND''' Admit DX (any slot) is (350, 352, 364) then = Error.
| DIC_related_concepts = Renal Transplant; CRF - Chronic Renal Failure; ARI; Acute Tubular Necrosis; ARF (Diagnosis)
'''OR'''  
| DIC_firmness = hard check
'''IF''' Comorbid DX (any slot) is 351 '''AND''' Admit DX (any slot) is (350, 352, 364) then = Error--[[User:TOstryzniuk|TOstryzniuk]] 21:08, 21 January 2010 (CST)
| DIC_timing =
*[http://ltc.umanitoba.ca/wikis/ccmdb/index.php/!_Automated_Data_Integrity_Checks#Q2.11_-_Additional_check click here to see rule request to move to ccmdb.mdb]--[[User:TOstryzniuk|TOstryzniuk]] 21:17, 21 January 2010 (CST)
| DIC_app = CCMDB.accdb
* See: [[Requested CCMDB changes for the next version]] change log 2010.--[[User:TOstryzniuk|TOstryzniuk]] 16:12, 22 January 2010 (CST)
| DIC_coding = query ''Check Renal IncompatibleDxs''
| DIC_status = retired
| DIC_implementation_date = 2009-09-30
}}


== Administration ==
2014-12-24 retired.  
Hardcoded in query Check_Renal_IncompatibeDXs in [[CCMDB.mdb]].


== Start Date ==
See [[Query check ICD10 ESRD vs ARF]] for the ICD10 implementation of this query.
Sept 2009 (see [[Log]])


== Errors Scenarios ==
See [[Renal Coding Considerations (old)#CCMDB Data Integrity Checks: Competing Diagnoses]] for details.
Patient has both ARF and CRF
* 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 ===
being 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)
 
}}


[[Category: IT Instructions]]
[[Category:Old dx check]]
[[Category: Data Cleaner.mdb]]
[[Category: Data Collection Guide]]

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

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_Check_Renal_IncompatibleDxs&oldid=166600"