Query check CCI Picklist duplicates

Data Integrity Checks
Summary:	No duplication of CCI Picklist Px_Type, Px_Date, Px_Count
Related:	CCI Picklist, Px Type, Dx_Priority, No Dx Entered
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:	query check_CCI_Picklist_duplicates
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2018-10-14
Backlogged:	true

• Cargo

• SMW

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