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

PrevInptLocation 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
inpatient	yes/no	is an inpatient location, used by PrevInptLocation field
temporary	yes/no	is a temporary location, used by PrevInptLocation field
old_hospital_code	number	old code as in S_HospitalCodes
geog	text	geographical area (in town, out of province, etc)
notes	text	general notes about record
active	yes/no	logical delete
question	text	temporary field for questions during implementation
admit_from	yes/no	can be used as admit from
discharge_to	yes/no	can be used as discharge to
s_location	yes/no	can be used as location
surgical	yes/no	is a surgical location (used by e.g. Check ORDx)
boarding	yes/no	related to Category:Overflow but not really clear how this is to be used, needs review Template:Discussion

Some additional legacy fields are stored in the s_dispo_legacy_codes table.

location types

For easier sorting. Options are:

• ambulatory care
• ER
• hospice
• ICU
• non-patient
• Nursing Station
• operating
• PCH
• recovery
• unknown/other
• Ward