Query check has transfer ready date or checkbox: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 10: | Line 10: | ||
}} | }} | ||
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 | |||
== Log == | == Log == | ||
* 2021-02-03 - implemented | * 2021-02-03 - implemented |
Revision as of 17:03, 2021 February 4
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
Log
- 2021-02-03 - implemented
Related articles
Related articles: |