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

Online Payments System Case Study - Oxford City Council

Overview

Oxford City Council is a district council that provides a wide range of services for approximately 149,000 residents, 83,000 people who work in Oxford, and 7.5 million people who visit the city every year.

http://www.oxford.gov.uk/oxonline/

Objectives

To develop a modular online payments system for the Councils' website so that further payment types could be added in the future with the minimum of time and reduced testing.

Solution

BOCC undertook an initial requirements analysis session with OCC Business Systems and Cashiers staff to discuss the overall system requirements. BOCC advised on methods for data transfers between OCC 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. We agreed on the initial services to be included and the method to be employed for each.

The design had to cater for a very wide range of browsers, operating systems and match existing visual identity standards.

The facility allows payment of the following services:
  • Building Control Fees
  • Business rates (NNDR)
  • Commercial Property Rents
  • Council Housing Rent
  • Council Tax
  • Housing Benefit Overpayment
  • Housing Service Charge
  • Lottery or Raffle Licensing Fees
  • Oxford City Council Parking Fines
  • Park and Ride Season Tickets
  • Periodic Rents
  • Pest Control Charges
  • Sports Bookings

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 receipt generation (as printable web pages and optional email). Each day's payment transactions are transferred by Virtual Private Network (VPN) back to OCC, imported and processed automatically into the existing financial systems without any re-keying.

Technologies

The system utilises:

  • Microsoft™ SQL Server 2005
  • Adobe® ColdFusion®
  • Microsoft™ Internet Information Server
  • Replication for file data, which then integrates with OCC back-office systems
  • Secure replication of data to and from internal systems via a virtual private network (VPN)
  • Hosting on a fully managed dedicated web server at BOCC
  • Disaster recovery hosting facilities
  • SSL (Secure Server Certificate)
  • Extensible HyperText Markup Language 1.0
  • Cascading Style Sheets (CSS) 2.0 compliant