Query check overstay not entered
| Data Integrity Checks | |
| Summary: | check that all has been entered for the Overstay project |
| Related: | Overstay Predictor Project Collection Instructions, Overstay Predictor Project |
| Firmness: | hard check |
| Timing: | always |
| App: | CCMDB.accdb |
| Coding: | query check_overstay_not_entered |
| Uses L Problem table: | not relevant for this app |
| Status: | retired |
| Implementation Date: | 2017-07-31 |
| Backlogged: | No |
Log
- 2022-04-21 - query has been removed entirely at some point before this
- 2019-11-18 - changed to only check if Accept_DtTm < 2019-10-01
- 2019-10-27 - changed to only check if recordstatus = incomplete or complete
- 2016-11-09 - changed to exclude EMIP patients since that condition was generating a Overstay Predictor Project Collection Instructions warning.