Query NDC CLI AcqDX but NoCLI DateinTMPV2

From CCMDB Wiki
Jump to navigationJump to search
Data Integrity Checks
Summary: Checks for Patients who have a CLI but not the corresponding tmp entry.
Related: Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI), QA Infection CLI
Firmness: hard check
Timing: complete
App: Centralized data front end.accdb
Coding: query query NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2
Uses L Problem table: No
Status: implemented
Implementation Date: 2018/11/06


Swiss Army Knife.svg ICD/CCI remove once old pt gone


  • 2018-11-06 added ICD10 component
  • before: check had been around before

Related articles

Related articles: