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.mdb
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

"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. 

• 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.