S dispo table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) |
||
| (12 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The ''' | {{DISPLAYTITLE:s_dispo table}}The '''s_dispo''' table in [[CCMDB.accdb]] contains the possible values for the following fields: | ||
* [[Pre-admit Inpatient Institution field]] | * [[Pre-admit Inpatient Institution field]] | ||
* [[Previous Location field]] | * [[Previous Location field]] | ||
* [[Dispo field]] | * [[Dispo field]] | ||
* [[Service/Location field]] - i.e. it contains the [[Site and Location table]] | * [[Service/Location field]] - i.e. it contains the [[Site and Location table]] | ||
{{DJ | | |||
* "Hospice - other, WPG" is currently not grouped as Hospital {{=}} "Other Institution in WPG" as the other hospices - should it be? [[User:Ttenbergen|Ttenbergen]] 17:03, 11 March 2025 (CDT) | |||
}} | |||
== Data Structure == | == Data Structure == | ||
| Line 24: | Line 31: | ||
|| '''ward''' || text || ward name only, e.g. A1 for HSC_A1 | || '''ward''' || text || ward name only, e.g. A1 for HSC_A1 | ||
|- | |- | ||
|| '''hospital''' || text || hospital if one where we collect | || '''[[s_dispo.hospital]]''' || text || hospital if one where we collect | ||
|- | |- | ||
|| '''loc_type''' || text || [[S dispo.loc type]] | || '''[[s_dispo.loc_type]]''' || text || [[S dispo.loc type]] | ||
|- | |- | ||
|| '''geog''' || text(20) || geographical area (in town, out of province, etc) | || '''[[s_dispo.geog]]''' || text(20) || geographical area (in town, out of province, etc) | ||
|- | |- | ||
|| '''geoRegion''' || text(17) || geographical region | || '''[[s_dispo.geoRegion]]''' || text(17) || geographical region | ||
|- | |- | ||
|| '''[[MB_RHA]]''' || text(7) || regional health authority the institution is administered by | || '''[[MB_RHA]]''' || text(7) || regional health authority the institution is administered by | ||
| Line 38: | Line 45: | ||
|| '''question''' || text || questions while we implement, can be deleted after | || '''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 | || '''[[s_dispo.inpatient]]''' || yes/no || is an inpatient location, used by [[Pre-admit Inpatient Institution field]] drop-down and [[cross check]]s | ||
|- | |- | ||
|| '''previous_location''' || yes/no || can be used as [[Previous Location field]] | || '''previous_location''' || yes/no || can be used as [[Previous Location field]] | ||
| Line 44: | Line 51: | ||
|| '''surgical''' || yes/no || is a location where actual surgeries happpen (used by e.g. [[Check ORDx]]) (ie not just a surgical ward) | || '''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 | || '''[[s_dispo.meanLOS3STD]]''' || integer || used by [[Function long LOS()]] | ||
|- | |- | ||
|| '''s_location''' || yes/no || can be used as [[Site and Location table|location]] | || '''s_location''' || yes/no || can be used as [[Site and Location table|location]] | ||
| Line 54: | Line 61: | ||
|| '''acuity_level''' || yes/no || logical delete from dropdowns | || '''acuity_level''' || yes/no || logical delete from dropdowns | ||
|- | |- | ||
|| '''program''' || text || CC or Med, used for rows where '''real_name''' is one of our locations only | || '''[[s_dispo.program]]''' || text || CC or Med, used for rows where '''real_name''' is one of our locations only | ||
|- | |- | ||
|| '''colour''' || text || colour code for patient list view | || '''colour''' || text || colour code for patient list view | ||
|- | |- | ||
|| '''center''' || long integer|| chronological order sequence of the site and ward used in generating report (e.g. teaching hospitals first followed by community hospitals) | || '''[[S_dispo.center]]''' || long integer|| chronological order sequence of the site and ward used in generating report (e.g. teaching hospitals first followed by community hospitals); also used to combine [[Change of remaining location names from "our" names to EPR/Cognos names | old and new names of locations]] for reporting | ||
|} | |} | ||
| Line 104: | Line 111: | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: Data structure]] | [[Category:Data structure]] | ||
[[Category: 2016 Time and Place changes]] | [[Category:2016 Time and Place changes]] | ||
[[Category: S dispo table| *]] | [[Category:S dispo table| *]] | ||
Latest revision as of 20:12, 26 September 2025
The s_dispo table in CCMDB.accdb contains the possible values for the following fields:
- Pre-admit Inpatient Institution field
- Previous Location field
- Dispo field
- Service/Location field - i.e. it contains the Site and Location table
|
|
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; this is used to link the Previous Location/Dispo to Service/Location |
| 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 |
| s_dispo.hospital | text | hospital if one where we collect |
| s_dispo.loc_type | text | S dispo.loc type |
| s_dispo.geog | text(20) | geographical area (in town, out of province, etc) |
| s_dispo.geoRegion | text(17) | geographical region |
| MB_RHA | text(7) | regional health authority the institution is administered by |
| notes | text | general notes about record |
| question | text | questions while we implement, can be deleted after |
| s_dispo.inpatient | yes/no | is an inpatient location, used by Pre-admit Inpatient Institution field drop-down and 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) |
| s_dispo.meanLOS3STD | integer | used by Function long LOS() |
| 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 |
| s_dispo.program | text | CC or Med, used for rows where real_name is one of our locations only |
| colour | text | colour code for patient list view |
| S_dispo.center | long integer | chronological order sequence of the site and ward used in generating report (e.g. teaching hospitals first followed by community hospitals); also used to combine old and new names of locations for reporting |
Inactivating locations
Before inactivating a location, make sure that it is not used in any incomplete profiles.
Before inactivating any entry, check Query z_s_dispo_inactivatable to make sure it is not currently used in any incomplete records (RecordStatus incomplete).
We can occasionally check query Query z_s_dispo_lastUsed for entries that have not been used in a long time. If it is never used it may be an entry we no longer need, but it may also just be an entry that is rarely used.
|
_wiki housekeeping
|
|
Log
- 2022-04-21 - updated s_dispo table.meanLOS3STD with data from Julie
- 2022-03-24 - removed field "service_type" since it's no longer used; as discussed at task around 2022-02-03