Query check CCI must have entry

From CCMDB Wiki
Jump to navigationJump to search
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: 
Data processor.svg
  • 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


  • 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: