Query check has transfer ready date or checkbox

From CCMDB Wiki
Revision as of 14:18, 2021 February 4 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search
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
  • Cargo


  • SMW


  • Categories: 
  • form:


As per Transfer Ready DtTm tmp entry 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
  • Cargo


  • Categories

.

Log

  • 2021-02-03 - implemented

Related articles

Related articles: