S Locations: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
(18 intermediate revisions by 2 users 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]].
{{LegacyContent
|explanation=We moved to a different data structure for collection locations
|successor=[[s_dispo table]]
|content=


*Also see [[Site and Location]]
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]].


== to do before de-stubbing ==
== Data Structure ==
* explain 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


==Bug==
== Related Articles ==
* [[Site and Location]]


*'''not all PDA's are pulling updated data from s_location table for''' [[HanDBase]] on the PDA off the [[Regional Server]]. This may be the case for other [[s_files]]also.  This is a bug. If there any changes made to LOCATION collector will have to do them locally.  This might be a problem if S-Location for CCMDB is also not updated.--[[User:TOstryzniuk|TOstryzniuk]] 17:31, 17 December 2009 (CST)
}}
*Dec 17.09
[[Category: Legacy Data structure]]
*To best way to fix this problem in HanDBase on your PDA and ensure that it's data matches what is in the s_location file in Access, go to: [[Manual pull-down of s tables to the PDA]].
 
{{Discussion}}
*I just realized that some of the PDAs don’t pull their locations from the s_locations table, but are instead being entered manually. (Thanks for helping me figure that out Sheila D.). We eventually need to fix that, but in the short run, the trick is that you need to use the full location, with an underscore separating the hospital from the ward, all caps, when you enter the location, e.g.
*HSC_A4
*GRA_N5
*If you get that right, you should be able to send your audit patients.
**TINA
 
'''See [[How to set the Default location on the PDA]]'''
 
===how to edit S_Location table on PDA===
**go to: [[Manual pull-down of s tables to PDA]]
 
{{stub}}
[[Category: 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"