Query check CCI must have entry: Difference between revisions

Revision as of 17:36, 24 November 2021

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

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.

Related articles:
CCI Collection (← links) No procedure performed (← links) CCMDB.mdb Change Log 2018 (← links) Data Integrity Checks (← links) Query check CCI from OR no CCI (← links) CCMDB.accdb Change Log 2019 (← links) CCMDB.accdb Change Log 2021 (← links) CCMDB.accdb Change Log 2023 (← links)

@@ 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.
-** 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 ==