CCMDB Wiki

Query check overstay not entered: Difference between revisions

← Older edit
mNo edit summary
 
(12 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
|DIC_related_concepts=Overstay Predictor Project Collection Instructions; Overstay Predictor Project
| DIC_firmness = hard check  
|DIC_firmness=hard check
| DIC_timing =
|DIC_coding=query ''check_overstay_not_entered''
| DIC_app = CCMDB.mdb
|DIC_implementation_date=2017-07-31
| DIC_coding = query ''check overstay no colour''  
|DIC_status=retired
| DIC_status = implemented
|DIC_app=CCMDB.accdb
| DIC_implementation_date = 2017-07-31
|DIC_backlogged=No
}}
}}
== Log ==
== Log ==
Query changed in version 2016-11-09 to exclude EMIP patients since that condition was generating a [[Overstay Predictor Project Collection Instructions]] warning.  
* 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 ==
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_overstay_not_entered"