S dispo table

The S_dispo table in CCMDB.mdb contains the possible values for the following fields:

• Pre-admit Inpatient Institution field
• Previous Location field
• Dispo field

Data Structure

field	type	description
dispo_ID	text	unique ID
location_name	text	name as seen by collector
hospital	text	hospital if one where we collect
loc_type	text	see #location types
geog	text	geographical area (in town, out of province, etc)
notes	text	general notes about record
question	text	questions while we implement, can be deleted after
inpatient	yes/no	is an inpatient location, used by Pre-admit Inpatient Institution field drop-down and cross checks
temporary	yes/no	is a temporary location, used by Pre-admit Inpatient Institution field cross checks
previous_location	yes/no	can be used as Previous Location field
surgical	yes/no	is a surgical location (used by e.g. Check ORDx)
s_location	yes/no	can be used as location
dispo	yes/no	can be used in Dispo field
active	yes/no	logical delete from dropdowns

Some additional legacy and reporting fields are stored in the s_dispo_legacy_codes table.