Query check CCI component 1 and 2 compatible

From CCMDB Wiki
Revision as of 11:44, 22 September 2019 by Ttenbergen (talk | contribs) (Text replacement - "CCMDB.mdb" to "CCMDB.accdb")
Jump to navigation Jump to search
Data Integrity Checks
Summary: Component CCIs must have compatible component 1 and component 2
Related: [[CCI Procedure]]
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: query Check_CCI_component_1_and_2_compatible
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2018-10-14
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

It is possible to enter a Component 1 from e.g. diagnostics and a component 2 from e.g. imaging. This should be impossible in the first place, but making that happen in CCMDB.accdb turned out quite complicated, so has not been implemented. We need to have a cross check that disallows combining codes from different groups.

Related articles

Related articles: