Query check CCI must have entry

Data Integrity Checks
Summary:	There must be at least 1 CCI entry in L_CCI_Picklist table (which might be No procedure performed)
Related:	CCI Collection, No procedure performed, L_CCI_Picklist table
Firmness:	hard check
Timing:	complete
App:	CCMDB.mdb
Coding:	query check_CCI_must_have_entry
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:	2018/11/12
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:

Patients without CCI entries are slipping through and found by PL missing L Tables content , must fix PTorres 09:42, 2019 February 7 (CST)

• SMW

• Cargo

• Categories