Query check dispo lower acuity than location

Data Integrity Checks
Summary:	check for patients going to lower level of care (based on S dispo table.acuity_level) but without Transfer_Ready_DtTm; Check will launch an error but allow no date, ie it's just a reminder, see Transfer_Ready_DtTm#Hierarchy of levels of care.
Related:	Transfer Ready DtTm field, Dispo field
Firmness:	soft check
Timing:	complete
App:	CCMDB.accdb
Coding:	query check_dispo_lower_acuity_than_location and function Transfer_Ready_DtTm_vs_Location_vs_Dispo
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2016-06-06
Backlogged:	true

Related articles