Query check CCI if no then none

Data Integrity Checks
Summary:	If No procedure performed in CCI Picklist there must be no other entries in CCI Picklist or CCI Component
Related:	[[CCI Picklist, CCI Component, No procedure performed]]
Firmness:	hard check
Timing:	complete
App:	CCMDB.mdb
Coding:	query check_CCI_if_no_then_none
Uses L Problem table:	not relevant for this app
Status:	ready to implement
Implementation Date:
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. Property "DICRelatedConcepts" (as page type) with input value "CCI Picklist]], CCI Component, [[No procedure performed" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

• Categories:  

• form:

• need to make sure each pt has at least one CCI entry, possibly No procedure performed.