S dispo table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
 
(53 intermediate revisions by 2 users not shown)
Line 1: Line 1:
The '''S_dispo''' table contains the possible values for [[Dispo field (proposed)]] and [[PrevInptLocation field]].  
{{DISPLAYTITLE:s_dispo table}}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]]
 
 
{{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 7: Line 18:
!| type
!| type
!| description
!| description
|-
|-
|| '''dispo_ID''' || text || unique ID  
|| '''dispo_ID''' || text || unique ID  
Line 14: Line 23:
|| '''location_name''' || text || name as seen by collector  
|| '''location_name''' || text || name as seen by collector  
|-
|-
|| '''hospital''' || text || hospital if one where we collect
|| '''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]]
|-
|-
|| '''loc_type''' || text || see [[#location types]] 
|| '''real_name''' || text || unit name as reported, e.g. STB_ICMU vs STB_MICU
|-
|-
|| '''inpatient''' || yes/no || is an inpatient location, used by [[PrevInptLocation field]]
|| '''site''' || text || our short hospital name, eg HSC
|-
|-
|| '''temporary''' || yes/no || is a temporary location, used by [[PrevInptLocation field]]
|| '''ward''' || text || ward name only, e.g. A1 for HSC_A1
|-
|-
|| '''old_hospital_code''' || number || old code as in [[S_HospitalCodes]]
|| '''[[s_dispo.hospital]]''' || text || hospital if one where we collect
|-
|-
|| '''geog''' || text || geographical area (in town, out of province, etc)  
|| '''[[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  
|| '''notes''' || text || general notes about record  
|-
|-
|| '''active''' || yes/no || logical delete
|| '''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]]
|-
|-
|| '''question''' || text || temporary field for questions during implementation
|| '''surgical''' || yes/no || is a location where actual surgeries happpen (used by e.g. [[Check ORDx]]) (ie not just a surgical ward)
|-
|-
|| '''admit_from''' || yes/no || can be used as [[admit from]]
|| '''meanLOS3STD''' || integer || used by LOS check
|-
|-
|| '''discharge_to''' || yes/no || can be used as [[discharge to]]  
|| '''s_location''' || yes/no || can be used as [[Site and Location table|location]]  
|-
|-
|| '''s_location''' || yes/no || can be used as [[location]]  
|| '''dispo''' || yes/no || can be used in [[Dispo field]]
|-
|-
|| '''surgical''' || yes/no || is a surgical location (used by e.g. [[Check ORDx]])
|| '''active''' || yes/no || logical delete from dropdowns
|-
|-
|| '''boarding''' || yes/no || related to [[:Category:Overflow]] but not really clear how this is to be used, needs review {{discussion}}
|| '''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 [[Change of remaining location names from "our" names to EPR/Cognos names | old and new names of locations]] for reporting
|}
|}


== location types ==
== Inactivating locations ==
For easier sorting. Options are:
Before inactivating a location, make sure that it is not used in any incomplete profiles.
*ambulatory care
 
*ER
Before inactivating any entry, check [[Query z_s_dispo_inactivatable]] to make sure it is not currently used in any incomplete records ([[RecordStatus]] incomplete).
*hospice
 
*ICU
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.
*non-patient
 
*Nursing Station
{{Todo
*operating
| who = Tina 
*PCH
| question = _wiki housekeeping
*recovery
* break this out because it needs to apply to locations in general, wiki side, s_dispo, boarding loc etc.  
*unknown/other
| todo_added = 2022-02-10
*Ward
| 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: 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"