| Data Integrity Checks
|
| Summary:
|
Component CCIs must have compatible component 1 and component 2
|
| Related:
|
[[CCI Procedure]]
|
| Firmness:
|
hard check
|
| Timing:
|
complete
|
| App:
|
CCMDB.mdb
|
| 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
|
"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.
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.mdb 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