Query check ICD10 ESRD and AKI only if transplant

From CCMDB Wiki
Revision as of 16:49, 2021 January 12 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search
Data Integrity Checks
Summary: A patient who has an ESRD dx and an AKI dx is an error unless they also have a kidney transplant CCI.
Related: Chronic kidney disease (end-stage renal/kidney disease, ESRD), Stage 5, GFR LT 15, Renal Coding Considerations for ICD10
Firmness: soft check
Timing: complete
App: CCMDB.accdb
Coding: Query check_ICD10_ESRD_and_AKI_only_if_transplant
Uses L Problem table: not relevant for this app
Status: ready to program
Implementation Date:
Backlogged: true
  • Cargo


  • SMW

"ready to program" is not in the list (needs review, ready to implement, implemented, not feasible, declined, retired, not entered) of allowed values for the "DICStatus" property.

  • Categories: 
  • form:

This check will always need to be consistent with Kidney Transplant Coding Guidelines.

Due to the way that ESRD and AKI are defined there are some scenarios in which a pt could actually have ESRD and then get an AKI. For example, someone can have a GFR <15 and not be on dialysis, and then get an AKI that puts them on dialysis. There are probably other scenarios.

So, we can not have a hard check for this, where a collector would not be able to send. Instead we will implement a "soft check" that gives a warning but allows the collector to click past.

Related articles

Related articles: