Any selection of modules to be installed will be accompanied by the following three supporting modules:
The Dashboard is on top of all modules and provides a reporting tool which includes different Datamarts (per module).
The Dashboard/Datamarts are accessible to all users with a supervising role who are responsibel for internal and external reporting. Individual Datamarts can be limited to certain Lab Servant Roles to secure that confidential data are not compromised.
Where possible we promote the broad use of the Datamarts by the widest group of users based on the concept of fact driven self-steering. This follows the academic principle “to publish, unless … “.
The Dashboard supports the SMC concept (Standards – Measurements – Control). Measurements (data from different modules) are compared with agreed Standards, which are often derived from the applicable laws as well as the internal regulations of an organisation.
If deviations are found between Measurement and Standards, the organisation will seek to reduce them using Control. This dynamic is supported by the Dashboard/Datamarts.
Technically spoken each module has its own Datamart (sometimes more than one), which Datamarts are integrated into a data warehouse in the form of the Dashboard.
2. Organisation, Users and Roles
Rule 1: a full organisational chart defines the position of any User in the organigram of the user’s organisation. This position defines the basic (viewing) rights a User will have in the Lab Servant.
In general a User can view Objects that are within or below his own organisational unit, with other words: the higher in the organisation the more viewing rights a User will have.
Rule 2: Objects are also placed on different levels in the organisation. If you want to share e.g. a container with chemicals with everybody in the organisation place it on the top level.
Rule 3: a Role is attributed in the Lab Servant to a User. It permits the viewing (and editing if applicable) of defined objects.
According to Rule 3, Users can view resp. edit Objects that are placed in their own organisational unit if they have the required viewing resp. editing Role.
In addition according to Rule 1 Users can view/edit also the Objects placed below their own organisational unit.
According to Rule 2 Users can see/edit also the Objects placed above their own organisational unit.
In no case a User can view Objects that are placed in an organisation unit that’s on the same level as the user’s own organisational unit.
Applying these three rules a simple and effective authorisation mechanism is implemented that requires a minimum of daily maintenance and offers a maximum of personalisation of data.
The organigram, the Users, and the organisational unit of the user or in general synchronised via a web service with the corporate HR system. Roles are attributed to Users in the Lab Servant, preferable via the Workflow new employee.
Objects are linked to organisational units in a default manner but may be updated as required in specific cases. The overall maintenance effort is low.
3. Buildings, Areas/labs and Door signs
All Buildings and Areas/lab per building are stored in the Lab Servant. Imports can take place via Excel files derived from the corporate real estate system. Because all areas must have an Area supervisor to allocate Points of improvement to from the Inspection module, the Area supervisors must be added to the Excels before the import takes place.
A web service with the corporate real estate system may be used to signal merging and splitting of areas. These changes require a manual follow-up in the Lab Servant database, e.g. relocate storage locations, equipment, permits et cetera. Historic objects like Inspection rounds will stay linked to the former (non-actual) areas after a merge/split.
Door signs are used for labs and other areas where chemicals/gases and/or other dangerous materials or equipment are stored. On the door signs hazard symbols are shown, partly static, added by the Area supervisor, partly dynamic, derived directly from the Inventory system. Symbols for precautions and restrictions can be added to the door sign as well as the name of the responsible Area supervisor and safety officers responsible for specific processes in the lab.