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.accdb
Coding:	query check_CCI_Component_duplicates
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2018-10-14
Backlogged:	true

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.

Log

2023-11-25 - checked query as part of Change to having each collector collect both programs on the same laptop and found it to not use the usual column names.