S dispo table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 60: Line 60:
|}
|}


== Related articles ==
{{Related Articles}}


[[Category: Data structure]]
[[Category: Data structure]]
[[Category: 2016 Time and Place changes]]
[[Category: 2016 Time and Place changes]]
[[Category: S dispo table| *]]
[[Category: S dispo table| *]]

Revision as of 10:58, 2019 February 25

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

Data Structure

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)

Related articles

Related articles: