S dispo table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 57: Line 57:
|| '''service_type''' || text || [[CTU]] / [[NTU]] / [[EMIP]] / ICU
|| '''service_type''' || text || [[CTU]] / [[NTU]] / [[EMIP]] / ICU
|-
|-
|| '''center''' || long integer|| used by Julie for {{discussion}} what?
|| '''center''' || long integer|| chronological order sequence of the site and ward used in generating report (e.g. teaching hospitals first followed by community hospitals)
|}
|}



Revision as of 15:36, 2016 August 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_name text actual unit name, e.g. HSC_MICU vs HSC_MICa
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 surgical location (used by e.g. Check ORDx)
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)

Some additional legacy and reporting fields are stored in the s_dispo_legacy_codes table. Template:Discussion looks like we will keep all in s_dispo now, so need to clean that up.

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 ...