Changing a Laptop identifier

The location of a laptop (set in Settings (CCMBD.mdb)) has a bearing on various cross checks, output locations etc. Therefore, to change it all the related things need to be accounted for.

Check List

• confirm with the statistician whether there is impact
• CCMDB.mdb which feeds CFE tables
  • table S Locations / s_dispo table
  • table s_locations_allowed_collection
  • for medicine, table s_tmp_er_wait_r_locations
  • possibly table s_varOptions if new Var 1 - Admit-from Ward/Var 2 - Discharge-to Ward are required
  • possibly table S Tmp
  • find/search through all VBA modules for the new name, the current name, possible equivalent unit name
  • make sure that the location name is not relevant to any of the queries; I can't think of a nice way to automate this.

• batch files
  • set News and backup/Batstart.bat to new location
  • test n&b to make sure new location and directory name don't break anything
  • update locs.bat
  • create/update Data to local.bat

• directory structures
  • add a folder regional_server\programs\<new name> (rather than re-name, to facilitate backing out if we can’t finish)
  • add a folder regional server\data\<new name>

• local laptop settings
  • set A_Info/Settings (CCMBD.mdb) to new location
  • test sending to make sure new location and directory name don't break anything

• CFE
  • anything?

• workstations.mdb - add new location, should probably make this directory based just like Transfer Tracker.mdb

Transitioning

If a location is no longer available on a laptop records with that location can't be set to "complete". So, if we transition from one location to a new one, we need to get collectors to change the locations for all existing records to the new one, and change the number to using the new number series. Another option might be to keep old location available, at risk of manual mistakes and continuing to use the old location, and of location-numberPool mix-ups. Either way, needs to be planned.