Query check CCI TISS if no then none
Jump to navigation
Jump to search
| Data Integrity Checks | |
| Summary: | If No TISS Item (TISS Item) in CCI Picklist there must be no other entry from TISS Item List in CCI Picklist, and vice versa |
| Related: | CCI Picklist, No TISS Item (TISS Item) |
| Firmness: | hard check |
| Timing: | incomplete |
| App: | CCMDB.accdb |
| Coding: | query check_CCI_TISS_if_no_then_none |
| Uses L Problem table: | not relevant for this app |
| Status: | implemented |
| Implementation Date: | 2021-01-20 |
| Backlogged: | true |
This check can be done even on incomplete data, since while there might be no data, there should never be inconsistent data. So, it is triggered as part of tmp checker.
Log
- 2023-11-25 - check explicitly checked for program = CC but this should not be required, since other programs simply should not have T1 - No TISS Item (TISS Item) at all
- 2021-01-20 - check defined and implemented
Related articles
| Related articles: |