Query Check_from_ED_and_prev_location_same_site
| Data Integrity Checks | |
| Summary: | A patient would not usually be sent from their own site to their own ED. It can happen, so this is a soft check. |
| Related: | Previous_Location field, Service/Location field |
| Firmness: | soft check |
| Timing: | always |
| App: | CCMDB.accdb |
| Coding: | Query Check_from_ED_and_prev_location_same_site |
| Uses L Problem table: | not relevant for this app |
| Status: | ready to implement |
| Implementation Date: | not entered |
| Backlogged: | No |
This is a soft check to accommodate the scenarios described in Patients who appear to transfer from in-patient situation to Emergency Room.
Log
- 2025-08-19 added Patients who appear to transfer from in-patient situation to Emergency Room consideration (thanks to Julie for finding it)
- 2025-07-23 Task post meeting - discussed this query, decided that I would write it up at least so we have a clean discussion trail