WEBS - Scheme Management
The Woodland Energy Business Scheme (WEBS) is a grant scheme managed by the Forestry Commission in Wales. Many enquiries are received, a proportion of which progress to applications, awards and monitoring. A database application was developed to manage the full lifecycle of scheme activities and allow efficient interactions with the applicants. Key requirements were accurate record keeping and audit trail, fast retrieval of records, the allocation of tasks to office staff, task completion deadlines and tracking of projects through each stage of the process to ensure all activities are dealt with in a timely manner. The database is on a central forestry Microsoft SQL Server, the client applications are written in Visual Basic .Net and run on the office workstations.
A collaborative project undertaken on behalf of Hologic Gen-Probeto manage their scientific processes. The system automates the process of testing human genetic samples from the receipt of samples through testing to results entry and the generation of standardised reports. Athena is a platform-independent intranet application developed using J2EE (Java) on a Tomcat server, back-ended by a MySQL database. Reports are generated in a number of different formats (including HTML web pages, Microsoft Word documents and Adobe Acrobat PDF files) using XML, XSLT and FOP.
As a UCAS accredited scheme operator Welsh Lamb and Beef Producers are required to keep records related to their members for long periods. The amount of paper that accumulates had become a serious issue and it was even becomming a concern that the weight, in paper records, could potentially cause structural damage to their building if a solution was not found to the ever growing storage issue.