Check function preAdmit NE Location

Data Integrity Checks
Summary:	Pre-admit Inpatient Institution field can't be same as Service/Location field
Related:	Service/Location field, Pre-admit Inpatient Institution field
Firmness:	hard check
Timing:	complete
App:	CCMDB.mdb
Coding:	function preAdmit_NE_Location()
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:	not entered
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:

Failure for Service/Locations with the splitting letters at the end

need to make sure concept ICUa is discussed on wiki somewhere. This cross check will not detect previous locations that correspond to current locations with a letter at the end. Could probably change it so that this works by using s_dispo table.real_collection field. Would need to update Function preAdmit_NE_Location.

• SMW

• Cargo

• Categories

• • right now it just compares form fields, will need to change it to be a query based check