Query check CCI component 1 and 2 compatible
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 |
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: |