FANRPAN HIV

1
FANRPAN HIV AIDS Database

• Lindiwe Majele Sibanda
• Linds_at_ecoweb.co.zw
• Linds_at_mweb.co.za

2
Background to the Database

• Developed using Epi Info 2000, using Microsoft
  Access Database
• Developed from national level SPSS databases
• Has 167 variables and 1930 records from 7
  countries.
• Variables have household data on demographics,
  health, income, expenditure and impacts of HIV
  and AIDS.
• Analysis carried out at country and regional
  levels.
• Integrated framework within Epi Info allows for
  analysis and reporting.

3
Variables tracked
Key impact area Hypothesis Key Variables /Indicators Countries data situation Primary data Secondary data Data not available
Agricultural productivity H/A has led to a decline in agric productivity Yield, (area cultivated) Overall output, Agric inputs type and quantity Number of productive HH members infected Number of HHs affected Education level Demographic variables Type and quality of equipment Gender- of infected/affected Changes in household structure Extension and support services Area cultivated
Marketing Reduces participation in the market Sales (no. animal, no. bags) Number of strayed animals Price per herd No. of animals sold to butcheries 1, 2 2 1, 2 2, 3
Livestock asset Reduces number and quality of livestock Size of herd Price per head Expenditure on inputs Availability of labor 1, 2 2 1, 2 1, 2
4
Variables tracked (ctd)
Mobility Increases mobility of HH members Travel expenditure Household size/composition/structure Changing household structure Number of patients at health care centers 1, 2 1, 2 1 2
Environmental Increased degradation of environment Accumulation of disposable litter Number of animals with measles Educational level Gender 1 2 1 1
Food Consumption Decline in household food consumption Types of food consumed Expenditure and income patterns Household income levels Size of household Dietary composition 1 1 1 1 1
Production Assets Erosion of Household productive asset base HH resource allocation HH sources of Income HH expenditure patterns 1 1 1
Extension Support services Erosion of extension and research services Absentism due to illness Farmer extension ratios Number of deaths in the community Health status of extensionists 3 3 3 3
Demographic structure Increased dependency ratios Number of children under 15 years Number of adults above 65 years Sex composition of household members Education levels of household members Employment status 1 1 1 1 1
5
Example of variables collected demographics
Variable description Variable name Whether Countries collected data Whether Countries collected data Whether Countries collected data Whether Countries collected data Whether Countries collected data Whether Countries collected data Whether Countries collected data
Country Country NAMIBIA BOTSWANA ZIMBABWE SWAZILAND LESOTHO SOUTH AFRICA ZAMBIA
QUESTIONNAIRE NUMBER QuestionnaireNumber yes yes yes yes yes yes yes
Date Date no no yes no no yes no
District or Region District yes yes yes yes yes yes yes
Age Of Household Head AgeOfHeadofHH yes yes yes yes yes yes yes
WARD/Enumeration area/village LocalArea no yes yes yes no yes yes
Sex of Household Head SexofHeadofHH yes yes yes yes yes yes yes
Family name FamilyName no no yes yes no yes no
Position of the respondent in the family RespondentPosition no yes yes no yes yes yes
Who is/are the head(s) of this family? FamilyHead yes yes yes yes no yes no
How long has the family been in agriculture (Years)? YearsFarming no no no yes yes yes no
Total household size TotalHouseholdSize yes yes yes yes yes no yes
Number of children/Dependents in the Household Dependents yes no yes yes yes yes yes
Dependancy Ratio Dependency yes no yes yes yes yes yes
6
Example of variables collected impacts
LIVESTOCK IS SOLD TO FINANCE MEDICATION OF THE SICK FarmingTimeLost no yes yes no no yes yes
IT TAKES FARMING TIME AS PEOPLE WILL BE LOOKING AFTER SICK PEOPLE FinancialResourcesDiverted no no yes yes no yes yes
FARMING FINANCIAL RESOURCES ARE DIVERTED TO MEDICATION for THE SICK FarmingImplementsSold no no yes no no yes no
FARMING IMPLEMENTS ARE SOLD TO FINANCE MEDICAL EXPENSES ChoresTimeLost no no yes no no yes no
TIME TO DO HOUSEHOLD CHORES IS SACRIFICED LOOKING AFTER THE SICK SchoolTimeLost no no yes no no yes no
IT TAKES CHILDREN'S TIME TO BE AT SCHOOL LOOKING AFTER THE SICK ParentingTimeLost no no yes no no yes no
IT TAKES AWAY PARENTS" TIME TO BE WITH THEIR CHILDREN HouseholdPropertySold no no yes yes no yes yes
SICKNESS RESULTS IN THE SELLING OF HOUSEHOLD PROPERTY War no no yes no no yes no