In the project settlement system, the hours worked on projects or cost clearing centers (overheads) are recorded for all of the customer's 15,000 employees. At the end of the month, these time sheets are signed electronically by employees and their supervisors. This forms the basis for settlement with the funding agencies and checking by auditors.
The settlement system is implemented as a web application. The MVC2 concept is implemented by means of Struts and JSP pages. The business logic is separated logically from the presentation layer in order to enable a physical separation of the layers in a second development stage. To achieve this, the use case controllers that map the business logic are encapsulated in session EJBs. The application is integrated in the employee portal. Users log on to the portal by means of a certificate. Authentication on the application then takes place via single sign-on. User information is determined from the token generated by the server from the certificate from the active directory. The data basis for the application is integrated into the ERP system. Read access only is used for existing tables. All the recorded data are written to tables that are used by the application only. The data are transferred to the ERP by a stored procedure when recording is completed for the current month.
The project was implemented for two reasons: 1) The existing procedure for recording hours on paper by 15,000 employees, followed by entering the data into the ERP system, was prone to errors and involved a large number of personnel. 2) There were frequent problems when funding agencies and auditors checked project settlement. The system eliminates these problems. The data are now available in the ERP system as soon as time recording is complete and they can be used for project settlement and controlling and for forecasting. Thanks to the certification and the workflow implemented in the application with digital signing of the time sheets, the quality of time recording (and therefore project settlement) is improved. This increases audit reliability.