Query check CCI Component no admin entries

From CCMDB Wiki
Jump to navigation Jump to search
Data Integrity Checks
Summary: There must be no No procedure entered/Blank procedure entry in CCI Component.
Related: CCI Component, No procedure entered, Blank procedure entry
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: query check_CCI_Component_if_no_admin_entries
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2018-10-14
Backlogged: true
  • Cargo

  • SMW

  • Categories: 
  • form:


  • 2023-11-25 - found this to have "*" selected and to not be properly editable, fixed
  • 2023-02-08 - broke original query in two and fixed it
  • 2018-10-14 - initially implemented as one query to check both picklist and component list, but wasn't working right

Related articles

Related articles: