Software Solutions Sydney | Ecommerce Developers – CoSource

Contact Us on 020 4577 3640

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.



case nsw

In Summary


NSW Health



Business Problem

Outdated system that was difficult to support and add new features.


Custom Microsoft SharePoint Application that integrated into their ERP & Financial systems.


An extensible system that allowed the staff members in charge of TESL to manage the approval process and add custom rules, resulting in less support calls to the Technical team.


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.


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 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.


  • 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.

Technologies Used

** Microsoft SharePoint ** Microsoft .net 4.0 ** Entity Framework ** SQL Server ** jQuery **

× Talk to an expert