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.mdb
Coding:	query check_CCI_Picklist_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 (CCMDB.accdb, Centralized data front end.accdb, TISS28.accdb, SAP, DSM Labs Consistency check.accdb, not entered) 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 (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.