Lambeth PCT
Background
As part of a stop smoking campaign initiated by Dr Foster Intelligence for Lambeth PCT, I built Lambeth an online database, enabling them to upload and import custom spreadsheets sent in by GP practices across the borough. They could also run reports for the Department of Health, showing the breakdown of quitters per quarter by age, gender and ethnicity amongst others.
The system also contains a manual entry form and an admin area, in which the PCT can verify the results of the spreadsheet import for each GP surgery and edit the options available for certain questions on the manual entry form.
How the system works
The system is built using ASP.NET 2.0 and C#, with a SQL Server 2000 backend database. It makes use of the ATLAS framework, which improves the user experience. The system is secured by an administrator login, so makes use of the membership API. The spreadsheet upload was built into the manual entry form, so Lambeth could import spreadsheets immediately upon login. Because the spreadsheets were heavily formatted, I performed a complex data cleanse on them during import, rejecting any patient records that didn't conform to the structure I had mapped out. These records would then be inputted manually.