Link suspect transfer ready before arrive date
Legacy Content
This page contains Legacy Content.- Explanation: Query retired because we no longer use Transfer Ready DtTm field, and because this can and will be done in CCMDB.accdb by query check_transfer_DtTm_during_admission for the new Transfer Ready DtTm tmp entry.
- Successor: query check_transfer_DtTm_during_admission
Click Expand to show legacy content.
| Data Integrity Checks | |
| Summary: | Checks for records that have Transfer Ready DtTm field is before Arrive_DtTm field. |
| Related: | Transfer Ready DtTm field |
| Firmness: | hard check |
| Timing: | always |
| App: | Centralized data front end.accdb |
| Coding: | query Link_suspect_transfer_ready_before_arrive_date |
| Uses L Problem table: | False |
| Status: | retired |
| Implementation Date: | 2020/02/21 |
| Backlogged: | No |
There were some remaining errors in this query but they were all old, and were added to L Problem table
Related articles
| Related articles: |