Query check CCI TISS NrDays GT LOS
Data Integrity Checks | |
Summary: | There has to be a TISS entry in CCI Picklist with a Px_Date for each date between Accept DtTm and Dispo DtTm |
Related: | CCI Picklist, No TISS Item (TISS Item) |
Firmness: | hard check |
Timing: | complete |
App: | CCMDB.accdb |
Coding: | query check_CCI_TISS_each_day |
Uses L Problem table: | not relevant for this app |
Status: | needs review |
Implementation Date: | |
Backlogged: | true |
Will replace Query TISS Errors missing days; Query TISS Errors NrTISSDays NE LOS
Log
- 2021-01-20 - check defined and implemented