Changing a Laptop identifier: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →Check List: m |
Ttenbergen (talk | contribs) m →Check List: m |
||
| Line 4: | Line 4: | ||
* confirm with the [[statistician]] whether there is impact | * confirm with the [[statistician]] whether there is impact | ||
* [[CCMDB.mdb]] which feeds [[CFE]] tables | * [[CCMDB.mdb]] which feeds [[CFE]] tables | ||
** table [[S Locations | * pre [[2016 Time and Place changes]] | ||
** table [[S Locations]] | |||
** table ''[[s_locations_allowed_collection]]'' | ** table ''[[s_locations_allowed_collection]]'' | ||
** for medicine, table ''[[s_tmp_er_wait_r_locations]]'' | ** 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_varOptions]]'' if new [[Var 1 - Admit-from Ward]]/[[Var 2 - Discharge-to Ward]] are required | ||
** possibly table '''[[S Tmp]]''' | |||
* post [[2016 Time and Place changes]] | |||
** [[s_dispo table]] | |||
** table ''[[s_locations_allowed_collection]]'' | |||
** possibly table '''[[S Tmp]]''' | ** possibly table '''[[S Tmp]]''' | ||
** find/search through all VBA modules for the new name, the current name, possible equivalent unit name | ** find/search through all VBA modules for the new name, the current name, possible equivalent unit name | ||
Revision as of 10:16, 2016 May 19
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
- pre 2016 Time and Place changes
- table S Locations
- 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
- post 2016 Time and Place changes
- s_dispo table
- table s_locations_allowed_collection
- 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.