S Locations: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m New page: The '''S Locations''' table contains the locations where we collect data, i.e. the values that are allowed for the Location field. == to do before de-stubbing == * explain data struct... |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (29 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{LegacyContent | |||
|explanation=We moved to a different data structure for collection locations | |||
|successor=[[s_dispo table]] | |||
|content= | |||
Sites where we collect can be found in [[Site and Location table]]. | |||
The '''S Locations''' table contains the locations where we collect data, i.e. the values that are allowed for the [[Location field]]. Possible contents of the field are documented in [[Site and Location table]]. | |||
== Data Structure == | |||
[[Category: Data structure]] | The table has three columns: | ||
* Site - 3 letter hospital code, e.g. ''HSC'' | |||
* Ward - 2-4 letter unit code, e.g. ''A4'' or ''MICU'' | |||
* Location - combination of site and ward in format <site>_<ward>, e.g. ''HSC_A4'' | |||
* Program - CC (critical care) or med (medicine) | |||
* active - "logical delete" for the dropdown boxes, will only show up if checked/true | |||
* meanLOS3STDF - value used to warn of excessively long LOS during data collection, provided by the [[statistician]]. | |||
* colour - VBA colour value that this location will have in [[Patient List]] | |||
* service_type - is the unit a [[CTU]]/[[NTU]], [[EMIP]], ICU | |||
* Centre - variable mostly used by Julie for print order in reports | |||
== Related Articles == | |||
* [[Site and Location]] | |||
}} | |||
[[Category:Legacy Data structure]] | |||
Latest revision as of 12:01, 30 July 2025
Legacy Content
This page contains Legacy Content.
- Explanation: We moved to a different data structure for collection locations
- Successor: s_dispo table
Click Expand to show legacy content.
Sites where we collect can be found in Site and Location table.
The S Locations table contains the locations where we collect data, i.e. the values that are allowed for the Location field. Possible contents of the field are documented in Site and Location table.
Data Structure
The table has three columns:
- Site - 3 letter hospital code, e.g. HSC
- Ward - 2-4 letter unit code, e.g. A4 or MICU
- Location - combination of site and ward in format <site>_<ward>, e.g. HSC_A4
- Program - CC (critical care) or med (medicine)
- active - "logical delete" for the dropdown boxes, will only show up if checked/true
- meanLOS3STDF - value used to warn of excessively long LOS during data collection, provided by the statistician.
- colour - VBA colour value that this location will have in Patient List
- service_type - is the unit a CTU/NTU, EMIP, ICU
- Centre - variable mostly used by Julie for print order in reports