Query check overstay no colour: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = Med pts must have [[Overstay]] colours
|DIC_summary=Med pts must have [[Overstay]] colours
| DIC_related_concepts = Overstay
|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_no_colour''
| 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 ==
* 2022-04-21 - at some point before now this query was removed entirely
* 2019-11-18 - changed to only check if ''Accept_DtTm'' < 2019-10-01


== Related articles ==
== Related articles ==

Latest revision as of 17:19, 21 April 2022

Data Integrity Checks
Summary: Med pts must have Overstay colours
Related: Overstay Predictor Project Collection Instructions, Overstay Predictor Project
Firmness: hard check
Timing: always
App: CCMDB.accdb
Coding: query check_overstay_no_colour
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 - at some point before now this query was removed entirely
  • 2019-11-18 - changed to only check if Accept_DtTm < 2019-10-01

Related articles

Related articles: