Query check CCI Component no admin entries

From CCMDB Wiki
Revision as of 12:28, 8 February 2023 by Ttenbergen (talk | contribs) (Created page with "{{Data Integrity Check | DIC_summary = There must be no No procedure entered/Blank procedure entry in CCI Component. | DIC_related_concepts = CCI Component; No procedure entered; Blank procedure entry | DIC_firmness = hard check | DIC_timing = complete | DIC_app = CCMDB.accdb | DIC_coding = query ''check_CCI_Component_if_no_admin_entries'' | DIC_status = implemented | DIC_implementation_date = 2018-10-14 }} == Log == * 2023-02-08 - broke original query in t...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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:

Log

  • 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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_CCI_Component_no_admin_entries&oldid=158476"