Query check transfer DtTm during admission: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 5: Line 5:
|DIC_coding=query ''check_transfer_DtTm_during_admission''
|DIC_coding=query ''check_transfer_DtTm_during_admission''
|DIC_implementation_date=2021-01-28
|DIC_implementation_date=2021-01-28
|DIC_status=needs review
|DIC_status=implemented
|DIC_app=CCMDB.accdb
|DIC_app=CCMDB.accdb
|DIC_backlogged=No
|DIC_backlogged=No

Revision as of 15:48, 2021 February 3

Data Integrity Checks
Summary: Transfer Ready DtTm tmp entry should never be earlier than first Boarding Loc dttm or later than Dispo DtTm
Related: Transfer Ready DtTm tmp entry, Dispo DtTm field, Boarding Loc
Firmness: not entered
Timing: always
App: CCMDB.accdb
Coding: query check_transfer_DtTm_during_admission
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2021-01-28
Backlogged: No
  • Cargo


  • SMW


  • Categories: 
  • form:

.

Log

  • 2021-02-03 broke check into two, since we can check date in range always, but date present only when record is complete.
  • 2021-01-28 implemented

Related articles

Related articles: