Query check CCI Component duplicates

Data Integrity Checks
Summary:	No duplication of CCI Component Px_Type, Px_Date, Px_Count
Related:	[[CCI Picklist, 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:	needs review
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]], Px Type, Dx_Priority, [[No Dx Entered" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

• Categories:  

• form:

• Px Type = Acquired – no same Px_Date and CCI code and Px Count
• Px Type = Admit – no same CCI code and Px Count, (exclude the Px_date entered).

We are not currently planning to check for CCI Procedures coded once per ward admission only being there once.