Query check transfer DtTm during admission
| Data Integrity Checks | |
| Summary: | Transfer Ready DtTm tmp entry should never be earlier than first Boarding Loc dttm or later than Dispo DtTm, and if the Transfer Ready DtTm tmp entry has no dttm its checbox has to be checked |
| Related: | Transfer Ready DtTm tmp entry, Dispo DtTm field |
| 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: | needs review |
| Implementation Date: | 2021-01-28 |
| Backlogged: | No |
Log
- 2021-02-03 disabled check;
|
turns out just because someone has a Dispo DtTm doesn't mean we can assume they should have a proper Transfer Ready DtTm tmp entry; will need to reconsider what we can test when (always vs complete) |
|
- 2021-01-28 implemented