Query check CCI ICD10 Dialysis no Dx

From CCMDB Wiki
Revision as of 12:45, 23 September 2021 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search
Data Integrity Checks
Summary: If there is a TISS28 entry for Hemodialysis there should be a corresponding Dx.
Related: Peritoneal dialysis (TISS Item), CRRT (TISS Item), [[Intermittent hemodialysis (TISS Item)]], Kidney, acute renal failure NOS, Kidney, acute renal failure, postprocedural, Kidney, acute tubular necrosis (ATN), Kidney, renal failure/insufficiency/uremia, unspecified as acute or chronic, Kidney, acute renal failure, postprocedural, Kidney, acute renal failure NOS, Kidney, acute tubular necrosis (ATN), Hyperkalemia, severe or symptomatic, Congestive heart failure with pulmonary edema, Fluid overload, Acidosis, NOS, Kidney, renal tubular acidosis (RTA, all types), Aspirin or other salicylate or NSAID, overdose/toxicity, Antiseizure drug NOS, overdose/toxicity, Insulin or other antidiabetes drug, overdose/toxicity, Psychiatric drug NOS, adverse effect, Drug or biological substance/agent NOS, overdose/toxicity, Alcohol (ethanol), poisoning, Toxic alcohols, poisoning, Calcium channel blocker, overdose/toxicity
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: query check_CCI_ICD10_Dialysis_has_Dx
Uses L Problem table: not relevant for this app
Status: ready to implement
Implementation Date:
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

If there is a #Dialysis TISS Items there should be a #Dialysis qualifying Dxs.

Has #Dialysis TISS Items but no #Dialysis qualifying Dxs

If meets following the entry is an error:

Dialysis CCI Items

Dialysis qualifying Dxs

all #Dialysis requiring Dxs plus: Concept:Chronic Kidney Disease:

Allan confirmed that we would not need to add covid because if used in that context, renal failure would also be coded.

Related articles

Related articles: