...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Delivery Zone: North Gaza
| Data Entry | Expected Result | |||||||||
| Scenario | Did You Visit? | No Visit Reason | Child Coverage Tab - Enter Form N/A? | Child Coverage: Polio 2 0-11 months HC | Child Coverage: Polio 2 12-23 mos | Health Units Visited | Health Units Reporting | Polio 2 Child Coverage Rate |
| |
|---|---|---|---|---|---|---|---|---|---|---|
Health unit was visited. Child coverage data 0-11 mos provided G095 Chidulo, Chicualacuala | Yes | irrelevant | No - enter data | 50 / 1 | 10 / 20 | 1 | 1 | 51/target group (58) | ||
Health unit was visitied. No children 0-11 months immunized with Polio 2. G097, Cs, Chicualacuala | Yes | irrelevant | No - enter data | 0 | 5 Polio 2: 5/1 | 1 | 1 | 0% | ||
Health unit was visited. Child coverage data is n/a. G097, Cs, Chicualacuala | Yes | irrelevant | No - enter data | Polio 3: "n/a" | Polio 3: 5/1 | 1 | 1 | Null | ||
Health unit wasn't visited. No Routine data reported. G104, Lithatha, Chicualacuala | No | any value | Yes - "n/a" whole form | "n/a" | 0 | 0 | Null | |||
Health unit wasn't visited. Routine data was reported G108, Mahathane, Chicualacuala | No | any value | No - enter data
| any number 2 | 0 | 1 | % 7% | |||
Full Deliveries
...
Polio 20
Delivered
Quantity
...
Health Unit Not Visited, No Routine Data
G098, Cs Dindiza, Chigubo BCG
G098, Cs Dindiza, Chigubo BCG
...
Health Unit Visited, Routine Data
G108, Mahathane, Chicualacuala BCG
...
Child Coverage Test Cases
Delivery Zone: North Gaza
| Data Entry | Expected Result | ||||||||||
| Scenario | Did You Visit? | No Visit Reason | Child Coverage Tab - Enter Form N/A? | Child Coverage: Polio 2 0-11 months HC | Child Coverage: Polio 2 12-23 mos | HU IN Prog | Health Units Visited | Health Units Reporting | Polio 2 Child Coverage Rate |
| |
|---|---|---|---|---|---|---|---|---|---|---|---|
Health unit was visited. Child coverage data 0-11 mos provided G095 Chidulo, Chicualacuala | Yes
| irrelevant | No - enter data | 50 / 1 / 1 | 10 / 20 | 1 | 1 OK | 1 OK | 2/target group (58) OK | ||
Health unit was visitied. No children 0-11 months immunized with Polio 2. G097, Cs, Chicualacuala | Yes | irrelevant | No - enter data | 0 | 5 Polio 2: 5/1 | 1 | 1 OK | 1 OK | 0% OK | ||
Health unit was visited. Child coverage data is n/a. G097, Cs, Chicualacuala | Yes | irrelevant | No - enter data | Polio 3: "n/a" | Polio 3: 5/1 | 1 | 1 OK | 1 OK | Null FAIL SELV-120 | ||
Health unit wasn't visited. No Routine data reported. G104, Lithatha, Chicualacuala | No | Not "Not in Prog" | Yes - "n/a" whole form | "n/a" | 1 OK | 0 OK | 0 OK | Null FAIL SELV-120 | |||
Health unit wasn't visited. Routine data was reported G108, Mahathane, Chicualacuala | No | Not "Not in Prog" | No - enter data
| any number 2 | 1 OK | 0 OK | 1 OK | % 7% OK | |||
Full Deliveries
| Set-Up | Result | |||||||||||
| Scenario | Did You Visit | BCG Delivered Quantity | Polio 10 Delivered Quantity | Polio 20 Delivered Quantity | Child Coverage Tab - Enter Form N/A? | Full Delivery BCG Expected | Full Delivery BCG Actual 21a | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
Health Unit Not Visited, No Routine Data G098, Cs Dindiza, Chigubo BCG G098, Cs Dindiza, Chigubo BCG
| No | irrelevant | Yes - "n/a" whole form | 0 | 0 OK | |||||||
Health Unit Visited, Routine Data G108, Mahathane, Chicualacuala BCG | No | irrelevant | No - enter data | 0 | 0 OK | |||||||
Health Unit Visited, BCG (single vial size) exact full delivery G095 Chidulo, Chicualacuala BCG | Yes | integer, select value so that existing + delivered = ISA | irrelevant | 1 | 1 OK | |||||||
Health Unit Visited, BCG (single vial size) more than full delivery G097, Cs, Chicualacuala BCg | Yes | integer, select value so that existing + deliver > ISA 30 / 10/ 21/ 0 | irrelevant | 1 | 1 OK | |||||||
Health Unit Visited, BCG (single vial size) exact less than full delivery G095 Chidulo, Chicualacuala G102 Cubo, Chigubo - BCG | Yes | integer, select value so that existing + delivered =< ISA 30/19/10/1 | irrelevant | 10 | 0 OK | |||||||
Health Unit Visited, BCG (single vial size) more than full delivery G097, Cs, Chicualacuala BCg | Yes | integer, select value so that existing + deliver > ISA 30 / 10/ 21/ 00 delivered G102 Cubo, Chigubo - PCV10 | Yes | 0 PCV10 : 1/0/N/R | irrelevant | PCV 10: 0 | 1 0 OK | |||||
Health Unit | Visited, BCG (single vial size) less than full deliveryVisitied, Existing Quantity >= ISA G102 Cubo, Chigubo - | BCGSarampo | Yes | integer, select value so that existing + delivered < ISA 30/19/10/1Existing Quantity >= ISA Delivered Quantity = 0 | irrelevant | 0 | Sarampo (measles): 1 | 1 OK | ||||
Health Unit Visited, BCG Polio (single multi vial size) 0 deliveredG102 Cubo, Chigubo - PCV10- Polio 20 in stock, Polio 20 delivered, >= ISA G097, Cs, Chicualacuala Polio | Yes | 0PCV10 : 1/0/N/R | integer, select value so that existing + deliver > ISA 13 / 10 / 3 / 1 | irrelevant1 | PCV 10: 0 | 1 OK | ||||||
Health Unit Visitied, Existing Quantity >= ISA G102 Cubo, Chigubo - Sarampo | Yes | Existing Quantity >= ISA Delivered Quantity = Visited, Penta (multi vial size) - Polio 20 in stock, Polio 20 delivered, < ISA G097, Cs, Chicualacuala Penta | Yes | 0 | integer, select value so that existing + deliver < ISA 19/2/10/0 | 0 | Sarampo: 1 FAIL | |||||
Health Unit Visited, Polio (multi vial size) - Polio 20 in stock, Polio 20 10 delivered, >= ISA G097, Cs, Chicualacuala G102 Cubo, Chigubo Polio | Yes | 0 | integer, select value so that existing + deliver >= ISA 13 / 10 / 3 / 1Polio 10 ISA 5, Polio 20 ISA 2 Polio 10 Exisiting 0, Polio 20 Exist 1 Polio 10 Del 3, Polio 20 Del 0 | 0 | 1 | 1 OK | ||||||
Health Unit Visited, Penta Polio (multi vial size) - Polio 20 in stock, Polio 20 10 delivered, < ISA G097, Cs, Chicualacuala G102 Cubo, Chigubo - Penta | Yes | 0 | integer, select value so that existing + deliver < ISA 19/2/10/Penta 1 ISA 34, 10 ISA 3 Pent 1 Exit 20, Penta 10 Exist 0 Penta 1 Del 0, Penta 10 Del 1 | 0 | 0 | 1 FAIL | ||||||
Health Unit Visited, Polio (multi vial size) - Polio 20 10 in stock, Polio 10 20 delivered , >= ISA G102 CuboG107 Machaila, Chigubo Polio | Yes | 0 Polio 10: 10/ 2/ 0 Polio 20: 5/0/4 | integer, select value so that existing + deliver > = ISA Polio 10 ISA 5, Polio 20 ISA 2 Polio 10 Exisiting 0, Polio 20 Exist 1 Polio 10 Del 3, Polio 20 Del 0 | 0 | 1 | 1 OK | ||||||
Health Unit Visited, Polio (multi vial size) - Polio 20 10 in stock, Polio 10 20 delivered , < ISA G102 CuboG107 Machaila, Chigubo - Penta | Yes | integer, select value so that existing + deliver < ISA0 Penta 1 ISA 34, 10 ISA 3 Pent 1 Exit 20, Penta 10 Exist 0 Penta 1 Del 0, Penta 10 Del 1 0: 10/0/0 Penta 10: 0/6/0 | integer, select value so that existing + deliver < ISA | 0 | 1 FAIL | |||||||
Health Unit Visited, Polio (multi vial size) - Polio 10 in stock, Polio 20 10 delivered >= ISA G107 MachailaG113 Nhanale, Chigubo Polio | Yes | 0 Polio 10: 10/ 2/ 0 Polio 20: 5/0/4 | integer, select value so that existing + deliver >= ISA | 0 | 1 | 1 OK | ||||||
Health Unit Visited, Polio (multi vial size) - Polio 10 in stocked out stock, Polio 20 10 delivered < >= ISA G107 MachailaG13 Nhanale, Chigubo Penta | Yes | 0 | Penta 1 dose: 1075 /0/075 Penta 10 dose: 0/60/0 | integer, select value so that existing + deliver < ISA | 1 | 0 | 0 - This should not be a stock-out! If there is Polio 10 OR Polio 20 not stocked out. 1 OK | |||||
Health Unit Visited, Polio (multi vial size) - Polio 10 in stock, Polio 10 delivered >= < ISA G113 NhanaleG117 Saute, Chigubo Polio | Yes | integer, select value so that existing + deliver >= < ISA | 0 | 0 | 1 0FAIL | |||||||
Health Unit Visited, Polio (multi vial size) - Polio 10 stocked out 20 in stock, Polio 10 20 delivered >= < ISAG13 Nhanale G117 Saute, Chigubo - Penta | Yes | 1 dose: 75 38/0/0/750 10 dose: 0/0/0 | 1 | 1 - both sizes stocked out | ||||||||
Health Unit Visited, Polio (multi vial size) - Polio 10 in stock, Polio 10 delivered < ISA G117 Saute, Chigubo
| Yes | integer, select value so that existing + deliver < ISA | 0 | 0 | ||||||||
Health Unit Visited, Polio (multi vial size) - Polio 20 in stock, Polio 20 delivered < ISA G117 Saute, Chigubo - Penta | Yes | 1 dose: 38/0/0/0 10 dose:4/2/1/1 | 0 | 0 | ||||||||
Stock Outs
- If not visited, no stock out
Mahathane, Chicualacuala,
Lithatha, Chicualacuala - If any product existing quantity = 0, stock out = 1
- If existing quantity = n/a, doesn't count
G095. Chidulo, Chicualacuala. Entire form N/A, Stock Out Should = 0 - G097 Cs, Chicualacuala. Penta Inventory 0. Stock Out Should = 1
- If existing quantity = n/a, doesn't count
- G109 Mapai, Chicualacuala: 5ml Syringe ISA=0, Existing quantity=0, Stock Out should be 0 (stock outs should only look at vaccine products)
- G111 Mepuzi, Chicualacuala: Safety Box ISA=null, Existing quantity=0, Stock Out should be 0 (stock outs should only look at vaccine products)
No Visit Reason*
...
4/2/1/1 | 0 | 1 FAIL |
All full deliveries errors on ticket SEVL-126
Stock Outs
- If not visited, no stock out
Mahathane, Chicualacuala,
Lithatha, Chicualacuala - If any product existing quantity = 0, stock out = 1
- If existing quantity = n/a, doesn't count
G095. Chidulo, Chicualacuala. Entire form N/A, Stock Out Should = 0 - G097 Cs, Chicualacuala. Penta Inventory 0. Stock Out Should = 1
- If existing quantity = n/a, doesn't count
- G109 Mapai, Chicualacuala: 5ml Syringe ISA=0, Existing quantity=0, Stock Out should be 0 (stock outs should only look at vaccine products)
G111 Mepuzi, Chicualacuala: Safety Box ISA=null, Existing quantity=0, Stock Out should be 0 (stock outs should only look at vaccine products)
Facility Expected Stockout Results Mahathane, Chicualacuala none (not visited) 0 Lithatha, Chicualacuala none (not visited) 0 G095. Chidulo, Chicualacuala 0 0 G097 Cs, Chicualacuala 1 0 FAIL
OK SJG109 Mapai, Chicualacuala 0 0 G111 Mepuzi, Chicualacuala 0 0
No Visit Reason*
Not in Program
G115 Pafuri, Chicualacuala.
Not Visitied / Not in DLS
Expected Result:
HU In Program = 0
HU Visitied = 0
No Fuel or Per Diem
G098, Cs Dindiza, Chigubo
Not Visitied / Not Fuel or Per Diem
Expected Result:
HU In Program = 1
HU Visitied = 0
Not Visited with Visit Data
G072 Zulo, Massingir
Will it sync with this in the distribution?
| Facility | Expected Result HU in Program | Actual Result 21a HU in program | Expected Result HU Visited | Actual Result 21a HU Visited |
|---|---|---|---|---|
| G115 Pafuri, Chicualacuala. |
Not Visitied / Not in DLS
...
| 0 | 0 |
...
| 0 |
...
| 0 |
| G098, Cs Dindiza, Chigubo |
Not Visitied / Not Fuel or Per Diem
HU In Program = 1
HU Visitied = 0
Not Visited with Visit Data
G072 Zulo, Massingir
...
| 1 | 1 | 0 | 0 | |
| G072 Zulo, Massingir (see above) | ? OK SJ | 1 | ? | 0 |
Delivery Intervals:
Find 4 facilities and determine the last visit date using Tableau (or have Josh look)
Expected
ResultActual Result ID Last Visit March Visit Date Days Interval G110Chibotane, Massingir 12/23 1/25 33 < 33 < 33 OK G027Cs, Massingir 12/23 1/26 34 34-40 34-40 OK G056Mucatine, Massingir 12/23 2/1 40 34-40 34-40 OK G103 Cubo, Massingir 12/23 2/2 41 41-47 41-47 OK
- For each facility, hand-calculate the a visit that is at each delivery interval boundary:
- <= 33, 34-40, 41-47, 48+
- 33, 34, 35
- 39, 40, 41, 42
- 47, 48
- ,
- <= 33, 34-40, 41-47, 48+