Query s tmp check combined BL and TRDtTm nonsequential
Jump to navigation
Jump to search
| Data Integrity Checks | |
| Summary: | Validates that the combiner integers for Transfer Ready DtTm tmp entry and Boarding Loc are consecutive with the date/time_vals |
| Related: | Boarding Loc, Transfer Ready DtTm tmp entry |
| Firmness: | hard check |
| Timing: | complete |
| App: | CCMDB.accdb |
| Coding: | query s_tmp_check_combined_BL_and_TRDtTm_nonsequential |
| Uses L Problem table: | not relevant for this app |
| Status: | retired |
| Implementation Date: | 2021-08-26 |
| Backlogged: | No |
Log
- 2022-05-03 - retired, replace by query check_Transfer_DtTm_after_paired_BL_and_before_later_BL
- 2021-08-26 - implemented
- 2021-08-09 - Julie changed definition