Constructed from an e-mail conversation between David Platten and Ed McDonagh:
If two rooms have the same
station_name then only one entry appears on the OpenREM summary front page for the two rooms. The number of studies shown reflects the total of the two rooms together. When you go to the corresponding filtered page all is well.
A suggested solution is to add a new table (
unique_bits_of_kit…) that contains one row per piece of kit that has talked to OpenREM, including a
Display name field which is populated with a sensible default (combination of
station_name, perhaps). Each time a study is added the system can check if it’s a new piece of kit. If it is, a new row is added to
unique_bits_of_kit with the appropriate information. The
generalequipmentmoduleattr table would need a new field added to it to contain the row of
unique_bits_of_kit to use for that study’s
Display name. An administrator could be allowed to change the value stored in the
Display name field of
unique_bits_of_kit table would need to keep all of the following fields to determine if the kit is unique:
- Institution Name
- Institution Address
- Station Name
- Institutional Department Name
- Manufacturer’ Model Name
- Device Serial Number
- Software Versions – maybe not?
- Gantry ID
And then the final field of
Display Name, which could be the same for several rows that actually refer to the same bit of kit.
Display Name would also need to be added to each of the filtering searches.