My VSO Placement
on Hoggs in Uganda (Uganda), 17/Mar/2010 04:01, 34 days ago
Bobby - 16th March 2010This is probably the most boring blog so far (no photos but I thought some flowcharts might be helpful) but being 6 months through our 1 year placement I thought I should record a bit more about the work I am doing. I am enjoying my placement and feel very lucky that there is a substantial job to be done.I am working for (as is Rhona) Reach Out Mbuya HIV and AIDS Initiative. It started in 2001 with less than 20 clients and now has around 3,000. Since its start over 7,000 clients have been registered. Mbuya is a parish on the east side of Kampala on the Port Bell Road. Our house is about 3km further out on the Port Bell Road which  makes travelling to work relatively easy.Reach Out is required to make regular reports to the Ministry of Health and funders. As the organisation grew the reporting depended more and more on spreadsheets and at some point it was realised that there would be benefits from establishing a Health Management Information System (HMIS) which would capture data from day to  day and generate the analyses for the required internal and external reporting.In February 2009 Reach Out engaged a consultant/contractor to provide the HMIS using an MS SQL Server database and Visual Basic front end for the data capture. The contract was for 2 months starting  February 2009. When I arrived on the scene at the end of September 2 data capture screens (out of around 20) were in use.  The consultant was claiming that the system was substantially complete but Reach Out had not tested or implemented most of what had been delivered. This was not surprising as I discovered the only database established was the one Reach Out was using to key the live data into  - there was no test system. The system had been described/specified as a number of modules e.g. pharmacy, laboratory, medical (including Follow Up records, TB register, PMTCT register), stores, so I set about identifying all the issues/bugs which required to be addressed. I spent the 3 months up to Christmas working with the consultant trying to get him to fix the problems and address some of the other issues.I think the basic problem was the specification was very loose and the consultant didn’t seem to be keen to do much analyses so in many cases what was delivered did not meet the requirements and there was little detail on what they were.I had no previous experience of MS SQL Server but, when I established the test system, I was delighted to discover how easy it was to take an MS Access database and convert it into a front end for the MS SQL Server database. Importing the MS Access tables worked a treat and MS Access ODBC links were easily established. Around 70,000 Follow Up  records had been entered and MS Access link tables allowed us to start checking and using the data for the reports at the end of December. (A number of staff at Reach Out have some knowledge of MS Access)Reach Out are trying to capture all the historical records going back to the start in 2001. As the data capture was way behind schedule and the consultant was“slow” in delivering I suggested as an interim measure that I create an MS Access database to capture the TB Register data. When the consultant delivered the VB screens we could convert to using them.Christmas came and went and I was getting concerned at the amount of time I was wasting checking each delivered offering from the consultant only to find that a substantial number of the outstanding issues were not addressed and had to be followed up in the next delivery.In January we had a meeting with some of the IT staff from CDC, Reach Out’s main sponsor, and I was very interested to hear that they were encouraging the use of MS Access as a front end to MS SQL Server as it gave the (more competent) users the option to change the data capture and add new fields to meet changing needs without having to further engage the services ofa consultant.A short step from that was the realisation that the time I was wasting with the consultant would be better spent developing MS Access front ends to the HMIS database. So we have abandonned any further development of the VB modules and I am now developing the HMIS system. I am enjoying this although my lack of experience with MS SQL Server can be a bit of a constraint.I have had concerns that I wasn’t passing on skills to the staff but it’s not too bad just now with a few keen to learn from me.I have a clear idea what I want to achieve in the next 2 months so that the last 4 months will just be consolidating the procedures and training– if only. There are signs of the next phase of requirements emerging but I will have to try not to get to involved or else I will never get home.What do you think? Is this really boring? Please comment.