S dispo table: Difference between revisions

Revision as of 16:05, 2015 August 5

The S_dispo table contains the possible values for Dispo field (proposed) and PrevInptLocation field.

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

For easier sorting. Options are:

@@ Line 40: / Line 40: @@
 || '''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 {{discussion}}
+|| '''boarding''' || yes/no || related to [[:Category:Overflow]] but not really clear how this is to be used, needs review {{discussion}}
 |}