Query check pt from ER: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
m Text replacement - "cross check " to "cross check "
 
Line 10: Line 10:
}}
}}


This query in [[CCMDB.accdb]] identifies patients from ER. The name would lead you to think it's a cross check query, but it isn't.
This query in [[CCMDB.accdb]] identifies patients from ER. The name would lead you to think it's a [[cross check]] query, but it isn't.


Query is used by by function from_ER() which is in turn used [[query check_tmp_ER_Boarding_Loc_should_exist_if_from_ER]]
Query is used by by function from_ER() which is in turn used [[query check_tmp_ER_Boarding_Loc_should_exist_if_from_ER]]

Latest revision as of 13:27, 20 June 2025

Data Integrity Checks
Summary: part of validating Boarding Loc
Related: Previous Location
Firmness: soft check
Timing: always
App: CCMDB.accdb
Coding: function from_ER(); query check_pt_from_ER
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: date change was rolled out / first applied
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

This query in CCMDB.accdb identifies patients from ER. The name would lead you to think it's a cross check query, but it isn't.

Query is used by by function from_ER() which is in turn used query check_tmp_ER_Boarding_Loc_should_exist_if_from_ER

Related articles

Related articles: