Query check CCI Picklist 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 Picklist.
Related: CCI Picklist, No procedure entered, Blank procedure entry
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: query check_CCI_Picklist_if_no_admin_entries
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2023-02-08
Backlogged: true
  • Cargo

  • SMW

  • Categories: 
  • form:


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