Query check ApARF CRF: Difference between revisions

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


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


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

Revision as of 13:28, 2018 November 13

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.

refine this for implementation and implement

  • SMW


  • Cargo


  • Categories

See also

Log

Related Articles

Related articles: