Overall Workbook Suggested Updates

[kgichuhi]

• [ ] Be sure to indicate on each tab what the intent is - why should the user 'care'? For instance if the positivity rates are increasing or are high - flag for TA?

• [x] Include a tab that provides the instructions and considerations for use similar to what we do for other tools

• [x] If we want to strengthen our ability to target TA then when we select a country we should also be able to select SNU/PSNU as well

[davidcreightonsullivan]

• [x] peds overall testing & linkage data on HEI dashboard for program context

[davidcreightonsullivan]

wonder about utility of <1 testing data... does it reflect those who weren't picked up by pmtct or data reporting errors?

[KatieOC]

@nmcdavid I am moving Rachel's feedback to here: Thanks for sharing, Nashiva, and apologies for the late reply. I hope last week's call went well.

A few quick thoughts:

Wow!! Thanks for all of your work! I really like being able to have high level view across OUs with the option to do a deeper dive. This dashboard seems much more user friendly than Panorama.

• [x] Ilikely missed this, so feel free to point me in the right direction -- any thoughts on comparing the PMTCT_EID indicator with PMTCT_STAT as a proxy for EID coverage? Again, I may have missed this.

• [x] On the 3rd tab (PMTCT_EID Proxy Positivity) -- is this positivity or yield? I know the terms are often used interchangeably and I'm trying to force myself to use them correctly. :)

• [x] On the 4th tab (PMTCT_HEI_POS Linkage) - Just want to confirm this is proxy linkage. Also, do you know if the "positives" represent DBS results sent and received before 2m of age? Or just sent before 2m of age?

• [x] In general, I have some reservations with using HTS_TST for infants as some countries have universal rapid testing for all babies regardless of HIV exposure -- I'm not sure how, if at all, this may impact data collection/reporting despite guidance to not include these data points.

• [x] Do you know if any quick checks have been done to ensure that HTS_TST < 1y is less than PMTCT_EID 0 - 12m for all OUs as all positive rapid tests (HTS_TST) should be followed up with a DBS (PMTCT_EID).

[KatieOC]

@megitoh after our call, can you add the CDC's team feedback here? To add the check boxes, just select the "check" icon which is to the right of the bullet/number icon in the ribbon right about this chat box. Thanks!

[megitoh]

General comments from CDC HEI unit (Helen, Michele and Meg)

