(zero)seven

Zeroseven analysed the existing separate Access databases and other process documents used to run each service, interviewed key operational staff and then designed a single web-based solution to run all three services. Through this new system, St John staff manage 2000 volunteers, 10 000  clients, over 100 trips a day, 150 telephone schedules a day, 500 hospital schedules, drivers, vehicles, and more, through one intuitive interface.  There is extensive reporting generation (including HACC reporting) and a log to track user activity. By providing St John Qld with a database to match their needs, St John Qld are able to provide a better service for clients, volunteers and the community.

Solution

An important factor in managing community services such as the St John transport, Silvercord and hospital visitation service, is the time needed for staff to manage and schedule volunteers for these services.

With the new database, staff not only save time during the scheduling process, the management of client and volunteer details has become easier and vital information can be easily found in the system, whether it be via the client or volunteer search or overview screens for each of the three services.

Results

Reporting on the services has also been made easier with detailed information being captured and custom reports generated for internal use and external reporting.

Technology

Microsoft.NET, SQL Server, HTML, CSS, JavaScript, AJAX

Site Description

An extensive database running community services throughout South East Queensland.