Query check pt from ER: Difference between revisions

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

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

@@ Line 1: / Line 1: @@
 {{Data Integrity Check
-| DIC_summary = part of validating [[Accept DtTm]]
+| DIC_summary = part of validating [[Boarding Loc]]
-| DIC_related_concepts = Accept DtTm; Previous Location
+| DIC_related_concepts = Previous Location
 | DIC_firmness = soft check
 | DIC_timing = always
 | DIC_app = CCMDB.accdb
-| DIC_coding = query ''check_pt_from_ER'', function Validate_Accept_DtTm(); function from_ER()
+| DIC_coding = function from_ER(); query ''check_pt_from_ER''
-| DIC_status = needs review
+| 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.
+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 by function Validate_Accept_DtTm() which validates the [[Accept DtTm]].
+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 ==