Query check ICD10 only 1 stage of renal failure

From CCMDB Wiki
Revision as of 14:10, 2019 March 1 by Ttenbergen (talk | contribs) (Text replacement - "format=list" to "format=plainlist")
Jump to navigation Jump to search
Data Integrity Checks
Summary: can only have one stage of renal failure in Comorbid Diagnosis and in Admit Diagnosis
Related: Chronic kidney disease (chronic renal insufficiency, uremia) Stage 1, GFR GT 90, Chronic kidney disease (chronic renal insufficiency, uremia) Stage 2, GFR 60-89, Chronic kidney disease (chronic renal insufficiency, uremia) Stage 3, GFR 30-59, Chronic kidney disease (chronic renal insufficiency, uremia) Stage 4, GFR 15-29, Chronic kidney disease (end-stage renal/kidney disease, ESRD), Stage 5, GFR LT 15, Chronic kidney/renal disease, NOS (stage unspecified), Kidney, renal failure/insufficiency/uremia, unspecified as acute or chronic, Renal Coding Considerations for ICD10
Firmness: hard check
Timing: complete
App: CCMDB.mdb
Coding: Query check_ICD10_only_1_stage_of_renal_failure
Uses L Problem table: not relevant for this app
Status: ready to implement
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 Concept:Chronic Kidney Disease:

 Has ICD10Code
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


pt could have several stages during acquired, right? Is that how we would want to code deterioration?

  • AG REPLY -- not really. While one could have a lower level as a comorbid, and be admitted with what is finally decided to be an advancement of CRF (so that an admit dx is a higher level), in many cases what you'll have is some degree of CRF + an AKI on top of it. It's important to distinguish between these.
    • Emailed Michelle to find out if that is how she would have understood it as a renal-focused collector. Ttenbergen 08:25, 2019 January 24 (CST)
      • M said it made sense.
  • SMW


  • Cargo


  • Categories