Query check tmp Transfer Ready not before Boarding Loc
| Data Integrity Checks | |
| Summary: | Validates that the DtTm for a Transfer_Ready_DtTm_tmp entry is not before its matching Boarding Loc entry |
| Related: | Boarding Loc, Transfer_Ready_DtTm_tmp entry |
| Firmness: | hard check |
| Timing: | complete |
| App: | CCMDB.accdb |
| Coding: | query check_tmp_Transfer_Ready_not_before_Boarding_Loc |
| Uses L Problem table: | not relevant for this app |
| Status: | retired |
| Implementation Date: | 2021-08-04 |
| Backlogged: | true |
This check is a subset of query check_transfer_DtTm_during_admission, and we don't need both, since both ran at pre-send checker time, and include all records except deleted ones. Retiring this check.
Log
- 2021-10-05 - retiring check
- 2021-08-06 - tweaked to only consider undeleted records.
- 2021-08-04 - implemented
Related articles
| Related articles: |