S dispo table: Difference between revisions

Revision as of 10:39, 22 March 2016

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

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 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
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.

For easier sorting. Options are:

@@ Line 21: / Line 21: @@
 || '''loc_type''' || text || see [[#location types]]
 |-
-|| '''inpatient''' || yes/no || is an inpatient location, used by [[PrevInptLocation field]]
+|| '''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 [[PrevInptLocation field]]
+|| '''temporary''' || yes/no || is a temporary location, used by [[Pre-admit Inpatient Institution field]] cross checks
 |-
 || '''old_hospital_code''' || number || old code as in [[S_HospitalCodes]]