Query check CCI TISS if no then none: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Text replacement - "TISS28 checks" to "TISS28 check" |
Ttenbergen (talk | contribs) m →Log |
||
| Line 13: | Line 13: | ||
== Log == | == Log == | ||
* 2023-11-25 - check explicitly checked for program = CC but this should not be required, since other programs simply should not have {{TISS w Nr|No TISS Item (TISS Item)}} at all | |||
* 2021-01-20 - check defined and implemented | * 2021-01-20 - check defined and implemented | ||
Latest revision as of 10:30, 25 November 2023
| 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: |