Data cleaning process for HIV-indicator data extracted from DHIS2 national reporting system: a case study of Kenya

Table 2 Example of sectional illustration of first data set containing facility records

Year	Organisation unit	CPC-HCT	RR-HCT	RRT-HCT	CPC-BS	RR-BS	RRT-BS	Avg-CPC	Avg-RR	Avg-RRT
2016	Facility A	0	0	0	0	0	0	0	0	0
2016	Facility B	0	0	0	0	0	0	0	0	0
2017	Facility C	10	90	80	100	90	80	50	60	50

CPC cumulative percentage completion, RR-HCT reporting rate HIV counselling and testing, RRT reporting rate on time, BS blood safety, Avg average, ** remaining four reports with the same variable sequence

ISSN: 1472-6947