1. PEPFAR/MOH Data Alignment Activity Overview

Objectives

Goals

Short-term; for countries to use the data to identify reporting challenges, with the goal to improve reporting processes, data quality, and program efficiencies

FY24 Activity Timeline

Please find a recording and the slide deck for the FY23 Kick-off Webinar below

PEPFAR Virtual Academy (PVA)

Sign into the PEPFAR Virtual Academy (PVA) to find instructions on the Data Import Tools & Process as well as Data Use and Analysis Tools.  The course can be found at https://learn.pepfar.net/   Once you have created and account/logged in, you can search for the course under the name “PEPFAR/MOH Data Alignment Activity”.   

Data Alignment Activity Process

The PEPFAR/MoH Data Alignment Activity is broken out into four key milestones. The first three milestones involve transforming the data into a compatible format and imported into DATIM while the fourth involves data analysis and use. Through completing the four milestones, Ministries of Health, PEPFAR country teams, and PEPFAR HQ will have access and visibility into the same aggregate data collectively housed within the PEPFAR DATIM system.

These four milestones include:  

1. Facility Alignment: Aligning the DATIM organizational hierarchy and facility list to the authoritative master facility list (MFL) in each country.
2. Indicator Mapping: Mapping indicators in the MoH health management information system (HMIS) to the equivalent PEPFAR MER indicators.
3. MoH Results Data Extraction, Transformation, and Loading (ETL): Extracting facility level results from the MoH system, transforming data according to the indicator mapping, and loading the data into the DATIM system.
4. Data Use: Analyzing the resulting complementary datasets (MoH and PEPFAR side by side) within the DATIM system or exported for analysis in other systems or to share with relevant stakeholders.

To Date

The FY2024 Activity is now underway, but there is much that has already been accomplished by this activity:

• The FY2017 Activity launched in collaboration with the 13 priority epidemic control countries to align six key HIV indicators. In September 2017, PEPFAR conducted an in-person workshop in Johannesburg, South Africa with all 13 participating countries to complete Activity deliverables and provide direct technical support. By the end of the 2017 Activity, country teams and MoHs successfully aligned almost 30,000 facilities, added an additional 4,000 facilities, and triangulated site-level data identifying areas for data quality improvement. 
• The FY2018 Activity expanded to include all 23 PEPFAR Long Term Strategy countries. These countries were also included in The FY2019 Activity as well. At the start of the FY2018 activity, PEPFAR conducted a month-long Virtual Workshop with all 23 participating countries through the newly established PEPFAR Virtual Academy. The Virtual Workshop included instructional webinars, video tutorials, and other technical information to assist country teams and MoHs in completing the deliverables. 
• The FY2020 Activity focused on data use and introduced new tools that empowered the country teams to analyze and integrate DAA data in their program management.  We also continued to improve the tools to build efficiencies in the reporting processes and maintain alignment with facility lists and indicator definitions. Also with FY20, we were able to publish this aggregated data on the PEPFAR website as it can be found at https://data.pepfar.gov/daaMap1. 
• The FY2022 Activity expanded on the data collection with tracking two more indicators, TX_PVLS (Numerator) and TX_PVLS (Denominator). We also added a second 'Fine' disaggregation (65+) for TX_CURR that now include more age groups of 50-54, 55-59, 60-64, and 65+ to increase age data accuracy. In addition, site attributes were added to the data collection process. Site attribute data included facility type, ownership type, university, faith based, community services provided, and clinical hours.
• The FY2023 Activity added the additional 'Fine" disaggregation of 65+ to four more indicators: TX_NEW, TX_PVLS (Numerator), TX_PVLS (Denominator), and PMTCT_ART.
• The FY2024 Activity added five additional site attributes:  Electronic Medical Record System (EMRS)​, Logistics Management Information System (LMIS)​, Laboratory Information System (LIS)​, Pharmacy Information System (PIS)​, Other Digital Health Information System​

Participating Countries

• Botswana
• Burundi
• Cameroon
• Cote d'Ivoire
• Democratic Republic of the Congo
• Eswatini
• Ethiopia
• Haiti
• Kenya
• Lesotho
• Malawi
• Mozambique
• Namibia
• Nigeria
• Rwanda
• South Africa
• South Sudan
• Tanzania
• Uganda
• Ukraine
• Vietnam
• Zambia
• Zimbabwe