DATIM

PEPFAR FY19 Q1, Q2 and Q3 MER Canned Cleaning Favorites Guidance

Timothy Harding -

PEPFAR FY2019 Q1, Q2 & Q3 MER Canned Cleaning Favorites

PRIME has created canned cleaning favorites for FY2019 Quarter 1, Quarter 2 and Quarter 3 MER indicators to be used by field teams to perform quality control checks on their data. These canned favorites are in the form of pivot tables and are accessible via DATIM.

PURPOSE: These canned cleaning favorites are created as a starting point for reviewing FY19 Q1, Q2 and Q3 entered data. These canned favorites’ layouts emulate the MER data entry screen. This allows for DATIM users to review the totals of MER indicators and if the totals are not equal to the users’ expected result, users can look at the disaggregated data to see where a data error is present. 

These canned favorites also include the MER indicators that are calculated by auto-summing data entered into other indicators and/or disaggregates (i.e. VMMC_CIRC, HTS_TST numerator, HTS_RECENT numerator, etc.). Users should use these tables to check if their auto-summed indicator value is accurate. If not, users may use the canned favorite table to check in which indicator/disaggregate the data error occurred and clean accordingly during the data cleaning period.

NAMING CONVENTION: In DATIM’s pivot table app, each canned cleaning favorite has the following naming convention:

PEPFAR FY19Q1 Results <Indicator> <’N’ or ‘D’><Disaggregation, if any> Completeness Review Pivot

The ’N’ or ‘D’ represents Numerator or Denominator. For example, for the numerator of PMTCT_STAT disaggregated by Age/Sex/KnownNewResult, the canned cleaning favorite is named:

“PEPFAR FY19Q1 Results PMTCT_STAT N AUTO-SUM Age/Sex/KnownNewResult Completeness Review Pivot”

Note: if the indicator is calculated by auto-summing other indicators and/or disaggregates, “AUTO-SUM” will be present in the favorite’s name (as seen in above example).

HOW TO USE: Starting from a canned favorite, DATIM users may use the group set options on the left side of the Pivot Table app to customize the canned favorite for their own use. After customization, users may also save the edited favorite under a new name to retain the favorite for future use.

ACCESS: DATIM users can access the canned favorites by following the HTML report of the quarter they want to look at. For FY19Q1, users should click on the “MER Results Cleaning Favorites FY2019Q1” link in the MER FY19 Q1, Q2 and Q3 Cleaning Favorites dashboard that is on the DATIM homepage. For FY19Q2, users should click on the “MER Results Cleaning Favorites FY2019Q2” link in the same dashboard. For FY19Q3, users should click on the “MER Results Cleaning Favorites FY2019Q3” link in the same dashboard. If you do not have access to this dashboard, please submit a Zen Desk ticket requesting access.

HTML REPORT FORMAT: The report is structured following the clinical cascade. The hyperlinked text informs users what indicator and disaggregation combination it will redirect to. The link will redirect users to the canned cleaning favorite in DATIM. There are also headers for each set of indicators. Hyperlinked text with “Auto-calculated” in the text indicates these are MER indicators created through the auto-summing of indicators and/or disaggregates.

Cleaning Favorites Released: Indicators by Quarters

FY19 Quarter 1

FY19 Quarter 2

FY19 Quarter 3
HTS_INDEX_COM
HTS_INDEX_FAC
HTS_RECENT
HTS_SELF
HTS_TST
PMTCT_ART
PMTCT_EID
PMTCT_HEI_POS
PMTCT_STAT
TB_ART
TB_STAT
TX_CURR
TX_NEW
TX_PVLS
VMMC_CIRC
HTS_INDEX_COM
HTS_INDEX_FAC
HTS_RECENT
HTS_SELF
HTS_TST
PMTCT_ART
PMTCT_EID
PMTCT_HEI_POS
PMTCT_STAT
TB_ART
TB_STAT
TX_CURR
TX_NEW
TX_PVLS
VMMC_CIRC
CXCA_TX
CXCA_SCRN
KP_PREV
OVC_HIVSTAT
OVC_SERV
PP_PREV
PrEP_CURR
PrEP_NEW
TB_PREV
TX_ML
TX_TB
HTS_INDEX_COM
HTS_INDEX_FAC
HTS_RECENT
HTS_SELF
HTS_TST
PMTCT_ART
PMTCT_EID
PMTCT_HEI_POS
PMTCT_STAT
TB_ART
TB_STAT
TX_CURR
TX_NEW
TX_PVLS
VMMC_CIRC

* Bolded indicators denotes the indicators that are in the FY19Q2 cleaning favorites that are not in the FY19Q1 or Q3 cleaning favorites because these indicators are semi-annual indicators.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk