Transforming medical study leave approvals from an unmanageable legacy system to a modern SharePoint-based workflow solution.
Customer
NSW Health
Challenge
Outdated system difficult to support and extend
Solution
Custom SharePoint application with ERP integration
Outcome
Extensible system with reduced support calls
The TESL (Travel, Education, Study Leave) application allows doctors to request study leave to attend both domestic and international conferences. The system references ATO travel allowances and integrates with multiple internal systems to determine authorization.
The legacy TESL application was built using a problematic mix of web technologies including Cold Fusion, Classic ASP, and JavaScript. Over time, this technology stack made support and extensibility increasingly challenging, eventually rendering the system unmanageable.
Mix of Cold Fusion, Classic ASP, and JavaScript creating maintenance nightmares
Difficult to support and add new features due to outdated architecture
System had become unmanageable, requiring complete modernization
CoSource, working through Data#3, delivered a modern SharePoint-based solution with comprehensive system integration
Microsoft SharePoint 2007 was chosen as the foundation, enabling the customer to manage workflows and configuration data directly. The solution featured a three-tier architecture built with ASP.NET 4.0 and Entity Framework.
CatDog ERP System
VB6 and SQL Server 2000
Oracle Financial Database
Financial system integration
SharePoint 2007
Workflow and document management
SharePoint workflows enable customer-controlled approval processes without developer intervention
SharePoint security model provides easy access control and user permission management
SharePoint lists enable uniform, consistent configuration information management
The new TESL system delivered significant improvements in manageability, extensibility, and user control
The approval process consists of a series of approvals from each doctor's managers. By building custom workflows within SharePoint, customers can control the workflow process directly, eliminating the need for developer maintenance.
Using SharePoint's security model, customers can easily control system access and define user permissions, providing granular control over what each user can access and perform.
SharePoint lists enable customers to manage configuration information through a uniform, consistent process, reducing complexity and improving maintainability.
Reduced Support Calls
Extensible system reduced technical team support requirements
Self-Service Management
Staff can manage approval processes and add custom rules independently
Modern Architecture
Replaced unmanageable legacy system with maintainable solution
System Integration
Seamless integration with existing ERP and financial systems
We specialize in transforming unmanageable legacy systems into modern, maintainable solutions that empower your team.