COP19 Data Pack Targeting

Feb 12, 2018
How does PEPFAR country targeting work for COP 19

1. the data pack starting at square one shanon heron/flickr
2. what’s the data pack • Excel-based targeting tool designed to help PEPFAR teams set targets in line with the 90-90-90 goals • data packs are pre-populated with FY16 results, FY17 targets, PLHIV estimates, and assumptions for a series of key indicators, mostly along the clinical cascade diagnosed on treatment virally suppressed 90% 90% 90%
3. a quick look in
4. targeted indicators GEND_GBV PP_PREV [N] HRH_PRE PREP_NEW HTS_TST [facility+community] TB_ART [N+D] KP_MAT TB_PREV KP_PREV [N] TB_STAT [N+D] LAB_PTCQI TB_TX LAB_PTCQI (POCT) TX_CURR OVC_SERV TX_NEW PMTCT_ART TX_PVLS [N+D] PMTCT_EID TX_RET [N+D] PMTCT_STAT [N+D] VMMC_CIRC MER 2.0
5. targeted indicators GEND_GBV PP_PREV * [N] HRH_PRE PREP_NEW HTS_TST [facility+community] TB_ART [N+D] KP_MAT TB_PREV KP_PREV* [N] TB_STAT [N+D] LAB_PTCQI TB_TX LAB_PTCQI (POCT) TX_CURR OVC_SERV TX_NEW PMTCT_ART TX_PVLS [N+D] PMTCT_EID TX_RET [N+D] PMTCT_STAT [N+D] VMMC_CIRC calculated in the Data Pack
6. late Jan - data packs released with rest of COP material early Feb - PSNU targets due at DCMM mid March – COP & district level targets due late Apr – in person COP with site targets entered into DATIM timeline
7. Fact View Datasets Data Pack Country Team Adjustments District Level Targets IM Level Targets Site/Disagg Allocation Tool Site-IM Level Targets PBAC Country Team Adjustments Country Team Adjustments getting to site targets FACTS Info
8. country team process • start with PLHIV estimates by PSNU
9. country team process • start with PLHIV estimates by PSNU • calculate ART coverage (national/host country program) for each SNU
10. country team process • start with PLHIV estimates by PSNU • calculate ART coverage (national/host country program) for each SNU • teams review and revise PSNU prioritization levels (attained, scale-up saturation/aggressive, sustained, central support)
11. country team process • start with PLHIV estimates by PSNU • calculate ART coverage (national/host country program) for each SNU • teams review and revise PSNU prioritization levels (attained, scale-up saturation/aggressive, sustained, central support) • targeted SNU ART coverage levels are set based on previous coverage and PSNU; teams modify targeted SNU ART coverage levels
12. country team process • start with PLHIV estimates by PSNU • calculate ART coverage (national/host country program) for each SNU • teams review and revise PSNU prioritization levels (attained, scale-up saturation/aggressive, sustained, central support) • targeted SNU ART coverage levels are set based on previous coverage and PSNU; teams modify targeted SNU ART coverage levels • based on ART targets (adult and pediatric), data pack calculates the number of HIV positive individuals that must be identified through HTS in order to reach ART targets
13. data pack site map assumption input target calculation HTC target calculation DATIM indicator table SNU targets for EA allocation by IM PBAC IM targets key ind trends change form output editable view only
14. the ICPI Fact View PSNU dataset is munged to create a wide data format, with specific indicators, centered around the clinical cascade
15. start with the PSNU by IM Fact View data set…
16. …create a wide dataset with modified indicators… htc_tst_u15 = fy2016apr IF & indicator=="HTC_TST" & disaggregate=="Age/Sex/Result" & inlist(age, "<01", "01-04", "05-09","10-14") & numeratordenom=="N"
17. …finish with a wide dataset where each row is a district
19. data pack site map DATIM indicator table the munged dataset is used as the base for each OU specific data pack, and populated into a tab for use and country team edits
20. country team makes edits to inputs
21. assumption input DATIM indicator table the other main area for country input and review is on the assumptions tab. the table has been prepopulated TWG guided assumptions at the PSNU level. country teams must review and make PSNU specific updates here
22. assumptions made at the district level for ART
23. assumption input target calculation DATIM indicator table both the munged and updated Fact View data as well as the updated assumptions then feed into the target setting tab/process around each key indicator and/or program area
24. results + assumptions + calculations = targets
25. results + assumptions + calculations = targets
26. results + assumptions + calculations = targets TX_NET_NEW = [PEPFAR coverage of net new x est. # of PLHIV, end of FY17 x target coverage rage] – FY17 expected TX_CURR results
27. results + assumptions + calculations = targets
28. assumption input target calculation HTC target calculation DATIM indicator table due to the complexity of the HTS disaggregates, countries complete a separate HTS table that builds off the assumption inputs, allocation of testing, and yield by modality to create adult and peds testing targets
29. HTS allocations by district
30. HTS positivity by district
31. HTS adult targets TB HTS target = [total district positives to identify x distribution of TB to total district tests] ÷ TB positivity
32. assumption input target calculation HTC target calculation DATIM indicator table SNU targets for EA this tab pulls the calculated targets necessary for expenditure analysis into a clean table, which will be copied and pasted directly into the PBAC as well as the site and disagg tool
33. assumption input target calculation HTC target calculation DATIM indicator table SNU targets for EA allocation by IM in order to get psnu targets down to the IM level, the data pack takes the IM (and dedup) distribution from the previous year results and multiplies it by the new targets
34. a peak into the IM distribution tab
35. let’s assume we’re working in pepfarlandia pepfarlandia allocation by IM
36. which has six districts a e d c b f pepfarlandia allocation by IM
37. and four distinct IMs a e d c b f pepfarlandia allocation by IM
38. working across the country a e d c b f pepfarlandia allocation by IM
39. it’s easy to figure things out with one mechanism in a snu a e d c b f pepfarlandia allocation by IM results distribution district e 100% im target snu target im 200 tests 200 tests 100% 200 tests
40. a e d c b f pepfarlandia allocation by IM results distribution district b 70% im target snu target im 800 tests 560 tests 30% 240 tests 100% 800 tests but is more challenging with multiple mechanisms
41. a e d c b f pepfarlandia allocation by IM results distribution district b 70% im target snu target im 800 tests 560 tests 40% 320 tests 100% 800 tests -10% -80 tests and more challenging with dedups
42. assumption input target calculation HTC target calculation DATIM indicator table SNU targets for EA allocation by IM PBAC IM targets the PBAC tab takes the targets allocated at the district-IM level in the previous tab, aggregating them to the IM level to be used in the PBAC for IM budgeting
43. assumption input target calculation HTC target calculation DATIM indicator table SNU targets for EA allocation by IM PBAC IM targets lastly, any changes made throughout the data pack should be documented in the change form in the last tab, documenting the change and rationale change form
44. site disagg targeting target calculation HTC target calculation DATIM indicator table site IM targets site disagg tool allocation by disagg data pack assumption input
45. a e d c b f pepfarlandia allocation by IM results distribution district b 70% im target snu target im 800 tests 560 tests 30% 240 tests recap 100% 800 tests
46. a e d c b f pepfarlandia allocation by IM and site results distribution district b im site target snu target im site 800 tests 20% 160 tests 20% 160 tests 20% 160 tests 30% 240 tests 10% 80 tests 1 2 3 1 2 560 tests 240 tests 70% 30% step 1 100% 800 tests
47. a e d c b f pepfarlandia allocation by IM and site results distribution district b im site target snu target im site 800 tests 20% 160 tests 20% 160 tests 20% 160 tests 30% 240 tests 10% 80 tests 1 2 3 1 2 560 tests 240 tests 70% 30% step 1 100% 800 tests
48. a e d c b f pepfarlandia allocation by IM and site results distribution district b, im site modality target im site target modality 20% 160 tests 1 index inpatient TB VMMC mobile VCT 10% 70% 32 16 112 step 2 100% 160
49. b 70% 800 tests 560 tests 30% 240 tests visualizing another way allocation by IM
50. b 1 2 3 1 2 allocation by IM and site 20% 160 tests 800 tests 20% 30% <15/F 15+/F <15/M 15+/M 10% 60% 5% 25% 16 96 8 40
51. considerations • ease of use/user experience • underlying purpose • time v. effort for country team, HQ, and partners • feasibility • nimbleness v. rigidity
52. the end