S dispo table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
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) |