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:	needs review
Implementation Date:	not entered
Backlogged:	No

• Cargo

• SMW

• Categories:  

• form:

Known scenarios... I think we already have that written up somewhere and should link to it and not re-write it here. Somehting about GRA ICU and Direct admits.

We discussed this in our after-Task meeting 2023-07-23 and I just stumbled across it. Does this sound right? No hurry. In fact I'd prefer if you not hurried ;-). Ttenbergen 21:39, 13 August 2025 (CDT) SMW Cargo Categories

• SMW

• Cargo

• Categories

Log

• 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