Development of an integrated database and data collation system for monitoring and evaluating the public sector antiretroviral treatment (ART) in the Free State province, South Africa

Simple item page
dc.contributor.authorFairall, L.
dc.contributor.authorStaniland, G.
dc.contributor.authorMsimanga, M.
dc.contributor.authorTimmerman, V.
dc.contributor.authorGoedele, L.
dc.date.accessioned2009-10-07T18:00:57Z
dc.date.available2009-10-07T18:00:57Z
dc.date.issued2006
dc.descriptionMeeting: 16th International AIDS Conference, Toronto, Canada, August 13 - 18, 2006en
dc.description.abstractISSUES: Paper-based structured clinical records are widely used for monitoring and evaluating the public sector HIV antiretroviral (ART) treatment program in South Africa. Computerized systems are sometimes used for operational data capture but are usually limited to individual clinics and hospitals. Important information also exists in other databases. A requirement exists to collate information into electronic format and integrate data from a variety of sources to facilitate reporting and quality controls. DESCRIPTION: Handheld computers (PDA's) were used to collate data from paper records at urban and rural sites during the first nine months of the ART roll-out program in the Free State province of South Africa. Thereafter a commercial online computer system (Meditech) was implemented. A Microsoft SQL Server 2000 database server was used to deploy the information into a relational and dimensional format using Microsoft Data Transformation Services. External laboratory and resistance data were integrated as well. After 18 months 19013 patients were registered on the system, of which 2743 were ART patients. A total of 143751 forms have been captured with a median of 4 forms/non- ARV patient and 26 forms/ARV patient. Six quality categories with a total of 32 quality routines were implemented. The system has also been used to compile quarterly reports and national indicators. LESSONS LEARNED: PDAs compare favourably with online systems for data collection from remote rural and urban sites and are useful where online systems or connectivity are lacking. Dimensional data modelling and data warehousing techniques are fundamental for creating databases that are optimized for querying, aggregated reporting, longitudinal analysis and research. RECOMMENDATIONS: Data quality remains the most challenging aspect of information systems for monitoring and evaluation. The next phase will be to feed information back to the health care workers and patients to give them the benefit of information systems and to encourage better input data quality.en
dc.formatTexten
dc.format.extent1 digital file (2 p.)en
dc.identifier.urihttp://hdl.handle.net/10625/40260
dc.language.isoen
dc.publisherInternational AIDS Society (IAS), Geneva, CHen
dc.subjectMEDICAL RECORDSen
dc.subjectDATABASESen
dc.subjectCOMPUTERIZED SYSTEMSen
dc.subjectINFORMATION TECHNOLOGYen
dc.subjectDATA COLLECTIONen
dc.subjectPDAen
dc.subjectANTIRETROVIRAL TREATMENTen
dc.subjectAIDSen
dc.subjectDISEASE CONTROLen
dc.subjectFREE STATEen
dc.subjectSOUTH AFRICAen
dc.titleDevelopment of an integrated database and data collation system for monitoring and evaluating the public sector antiretroviral treatment (ART) in the Free State province, South Africaen
dc.typePresentationen
idrc.copyright.holderInternational AIDS Society (IAS)
idrc.dspace.accessOpen Accessen
idrc.project.number102411
idrc.rims.adhocgroupIDRC SUPPORTEDen

Files

Original bundle
Now showing 1 - 1 of 1
Thumbnail Image
Name:
128813.pdf
Size:
23.76 KB
Format:
Adobe Portable Document Format
Description:
Download

Collections

IDRC Research Results / Résultats de recherches du CRDI
2000-2009 / Années 2000-2009
Health / Santé
Research Results (ACACIA) / Résultats de recherches (ACACIA)
Research Results (CA) / Résultats de recherches (CA)