• [x] Is it possible to add ability to do deep-dive analyses by PSNUs as well?
• [x] Need a tab that looks at PMTCT cascade and EID coverage (# EID tests sent by 2mo/PMTCT_STAT_POS for 2mo coverage, EID by 12 mo/PMTCT_STAT_POS for 12mo coverage)
• [ ] To get at a more accurate denominator for EID coverage, would want to include disagg for breastfeeding women who are tested positive during BF. Consider adding a separate tab that looks at the true denominator (PMTCT_STAT_POS plus HTS_TST_POS or TX_NEW during breastfeeding). Also, this could be where we add TX_PVLS among breastfeeding women now that this indicator will be monitored quarterly

Specific comments on each tab: Data Quality Considerations tab

• [x] Filters do not seem to be working??
• [x] Unclear why we need to look at % difference between HTS_TST and PMTCT_EID other than to suggest to countries they’re likely reporting HTS_TST incorrectly

PMTCT_EID Proxy Positivity tab

• [x] Compare <=2mo vs. <=12 mo (not 2-12mo)
• [ ] Show only the proxy positivity in graph (no need to show PMTCT_EID volume since that would be covered in a different tab)
• [x] Call out data labels on the positivity rates
• [x] Deep dive by PSNU From the call

PMTCT_HEI_POS Linkage tab

• [ ] Would be useful to show comparison of linkages using HEI_POS_ART vs. TX_NEW<1 (currently the linkage appears to be using HEI_POS_ART)
• [ ] Titles of the last two graphs should reflect linkage From the call (happy to make changes directly on the tool at a later date)
• [x] Correct the yellow dots in the ‘PMTCT_HEI_POS among infants <=2 mo, by OU’ graph to indicate linkage
• [x] < 2mo and <12mo (not 2-12mo)
• [ ] Should we re-consider the conditional formatting for linkage? Are we using the same classification for linkage as for adults? Should we be setting a higher bar for linkage of infants? This may be a question for the larger group and can discuss at the call next week
• [ ] Add an OU table for linkage (similar to the “linkage” tab in our template example (see below))

HTSTST linkage to TX_NEW <1 tab

• [x] Consider deleting this tab?

TX_NEW vs. HEI_POS_ART tab

• [x] This is great. No comments

Copy of Draft OU analysis template for FY18_22Mar2018.xlsx This is a template we had created a while back on analyses we'd like to see in the dashboard. Could we consider incorporating the following tabs into the dashboard?

OU Quarterly cumulative tab

• [x] Move the coverage columns before the APR18 cum/APR17 result ratio columns (which basically gets at how the numerator/denominator for EID coverage calculation changed compared to last year)

Trend data tab

• [x] Consider adding spark lines to look at visualize trend

Target analysis tab

• [x] Add as a static table to the dashboard to look at ambitiousness of targets

Linkage tab

• [ ] This can be incorporated into the HEI dashboard ‘PMTCT_HEI_POS Linkage’ tab and show it in a table format below the graph by OU.
• [ ] Also, compare linkages using HEI_POS_ART vs. TX_NEW <1

[KatieOC]

here is the link to a folder which contains an example of the Zambia VL dashboard for the structure for site level tool: https://www.pepfar.net/OGAC-HQ/icpi/Shared%20Documents/Forms/AllItems.aspx?RootFolder=%2FOGAC%2DHQ%2Ficpi%2FShared%20Documents%2FClusters%2FHIV%2DTB%20Diagnosis%2FProjects%2FHEI%20Dashboard%2Fworking%2Fexample%20tools&FolderCTID=0x01200080CC6F83D1766F4D9E3497D4529EC74A&View=%7B94C838B2%2DE166%2D4122%2DB8B4%2D7BEB9E1BC12B%7D

[nmcdavid]

@kgichuhi

• I'll be adding a table of contents in the next draft the explains what each tab is intended for and what questions the visuals and tables address. The tab will include links to the tabs (similar to the CHiPs tool)

[nmcdavid]

rachel golin -https://github.com/ICPI/HEI-Dashboard/issues/6#issuecomment-406640685

This is proxy positivity, according to the indicator reference definition for HEI_POS

I likely missed this, so feel free to point me in the right direction -- any thoughts on comparing the PMTCT_EID indicator with PMTCT_STAT as a proxy for EID coverage? Again, I may have missed this.

• I do plan on adding this to the tool set. This metric is available in the panorama dashboard but it wouldn't be a problem to add this to the HEI Dashboard

On the 3rd tab (PMTCT_EID Proxy Positivity) -- is this positivity or yield? I know the terms are often used interchangeably and I'm trying to force myself to use them correctly. :)

• This is proxy positivity, according to the indicator reference definition for HEI_POS

On the 4th tab (PMTCT_HEI_POS Linkage) - Just want to confirm this is proxy linkage. Also, do you know if the "positives" represent DBS results sent and received before 2m of age? Or just sent before 2m of age?

• The indicator reference sheet doesn't define this as proxy but as linkage in general. The positive represent virological samples collected <2 months, regardless of when results were returned. Below are sections from the MER guidance
• The numerator is divided into HIV-infected infants who had their diagnostic sample collected for virologic testing between birth and 2 months of age and those whose diagnostic sample was collected between 2 and 12 months of age. The 0- ≤2 month and 2-12-month time periods are based on age at sample collection for virologic HIV testing, not on date of result available to the facility or caregiver. HIV-infected infants should be reported in the quarterly time period in which they are identified, even if the sample was collected/sent in the previous quarter; their age should be reported by age at the time of collection of the sample that produced the positive result, and not the age when the result was available to the site.
• Example scenario to clarify time period and age: an infant has a DBS collected in quarter 3, aged 11 months. Due to long turnaround times, the positive result returns to the site in quarter 4 and staff now identify him/her as HIV-infected at 13 months old. This infant should be counted in quarter 4 as HIV-infected, and his/her age should be reported as 11 months (2-12mo age band)
• HEI_POS_ART - An HIV-infected infant reported as “ART initiation confirmed” should have documentation of an ART regimen in their record. An HIV-infected infant whose record includes documentation of “referred to ART” or an ART clinic number without evidence of receipt of an ART regimen should not be reported as “ART initiation confirmed.” ART does not include infant ARV prophylaxis regimens for PMTCT."

In general, I have some reservations with using HTS_TST for infants as some countries have universal rapid testing for all babies regardless of HIV exposure -- I'm not sure how, if at all, this may impact data collection/reporting despite guidance to not include these data points. Do you know if any quick checks have been done to ensure that HTS_TST < 1y is less than PMTCT_EID 0 - 12m for all OUs as all positive rapid tests (HTS_TST) should be followed up with a DBS (PMTCT_EID).

• I understand the concern and was brought up during our first HEI call. Part of the reason I added the data quality consideration tab is because I know that some folks who want to look at <1 data sometimes go straight to HTS_TST instead of PMTCT_EID and I was hoping to highlight which OUs or Partners might be collecting/reporting the data incorrectly.
• This tab has been removed