S dispo table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
m Text replacement - "|*" to "| *"
 
(29 intermediate revisions by the same user not shown)
Line 1: Line 1:
The '''S_dispo''' table in [[CCMDB.mdb]] contains the possible values for the following fields:  
{{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]]
{{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 15: Line 23:
|| '''location_name''' || text || name as seen by collector  
|| '''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_collection''' || text || unit name as collected by us, e.g. HSC_MICU vs HSC_MICa; '''this is used to [[Linking|link ]] the [[Previous Location]]/[[Dispo]] to [[Service/Location]]
|-
|-
|| '''real_name''' || text || unit name as reported, e.g. STB_ICMU vs STB_MICU
|| '''real_name''' || text || unit name as reported, e.g. STB_ICMU vs STB_MICU
Line 23: 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 || geographical area (in town, out of province, etc)  
|| '''[[s_dispo.geog]]''' || text(20) || geographical area (in town, out of province, etc)  
|-
|-
|| '''[[MB_RHA]]''' || text || regional health authority the institution is part of
|| '''[[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  
|| '''notes''' || text || general notes about record  
Line 35: 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 checks
|| '''[[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]]  
|| '''previous_location''' || yes/no || can be used as [[Previous Location field]]  
Line 43: Line 53:
|| '''meanLOS3STD''' || integer || used by LOS check  
|| '''meanLOS3STD''' || integer || used by LOS check  
|-
|-
|| '''s_location''' || yes/no || can be used as [[location]]  
|| '''s_location''' || yes/no || can be used as [[Site and Location table|location]]  
|-
|-
|| '''dispo''' || yes/no || can be used in [[Dispo field]]
|| '''dispo''' || yes/no || can be used in [[Dispo field]]
Line 51: 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  
|-
|-
|| '''service_type''' || text || [[S dispo.service type]]
|| '''[[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
|-
|| '''center''' || long integer|| chronological order sequence of the site and ward used in generating report (e.g. teaching hospitals first followed by community hospitals)
|}
|}


== 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.
{{Todo
| who = Tina 
| question = _wiki housekeeping
* break this out because it needs to apply to locations in general, wiki side, s_dispo, boarding loc etc.
| todo_added = 2022-02-10
| todo_action = 2022-02-10 
}}
{{Foreign key
| foreign_key_table=L_Log
| foreign_key_field=Previous Location
| primary_key_table=s_dispo
| primary_key_field=dispo_ID}}
{{Foreign key
| foreign_key_table=L_Log
| foreign_key_field=Pre-admit Inpatient Institution
| primary_key_table=s_dispo
| primary_key_field=dispo_ID}}
<!-- {Foreign key
| foreign_key_table=L_Log
| foreign_key_field=Service/Location
| primary_key_table=s_dispo
| primary_key_field=dispo_ID} -->
{{Foreign key
| foreign_key_table=L_Log
| foreign_key_field=Dispo
| primary_key_table=s_dispo
| primary_key_field=dispo_ID}}
==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
== 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 00:26, 12 March 2025

The s_dispo table in CCMDB.accdb contains the possible values for the following fields:


  • "Hospice - other, WPG" is currently not grouped as Hospital = "Other Institution in WPG" as the other hospices - should it be? Ttenbergen 17:03, 11 March 2025 (CDT)
  • SMW


  • Cargo


  • Categories


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

  • break this out because it needs to apply to locations in general, wiki side, s_dispo, boarding loc etc.
  • added: 2022-02-10
  • action: 2022-02-10
  • Cargo


  • Categories


  • Cargo


  • Categories
  • Forms

none; if we wanted to include this in a form it would need to be in the data field from

  • SMW


  • Cargo


  • Categories
  • Forms

none; if we wanted to include this in a form it would need to be in the data field from

  • SMW


  • Cargo


  • Categories
  • Forms

none; if we wanted to include this in a form it would need to be in the data field from

  • SMW

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

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=S_dispo_table&oldid=162935"