Program solution for work scheduling in a hospital

Ms. Maja Jagrič
Faculty of Organizational Sciences, University of Maribor, Slovenia

The solution for hospital personnel scheduling was designed as an internet application with the Oracle 9i Application Server Portal development tool. Views, updates and inserts are enabled for data about doctors, organizational units, processes, work orders, work, outpatients departments and absence from work. The execution of personnel scheduling procedures and graphical presentations about past work are included. The solution is suitable for intranet application and offers a simple personnel scheduling and work reviews. The advantage of the presented solution is the access that is possible with user name and password from any computer connected to the internet.

The testing of the solution was focused on component testing. It was established that the solutions is suitable for simple data retrieval, while its disadvantage are complicated forms and reports. The stability of the solution depends on Oracle 9i AS Portal as also on the demands of the build in portlets.

The learning curve for Oracle 9i AS Portal is low in the beginning, but after some months of work, it rapidly increases. This slow progress often causes the user to give up after months of attempts.

Full paper