S dispo table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
 
(25 intermediate revisions by the same user not shown)
Line 1: Line 1:
The '''S_dispo''' table in [[CCMDB.accdb]] 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]]
* [[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  
|-
|| '''[[s_dispo.loc_type]]''' || text || [[S dispo.loc type]]
|-
|-
|| '''loc_type''' || text || [[S dispo.loc type]]
|| '''[[s_dispo.geog]]''' || text(20) || geographical area (in town, out of province, etc)
|-
|-
|| '''geog''' || text || geographical area (in town, out of province, etc)
|| '''[[s_dispo.geoRegion]]''' || text(17) || geographical region 
|-
|-
|| '''[[MB_RHA]]''' || text || regional health authority the institution is part of
|| '''[[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 36: 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 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 42: 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 check
|| '''[[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 52: 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 ==
== Inactivating locations ==
Before inactivating a location, make sure that it is not used in any incomplete profiles. Run the following query in CFE. It will ask for two parameters, the name of the location and the latest time at which the location would have been available.  
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}}


<code> SELECT L_Log.D_ID, L_Log.RecordStatus, L_Log.Dispo_DtTm, preAdm.location_name AS preAdm, previous.location_name AS Prev, SL.location_name AS SL, dispo.location_name AS dispo
==Log==
FROM (((L_Log INNER JOIN s_dispo AS preAdm ON L_Log.Pre_admit_Inpatient_Institution = preAdm.dispo_ID) INNER JOIN s_dispo AS previous ON L_Log.Previous_Location = previous.dispo_ID) INNER JOIN s_dispo AS SL ON L_Log.Service_Location = SL.dispo_ID) INNER JOIN s_dispo AS dispo ON L_Log.Dispo = dispo.dispo_ID
* 2022-04-21 - updated [[s_dispo table]].meanLOS3STD with data from Julie
WHERE (((L_Log.RecordStatus)="incomplete") AND ((preAdm.location_name)=[the_location_name])) OR (((L_Log.RecordStatus)="incomplete") AND ((previous.location_name)=[the_location_name])) OR (((L_Log.RecordStatus)="incomplete") AND ((SL.location_name)=[the_location_name])) OR (((L_Log.RecordStatus)="incomplete") AND ((dispo.location_name)=[the_location_name])) OR (((L_Log.RecordStatus)="incomplete") AND ((L_Log.Dispo_DtTm)<[end_date]) AND ((preAdm.location_name) Is Null)) OR (((L_Log.RecordStatus)="incomplete") AND ((L_Log.Dispo_DtTm)<[end_date]) AND ((previous.location_name) Is Null)) OR (((L_Log.RecordStatus)="incomplete") AND ((L_Log.Dispo_DtTm)<[end_date]) AND ((SL.location_name) Is Null)) OR (((L_Log.RecordStatus)="incomplete") AND ((L_Log.Dispo_DtTm)<[end_date]) AND ((dispo.location_name) Is Null));
* 2022-03-24 - removed field "service_type" since it's no longer used; as discussed at task around 2022-02-03
</code>


== Related articles ==
== Related articles ==
{{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 21:12, 26 September 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)
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

  • 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=167677"