Query check CCI must have entry: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
m Text replacement - "[[Category: " to "[[Category:"
 
(2 intermediate revisions by 2 users not shown)
Line 5: Line 5:
|DIC_timing=complete
|DIC_timing=complete
|DIC_coding=query ''check_CCI_must_have_entry''
|DIC_coding=query ''check_CCI_must_have_entry''
|DIC_implementation_date=2018/11/12
|DIC_implementation_date=2018-11-12
|DIC_status=needs review
|DIC_status=implemented
|DIC_LProblem=No
|DIC_app=CCMDB.accdb
|DIC_app=CCMDB.accdb
|DIC_backlogged=No
}}
}}
{{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 ==
== Log ==
* 2021-01-20 - updated so TISS entries will not satisfy this requirement
* 2021-01-20 - updated so TISS entries will not satisfy this requirement
Line 24: Line 18:
{{Related Articles}}
{{Related Articles}}


[[Category: CCI]]
[[Category:CCI]]
[[Category: CCI Px check‎]]
[[Category:CCI Px check‎]]

Latest revision as of 11:56, 30 July 2025

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: implemented
Implementation Date: 2018-11-12
Backlogged: No
  • Cargo


  • SMW


  • Categories:  
  • form:

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.

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_CCI_must_have_entry&oldid=166542"