S dispo table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 25: | Line 25: | ||
|| '''hospital''' || text || hospital if one where we collect | || '''hospital''' || text || hospital if one where we collect | ||
|- | |- | ||
|| '''loc_type''' || text || | || '''loc_type''' || text || [[S dispo.loc type]] | ||
|- | |- | ||
|| '''geog''' || text || geographical area (in town, out of province, etc) | || '''geog''' || text || geographical area (in town, out of province, etc) | ||
| Line 57: | Line 57: | ||
|| '''colour''' || text || colour code for patient list view | || '''colour''' || text || colour code for patient list view | ||
|- | |- | ||
|| '''service_type''' || text || [[ | || '''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) | || '''center''' || long integer|| chronological order sequence of the site and ward used in generating report (e.g. teaching hospitals first followed by community hospitals) | ||
| Line 65: | Line 65: | ||
{{discussion}} can't remember how this is used, and a quick look VBA and queries in ccmdb.mdb didn't tell me either. Does anyone remember what exactly this is and how it is different from the inpatient field? Ttenbergen 17:29, 2017 November 6 (CST) | {{discussion}} can't remember how this is used, and a quick look VBA and queries in ccmdb.mdb didn't tell me either. Does anyone remember what exactly this is and how it is different from the inpatient field? Ttenbergen 17:29, 2017 November 6 (CST) | ||
[[Category: Data structure]] | [[Category: Data structure]] | ||
[[Category: 2016 Time and Place changes]] | [[Category: 2016 Time and Place changes]] | ||
Revision as of 18:45, 2017 November 8
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 |
| 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 | 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) |
"temporary" field vs "inpatient" field
Template:Discussion can't remember how this is used, and a quick look VBA and queries in ccmdb.mdb didn't tell me either. Does anyone remember what exactly this is and how it is different from the inpatient field? Ttenbergen 17:29, 2017 November 6 (CST)