Query check CCI if no then none: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = If [[No procedure performed]]  in [[CCI Picklist]] there must be no other entries in [[CCI Picklist]] or [[CCI Component]]
| DIC_summary = If [[No procedure performed]]  in [[CCI Picklist]] there must be no other entries in [[CCI Picklist]] or [[CCI Component]]
| DIC_related_concepts = [[CCI Picklist]], [[CCI Component]], [[No procedure performed]]
| DIC_related_concepts = CCI Picklist; CCI Component; No procedure performed
| DIC_firmness = hard check  
| DIC_firmness = hard check  
| DIC_timing = complete
| DIC_timing = complete

Revision as of 22:26, 26 October 2018

Data Integrity Checks
Summary: If No procedure performed in CCI Picklist there must be no other entries in CCI Picklist or CCI Component
Related: CCI Picklist, CCI Component, No procedure performed
Firmness: hard check
Timing: complete
App: CCMDB.mdb
Coding: query check_CCI_if_no_then_none
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2018-10-14
Backlogged: true
  • Cargo


  • SMW
"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. 
  • Categories:  
  • form:

Related articles

Related articles: