October 23, 2023

TESL – Training, Education Study Leave for Doctors

The TESL application allows doctors to request study leave to attend both domestic and international conferences. The system references ATO travel allowances, as well as a number of 3rd party internal systems to determine whether or not the doctor is authorised to attend the conference.

In Summary

Customer

South Eastern Sydney Illawarra NSW Health

Industry

Training, Education Study Leave for Doctors

Business Problem

—

Solution

—

Outcome

—

Background

The old TESL application was built by a contractor using a mix of web technologies (Cold Fusion, Classic ASP, and JavaScript), which overtime made the support and extensibility of the system a challenging exercise, that eventually lead to the system becoming unmanageable.

As the area was starting to adopt SharePoint to automate workflows and forms, CoSource through Data#3 was commissioned to assist in building a new TESL application.

Solution

Microsoft SharePoint was used as the foundation to build the application upon. By using SharePoint the customer was able to manage the application’s work flow and configuration data through.

The solution needed to integrate into a number of third party systems:

An ERP system named CatDog (Built with VB6 and SQL Server 2000)
Oracle (The financial database)
SharePoint 2007

The application forms, business logic, and data logic were built with asp.net 4.0 and the entity framework over a three tier architecture. Web services were used to enable the systems to easily exchange information while maintaining security and performance.

Benefits

The application’s approval process exists of a series of approvals from each of the doctor’s managers, by building a custom workflow within Sharepoint the customer could control the work flow process, where previously this had to be maintained by a developer.
By using SharePoint security model, the customer could easily control access to the system, and when given access what a user could do
SharePoint lists had enabled the customer to manage configuration information in a uniform consistent process.