Function Validate Pre admit Inpatient Institution

Data Integrity Checks
Summary:	validates Pre-admit Inpatient Institution field: Can not be blank preAdmit_NE_Location() - Pre-admit Inpatient Institution field can't be same as Service/Location field
Related:	[[Pre-admit Inpatient Institution field]]
Firmness:	hard check
Timing:	always
App:	CCMDB.mdb
Coding:	Function Validate_Pre_admit_Inpatient_Institution
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:	2016-05-12
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:

approximate implementation date

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

Template:Discussion 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. Need to review

Related articles

Related articles:

Pre-admit Inpatient Institution field (← links) Data Integrity Checks (← links)