Query check overstay not entered: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "Query used to check that all has been entered for the overstay project. Category:OverstayProject" |
Ttenbergen (talk | contribs) m →Log |
||
| (18 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{Data Integrity Check | |||
|DIC_summary=check that all has been entered for the [[Overstay]] project | |||
|DIC_related_concepts=Overstay Predictor Project Collection Instructions; Overstay Predictor Project | |||
|DIC_firmness=hard check | |||
|DIC_coding=query ''check_overstay_not_entered'' | |||
|DIC_implementation_date=2017-07-31 | |||
|DIC_status=retired | |||
|DIC_app=CCMDB.accdb | |||
|DIC_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. | |||
== Related articles == | |||
{{Related Articles}} | |||
[[Category:OverstayProject]] | [[Category:OverstayProject]] | ||
[[Category:Tmp check]] | |||
Latest revision as of 15:54, 21 April 2022
| 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.