Query check dx primary not exactly one

From CCMDB Wiki
Jump to navigation Jump to search
Data Integrity Checks
Summary: There has to be exactly one dx per patient with Dx Primary checked, and it has to be an Admit Diagnosis
Related: Dx Primary, Admit Diagnosis, Primary Admit Diagnosis
Firmness: hard check
Timing: always
App: CCMDB.accdb
Coding: query check_dx_primary_not_exactly_one
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2018-10-01
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

Incidentally, this check also makes sure that at least one Admit Diagnosis must be present, so this doesn't need to be checked separately.

Related articles

Related articles: