Query check ApARF CRF: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = [[ARF (APACHE)]] and [[CRF - Chronic Renal Failure]] can not be coded together for the same patient.  
|DIC_summary=[[ARF (APACHE)]] and [[CRF - Chronic Renal Failure]] can not be coded together for the same patient.
| DIC_related_concepts = ARF (APACHE);Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5
|DIC_related_concepts=ARF (APACHE);Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5
| DIC_firmness = hard check (not allowed) or soft check (allowed, but give error; in CFE this means it has to go into the ... table, and cross checks have to consider that table)
|DIC_firmness=hard check
| DIC_timing =
|DIC_coding=query ''Check_ApARF_CRF ''
| DIC_app = CCMDB.mdb
|DIC_implementation_date=date change was rolled out / first applied
| DIC_coding = query ''Check_ApARF_CRF ''
|DIC_status=needs review
| DIC_status = needs review
|DIC_app=CCMDB.mdb
| DIC_implementation_date = date change was rolled out / first applied
}}
}}
== ICD10 ==
== ICD10 ==
*[[ARF (APACHE)]]
*[[ARF (APACHE)]]
*[[Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5]]
*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.
can not be coded together.
**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.
 
*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. 
{{DA | Does this only apply when they are specifically [[Admit Diagnosis]], [[Acquired Diagnosis]] or [[Comorbid Diagnosis]]? }}
**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.


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

Revision as of 15:07, 2018 October 29

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

  • ARF (APACHE)
  • 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.

See also

Log

Related Articles

Related articles: