Query check has transfer ready date or checkbox: Difference between revisions

Revision as of 13:17, 4 February 2021

Data Integrity Checks
Summary:	Each Transfer Ready DtTm tmp entry has to have either a dttm, or its checkbox checked.
Related:	Transfer Ready DtTm tmp entry
Firmness:	not entered
Timing:	complete
App:	CCMDB.accdb
Coding:	query check_has_transfer_ready_date_or_checkbox
Uses L Problem table:	not relevant for this app
Status:	ready to implement
Implementation Date:	2021-02-03
Backlogged:	No

	As per [[]] we can and should go further: comment (under 'q'): only if TR date not available (ie if checkbox checked), enter either "not ready" or "not available" into the comment field.	added: no added date action: no action date

.

@@ Line 5: / Line 5: @@
 |DIC_coding=query check_has_transfer_ready_date_or_checkbox
 |DIC_implementation_date=2021-02-03
-|DIC_status=implemented
+|DIC_status=ready to implement
 |DIC_app=CCMDB.accdb
 |DIC_backlogged=No
 }}
+{{TT |
+As per [[]] we can and should go further:
+* comment (under 'q'): '''only if TR date not available (ie if checkbox checked), enter either "not ready" or "not available" into the comment field.}}
 .
 == Log ==