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.accdb
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

• 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) I seem to remember discussing this with Pagasa. There was a misconception that a "no CCIs" had to be present in both component and picklist, but that is not true: it only needs to be in the Picklist. Is this still a problem? If so, please tell me an example when one comes up. Michelle sent email 2019-10-31 that she was able to click "D" with no CCIs entered. I tested on my copy and got an error when I tried. Will need more info about the scenarios where this can slip through.

• SMW

• Cargo

• Categories

Log

• 2021-01-20 - updated so TISS entries will not satisfy this requirement
• 2019-11-17 - confirmed that this works since there was talk about records without CCIs slipping through
• 2019-10-27 - updates so it only checks for Recordstatus = complete or incomplete.