Query check ApARF CRF: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 10: Line 10:


== ICD10 ==
== ICD10 ==
*[[ARF (APACHE)]]
*[[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 16: Line 19:
**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.
**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.


{{Discuss | who = Tina | question = refine this for implementation and implement }}
{{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]]?
}}


== See also ==
== See also ==

Revision as of 01:25, 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: