Query check overstay not entered: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m →Log |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
| DIC_summary = check that all has been entered for the [[Overstay]] project | |DIC_summary=check that all has been entered for the [[Overstay]] project | ||
| DIC_related_concepts = Overstay Predictor Project Collection Instructions; Overstay Predictor Project | |DIC_related_concepts=Overstay Predictor Project Collection Instructions; Overstay Predictor Project | ||
| DIC_firmness = hard check | |DIC_firmness=hard check | ||
|DIC_coding=query ''check_overstay_not_entered'' | |||
|DIC_implementation_date=2017-07-31 | |||
| DIC_coding = query ''check_overstay_not_entered'' | |DIC_status=retired | ||
|DIC_app=CCMDB.accdb | |||
| DIC_implementation_date = 2017-07-31 | |DIC_backlogged=No | ||
}} | }} | ||
== Log == | == Log == | ||
* 2019-11-18 - changed to only check if | * 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 | * 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. | * 2016-11-09 - changed to exclude EMIP patients since that condition was generating a [[Overstay Predictor Project Collection Instructions]] warning. | ||
== Related articles == | == Related articles == | ||
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.