Tuesday 6 January 2009
The Big Oxford Computer Co. Ltd.

Online Payments and Accounts System Case Study - London Borough of Camden

Overview

The London Borough of Camden covers an area of 22 square kilometres (2,180 hectares) of inner London, north of the West End and City of London. The Council provides services across the Borough to a diverse range of social and economic conditions and has consistently led the way with Internet initiatives.

http://www.camden.gov.uk/pay/

Objectives

The Government's requirement for councils to provide all services online by 2007 was a demanding challenge and London Borough of Camden undertook to deliver three key payment services in early 2001. London Borough of Camden provided a specification for the project and BOCC successfully tendered for this work.

Solution 

London Borough of Camden developed a walkthrough of the main user process steps with BOCC. BOCC advised on methods for data transfers between London Borough of Camden and BOCC and then developed a modular system so that further payment types could be added in the future with the minimum of time and reduced testing.

The design had to cater for a very wide range of browsers, operating systems and match existing visual identity standards. The design also had to complement the existing Camden Connect website and ensure that the service users could navigate through the process without confusion.

The facility allows payment of the following services:

  • CCTV bus lane contravention fines;
  • Parking fines;
  • Business rates;
  • Commercial rents;
  • Council tax;
  • Housing rents;
  • Housing benefit overpayments;
  • Leaseholder service charges;
  • Sales invoices.

Account data balance files are exported each night and used to update the website. There is live online payment card authorisation using Datacash's merchant services and Anite's PARIS web services and receipt generation (as printable web pages and optional email). Each day's payment transactions are transferred by Virtual Private Network (VPN) back to London Borough of Camden, imported and processed automatically into the existing financial systems without any re-keying.

Technologies 

The system utilises:

  • Microsoft™ SQL Server 2005
  • Adobe® ColdFusion®
  • Secure replication of data from internal systems via a virtual private network (VPN)
  • Fully managed dedicated web server at BOCC
  • SSL (Secure Server Certificate)
  • Extensible HyperText Markup Language 1.0
  • Cascading Style Sheets (CSS) 2.0 compliant