Query check CCI Component duplicates

Revision as of 21:31, 26 October 2018 by Ttenbergen (talk | contribs)
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.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. 
  • Categories:  
  • form:

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.

Related articles

Related articles: