Query Check_from_ED_and_prev_location_same_site

Data Integrity Checks
Summary:
Related:
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:
Implementation Date:
Backlogged:	No

• Cargo

• SMW

• Categories:  

• form:

We discussed this in our after-Task meeting 2023-07-23 and I just stumbled across it. I do not remember what this was about, nor what a reasonable delay would be. Could one of you fill in the details for the query if we still want it? No hurry. In fact I'd prefer if you not hurried ;-). Ttenbergen 21:39, 13 August 2025 (CDT) SMW Cargo Categories

• SMW

• Cargo

• Categories

also see Query check_tmp_ER_Boarding_Loc_should_exist_if_from_ER

The converse is not true, exceptions:

• a patient could board in ER after admission, e.g. GRA ICU uses their ER
• Direct admit

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