Query Check Renal IncompatibleDxs: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
Ttenbergen (talk | contribs)
CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators
92,599 edits
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
m Text replacement - "[[Category: " to "[[Category:"
 
(24 intermediate revisions by 2 users not shown)
Line 1: Line 1:
'' see also [[!_Automated_Data_Integrity_Checks#CRF_vs_ARF]]
{{LegacyContent
|explanation=retired as part of move to ICD10.
|successor=[[Query check ICD10 ESRD vs ARF]]
|content=


Comorbid [[CRF]] can not be coded with the following diagnoses for the same patient:
{{Data Integrity Check
* [[ARF]] 350 -(as instructed by coding guideline)
| DIC_summary = can't have ARF and CRF in same record
* [[ARI]] 364 -(as instructed by coding guideline)
| 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.


==Integrity Rule that includes renal Transplant (805)==
See [[Query check ICD10 ESRD vs ARF]] for the ICD10 implementation of this query.  
*here is what we want as an integrity check rule that also includes kidney transplant:
*'''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.
'''OR'''
'''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)
*[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)
* See: [[Requested CCMDB changes for the next version]] change log 2010.--[[User:TOstryzniuk|TOstryzniuk]] 16:12, 22 January 2010 (CST)


== Administration ==
See [[Renal Coding Considerations (old)#CCMDB Data Integrity Checks: Competing Diagnoses]] for details.
Hardcoded in query Check_Renal_IncompatibeDXs in [[CCMDB.mdb]].
* 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 **)


== Start Date ==
See also [[ICD10 Guideline for Renal Coding]]
Sept 2009 (see [[Log]])


== Errors Scenarios ==
=== Status ===
Patient has both ARF and CRF
* 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)


=== Status ===
}}
being implemented[[CCMDB.mdb_Change_Log_2009#v1.90]]. [[User:Ttenbergen|Ttenbergen]] 15:50, 29 September 2009 (CDT)


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

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

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