CCMDB Wiki

Query Check Renal IncompatibleDxs: Difference between revisions

← Older edit
Ttenbergen (talk | contribs)
CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators
92,607 edits
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
m Text replacement - "[[Category: " to "[[Category:"
 
(28 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
| 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]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_Check_Renal_IncompatibleDxs"