S dispo table

From CCMDB Wiki
Jump to navigation Jump to search

The S_dispo table contains the possible values for Dispo field (proposed) and PrevInptLocation field.

Data Structure

field type description


dispo_ID text unique ID
location_name text name as seen by collector
hospital text hospital if one where we collect
loc_type text see #location types
inpatient yes/no is an inpatient location, used by PrevInptLocation field
temporary yes/no is a temporary location, used by PrevInptLocation field
old_hospital_code number old code as in S_HospitalCodes
geog text geographical area (in town, out of province, etc)
notes text general notes about record
active yes/no logical delete
question text temporary field for questions during implementation
admit_from yes/no can be used as admit from
discharge_to yes/no can be used as discharge to
s_location yes/no can be used as location
surgical yes/no is a surgical location (used by e.g. Check ORDx)
boarding yes/no related to Category:Overflow but not really clear how this is to be used, needs review Template:Discussion

location types

For easier sorting. Options are:

  • ambulatory care
  • ER
  • hospice
  • ICU
  • non-patient
  • Nursing Station
  • operating
  • PCH
  • recovery
  • unknown/other
  • Ward