Query check has transfer ready date or checkbox
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: |