Query check CCI Component duplicates

Data Integrity Checks
Summary:	No duplication of CCI Component Px_Type, Px_Date
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:	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. 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
• 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 Procedures coded once per ward admission only being there once.

Waiting for...

We are reviewing some details in the definition of when to count or only enter once etc, so waiting to implement until that is settled.