S Locations: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
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]].
{{LegacyContent
|explanation=We moved to a different data structure for collection locations
|successor=[[s_dispo table]]
|content=


== Editing the S_Locations Table ==
Sites where we collect can be found in [[Site and Location table]].
See [[Rolling out changes]]


To make a new entry in s_locations visible in CCMDB.mdb a record also needs to be added to table ''s_locations_allowed_collection'' which drives which locations are visible on a given laptop.
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 ==
== Data Structure ==
Line 15: Line 17:
* meanLOS3STDF - value used to warn of excessively long LOS during data collection, provided by the [[statistician]].
* 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]]
* 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 ==
== Related Articles ==
* [[Site and Location]]
* [[Site and Location]]


 
}}
[[Category: Data structure]]
[[Category: Legacy Data structure]]
[[Category: Site and Location]]

Latest revision as of 17:04, 2018 July 29

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

Related Articles

Retrieved from "https://ccmdb.kuality.ca/index.php?title=S_Locations&oldid=118194"