Query check overstay not entered: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
(16 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]]
|DIC_related_concepts=Overstay Predictor Project Collection Instructions; Overstay Predictor Project
| DIC_firmness = hard check  
|DIC_firmness=hard check
| DIC_app = CCMDB.mdb
|DIC_coding=query ''check_overstay_not_entered''
| DIC_coding = query ''check overstay no colour''  
|DIC_implementation_date=2017-07-31
| DIC_status = implemented
|DIC_status=retired
| DIC_implementation_date = 2017-07-31
|DIC_app=CCMDB.accdb
|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 ==
Line 16: Line 19:


[[Category:OverstayProject]]
[[Category:OverstayProject]]
[[Category:Tmp check]]

Latest revision as of 15:54, 2022 April 21

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
  • Cargo


  • SMW


  • Categories:  
  • form:

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: