S dispo table: Difference between revisions

 
(6 intermediate revisions by the same user not shown)
Line 6: Line 6:




{{DJ |
{{DJ |  
* in [[s_dispo table]] [[HSC Lennox Bell]] is listed as site{{=}}HSC; it kind of is, but wherever that column is used to group, would this be a location we would expect in that group? Or should it be blank? [[User:Ttenbergen|Ttenbergen]] 15:24, 11 March 2025 (CDT)
* "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)
}}
}}


Line 31: Line 31:
|| '''ward''' || text || ward name only, e.g. A1 for HSC_A1
|| '''ward''' || text || ward name only, e.g. A1 for HSC_A1
|-
|-
|| '''[[S_dispo.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]]
|| '''[[s_dispo.loc_type]]''' || text || [[S dispo.loc type]]
|-
|-
|| '''[[S_dispo.geog]]''' || text(20) || geographical area (in town, out of province, etc)  
|| '''[[s_dispo.geog]]''' || text(20) || geographical area (in town, out of province, etc)  
|-
|-
|| '''[[S_dispo.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 45: 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 51: 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 61: 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  
Line 111: 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| *]]