Query Check Renal IncompatibleDxs: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
mNo edit summary
Line 1: Line 1:
'' see also [[!_Automated_Data_Integrity_Checks#CRF_vs_ARF]]
The query '''Check Renal IncompatibleDxs''' implements the rules and exclusions in [[Renal_Coding_Considerations#Competing_Diagnoses]]. It is hardcoded in query Check_Renal_IncompatibeDXs in [[CCMDB.mdb]].
 
Comorbid [[CRF]] can not be coded with the following diagnoses for the same patient:
* [[ARF]] 350 -(as instructed by coding guideline)
* [[ARI]] 364 -(as instructed by coding guideline)
 
 
==Integrity Rule that includes renal Transplant (805)==
*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 ==
Hardcoded in query Check_Renal_IncompatibeDXs in [[CCMDB.mdb]].


== Start Date ==
== Start Date ==
Sept 2009 (see [[Log]])
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)
 
=== Related Articles ===
* [[!_Automated_Data_Integrity_Checks#CRF_vs_ARF]]


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


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

Revision as of 19:44, 8 February 2010

The query Check Renal IncompatibleDxs implements the rules and exclusions in Renal_Coding_Considerations#Competing_Diagnoses. It is hardcoded in query Check_Renal_IncompatibeDXs in CCMDB.mdb.

Start Date

Sept 2009 (see Log)

Status

implementedCCMDB.mdb_Change_Log_2009#v1.90. Ttenbergen 15:50, 29 September 2009 (CDT)

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