Data Entry Instruction Sheet
Uganda Health Workforce Retention Study
1. Enter the Questionnaire Number from the top right corner of page 1 into the column titled “SurveyID” in the spreadsheet.
2. Enter the Interviewer ID Number in the column titled InterviewerID. See the list below for names of interviewers and corresponding ID numbers.
1
1 – Sindhu Ramalingam
2 – Miriam Nakalenbe
3 – Sanne Visser
4 – Ivy Kagere
5 – Miriam Nansunga
6 – Patrick Bateganya
7 – Charles Isabirye
8 – Teophista Kabalisa
9 – Tom Ngabirano
10 – Emily Bancroft
11 – Ann Kajoina
12 – Tony Mukooyo
13 – Daniel Talemwa
14 – Esther Nderitu
15 – Mercy Muwema
16 – Allen Meeme
17 – Albert Ssebiddee
18 – David Wajumbuka
1
3. Enter the Date of Interview from the top right hand box into the column called InterviewDate.
Begin entering data from the completed questionnaire, using the codes listed below.
SECTION I
A. District Name
1 – Mbarara/Ntungamo2 – Kibale
3 – Kampala
4 – Mbale/Sironko
5 – Nebbi / 6 – Kabarole
7 – Apac
8 – Gulu
9 - Moyo
B. Facility Name
00 – Kibuli Muslim Hospital01 – Itojo
02 – Ibanda
03 – Kagadi
04 – Private Hospital in Kibale
05 – Mulago
06 – Rubaga
07 – Mbale Regional Referral Hospital
08 – Muslim Hospital
09 – Nebbi Hospital / 10. Angal Hospital
11. Buhinga Hospital
12. Virika Hospital
13. Apac Hospital
14. Aber Hospital
15. Gulu Hospital
16. Lacor Hospital
17. Moyo Hospital
18. Moyo Mission
C. What is your cadre?
Enter the number corresponding to the type of cadre (for example, enter 4 for Pharmacy). Then type the text from “Specify Type” into the column titled “CadreSpecify.”
D. Type the current job title.
E. Enter the number corresponding to the circles answer (for example, 1 for yes and 2 for no)
E1. Enter the number.
E2. Type the response
E3. Type the response.
E4. Type the response.
E5. Enter the number that corresponds with the answer choice.
E6. Enter the answer in MONTHS by multiplying the number of years by 12 and adding the number of months.
E7. Type the response.
NOTE: E1 – E7 will be blank for STAYERS.
SECTION II
1. Enter 1 for male and 2 for female.
2. Enter the year
3. Enter 1 for Uganda and 2 for other. Enter name of location in “3 (Other)” if not Uganda.
3.1 Enter the code for the district from the list below.
1 – Adjumani2 – Arua
3 – Moyo
4 – Nebbi
5 – Yumbe
6 – Apac
7 – Gulu
8 – Kitgum
9 – Lira
10 – Pader
11 – Katakwi
12 – Kotido
13 – Moroto
14 – Nakapiripirit
15 – Bugiri
16 – Busia
17 – Iganga
18 – Jinja
19 – Kaberamaido
20 – Kamuli
21 – Kapchorwa
22 – Kumi
23 – Mayuge
24 – Mbale
25 – Pallisa
26 – Sironko
27 – Soroti
28 – Tororo / 29 – Kalangala
30 – Kampala
31 – Kayunga
32 – Kiboga
33 – Luweero
34 – Masaka
35 – Mpigi
36 – Mubende
37 – Mukono
38 – Nakasongola
39 – Rakai
40 – Sembabule
41 – Wakiso
42 – Bushenyi
43 – Kabale
44 – Kanungu
45 – Kisoro
46 – Mbarara
47 – Ntungamo
48 – Rukungiri
49 – Bundibugyo
50 – Hoima
51 – Kabarole
52 – Kamwenge
53 – Kaseses
54 – Kibale
55 – Kyenjojo
56 - Masindi
4. Enter the number corresponding to their answer.
5. Enter the number corresponding to the answer.
5.1 Enter the number
5.2 Enter the age in MONTHS by multiplying 12 by the number of years and adding the number of months.
5.3 Enter the age in MONTHS by multiplying 12 by the number of years and adding the number of months.
6. Type their answer.
7. Enter the year (YYYY).
8. Enter the year (YYYY).
9. Enter the time in MONTHS by multiplying 12 by the number of years and adding the number of months.
10. Enter the time in MONTHS by multiplying 12 by the number of years and adding the number of months.
11. Enter the number that corresponds with the answer.
Section III
Enter the number in the box that is circled or checked on the questionnaire in the corresponding space in the spreadsheet. If you are entering a LEAVER questionnaire, enter the rating for the past job in column a and the answer for the current job in column b. If you are entering a STAYER questionnaire, leave column a blank and enter the rating for the CURRENT job in column b.
Section IV
Same instructions as Section III.
Section V
Enter the number that corresponds with the answer in the box on the spreadsheet.
Section VI
Same instructions as Section III.
Section VII
Enter the number that corresponds with the answer in the box on the spreadsheet.
Section VIII
Enter the number that corresponds with the answer in the box on the spreadsheet.
Section IX
Type the text exactly as written on the questionnaire in the appropriate boxes on the spreadsheet. Enter the number that corresponds with the correct answer for questions 78 and 79. If no answer, leave blank.
Section X
Type the text exactly as written on the questionnaire in the appropriate boxes on the spreadsheet. Enter the number that corresponds with the correct answer for questions 78 and 79. If no answer, leave blank.
1