Query check CCI TISS if no then none: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "{{Data Integrity Check | DIC_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 v..." |
Ttenbergen (talk | contribs) m →Log |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 6: | Line 6: | ||
| DIC_app = CCMDB.accdb | | DIC_app = CCMDB.accdb | ||
| DIC_coding = query ''check_CCI_TISS_if_no_then_none'' | | DIC_coding = query ''check_CCI_TISS_if_no_then_none'' | ||
| DIC_status = | | DIC_status = implemented | ||
| DIC_implementation_date = | | DIC_implementation_date = 2021-01-20 | ||
}} | }} | ||
This check can be done even on incomplete data, since while there might be no data, there should never be inconsistent data. | 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 == | == Log == | ||
* 2021-01-20 - check defined | * 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 | |||
== Related articles == | == Related articles == | ||
| Line 20: | Line 21: | ||
[[Category:CCI]] | [[Category:CCI]] | ||
[[Category:CCI Px check]] | [[Category:CCI Px check]] | ||
[[Category:TISS28 | [[Category:TISS28 check]] | ||
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: |