The 'OPJ' project

The database aspect

The first part of this project was to design a MS Access database allowing to handle organisation data and manage dependencies between services, sub-services, managers and employees.

OPJData Access database and GUI.

 

This database relies on external data for the information related to services and employees while having its own data structure for the information concerning job positions and organisation charts.

Both job positions and organisation charts can be created automatically based on the existing information on services and related employees. The user can then reorganize the data in order to represent whatever dependencies he needs, such as hierarchical dependencies or functionnal dependencies.

The HTML export aspect

Once the organisation data have been entered into the database, a Java application allows to generate the HTML-based organisation charts automatically. The corresponding HTML pages can then be straigh-forwardly published on the internet/intranet and allow any visitor to navigate through the given organisation and obtain detailed information on any given service or employee.

OPJHTML generated organisation charts.