Query check CCI must have entry: Difference between revisions

Revision as of 22:37, 17 November 2019

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

	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.

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.

@@ Line 10: / Line 10: @@
 |DIC_app=CCMDB.accdb
 }}
+{{bug}}
 {{Discuss | who = Pagasa |
 * Patients without CCI entries are slipping through and found by [[PL missing L Tables content]] , must fix [[User:PTorres|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. }}
+** 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.}}
 == Log ==