Query check dx primary not exactly one

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.