Query check transfer DtTm during admission: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 9: | Line 9: | ||
|DIC_backlogged=No | |DIC_backlogged=No | ||
}} | }} | ||
. | |||
This check runs at pre-send checker time and considers all records except deleted ones. | |||
== Log == | == Log == | ||
* 2022-06-29 - confirmed that this catches this problem; records with it still seem to show up in CFE, not sure how that's possible | |||
* 2021-02-03 broke check into two, since we can check date in range always, but date present only when record is complete. | * 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 | * 2021-01-28 implemented | ||
Latest revision as of 09:40, 29 June 2022
| 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 |
This check runs at pre-send checker time and considers all records except deleted ones.
Log
- 2022-06-29 - confirmed that this catches this problem; records with it still seem to show up in CFE, not sure how that's possible
- 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