Query check_ICD10_ESRD_and_AKI_only_if_transplant

From CCMDB Wiki
Revision as of 11:13, 2023 May 18 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, ICD10 Guideline for Renal Coding
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 implement
Implementation Date:
Backlogged: true
  • Cargo


  • SMW


  • 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.

See also

Related articles

Related articles: