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.mdb
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

• Cargo

• SMW

"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. 

• Categories:  

• form: