Purpose: This repo has been repurposed to host mathematical formulae and code-snippets for commonly derived PEPFAR indicators. When possible, code snippets will be provided R, python and Tableau (if applicable).
For example, Viral Load Coverage:
-
in plain text is the number of adult and pediatric ART patients with a viral load result documented in the patient medical record and/or laboratory records in the past 12 months divided by the number of adults and children currently receiving antiretroviral therapy (ART) two periods prior.
-
in mathematical notation it is
$VLC = TX_PVLS_D / TX_CURR_{lag_two_periods}$ -
in R this becomes
mutate(VLC = TX_PVLS_D / lag(TX_CURR, 2, order_by = period)
Tracking MSD, Genie, and Pano errors, along with their associated resolutions for the sake of transparency and benefit to data consumers.
Process:
Please submit an issue if there is an indicator you would like defined in plain text, mathematical notation and code snippet exmples.
If a team member identifies an issue an any of the above data sets or systems, or becomes alerted to one through other means, they should enter it in the Issues Tab and tag the issue with appropriate labels. Current label categories include:
- OU;
- Program/Tech Area; and
- Platform.
When submitting a ticket, select at least one label from each of these categories.
Screenshots documenting the issue should be placed in this folder or alternate so long as it's accessible to the SI team. When an issue is submitted, link to the screenshot(s) and any other relevant information.
The team member submitting the issue is also responsible for tracking resolution and updating tickets accordingly.
Disclaimer: The findings, interpretation, and conclusions expressed herein are those of the authors and do not necessarily reflect the views of United States Agency for International Development. All errors remain our own.