Query check pt from ER: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "This query identifies patients from ER for the Overstay project. The name would lead you to think it's a cross check query, but it isn't. == Related articles == {{Relate..."
 
mNo edit summary
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
This query identifies patients from ER for the [[Overstay]] project. The name would lead you to think it's a cross check query, but it isn't.  
{{Data Integrity Check
| DIC_summary = part of validating [[Boarding Loc]]
| DIC_related_concepts = Previous Location
| DIC_firmness = soft check
| DIC_timing = always
| DIC_app = CCMDB.accdb
| DIC_coding = function from_ER(); query ''check_pt_from_ER''
| DIC_status = implemented
| DIC_implementation_date = date change was rolled out / first applied
}}
 
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 ==
{{Related Articles}}
{{Related Articles}}


[[Category: OverstayProject]]
[[Category:CCMDB.accdb]]

Latest revision as of 16:21, 21 April 2022

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: