Query Check Renal IncompatibleDxs

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)

Discussion

• ATN 352 - must be included here also. This is missing from integrity check for ccmdb. see rule here.--TOstryzniuk 21:08, 21 January 2010 (CST)

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--TOstryzniuk 21:08, 21 January 2010 (CST)

• click here to see rule request to move to ccmdb.mdb--TOstryzniuk 21:17, 21 January 2010 (CST)

Administration

Hardcoded in query Check_Renal_IncompatibeDXs in CCMDB.mdb.

Start Date

Sept 2009 (see Log)

Errors Scenarios

Patient has both ARF and CRF

Status

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