Query check CCI Component duplicates

Data Integrity Checks
Summary:	No duplication of CCI Component Px_Type, Px_Date
Related:	CCI Component, Px Type, Dx_Priority, No Dx Entered
Firmness:	hard check
Timing:	complete
App:	CCMDB.mdb
Coding:	query check_CCI_Component_duplicates
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2018-10-14
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:

• Px Type = Acquired – no same Px_Date and CCI code
• Px Type = Admit – no same CCI code (it should not have a Px_Date at all, dealt with by Query check CCI Date).

We are not currently planning to check for CCI Collection Modes being used correctly but this may change.