Query check pt from ER: Difference between revisions

mNo edit summary
m Text replacement - "cross check " to "cross check "
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Data Integrity Check
{{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_firmness = soft check
| DIC_timing = always
| DIC_timing = always
| DIC_app = CCMDB.accdb
| 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 = implemented
| DIC_status = implemented
| DIC_implementation_date = date change was rolled out / first applied
| 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 ==
== Related articles ==