S dispo table: Difference between revisions

Revision as of 17:34, 2017 December 6

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
real_collection	text	unit name as collected by us, e.g. HSC_MICU vs HSC_MICa
real_name	text	unit name as reported, e.g. STB_ICMU vs STB_MICU
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	S dispo.loc type
geog	text	geographical area (in town, out of province, etc)
MB_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
previous_location	yes/no	can be used as Previous Location field
surgical	yes/no	is a location where actual surgeries happpen (used by e.g. Check ORDx) (ie not just a surgical ward)
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, used for rows where real_name is one of our locations only
colour	text	colour code for patient list view
service_type	text	S dispo.service type
center	long integer	chronological order sequence of the site and ward used in generating report (e.g. teaching hospitals first followed by community hospitals)

@@ Line 36: / Line 36: @@
 |-
 || '''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]]
@@ Line 61: / Line 59: @@
 || '''center''' || long integer|| chronological order sequence of the site and ward used in generating report (e.g. teaching hospitals first followed by community hospitals)
 |}
-=== "temporary" field vs "inpatient" field ===
-{{discussion}} can't remember how this is used, and a quick look VBA and queries in ccmdb.mdb didn't tell me either. Does anyone remember what exactly this is and how it is different from the inpatient field? Ttenbergen 17:29, 2017 November 6 (CST)
-I just had this hunch that that was a concept we ''used'' to use, but gave up on a while ago. Does anyone remember about this?  Ttenbergen 18:47, 2017 November 8 (CST)