S Locations

From CCMDB Wiki
Revision as of 18:20, 2010 January 26 by TOstryzniuk (talk | contribs) (→‎Bug)
Jump to navigation Jump to search

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 structure

Bug

  • 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_filesalso. 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.--TOstryzniuk 17:31, 17 December 2009 (CST)
  • Dec 17.09
  • 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.

Template: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

Template:Stub