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
real_name	text	actual unit name, e.g. HSC_MICU vs HSC_MICa
site	text	our short hospital name, eg HSC
ward	text	ward name only, e.g. A1 for HSC_A1
hospital	text	hospital if one where we collect
loc_type	text	see #location types
geog	text	geographical area (in town, out of province, etc)
RHA	text	regional health authority the institution is part of
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)
meanLOS3STD	integer	used by LOS check
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
acuity_level	yes/no	logical delete from dropdowns
program	text	CC or Med for our locations only
colour	text	colour code for patient list view
service_type	text	CTU / NTU / EMIP / ICU
center	long integer	used by Julie for Template:Discussion what?

Some additional legacy and reporting fields are stored in the s_dispo_legacy_codes table. Template:Discussion looks like we will keep all in s_dispo now, so need to clean that up.