Query check ApARF CRF

Data Integrity Checks
Summary:	ARF (APACHE) and CRF - Chronic Renal Failure can not be coded together for the same patient.
Related:	ARF (APACHE), Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5
Firmness:	hard check
Timing:	always
App:	CCMDB.mdb
Coding:	query Check_ApARF_CRF
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:	date change was rolled out / first applied
Backlogged:	true

• Cargo

• SMW

"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. 

• Categories:  

• form:

ICD10

• ARF (APACHE)
• If a person has pre-existing Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5 then they cannot subsequently have any of the various Acute Renal Failure/AKI diagnoses UNLESS they got a renal transplant in between --- so the ESRD is before the TP and the AKI is in the new/transplanted kidney.
  • So we will use the rule that no single database record can include both Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5 and an ARF/AKI code unless a kidney transplant occurred and the ARF/AKI is for the transplanted kidney.
• Thus, even though it is possible for an AKI to become fixed/permanent and become any level (1-5) of CRF -- this usually takes time (weeks to months) and for simplicity in coding, except for the case above where a renal TP occurred, the rule is that no single record should have both Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5 and an ARF/AKI code.
  • This really is only an issue for patients with very long hospital stays, and we've decided we can live with this small, uncommon inconsistency.

refine this for implementation and implement

• SMW

• Cargo

• Categories

• ARF (APACHE) should be always be NO when the person has comorbid Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5 or having Renal dialysis care, including dialysis itself in ICD10 diagnosis. --JMojica 12:28, 2018 November 13 (CST)

See also

• Renal Coding Considerations (old)
• Renal Coding Considerations for ICD10

Log

• updated as of CCMDB.mdb Change Log 2011#ver 2011-12-09 Ttenbergen 13:27, 11 December 2011 (CST)
• implemented CCMDB.mdb Change Log 2009#v1.90. Ttenbergen 15:50, 29 September 2009 (CDT)