Query Check_from_ED_and_prev_location_same_site

From CCMDB Wiki
Revision as of 09:04, 14 August 2025 by JMojica (talk | contribs)
Jump to navigation Jump to search
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.

https://ccmdb.kuality.ca/index.php?title=Patients_who_appear_to_transfer_from_in-patient_situation_to_Emergency_Room

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)

  • yes we have discussed and you made a page shown above. --JMojica 09:04, 14 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
Related articles: