Query NDC Dialysis TISS CCI

From CCMDB Wiki
Revision as of 16:53, 2020 May 5 by Ttenbergen (talk | contribs) (Text replacement - "{{DT" to "{{TT")
Jump to navigation Jump to search
Data Integrity Checks
Summary: Critical care patients who have CCI entries for a type of dialysis must have a TISS28 entry for the same type of dialysis as well, and vice versa.
Related: CRRT (incl volume removal via PRISMA device), PD (Peritoneal dialysis), HD (Hemodialysis), Peritoneal dialysis (TISS Item), CRRT (TISS Item), Intermittent hemodialysis (TISS Item), Renal Coding Considerations for ICD10
Firmness: hard check
Timing: complete
App: Centralized data front end.accdb
Coding: Query NDC_Dialysis_TISS_CCI
Uses L Problem table: Yes
Status: needs review
Implementation Date: 2019/01/06
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:


_dev_CFE change to wait till complete

  • added: no added date
  • action: no action date
  • Cargo


  • Categories

This query lists three pairs of columns. If there is an entry in one of the HD columns, there has to be one in the other. Same for the CRRT and PD columns.

Supersedes

This will supersede

Why does this not include Renal dialysis care, including dialysis itself?

Renal dialysis care, including dialysis itself can't be included because it doesn't imply that it happened while there. See that code's collection instructions for more info.