S dispo table
The S_dispo table in CCMDB.mdb 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 |
Some additional legacy fields are stored in the s_dispo_legacy_codes table.
location types
For easier sorting. Options are:
- ambulatory care
- ER
- hospice
- ICU
- non-patient
- Nursing Station
- operating
- PCH
- recovery
- unknown/other
- Ward