Query check previous location vs service inconsistent

Data Integrity Checks
Summary:	patients with Previous Location field in medicine must have Previous Service field medicine; ICU (except STB ACCU, STB CICU/ICCS) must have previous service "critical care".
Related:	Previous Location field, Previous Service field
Firmness:	hard check
Timing:
App:	CCMDB.accdb
Coding:	function previous_location_vs_service_inconsistent, query check previous location vs service inconsistent
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	date change was rolled out / first applied
Backlogged:	true

Related articles