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

Full Delivery Calculation - Products with Single Vial Size

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.

Calculation: Delivered Stock (in doses) + Existing Stock (in doses) >= ISA (in doses)

If a facility is not visited, there is not a full delivery

Full Delivery Calculation - Products with Multiple Vial Sizes (Polio 10 dose, 20 dose & Penta 1 dose, 10 dose)

For products with multiple vial sizes, a Full Delivery occurs when the delivered stock plus existing stock of both vial sizes is greater than the ideal stock amount.The ideal stock amount is the number of doses of the vaccine needed at the health center, regardless of vial size. For example, the ideal stock of polio doses is 240, and when the field coordinator visits there are currently 40 doses in stock (four 10-dose vials). An addition 200 doses are needed - It doesn't matter if this is fulfilled with twenty 10-dose vials of ten 20-dose vials.

Unfortunately, SELV doesn't support this concept of a general Polio ISA. Instead in SELV there is an ISA for Polio (10 dose) and Polio (20 dose).  These calculations are currently the same for the various sizes: Example:

Calculation: Delivered Stock Polio (10 dose) + Existing Stock Polio (10 dose) + Delivered Stock Polio (20 dose) + Existing Stock Polio (20 dose) > Polio (10 dose) ISA*     Note: All values in calculation are in doses

*because SELV doesn't have a general Polio ISA, the calculation compares the total stock to the Polio (10 dose) ISA. This should be fine, because the Polio (10 dose) and Polio (20 dose) ISAs are the same. If they ever become different, this needs to be re-evaluated.

Tableau Calculation

Single Vial Size:

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)

Multiple Vial Sizes:

Josh to insert

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.