Query check pt from ER

Data Integrity Checks
Summary:	part of validating Accept DtTm
Related:	Accept DtTm, Previous Location
Firmness:	soft check
Timing:	always
App:	CCMDB.accdb
Coding:	query check_pt_from_ER, function Validate_Accept_DtTm(); function from_ER()
Uses L Problem table:	not relevant for this app
Status:	needs review
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 by function Validate_Accept_DtTm() which validates the Accept DtTm.

Related articles