HFR Codebook - USAID-OHA-SI/Wavelength GitHub Wiki

SUBMITTED VARIABLES/COLUMNS

Variable Name	Variable Label	Acceptable Inputs
operatingunit	Operating Unit name	OU name as it appears in DATIM
fundingagency	Funding Agency	Funding Agency as it appears in DATIM, should only be USAID
date	HFR Week Start Date	see the HFR reporting period calendar foracceptable dates (Mondays), format: YYYY-MM-DD
snu1	OU defined Sub-National Unit (SNU), 1 level below country	SNU name as it appears in DATIM
psnu	OU defined Priority Sub-National Unit (PSNU)	PSNU name as it appears in DATIM
community	OU defined community geographic level	Community name as it appears in DATIM
orgunit	OU defined facility geographic level	Facility name as it appears in DATIM
orgunituid	Organizational Unit Unique Identifier (UID)	Community/Facility UID as it appears in DATIM
partner	Implementing partner (IP) name	IP name, preferably as it appears in DATIM
mechanismid	Implementing mechanism ID	Implementing mechanism ID as it appears in DATIM; numbers only, XXXXX
indicator	HFR indicators	HTS_TST, HTS_TST_POS, TX_NEW, PrEP_NEW, VMMC_CIRC, TX_CURR, TX_MMD
agecoarse	Coarse Age disaggregates	<15, 15+, Unknown
sex	Sex disaggregate	Female, Male, Unspecified
otherdisaggregate	Other disaggregate not defined in the specific disaggregates	for Period: 1 month, 2, months, 3 months, 4-5 months, 6 months or more
val	HFR value reported for a given date	[positive number]

HFRG CALCULATED VARIABLE/COLUMNS

Variable Name	Variable Label	Values
fy	Fiscal Year	reporting fiscal year, format: YYYY
hfr_pd	HFR Reporting Period	see the HFR reporting period calendar for numbering
mer_results	MER Cumulative Results	Cumulative MER results pulled from DATIM (API)
mer_targets	MER Fiscal Year Targets	Cumulative MER targets pulled from DATIM (API)
targets_gap	MER Target Gap	Calculated: mer_targets - mer_results
weekly_targets	MER Weekly Targets	Calculated: mer_targets/52
weekly_targets_gap	MER Target Gap per Week for the Remaining Weeks	Calculated: targets_gap/ weeks remaining in fiscal year