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 |
see #location types
|
| 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
|
| 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
|
| 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 for our locations only
|
| colour |
text |
colour code for patient list view
|
| service_type |
text |
CTU / NTU / EMIP / ICU
|
| center |
long integer |
chronological order sequence of the site and ward used in generating report (e.g. teaching hospitals first followed by community hospitals)
|
location types
| loc_type
|
description
|
| ambulatory care |
ambulatory care clinics at the hospitals where we collect data
|
| Boarding |
not used anywhere, just legacy fields
|
| ER |
...
|
| hospice |
...
|
| ICU |
...
|
| legacy |
for legacy records where the field is inconsistent
|
| non-patient |
e.g. home, a place where person would no lone be a patient
|
| Nursing Station |
nursing stations usually on first nations
|
| OR |
operating room
|
| PCH |
personal care home
|
| RR |
recovery room
|
| unknown/other |
...
|
| Ward |
...
|