Query check ICD10 ESRD vs ARF

From CCMDB Wiki
Revision as of 23:29, 2018 October 21 by Ttenbergen (talk | contribs) (Created page with "{{Data Integrity Check | DIC_summary = Can't have ESRD and acute renal failure | DIC_related_concepts = li...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
Data Integrity Checks
Summary: Can't have ESRD and acute renal failure
Related: list of related pages (probably the one it's on, but there might be others...)
Firmness: hard check
Timing: complete
App: CCMDB.mdb
Coding: how to find this in containing program, eg. SAS file, function name, query name...
Uses L Problem table: not relevant for this app
Status: needs review
Implementation Date:
Backlogged: true
  • Cargo


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

This is about codes N17-N19:

 Has ICD10Code
Kidney, acute tubular necrosis (ATN)N17.0
Kidney, acute renal failure NOSN17.9
Chronic kidney disease (chronic renal insufficiency, uremia) Stage 1, GFR GT 90N18.1
Chronic kidney disease (chronic renal insufficiency, uremia) Stage 2, GFR 60-89N18.2
Chronic kidney disease (chronic renal insufficiency, uremia) Stage 3, GFR 30-59N18.3
Chronic kidney disease (chronic renal insufficiency, uremia) Stage 4, GFR 15-29N18.4
Chronic kidney disease (end-stage renal/kidney disease, ESRD), Stage 5, GFR LT 15N18.5
Chronic kidney/renal disease, NOS (stage unspecified)N18.9
Kidney, renal failure/insufficiency/uremia, unspecified as acute or chronicN19

acute vs comorbid and other clarifications

  • SMW


  • Cargo


  • Categories
  • I think what we really want here is: can't have ESRD and (N17 or N19)

Transplant patients

Clearly this works OK for those without transplant. But it also works WITH a failed or failing transplant if we also make the rules that

  • Never code both [Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5]] and any of the acute renal failure codes.
    • The only time you might be inclined to do so is in the presence of a failed kidney transplant, where the ESRD would refer to the failure of the native kidney, and the acute renal failure to the transplanted kidney, but don't do it even there, because the FACT of a kidney transplant automatically indicates that ESRD had occurred