Query check ApARF CRF: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 10: Line 10:


== ICD10 ==
== ICD10 ==
*[[ARF (APACHE)]] checked and no [[Transplant]] means patient must not have
** [[Comorbid Diagnosis]] of [[Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5]]
** [[Comorbid Diagnosis]] of [[Renal dialysis care, including dialysis itself]]
*If a person has pre-existing [[Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5]] then they cannot ''subsequently'' have any of the various Acute Renal Failure/AKI diagnoses '''UNLESS''' they got a renal transplant in between --- so the ESRD is before the TP and the AKI is in the new/transplanted kidney.
*If a person has pre-existing [[Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5]] then they cannot ''subsequently'' have any of the various Acute Renal Failure/AKI diagnoses '''UNLESS''' they got a renal transplant in between --- so the ESRD is before the TP and the AKI is in the new/transplanted kidney.
**So we will use the rule that no single database record can include both [[Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5]] and an ARF/AKI code unless a kidney transplant occurred and the ARF/AKI is for the transplanted kidney.
**So we will use the rule that no single database record can include both [[Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5]] and an ARF/AKI code unless a kidney transplant occurred and the ARF/AKI is for the transplanted kidney.
Line 21: Line 17:
{{Discuss | who = Julie | question =  
{{Discuss | who = Julie | question =  
*[[ARF (APACHE)]] should be always be NO when the person has comorbid [[Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5]]  or having  [[Renal dialysis care, including dialysis itself]] in ICD10 diagnosis.  --[[User:JMojica|JMojica]] 12:28, 2018 November 13 (CST)
*[[ARF (APACHE)]] should be always be NO when the person has comorbid [[Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5]]  or having  [[Renal dialysis care, including dialysis itself]] in ICD10 diagnosis.  --[[User:JMojica|JMojica]] 12:28, 2018 November 13 (CST)
** A person with ARF would have dialysis, though, right? So probably more like ARF can't have ESRD or dialysis as [[Comorbid Diagnosis]]?
** A person with ARF could have dialysis, though, right, to treat the ARF? So, how about
***''[[ARF (APACHE)]] checked and no [[(T) Kidney]]+[[Transplant]] / [[Past history, transplanted kidney]] / [[Kidney transplant, failure or rejection or unspecified complication]] means patient must not have
**** ''[[Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5]]
**** ''[[Comorbid Diagnosis]] of [[Renal dialysis care, including dialysis itself]]
** Don't know if we can make that any tighter...
}}
}}



Revision as of 01:30, 2018 November 18

Data Integrity Checks
Summary: ARF (APACHE) and CRF - Chronic Renal Failure can not be coded together for the same patient.
Related: ARF (APACHE), Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5
Firmness: hard check
Timing: always
App: CCMDB.mdb
Coding: query Check_ApARF_CRF
Uses L Problem table: not relevant for this app
Status: needs review
Implementation Date: date change was rolled out / first applied
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:

ICD10

  • If a person has pre-existing Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5 then they cannot subsequently have any of the various Acute Renal Failure/AKI diagnoses UNLESS they got a renal transplant in between --- so the ESRD is before the TP and the AKI is in the new/transplanted kidney.
  • Thus, even though it is possible for an AKI to become fixed/permanent and become any level (1-5) of CRF -- this usually takes time (weeks to months) and for simplicity in coding, except for the case above where a renal TP occurred, the rule is that no single record should have both Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5 and an ARF/AKI code.
    • This really is only an issue for patients with very long hospital stays, and we've decided we can live with this small, uncommon inconsistency.
  • SMW


  • Cargo


  • Categories

See also

Log

Related Articles

Related articles: