CCMDB Wiki

Query check overstay not entered: Difference between revisions

← Older edit
No edit summary
 
(17 intermediate revisions by the same user not shown)
Line 1: Line 1:
Query used to check that all has been entered for the overstay project.
{{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.


Query changed in version 2016-11-09 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]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_overstay_not_entered"