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

Revision as of 16:03, 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

The following will trigger an error:

RecordStatus Complete and either TransferReady dttm or first Boarding Loc is after 2020-10-15 (ie. Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry)
and one of the following:
- checkbox is checked and yet a date is present
- checkbox is not checked, and no date is present
- checkbox is checked and comment is not either "not ready" or "not available"
- checkbox is not checked but there is a comment

@@ Line 10: / Line 10: @@
 }}
-{{TT |
+The following will trigger an error:
-As per [[Transfer Ready DtTm tmp entry]] we can and should go further:
+* [[RecordStatus]] Complete and either TransferReady dttm or first [[Boarding Loc]] is after 2020-10-15 (ie. [[Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry]])
-* comment (under 'q'): '''only if TR date not available (ie if checkbox checked), enter either "not ready" or "not available" into the comment field.}}
+* and one of the following:
-.
+** checkbox is checked and yet a date is present
+** checkbox is not checked, and no date is present
+** checkbox is checked and comment is not either "not ready" or "not available"
+** checkbox is not checked but there is a comment
 == Log ==
 * 2021-02-03 - implemented