Back to Annual Meeting Page		American Public Health Association 133rd Annual Meeting & Exposition December 10-14, 2005 Philadelphia, PA

Abstract #106555

Michael Rodriguez, John Snow Incorporated, 1860 Blake Street, Ste 320, Denver, CO 80202, 303-262-4312, mrodriguez@jsi.com and Upama Khatri, MPH, Measure Evaluation, John Snow Incorporated, 1616 N. Fort Myer Drive, 11th Floor, Arlington, VA 22209.

Through the President's Emergency Plan for AIDS Relief, the US Government is funding hundreds of programs that provide millions of people with HIV/AIDS prevention, care, and treatment services in 15 of the most severely affected countries in the world. Monitoring and evaluation is a key component of the Emergency Plan and provides USG and host-country partner organizations with the strategic information that is needed to plan and monitor programs; document and report on progress; promote evidence-based policy and practice; and ensure that resources are used cost-effectively. In South Africa, one of the hardest hit by the AIDS pandemic, there are about 60 partner organizations and as many sub-partner organizations that are implementing programs funded by the Emergency Plan. These partners and sub-partners are required to report to USG on a regular basis on their program-level indicators. The South Africa/Emergency Plan Data Warehouse is a health information system tool that is being developed by MEASURE Evaluation, in partnership with a local consulting firm Khulisa, to (1) streamline and systematize data flow from partner organizations to USG and (2) improve data use for program management and planning purposes. The data warehouse is accessed via the web and allows partners to capture their program-level indicators, verify captured data, query data, generate reports, and transmit data electronically to USG. Although the first objective of the data warehouse is to meet USG reporting requirements, it is also a tool that partners can use to capture and analyze information that they need on an organizational level for program management and planning purposes. This function is essential to make the tool truly useful for partners and create ownership of the system. The long-term goal of this project is to create a national data warehouse that contains information from all HIV/AIDS prevention, care, and treatment programs operating throughout South Africa.

Learning Objectives:

• 1)Identify the steps involved in designing and developing a data warehouse using the example of the South Africa/Emergency Plan Data Warehouse development experience
• 2)Describe the functional areas of the South Africa/Emergency Plan Data Warehouse including data capture, verification, analysis, and reporting.
• 3)Understand the prerequisites for and challenges of developing a country-level data warehouse for HIV/AIDS information

Keywords: HIV/AIDS, Information Databases

Related Web page: www.sharing.org.za

Presenting author's disclosure statement:

I wish to disclose that I have NO financial interests or other relationship with the manufactures of commercial products, suppliers of commercial services or commercial supporters.