Title: Full Deliveries by Product
Description/purpose
Calculate the percentage of health units that received a “full delivery” of PAV related supplies during a field coordinator’s site visit.
Definitions
- Full Delivery Event = when a field coordinator delivers enough stock of either a vaccine so that the Health Unit stock amount after the delivery of that item is greater than or equal to that item’s Ideal Stock Amount. True or False.
- Full Delivery = Existing Stock + Delivered Stock ≥ Ideal Stock Amount (this equation represents the full delivery statistic per item)
- Ideal Stock Amount = is the amount of stock for that item required at the health unit. This number is derived from the estimated target group number for that specific item. This metric (wheither the default calculation or the over-ridden amount) is stored in the visit record by the OpenLMIS system.
- Existing Stock: is the amount of stock of an item present when the field coordinator visits a health unit.
- Distributed Stock: is the amount of stock of an item the field coordinator delivers to the health unit.
- % of health units receiving full delivery of items
Metric Requirements
Calculation Notes
A Full Delivery occurs when the delivered stock amount plus the existing stock amount is greater than or equal to the ideal stock amount. This is a binary event, either it happened or it didn’t.
If a facility is not visited, there is not a full delivery
| Visited | Existing + Delivered >= ISA for at least one vial size | Full Delivery |
|---|---|---|
| Y | Y | Y |
| Y | N | N |
| N | n/a | N |
Full Delivery Instance Calculation:
Distributed Stock (converted to doses) + Existing Stock (converted to doses) ≥ Ideal Stock Amount
This information comes from the EPI Inventory tab (Section 3 on the Monthly Data Collection Form). Note that the distributed and existing stock values are entered in vials, while the ISA amount is in doses.
Tableau Calculation
sum(if
(((zn([epi_inventory_penta1_existing])+zn([epi_inventory_penta1_delivered])) * [Doses per Vial - Penta1]) >= [epi_inventory_penta1_isa])
or (((zn([epi_inventory_penta10_existing])+zn([epi_inventory_penta10_delivered])) * [Doses per Vial - Penta10]) >= [epi_inventory_penta10_isa])
then 1 else 0
end)
Calculation/aggregation Rules
- If existing quantity is marked as N/R, this is converted to a zero for the purposes of this calculation
- Only visited health units (health units not visited during the period are EXCLUDED) are included in this report.
- NOTE: The rule for Polio and Penta are more complex because there are two vial sizes (10 and 20). If either vial size is fully delivered, then it counts as fully delivered.
[MK1]Update based on determining methodology to combine product ISA’s into product group ISAs.